Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Can we use VI to place/drop a standard PO that pulls balance from a master PO?

Posted By EmmaAPI over 1 year ago

Hi,

We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are wondering if we can use VI to place a standard PO that pulls balance from a master order.

Thank you in advance.

Parents

0 David_Speck over 1 year ago

You should be able to create a VI import job against PO_PurchaseOrderHeader, use Next on the PurchaseOrderNo, and then set the MasterRepeatingOrderNo field to the value of the master order. Controlling how much of each line gets drawn may be tricky though as the only way to edit an existing line is to have the LineKey value in the source file and set it using the Replace operation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 David_Speck over 1 year ago

You should be able to create a VI import job against PO_PurchaseOrderHeader, use Next on the PurchaseOrderNo, and then set the MasterRepeatingOrderNo field to the value of the master order. Controlling how much of each line gets drawn may be tricky though as the only way to edit an existing line is to have the LineKey value in the source file and set it using the Replace operation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 100

Can we use VI to place/drop a standard PO that pulls balance from a master PO?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING