From the Maximo Support Desk - Distribute Tax On an Invoice Line

Body

It is possible to distribute tax among different GL Accounts or entities for a single invoice line...

There are business and accounting scenarios where tax needs to be distributed among multiple entities.  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.
13. Click on the Distribute Costs button.
14. In the Percentage field enter 75.
15. Click on the New Row button.
16. In the Percentage field enter 25.
17. In the GL Debit Account field use the GL Navigator to select a different GL Account, such as 6000-200-200.
18. Click OK.
19. 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

1. In the Invoice application click on the Change Status button
2. 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 result shows 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

Tom Richardson is an IBM Maximo Support Engineer and frequent contributor to the Asset Management Blog community.  For a complete index of links to his articles, visit
Index of articles by Tom Richardson, Support Engineer