Need to do a customization in a table

I want to do fasle “Open” field in the table “Item Ledger Entry” while posting the Purchase Order, this is because i don’t want to issue the item until the quality check (QC) done.

Please help me where i have to write the code to prevent the “Open” field

Well no need to customize to ensure that. That’s standard in the warehousing management setup, by using special bins/locations.

And especially not the customization you’re suggestion by changing the “Open” field functionality. If you do so, then you will break the inventory system of NAV.

You need to find a different solution anyway. So why not using the standards?

Thank for your reply.

As per the NAV system once Item received and GRN done inventory will updated and we can issue the item if i want, but what i want item should not be issue until we check the quality. as quality check will be done item can be issue.

by default “OPEN” field in “Item Ledger Entry” table go “true” when we post a purchase order that means item can be issue for production, but if i will do it “False” it will prevent the item to issue.

So how can i make it “False”.

I have tried to code in CODE UNIT - 22 but it is not working for me.

Please help me if anyone have any idea.

You cannot make it false. It will break (destroy) NAV’s inventory function.

could be that you have to extend the process. you could add a bool field to table item ledger entry “quality checked”. if that value is true, only then the item can be used in production. best you contact your nav partner for assistance.

Or you could do as most of my customers who need QA first. Upon receipt move it to a QA-bin, which is “released” when controlled. Takes “a bit” of setup to do it. But Jonathan’s suggestion could also do the job, with a bit more development.