Invoice Detail Lines
LINKS TO OTHER FILES: The Add and Edit options will allow you to access (using the F4 key in fields that allow it) maintenance for the following:
- Product code
- Tax code
To delete lines: Go to the line to be deleted and press CTRL+Del or press the right button of the mouse and select Delete Current Line in the menu displayed.
In the product code, press the F8 key or the right mouse button to search for products by substrings in their name. For example: when the string 'computer' is entered, the program will display all products containing this word in the description for you to select whichever one(s) you want.
Quantity: This is only required if the unit price is entered.
Product code: This is not required, but must exist if entered. If entered, the program will use as a default for the product the category code, the unit price according to the rate applied to the customer, the discount (Y/N) and the tax type. All these data can be changed in each line.
Category code: This is not required, but must exist if entered.
Product or description: This is not required.
Batch: Batch number. This is not required and only appears if Add Batch is enabled in preferences.
Unit price: This is not required.
Discount base: This is not required. If the quantity and price have been entered, this will be automatically calculated as follows:
base amount = (units x price) .
If the program has Invoicing By Weight enabled in preferences, the calculation is different: the price rate is taken as the price per weight unit and the base is calculated from the formula:
base amount = (units x product weight) x rate price
% Discount: This is not required. If a % is entered, the discount is calculated using the discount base.
Discount amount: This is not required. If a % discount has been entered, it will be automatically calculated using the discount base. If a % is not entered, a fixed amount can be entered.
Amount: This is not required. The amount is calculated automatically (discount base - discount amount).
Apply general discount (Y/N): This is required if there is an amount. The general discount will only be applied to amounts for which the field = Y.
Non-taxed costs (Y/N): If you indicate "Y", this is added to non-taxed costs and not considered when computing the taxes. This field only appears if non-taxed costs is enabled in preferences.
Tax class code: This is required if there is an amount. If entered, it should exist in the tax class file of the company.
Line number: This is used to insert or change the line positions. Whenever a line is added, the program assigns it a number in increments of 10 (10, 20, 30, etc.). To place line 30 between line 10 and line 20, change number 30 to number 25 and so on.
Cost Price: Cost price of the product. A column is shown with the cost of each product. By default, this cost is taken from the purchase price for the product, but can also be entered manually. This is not required and only appears if Display Product Cost is enabled in Preferences.
Number of packages: This is used on the shipper packing slip. This field only appears if shipping documents are enabled in preferences.
Weight: Unit weight. The default is taken from the product. This is not required and only appears if Add Weights is enabled in preferences.
Total weight: The following is calculated as follows: units x unit weight. This field is not required and only appears if add weights is enabled in preferences.
Promotion type: D = discount, G = giveaway. This is automatically filled in with the promotion used. This field only appears if promotions are enabled in preferences.
The following fields only appear if the following is enabled: invoicing for regular payments (Settings --> Preferences --> Invoice):
Payment frequency (in months): This indicates the frequency of regular payments for this line. By default, this is taken from the product.
Due date: This indicates the due date for this line. By default, the invoice date + the payment frequency (in months) is calculated when the product is a product with regular payments.
Recalculate at Due Date: Y or N values are allowed. If Y, then the product files are reread when the regular payment is issued and the data are placed on the detail line (if the price has gone up, then the regular payment will be issued at the new price). If the value is N, the product is not read when the renewal takes place and all the data for the previous invoice are used (retaining the prices, descriptions, taxes, discounts, etc. as they were previously).
DUE INV: This field is automatically filled in during the invoicing process for regular payments with the company code and the invoice number where the renewal is invoiced.
1ST INV: This contains the date of the initial invoice. It is automatically filled in Add invoices when a product with regular payments is entered. The field is used so you know, once various payments have been made, when the service actually began.