Database consistency check Error

(0) Share

Report

Posted on by ihabmahmoud

330

After i ran DBCC (check only) purchase order i got this error :

( pending or posted invoices exist for purchase order PO_######## . Changing the currency or the vendor is not allowed.)

This error is repeated with all POs. No.

Kindly can any one know what could be the reason....?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

guk1964 10,888 on at

Like (0)

Report

It can be caused by user error see this post for the explanation and steps to fix - but I would not expect this to be an issue for all orders. There have been hotfixes in this area previously

www.erpsoftwareblog.com/.../microsoft-dynamics-ax-2012-resolution-one-invoices-unsaved-changes-issue

Was this reply helpful? Yes No
ihabmahmoud 330 on at

Like (0)

Report

Thanks Magic for replying,

All POs. Invoiced having physical voucher , financial voucher & job status executed

I do not have any pending invoice......

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Ihab,

We have been doing a DBCC (check only) on the purchase orders and had the same exact error message for all of our PO created since go-live.
We are currently searching the reason for those error message.

I was wondering if you solved these errors and if so, how did you manage to solve it ?

Thank you.

Was this reply helpful? Yes No
ihabmahmoud 330 on at

Like (0)

Report

Hello VincentFC,

Unfortunately i did not solve my errors.

Hope i do.

BR.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi ihabmahmoud ,

Have you found the solution?

regards,

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

You can check invoice history and matching details in accounts payable / inquires

Was this reply helpful? Yes No
Suggested answer

Alex Kwitny 395 on at

Like (0)

Report
Ignore it. The consistency check can produce errant results.

There are specifically coded checks, then generic checks that run during it.

The generic checks are where it loops over records in a table, then calls "validateWrite" and "validateField" for the record.

In your case, AX has somewhat odd validation logic executing for a generic check. You can see this by taking any invoiced PO an calling this code:

PurchTable::find("PO-000007").validateField(fieldNum(PurchTable, orderaccount));

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

Hi Ihab Mahmoud,

Appreciate if you kindly share some input on below points to understand the root cause of this.

--- At any point of time, the invoice matching validation (2 way, 3 way) was activated in AP parameters form?

--- Later, is that matching validation removed from the setup?

I think, you may have created purchase orders which falls under these criteria where during PO creation, the matching validation was active but later the setup is changed before the PO is invoiced.

What Mahmoud Hakim has already mentioned; is the simplest way to fix this issue.

You have to go to AP > Inquiries and reporting > Invoice > Invoice history and matching details. Here, you have to select the purchase order for which job status must be in Waiting stage and then 'Delete' it.

Now go back to the purchase order and you will find the Invoice tab is enabled and the PO is ready for posting invoice.

Best regards,
Sourav Dam

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No