Share
Report
285Hello,
We process our orders through SOP, create an order, pick and confirm, transfer picked order to invoice. Our sales team enter the order while despatch transfer the order to invoice, thus a different user will create the invoice.
We want to be able to print on the invoice the user who entered the order.
I have added the SOP HEADER HISTORY (SOP30200) to the report that contains the User to Enter (USER2ENT) field. The SOP30200 is where an entry is created once an order is transfered to an invoice, ie from the SOP10100 table (SOP HEADER WORK), however I cannot work out how to extract the USER2ENT so that I can display it on the Invoice printout.
I tried by creating a Calculated Field Definition that is Conditional on:
SOP_HDR_WORK.Master Number = SOP_HDR_HIST.Master Number
True Case: SOP_HDR_HIST.User To Enter
False Case: SOP_HDR_WORK.User To Enter
However, all I ever got was the False Case being activated.
Is there I way I can access the data I need within Report Writer?
Any sugestions are eagerly awaited for me to try.
Thanks for your time, Cheers, Steve
*This post is locked for comments
All responses (
Answers (
