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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Additional info (screen shots)

Accrued Purchases report

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you Ludwig. I appreciate your time and suggestions.

-Darin

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No