Hello I need to edit the "Sales Blank Invoice History" form by bringing in the "PO Number" field from the RM_OPEN(RM20101). I thought SOP10103(SOP_Payment_Work_Hist) would do the trick but it didn't. Any ideas? Thanks in advance.
Did you edit the posted RM document and add the PO number? I presume it wasn't on the SOP document.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
If you are modifying the "SOP Blank History Invoice Form", and you are trying to get the "Customer PO Number" (Which you will have entered in the Sales Transaction Entry Window), onto the report, this field is already available in the Report. Just drag out the "Customer PO Number" field from the Sales Transaction History table (There is no need to create a link to the RM Open table).
If I've misunderstood the requirement, please send a few screenshots illustrating where you've entered the Customer PO Number.
Hi Leslie - I did not. I need it to come from the customer PO number in the edit transaction information window.
Hi Justin - looking to map the customer PO number from the edit transaction information window. Wish it was that simple. thx.
If you are not able to do with table link in Report Writer you can do VBA coding. Add report to VBA-->Create Calculated field poNmbr -->Add fields like SOPNumbr, calculated field (poNmbr) and do some vba coding base on that.
CSTPONBR from SOP30200 ? Sales Transaction History