Hi,
When i am creating any record in ax (PO,SO,Movement Journal) and this error is coming please help me....
"Cannot create a record in Inventory transactions (InventTrans). Financial date: , Yes.
The record already exists."
Hi Lally,
You are responding on a very old thread. If you have a question/problem, please create a new thread with your specific details, so we can help you with your specific scenario. I don't know what changes were done in your environment.
[quote user="André Arnaud de Calavon"]
So please check if there are changes to the index on the InventTrans table which might cause the issue. Also check on the SQL database if the stored procedure GetNextRecId exists and the AOS user has permissions on this stored procedure.
[/quote]
Assume that if they are changes on these tables by application /by user ..what do you suggest ?
I faced the same issue, and its resolved by did below step.
1) In Inventory Module, Setup, change the LOT-ID Sequence-No and increase the # and 9( both numbers by 3 or as you want),
and also change the next sequence No, Next sequence no = (1+ Select Max(InvenTransid) from InventtRansOrigin where dataareaid = 'YourDatAAreaID').
Have You Solved issue Shadab ?
how you overcome this issue?
Hi, Mr Andre
yes i restart the server and compile and sync on AOS but issue still same
Hi Shadab,
In addition, check the last used record ID in the InventTrans table. Compare this with the NextRec value in the table SysSequences for the table InventTrans (table ID 177).
Probably this is changed by someone.
Have you also tried to restart the AOS machine(s)?
Hi Shadab,
This error is very weird. I will explain why. The LotID (InventTransID) is taken from a number sequence, but is used in the table InventTransOrigin. This is the base for all inventory transactions. The unique index of the table InventTrans (inventory transaction) is based on three fields:
- InventTransOrigin (reference to the table with a record ID)
- InventDimId
- RecId
As the record ID of each table should be unique, there must be probably something wrong with an index on the InventTrans table or a stored procedure to retrieve the next RecId is not working.
So please check if there are changes to the index on the InventTrans table which might cause the issue. Also check on the SQL database if the stored procedure GetNextRecId exists and the AOS user has permissions on this stored procedure.
Hi Shadab Khan,
Have you also checked the number sequences of the inventory journal(s) you are using? Maybe something is wrong ("hanging") there (inventory Management - Setup - journals - Journal names, inventory). If everything looks fine please open a new journal and try recording your transaction to check if the number sequence ceck fixed your problem. You might have to delete your old existing journal though.
Hope it helps,
Ludwig
Hi ,Reinhard,
As you said i deleted the hanging number in the Status list but still same issue ....please help..
Hi Shadab Khan,
Probably start in the module where you currently have the issue e.g. inventory module. There you can check the inventory parameters and the last tab of the inventory parameters form shows you the number sequences used in this module. By doing a right-click and saying "view details", the respective number sequence will open. Once opened, please check whether the parameter "continuous" is selected. Also open the status list via the button at the very top of the form and see if some numbers are "hanging". If so, delete them with ALT+F9. Continue with the other modules where you have similar issues.
Hope it helps, Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,263
Super User 2024 Season 2
#2
Martin Dráb
228,112
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (