Database log production order delivery date

(1) Share

Report

Posted on by Sten Baumgarten

I'm trying to setup database log and log changes in the "Delivery date" field on a production order, but after I setup the log and changed the delivery date, it was not logged.

The I setup database log on the whole production order, but I still did not get anything logged.

I have the same issue in a 10.0.18 and 10.0.22 Preview.

Have someone in the Community experience the same and found an explanation and solution?

Best regards

Sten

I have the same question (0)

All responses (2)

Answers (1)

Sten Baumgarten 12 on at

Like (0)

Report

RE: Database log production order delivery date

Hi Chris

Thank you for your answer and explanation about staging. Your guide solved my issue :-)

Kind regards

Sten

Was this reply helpful? Yes No
Verified answer

Chris Bell 62 on at

Like (0)

Report

RE: Database log production order delivery date

Hi Sten,

I managed to get this to work.

Within the Database log wizard if you tick the "Show all tables" and "Show table names" at the bottom of the screen.

Then if you go to Production series I -> ProdTable -> DlvDate. That should work. I think the issue with your setup is that there are two tables called Production order in the wizard, but one seems to refer to a staging table.

After that I marked it to create a record in the Database Log on update:

After finishing the wizard I gave it a go and it created records in the log :)

Hope that helps.

Kind regards,

Chris

Was this reply helpful? Yes No