When we import invoices that have been attached to purchase orders in the purchasing module to the A/P module there are several cases where the information doesn't import correctly due to the differences in value options in purchasing to A/P. For example: We have a purchase order where we do an add-on amount for freight that prorates to all the line items. That freight amount is non-taxable, buit each of the individual line items are taxable. In purchasing the values show up in different columns: 1) item amount 2) item's tax amount 3) add-on amount 4) add-on's tax amount. However, in Accounts Payable there is only three columns: 1) pre-tax or total amount, 2) tax amount, 3) tax liability amount. These columns aren't even the same choices - in purchasing there is not a tax liability column, and in Accounts Payable there isn't the ability to separate the add-on amount from the item amount (so if the item and the add-on are not both taxable or both non-taxable the A/P system invoice amount doesn't match the PO system invoice amount). At the very minimum the two systems should be able to correctly communicate with each other (i.e. have the same column options).
by: Jennifer D. | over a year ago | 4 Purchasing & Inventory
Comments
Also, in this same subject, discrepancies arise when:
- Using miscellaneous deductions in an AP vendor, which we use for tax retention purposes, the invoice that gets sent from PO to AP, does not recognize the deductions, and they have to be put manually line by line. THIS IS KILLING US AND WE WOULD LIKE TO SEE IT RESOLVED AS SOON AS POSSIBLE.
-Issues arise also with the decimal points, as PO uses 4 and AP 2. Same thing happens in JC.