AR Invoice - sales tax for each invoice line

Using distribution...sales order entry, sales order pick, sales order shipment, a/r invoice.

Customized sales order acknowledgement, to display sales tax data for each sales order line.  Some lines are taxable other are non-taxable.

When sales order is shipped want the same sales tax data displayed for each line of the invoice...same as the sales order

The a/r invoice totals the sales tax for all lines and displays 1 total after the last invoice line as well as displaying the sales tax total in the total section.

QUESTION:

  • is it possible to display the sales tax for each line of the invoice under the detail line of each line displayed on the invoice.

thanks!

  • 0

    The breakdown for each line is tracked, so if it is the invoice form you're referencing for display of the sales tax detail, then you would have to modify the applicable business forms you are using. The sales tax tables that contain the detail are common for each document type, so you could use your modified acknowledgement to indicate the relationships and extent of the changes you would perform in Crystal Reports.

    The sales tax summary amount for the line is indicated on the Sales Tax reverse tab in Detail.

    If you click on the elipsis, you be able to view the breakdown of the tax calculation. It is linked to the detail from tarInvoiceLineDist.STaxTranKey, but how the tables are populated depends on how sales tax options are configured for the customer, item and company. Generally, you need to build the detail from the data in tciSTaxTran and tciSTaxCodeTran.