Auto-generate PurchaseOrder Item Sequence

Question

When you auto-generate a PO from a SO it brings the items over and places them in alphabetical order. Is there a setting to make the items come over in the same order as the SO? This would be all linked to the "line key" field I'm pretty sure.

David Speck · Answer

I don't believe so, considering how the process can summarize lines, I'm assuming that is why the lines end up in alphabetical order.

heybryce · Answer

Yes. The option is within PO Options. On the 3. Generate tab. There is a field titled 'Sort Purchase Order Lines By'. Select Sales Order Line No. from the drop down. The only issue here is you cannot be using the Combine Sales Orders by Vendor option too. That is the first check box on the same PO Options Window. If that box is select the items will pull into the PO in alphabetical order. 
 
 Also written up in Sages KB 70436 article.

Sage 100

Auto-generate PurchaseOrder Item Sequence

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING