Closing Inventory Not Completed

(0) Share

Report

Posted on by Community Member

I am facing an error "Cannot select a record in Inventory transactions (InventTrans). Financial date: 20-Jun-15, Yes.The SQL database has issued an error."
while i am run closing inventory

kindly assist me to solve this error.

mostafa hussein

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Sort by

André Arnaud de Cal... 304,603 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

If you look at some lines it sais that a table schema in SQL has been changed. Are you running this report locally or in batch? Are there any other batch tasks running at the same time? Is someone also importing customizations? Can you verify if some database maintenance scripts were running at the same time? I have seen scripts in the past where e.g. a fill factor change also caused a similar error.

Was this reply helpful? Yes No
ccolombel 2 on at

Like (0)

Report
Copy link

Link copied!

Hello Mohamed,

this errors occurs often when a SQL index REBUILD is done during a AX treatment

de reindex action change the table schema and throw this type of error

check with our sql admin if a index rebuild was done during the ax treatment windows.

Charles

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi André Arnaud

Thanks for replay

This is in relation to the problems SQL and what about the problem in the following

Transaction: Transfer AD-194063, lot ID AD-11551062

Unit cost price 25.23 can be wrong as the transaction cannot be fully settled.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Try to run Inventory Recalculation for all / specific items and see the results. Later you can try Inventory Close.

Avoid running this job during office hours, if possbile.

Check in test environment first and see the results .

Best Regards,

Vishal Salot

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Vishal Salot

Thanks for replay .what's mean wrong MSG related cost price .

i don't understand it after post her search bاy google but I can't find anyone answer what mean this

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Cause: This problem occurs because a receipt is physically updated but not financially updated.

Resolution:

To resolve this problem, financially update the receipt. To do this, invoice the purchase order, and then run the Close function for the inventory.

Best Regards,

Vishal Salot

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

All items show in this problem Resulting transfer journal
It is known there is no invoice

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Just check if any open Purchase Receipt is pending for Invoicing or Transfer order pending for receipt....

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 304,603 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed,

Like Vishal tries to mention it is due to not invoiced receipts. This is a normal situation where you have received goods at the end of previous month and the invoice has not been posted or even received. About the transfer you mentioned as example, try to find if the "Sold" transaction is being linked to an open purchase inventory transaction. You can do this from the Inventory closing form > Settlements.

Was this reply helpful? Yes No
Dhanicca Macatangay 355 on at

Like (0)

Report
Copy link

Link copied!

Hi Vishal,

Our client also encountered the SQL error mentioned above and got the same info log.

Can I ask what should be done with the inventory close that was initially run and where the SQL error occurred? Before doing the inventory recalculation and have the closing again.

Thank you!

Was this reply helpful? Yes No