Allow or deny New inserts in Item Ledger Entry (ILE)

CarlesTA

Hi folk,

I would know if there is a reliable method to block the creation of new movements in Item Ledger Entry table by Posting date.

Starting Posting Date would be defined by the manager in a auth page.

The goal is control once month is closed, that no user is allowed to post in the past

Navision allows to inform posting period for each user, but If we set that date here, the user is not allowed to modify old open entries (still in stock).
What we need is just to allow / lock new entries in ITL according to a certain Posting Date.

Catching onInsert event in ILE table would be a bad Idea? or even locate all the CDU that post in this ledger and insert some code here? is there any nav funtionallity ?

Thanks to all!

Carles

matteo_montanari

CarlesTA wrote:

Hi folk,

I would know if there is a reliable method to block the creation of new movements in Item Ledger Entry table by Posting date.

Starting Posting Date would be defined by the manager in a auth page.

The goal is control once month is closed, that no user is allowed to post in the past

Navision allows to inform posting period for each user, but If we set that date here, the user is not allowed to modify old open entries (still in stock).
What we need is just to allow / lock new entries in ITL according to a certain Posting Date.

Catching onInsert event in ILE table would be a bad Idea? or even locate all the CDU that post in this ledger and insert some code here? is there any nav funtionallity ?

Thanks to all!

Carles

Hi

Have you tried Inventory Periods? (https://msdn.microsoft.com/en-us/library/hh168417(v=nav.70).aspx)

Bye

Matteo