Distribute Tax On An Invoice

Answer

The following example will demonstrate how to distribute the tax:

1. Go To Purchasing | Invoices.
2. Click on the New Invoice button
3. In the Company field enter "almar" and tab out.
4. Verify that the check-box is checked for "Pay Tax to Vendor".
5. On the Invoice Lines tab click on the New Row button.
6. In the Line Type field verify that "Service" is selected.
7. In the Description field enter "Generic Service Line 1".
8. In the Line Cost field enter 75.
9. In the Tax Code field select any valid Tax Code, such as NJ.
10. Verify that the tax has populated in the Tax field.
11. In the GL Debit Account field use the GL Navigator to select a valid GL Account, such as 6000-200-000.
12. Save the record.
14. Click on the Distribute Costs button.
15. In the Percentage field enter 75.
16. Click on the New Row button.
17. In the Percentage field enter 25.
18. In the GL Debit Account field use the GL Navigator to select a different GL Account, such as 6000-200-200.
19. Click OK.
20. Save the record.

Using a database query tool, execute the following SQL to view the Invoice cost and distribution values:

select a.invoicenum, a.invoicelinenum, b.gldebitacct, b.linecost,a.tax1code, a.tax1 from invoiceline a, invoicecost b
where a.invoicenum = b.invoicenum and a.invoicenum = '<the invoice number here>';

The result does not show distribution of tax, the tax is the same for both GL Accounts:

INVOICENUM INVOICELINENUM GLDEBITACCT LINECOST TAX1CODE TAX1
-----------------------------------------------------------------------------------------------------
1054 1 6000-200-200 18.75 NJ 4.5
1054 1 6000-200-000 56.25 NJ 4.5

In the Invoice application click on the Change Status button
In the New Status field select Approved and click OK

Using a database query tool, execute the following SQL to view the Invoice line(s) and distribution values:

select a.invoicenum, b.invoicelinenum, a.gldebitacct, a.linecost, a.tax1code, a.tax1, a.loadedcost from servrectrans a, invoiceline b
where a.invoicenum = b.invoicenum and a.invoicenum = '<the invoice number here>'

The results show the tax being distributed:

INVOICENUM INVOICELINENUM GLDEBITACCT LINECOST TAX1CODE TAX1 LOADEDCOST
--------------------------------------------------------------------------------------------------------------------------
1054 1 6000-200-200 18.75 NJ 1.12 18.75
1054 1 6000-200-000 56.25 NJ 3.38 56.25