UDT Posting

SOLVED

I have a UDT that is used to capture data during SO Invoice Data Entry. I want to copy data from this UDT into different UDT where data will be stored for historical purposes. Ideally I would like to have this automated during Sales Journal update but I do not know if this is possible. If not, I gues I could have a button somewhere and linked to a script that would copy data from data entry UDT to history UDT.

Any suggestions are appreciated.

Also, does anybody how many records can UDT contain?

Thanks

  • 0
    verified answer

    ZoomZoom,

    There is no limit on the number of records in a UDT.

    Without knowing what's in the UDTs, I will just assume that the records are related to S/O invoices and the InvoiceNo$ is in the keys.  You want to move records from one UDT to another when the invoice is deleted in sales journal  update.

    You can write a SO Invoice Header Post Delete script.  In it you will check for oSession.Updating = 1 which indicates that the invoice is being deleted by sales journal update.  You will get the the value of InvoiceNo$ and use it to select records from one UDT and write to another and delete the records from the the first UDT.

  • 0 in reply to Natasha Chang

    Thanks Natasha. I will try this out and let you know how it goes