Ledgers Sales or Accounts Receivable: Invoice and Credit Note Change and Create

Invoice number

Invoices. Invoice number. {INVFILE.INVNO char 6} This is either an Invoice, Credit Note, CBD Invoice or blank when Not Invoiced.

Customer code

Customers. Unique customer identification code. {CUSFILE.CUSCODE char 6}

Customer name

Customers. Customer company name. {CUSFILE.CUSCNAM char 40}

Select Document

To select another document for changing. You will be asked to select an invoice in the Invoice or Credit Note Selection window.

Revert to Saved

To revert any changes to the previously saved version.

Save as Shown

To save the changes you have made to the data file.

Debit

Net-Disc+Tax amount

to A/R customer a/c

Credit

Net amount only

to G/L sales a/c

Credit

Tax amount only

to G/L tax control a/c(s)

Credit

Discount amount only

to G/L discount control a/c

Debit

Net-Disc+Tax amount

to G/L debtors control a/c

Debit

Net-Disc+Tax amount

to A/R customer a/c

Credit

Gross-Disc amount

to G/L sales a/c

Credit

Tax amount only

to G/L tax control a/c(s)

Debit

Net-Disc+Tax amount

to G/L debtors control a/c

Credit

Net-Disc+Tax amount

to A/R customer a/c

Debit

Net amount only

to G/L sales a/c

Debit

Tax amount only

to G/L tax control a/c(s)

Debit

Discount amount only

to G/L discount control a/c

Credit

Net-Disc+Tax amount

to G/L debtors control a/c

Credit

Net-Disc+Tax amount

to A/R customer a/c

Debit

Net-Disc amount

to G/L sales a/c

Debit

Tax amount only

to G/L tax control a/c(s)

Credit

Net-Disc+Tax amount

to G/L debtors control a/c

Invoice date

Invoices. Date creation date. {INVFILE.INVDATE date date1980}

Printed

Invoices. Invoice printed (True when printed). {INVFILE.INVPRIN boolean}

Sales Order

Invoices. Source document depending on source type (SO number, code or Job number). {INVFILE.INVSONO char 6}

Dispatch Note

Invoices. Dispatch Note number. {INVFILE.INVDESP char 6}

Customer reference

Sales History. Customer order reference. {SAHFILE.SAHCREF char 20}

Additional reference

Sales History. Additional user reference. {SAHFILE.SAHAREF char 6}

Header text

Invoices. SO header text. {INVFILE.INVTRTX char 32000}

Packing or comments

Invoices. Dispatch or Packing instructions from SOHCOMM. {INVFILE.INVPACK char 32000}

Currency

Invoices. Currency symbol code. {INVFILE.INVCUR char 3}

WARNING: Mixed currencies on accounts which do not have the local currency as their default currency is NOT recommended. Future reviews and statements can only be normalised to the default foreign currency values with reference to the current exchange rate rather than that which applied at the time of the transaction. If multi-currency transactions are expected the default currency for the account should be the local currency. You can force the currency to the default currency of the customer using the optAcNoMixedCur system option. This will disable the edit of the currency for customers with foreign default currencies.

Exchange rate

Invoices. Currency rate applicable when issued. {INVFILE.INVRATE number float}

Adjusted

Invoices. Currency adjustment applied to ledgers flag. {INVFILE.INVCUAP boolean}

Value pre-tax

Invoices. Invoice pre-tax value. {INVFILE.INVVALU number 2dp}

Tax

Invoices. Invoice pre-tax value. {INVFILE.INVVALU number 2dp}

Amount paid

Invoices. Invoice amount paid. {INVFILE.INVPAY number 2dp}

Paid

Invoices. Invoice paid (True=paid). {INVFILE.INVPAID boolean}

Quick payment %

Invoices. Quick payment discount percent. {INVFILE.INVQPDI number 2dpShortnum}

Quick payment date

Invoices. Quick-payment date after which the discount is not available. {INVFILE.INVQPDT date date1980}

Applied

Invoices. Quick payment discount received on payment flag. {INVFILE.INVQPAP boolean}

Payment due date

Invoices. Payment due date. {INVFILE.INVDUED date date1980}

Incoterm

Invoices. Incoterm code (Blank or IDXTYPE=9). {INVFILE.INVINCO char 4}

Incoterms are the internationally agreed method of designating trading transactions which cross national borders. They define the limits of commercial responsibility for the selling party and so clearly define the limits of cost of the delivery of the goods. In the system they are defined in File — System Manager — Index Codes. An Incoterm generally requires a parameter which is usually a place or port name. A Sales Order or Job Incoterm will be copied to any resulting invoices.

Incoterm Place

Invoices. Incoterm parameter (usually a named place or port). {INVFILE.INVINCP char 60}

Payment terms

Invoices. Payment terms. {INVFILE.INVTERM char 1000}

Invoice address

Contact and address that the invoice is addressed to (either default, alternative or individual).

Right-click on this field to obtain print functions for the currently selected address and contact (default for customer, if individual address):

Print Standard Letter opens the Standard Letter Selection window and Print 4×4 Label opens the 4 by 4 Label Position window.

Default customer address

This sets the address to the customers default address.

Alternative address

Clicking on this option when it is not already selected (or clicking Change if it is), opens the Address Selection window so that an address and/or contact can be selected.

Individual address

Clicking on this option when it is not already selected (or clicking Change if it is), will set the address field to edit mode so that a unique address can be entered.

Change

To create or select an alternative Invoice Address that would be applied to this document.

Delivery address

Contact and address that it was dispatched to (either default, alternative or individual). The print functions and likewise available from the context menu.

Default customer address

This sets the address to the customers default address.

Alternative address

Clicking on this option when it is not already selected (or clicking Change if it is), opens the Address Selection window so that an address and/or contact can be selected.

Individual address

Clicking on this option when it is not already selected (or clicking Change if it is), will set the address field to edit mode so that a unique address can be entered.

Change

To create or select an alternative Delivery Address that would be applied to this document.

Items list

List of all line items (sales history) on file for the document shown above.

Total value

The total value (without tax) for the listed items.

Total tax

The total tax for the listed items.

Total with tax

The total gross for the listed items.

Invoice line number

Sales History. Invoice Line Number (may be different from SO line number). {SAHFILE.SAHINVL number 0dpShortnum}

Part number

Sales History. Part number. {SAHFILE.SAHPTNO char 18 Idx}

Commission agents

Sales History. Commission agents posted commission for this line item (comma separated list of COMIDs). {SAHFILE.SAHCOMA char 100}

NOTE: For more details of the commissioning agents system within the program see the Commissioned Sales Agents Maintenance window and the Sales Commissions Review window topics.

Item description

Sales History. Item description if not a Part numbered item. {SAHFILE.SAHDESC char 32000}

Marketing project code

Sales History. Marketing project code from SOLMKTP or JOBMKTP (IDXID = con(‘0’,SAHMKTP)). {SAHFILE.SAHMKTP char 4 Idx} See the Marketing Data Maintenance window help for more details of Marketing Project codes and their use.

Marketing project description

Index and Other Codes. Index code, scrap reason, QA test or Incoterm description. {IDXFILE.IDXDESC char 255}

Show

Lists the available marketing codes set up the File — System Manager — Index Codes. Double-click on a listed code to enter that value.

Sales account

Sales history. G/L sales posting account code. {SAHFILE.SAHACCO char 10 Idx}

Sales UoM

Sales History. Sales Unit of measure. {SAHFILE.SAHSAUM char 6}

Quantity

Sales History. Quantity delivered per sales unit of measure. {SAHFILE.SAHQTY number 3dp}

List price

Sales History. Price per sales unit of measure before discount. {SAHFILE.SAHPSUM number 2dp}

Discount

Sales History. Discount percent given to customer. {SAHFILE.SAHDISC number 2dpShortnum}

Tax regime and class

Sales History. Tax regime code applied. {SAHFILE.SAHTAMC char 6} and Sales History. Sales tax class. {SAHFILE.SAHTAXC char 1}. Sales tax regime appropriate for the customer and the class appropriate to the goods being sold. Select from the dropdown lists. (See the Tax Maintenance window for details of the tax system.) By default the customer’s tax regime is applied or that of the dispatch additional address (if one is applied). The tax class applied by default is that of the part or the default sales non-part class set in the company details.

Tax rate

The current tax net rate for the entered tax regime and class.

Value without tax

The value of the selected item in the Invoice, exclusive of tax.

Tax amount

Sales History. Tax applied on dispatch quantity. {SAHFILE.SAHTAX number 2dp}

Value with tax

The value of the selected item in the Invoice, inclusive of tax.

Add Item

To add a non-part (or non-stock part) line entry to the document.

• Invoice or Credit Note Selection and Dispatch Note Selection
• Address Selection