Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Set Up Database Log for Inventory Journals

(0) ShareShare
ReportReport
Posted on by 435

Hi there,

            I want to set up Database Log for Inventory Journals like Movement, Inventory Adjustment, Transfer... 

I am trying to set up from

System Administration --> Set up --> Database Log Setup --> New

But i cant find the exact or relevant table name to set up log.

Can you please guide me the table name to set up the Log for Inventory  Journals. 

Thanks

Regards

*This post is locked for comments

  • Suggested answer
    Ajit Profile Picture
    Ajit 8,755 on at
    RE: Set Up Database Log for Inventory Journals

    Data base logging on these tables are not recommended as all expert mentioned already. But still if you want to enable it for short term to check something then just enable log for delete. DO NOT enable for insert and update.

  • Suggested answer
    RE: Set Up Database Log for Inventory Journals

    HI Mohammed,

    Try to do this through security roles, This will restrict users to remove lines.

    Thanks

    Nagendra Varma K

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Set Up Database Log for Inventory Journals

    Don't do it you will likely crash in minutes.

     Other approaches to consider- e.g. maybe hire people you can trust/train,   set up  a workflow approval, review security rights -maybe restrict entries to 1 or 2 persons, e signature requirement, variance analysis, an exception report...........

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Set Up Database Log for Inventory Journals

    Set up your security correctly then, so they would not be able to delete posted lines.

  • Mohammed Altaf Profile Picture
    Mohammed Altaf 435 on at
    RE: Set Up Database Log for Inventory Journals

    Hi @All,  

                Thanks for the reply.

    In inventory journal we are having Bill OF Material which is used to make BOM and DeBOM of products,

            The problem which i am facing here is after creating BOM or DeBOM, some users are deleting the Load Lines along with Journal, so which is why i want to enable the Log for this particular process.

    Regards.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Set Up Database Log for Inventory Journals

    Hi Mohammed Altaf,

    I would not recommend that you activate the database log for inventory transactions. Often there are a lot of inventory transactions occuring and if you activate the database log for them, your system performance might considerably suffer.

    Why is it that you want to log them?

    Best regards,

    Ludwig

  • Suggested answer
    RE: Set Up Database Log for Inventory Journals

    HI Mohammed,

    Is there any specific reason why you want to set database log for Inventory?

    Inventory Transactions are something you can trace into each level. until Lot level of traceability is there already.

    Please let us know if any specific reason so that we can suggest.

    Thanks

    Nagendra Varma K

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at
    RE: Set Up Database Log for Inventory Journals

    It is not a good idea to set up database logging for tables where you may have a large volume of records. Your SysDatabaseLog table will grow quickly, and you will get a performance bottleneck for each posting while the logging happens.

    The journal posting header table is called InventJournalTable ("Stock journal table" in EN-GB language).

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans