Hello guys, just as like the title stated
How do I prevent a double input to Item ledger entries? how to check the new record to prevent duplicate record?
Thank You, *I never used C/AL code before, any answer is appreciated*
-Rohad
You should simply never insert anything to the Item Ledger Entries table.
Everything that ends up there should come from running the different posting routines in the system.
So please never write any code that does any modifications to that table because you will break the consistency of your system.
The primary key in the table is the Entry No. that is assigned as an auto increment handles internally by the system.
Hi,
If you are talking about to manual insertion in the Item Ledger entry table, So I would suggest dont do this, Lets the system apply new entry every time in this table.
Thank you so much for the answer and the insight, much appreciated!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 4,160
Nimsara Jayathilaka. 2,943
Sumit Singh 2,823
