Sage 100

I have a client that uses the auto generate PO from SO button - everything works great but they want the PO line order to mimic the SO line order. As is, when it copies the lines over to PO, it orders by item #. I've looked through all of the settings and don't see an option to modify the sort order of the PO lines. Has anyone else experienced this or found a work around or setting I'm missing? Thanks

@EricAnderson, did you happen to get anywhere with this? We have the exact same scenario. Our Consultant thought he had it working by doing the following, but now it appears it may not be working completely: Made a UDF in the PO Detail file, used the sales order line sequence as the source, and passed that through to the PO.wrk file - and sorted off that. Will post further info as we get it. The sad thing is that Ext Sol PO-1020 (http://www.sagesoftware.com/mas90/ext_solutions/files/PO/po-1020.pdf) had that option: ""Transfer S/O Lines Unsorted/Uncombined: Select Yes if you want the lines transferred from the Sales Order to appear in the same order on the Purchase Order.

no Brett, never made any progress with this. but that sounds like I good idea for the form. It's been a while but I think my client was more concerned with the actual data entry screen.

Got it working (4.5): Created a 14 char String UDF in PO Detail (not PO Wrk) and then manually configured Data Sources screen (attached).

And then created the respective Business Object UDF in the PO Wrk file for usage on the PO form - rather than linking in the PO Detail file.

Of course we're now noticing this does not work if you enable the ""Summarize Drop Ship Items by Vendor"" setting on the PO Auto Gen from S/O's screen.

From the v2013 PU4 pre-release doc: ""UDF data now flows from SO Detail to PO Detail when creating PO from Auto Generate Orders Selection when ""Summarize Drop Ship Lines by Vendor"" checked, for non-summarized lines."" DE 101926 KBId 9000808