Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have several PO's fully invoiced and received, but still show a balance owed (like .01) and show on the Accrued Purchases excluding sales tax report. I need to find a way to get these PO's off the report so accounting no longer has to accrue the remaining amount. You can see, they have been accruing for awhile now. AX2012 R3 CU9.

*This post is locked for comments

All responses (7)

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

We have decided to leave them. We will be migrating to D365 in the future and have the opportunity to move limited historical data. So we should be able to drop them off then.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Good morning Darian,

Would be great if you could keep us informed here about the approach you decide to use to tackle this issue and share it with the community.

If there is nothing else needed then let's please verify and close this thread.

Thanks

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Thank you Ludwig. I appreciate your time and suggestions.

-Darin
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Hello DarinJ,

I do not think that there is an easy and fast way to get those two records out of the report.

You would have to take a look at the voucher and possibly record some adjustment transactions, which is something that I would not recommend doing because of 0.02 cent.

What you can do though is excluding your PO that has those differences from the report by applying a select filter.

This does not solve the problem but excludes those lines from the report.

If this is not acceptable for you then you might have to record corrective inventory postings, which change your stock levels and require a lot of work.

Really think if you want to invest that time and effort for those two cents.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Thanks Ludwig. I would agree. However, it does not help with clearing the current PO's stuck on the report. Do you have any suggestions for zeroing them out so they do not show on the report?
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Hello DarinJ,

Can this be a rounding issue?

How have you setup your currency rounding rules?

I would expect that if you round to 0.01 or 0.02 and setup your allowed penny differences in the GL/AP parameters form then you should not see this issue in the future anymore.

Best regards,

Ludwig
Community Member Microsoft Employee on at

Like (0)

Report

RE: Remove Invoiced PO's from the Accrued Purchases excluding sales tax report

Additional info (screen shots)

Accrued Purchases report