Hi experts,

I have used DAL-insert in LN to insert a record into table tdpur400 and also tdpur401.
I thought with DAL, history tables tdpur450 and tdpur450 will also be inserted by DAL automatically without any extra programming.
Is this true?

But I see the history tables is still empty. To insert into them, i have to assign all the fields again and this is sometimes prone to error.

What is the fastest way to generate Purchase Order and Purchase Order History tables in LN???

thanks and regards,

History logging should be turned on in the parameters and secondly only for approved purchase orders logging is done.

Hi

the parameter is already turned on.

History is created when using standard session.
It is just not created when I write a customized session and use DAL to insert new record into table.
There should be a DAL function to create history records when inserting new orders into the tables.

Appreciate if anyone can help further

thanks and regards,

Dear experts


When we insert a record in Purchase Order header and line, I supposed the DAL will also insert the same record in PO history tables.
Isn't this correct?

Can someone confirm this.

I am using dal.insert into tables tdpur400 and tdpur401. The PO header and line is inserted by my session but not the PO history tables. What should I do?


thanks and regards,

Hi Baanspider,

If is is programmed in the DAL script, the history will be logged. For DAL tdpur400/tdpur401 in older FPs, history is only logged when changing records. As of FP3 it is possible to log the history also during creation of the record.

See also SOL 234415.

Please do not double post.

You can see the answer in your other topic.

http://www.baanboard.com/baanboard/showthread.php?t=59315

Kees is correct - please do not double post. I merged them into one thread.