You’re offline. This is a read only version of the page.
25
I have several PO's showing on the accrued purchases excluding sales tax report that have a quantity remainder of less than one.
The issue is the PO is receiving an item with no decimals allowed. Example PC (piece). The Vendor invoice on the PO is allowing Decimal on quantity. Example, PO123 ordered item ABC quantity of 3 and received at quantity of 3. The vendor invoice comes in for quantity of 2.5. AP invoices the PO at 2.5 and the AX allows it. So item ABC is left with .5 on the accrued purchases report. The PO moved to invoiced status and will not allow a zero $ invoices to clear the .5 quantity.
How can we get these remaining items off the accrued purchases excluding sales tax report?
Is there a Microsoft fix for this issue?
Please see attached for screen shot examples.accrued-purchases-report.docx
The product receipt for the item shows 4 PC ordered and 4 PC received. The AP invoice shows 3.5 PC invoiced. I provided screen shots in original post. Is there a certain screen you would like me to share with you?
Hello Alison,
If the PO shows fully invoiced, what has been matched and invoice updated?
Can you share an example?
Many thanks,
Ludwig
The PO is showing as fully invoiced. The system will not allow for the .5 to be invoiced. I tired to increase the the delivery remainder back to the .5 and invoice it but I get the following error message - Updated quantity is greater than remaining quantity on order line when I try to post the invoice.
Hello Alison,
Will your vendor ever invoice the 0.5 pcs?
If you won't be invoiced then you basically received 3 and got an invoice for 2.5 only.
That is, you got the 0.5 for free and I would then invoice update the 0.5 pcs for a price of $0.01 if AX does not accept a $0 amount.
The overall effect of that small penny difference is not material and your controllers and auditors should not have a problem with that in my opinion.
Note that doing this will impact (lower) your inventory cost price per pcs and might affect your inventory values.
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (