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
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.
HI Mohammed,
Try to do this through security roles, This will restrict users to remove lines.
Thanks
Nagendra Varma K
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...........
Set up your security correctly then, so they would not be able to delete posted lines.
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.
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
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
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).
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,836
Most Valuable Professional
nmaenpaa
101,156