Technical Blog Post
Abstract
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:
- Go To Purchasing | Invoices.
- Click on the New Invoice button
- In the Company field enter "almar" and tab out.
- Verify that the check-box is checked for "Pay Tax to Vendor".
- On the Invoice Lines tab click on the New Row button.
- In the Line Type field verify that "Service" is selected.
- In the Description field enter "Generic Service Line 1".
- In the Line Cost field enter 75.
- In the Tax Code field select any valid Tax Code, such as NJ.
- Verify that the tax has populated in the Tax field.
- In the GL Debit Account field use the GL Navigator to select a valid GL Account, such as 6000-200-000.
- Save the record.
- Click on the Distribute Costs button.
- In the Percentage field enter 75.
- Click on the New Row button.
- In the Percentage field enter 25.
- In the GL Debit Account field use the GL Navigator to select a different GL Account, such as 6000-200-200.
- Click OK.
- 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 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
UID
ibm11112091