I wish to capture the Transaction Number from the Material Transaction table immediately after the record is written. I need to save this number for future reference.
In the Transfer Order Ship form, upon clicking the Ship button, a SP runs and the record is written.
In the SP there are Rowpointers created. I suspect one of these is used when writing the Material Transaction record. However, when I try to expose the Rowpointer in a DataView, it doesn't appear. My thinking was that if I grab the RP before the record is written, I could then use it to query the Material Transaction table to get the Transaction Number.
I cannot use a filter on the record written as only the Transaction Number (or RP) can guarantee the uniqueness of the record I need.
Has anyone dealt with any situation like this?
We are CSI 10 in the Cloud.
Regards,
Lance
