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

CarlesTA
CarlesTA Member Posts: 11
edited 2015-02-13 in NAV Three Tier
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

Comments

  • matteo_montanari
    matteo_montanari Member Posts: 189
    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
    Reno Sistemi Navision Developer

Categories