If there is a Header tax amount and no line item amount whatsoever, then the invoice was created in the Invoicing program as a sales tax adjustment and the error may be ignored (a future version of software will allow adjustments to be processed in the Invoice Adjustment Screen). If there is an amount in the line items, then the difference must be investigated and corrected as described below.
• Examine the invoice customer and ship to information (and possibly the customer master record and inventory record(s)) to determine what the correct Taxtype, Taxcode and taxable flags are for each line item.
• Confirm that the correct information is present in each line item record. If it is not, the missing information should be carefully entered using the Invoice Line Item Editor. Note the information must exactly match the valid records set up in the Taxcode and Gencode tables.
• Add any missing information to the Customer and or Inventory records used on the invoice which generated the error so that the error does not reoccur on future invoices for the customer.
• Calculate the total of the line item sales tax amounts as follows. If line item Taxtype is taxable Taxtype and inventory taxable flag = Y, then qty shipped * price = extended price, extended price * rate (determined by Taxcode and stored in line item) = sales tax amount for the line. This calculated amount should agree with line item sales tax total which is also stored in the line item file. If the amounts do not agree it indicates that the record has been edited since its creation as this stored amount is the original sales tax amount for the line item as calculated by invoicing program.
• Check the line item sales tax total against the invoice header sales tax field and edit the field if necessary using the Editor for the Invoice Header file. Note: If you edit this amount you must also make sure that all other Header amounts (Charges, CBAL Amt, etc) are in balance. If they are not you must edit them to the proper value. Note also that all editing of invoice amounts should be done before sales are posted. Editing invoice amounts after the invoice has been posted to the General Ledger can cause an out of balance condition between the A/R sub ledger and General Ledger A/R control account and if this is done the original Sales Postings for the invoices edited should be reversed and the Sales should be re-posted (both in the proper accounting period)