Microsoft Dynamics AX (Archived)

Set Up Database Log for Inventory Journals

(0) Share

Report

Posted on by Mohammed Altaf

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

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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).

Was this reply helpful? Yes No
Suggested answer

Nagendra Varma K on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mohammed Altaf 435 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

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...........

Was this reply helpful? Yes No
Suggested answer

Nagendra Varma K on at

Like (0)

Report

HI Mohammed,

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

Thanks

Nagendra Varma K

Was this reply helpful? Yes No
Suggested answer

Ajit 8,755 on at

Like (0)

Report

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.

Was this reply helpful? Yes No