Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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
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.
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.
If the PO shows fully invoiced, what has been matched and invoice updated?
Can you share an example?
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?
Business Applications communities