Sage 100

User inadvertently deleted the Back Order quantity when she changed the order quantity.  The PO has a status of completed, even though there should be 91 units left on the purchase order. What is the best way to get the 91 units back on a PO?   Modify the status field in the PO header table?  Enter a new PO using a variation of the original PO number ?

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

I can't think of any reason you couldn't use DFDM to change the PO status in the header file and then modify the back order quantity on the line.

------------------------------
Bernie Lehman
Lehman Wesley & Associates
------------------------------

Thanks @Bernie Lehman  ​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 10-03-2019 09:04
From: Bernie Lehman
Subject: Completed PO Not Really Complete

I can't think of any reason you couldn't use DFDM to change the PO status in the header file and then modify the back order quantity on the line.

------------------------------
Bernie Lehman
Lehman Wesley & Associates
------------------------------

What @Bernie Lehman said but also do same with PO_PurchaseOrderHistory Header and Detail (since they are defined as mirror tables in the dictionary).

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------

Original Message:
Sent: 10-03-2019 09:14
From: Doug Higgs
Subject: Completed PO Not Really Complete

Thanks @Bernie Lehman  ​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------


Original Message:
Sent: 10-03-2019 09:04
From: Bernie Lehman
Subject: Completed PO Not Really Complete

I can't think of any reason you couldn't use DFDM to change the PO status in the header file and then modify the back order quantity on the line.

------------------------------
Bernie Lehman
Lehman Wesley & Associates

Thanks @Alnoor Cassim ​​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc
------------------------------

Original Message:
Sent: 10-03-2019 10:15
From: Alnoor Cassim
Subject: Completed PO Not Really Complete

What @Bernie Lehman said but also do same with PO_PurchaseOrderHistory Header and Detail (since they are defined as mirror tables in the dictionary).

------------------------------
Alnoor Cassim

Free Agent Developer and Consultant
CallForHelp.biz
Email: alnoor@callforhelp.biz
Orange County, CA
------------------------------


Original Message:
Sent: 10-03-2019 09:14
From: Doug Higgs
Subject: Completed PO Not Really Complete

Thanks @Bernie Lehman  ​​

------------------------------
Doug Higgs
Assistant Technical Support / Building Maintenance Specialist
Midwest Commerce Solutions, Inc


Original Message:
Sent: 10-03-2019 09:04
From: Bernie Lehman
Subject: Completed PO Not Really Complete

I can't think of any reason you couldn't use DFDM to change the PO status in the header file and then modify the back order quantity on the line.

------------------------------
Bernie Lehman
Lehman Wesley & Associates