Cannot select a record in Inventory transactions (InventTrans). Financial date: 30/11/2023,AX 2012

(0) Share

Report

Posted on by Akbar Pasha

1,505

Hi All,

We are getting the below error while performing the Closing and Adjustment from Inventory Management.

Company-> Inventory Management->Periodic -> Closing and Adjustment

Error :

Do we need to do anything from SQL side or any action form AX application, please advise us.

Regards,

Akbar

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

Hi,

There have been discussions about similar issues on the forums before, and you can refer to these two old threads, both of which provide solutions:

Cannot create a record in Inventory transactions (InventTrans). The record already exists. (dynamics.com):

Cannot create a record in Inventory transactions (InventTrans). Financial date: , Yes. The record already exists. (dynamics.com):

Best regards,

Kevin

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 300,904 Super User 2025 Season 2 on at

Like (0)

Report

Hi Akbar,

Can you tell if the closing and adjustment job was running via a batch framework or started on a client session? At what time did it run? Can you check if at the same time some SQL server maintenance jobs were running? I have seen similar issues when a maintenance job did reorganize table indexes.

Anyway, the closing and adjustment job is put on pause. You can go to the periodic form for closing and adjustment and resume the calculation.

Was this reply helpful? Yes No
Akbar Pasha 1,505 on at

Like (0)

Report

Thank you Andre for the inputs,

we were getting the error when we click on the below menu item, we have not started any batch job for this.

we are not sure about the maintenance job were running on SQL side, we will connect with SQL team to check this.

We have resumed the calculations from periodic form for closing and adjustment , we will try again once the batch job is completed for "Resume calculations".

Regards,

Akbar

Was this reply helpful? Yes No
Akbar Pasha 1,505 on at

Like (0)

Report

Thank you very Andre for your inputs, we are able to resolve the issue by Resuming the calculations.

Regards,

Akbar

Was this reply helpful? Yes No