Table of Contents

How to transfer saved Back Order to Order/Invoice after the setup has been created in Dynamics GP?

How to transfer saved Back Order to Order/Invoice after the setup has been created in Dynamics GP?

While creating the Back Orders in GP the setup details will be updated to the SOP header and line tables based on the SOP Document Type ID for Back Order setup window. If we change the settings after the order has been created, details for the setup won’t update to SOP header and line tables. So, for this scenario, we need to update the setup values to SOP header table if we want to transfer the Back Order to Order/Invoice without deleting or recreating the same. And also we need to verify the Back Order Qty & Qty to Order/Qty to Invoice fields in SOP line tables.

Follow the below steps to update the SOP Order setup values to SOP header table.

1. Open SQL Server Management Studio and run the below code against company database.

SELECT USDOCID1,USDOCID2 FROM SOP10100 WHERE SOPTYPE = 5 AND SOPNUMBE = ‘Enter your SOP number for the Backorder’

2. Run the below query if the above does not return any values for the first two columns.

UPDATE SOP10100 SET USDOCID1 = ‘XXXXX’ , USDOCID2=’YYYYY’ WHERE SOPTYPE = 5 AND SOPNUMBE = ‘Enter your SOP number for the Backorder’

Note:

Update these USDOCID1 & USDOCID2 fields values based on your SOP Document Type ID for Back Order setup window. For example, If your SOP Document Type ID for Back Order setup window enabled the both “Transfer Back Order to Order” & “Transfer Back Order to Invoice”, then update both the values. Otherwise update these fields based on the setup.

XXXXX – Document ID for “Transfer Back Order to Order” in SOP Back Order setup window.

YYYYY – Document ID for “Transfer Back Order to Invoice” in SOP Back Order setup window.

3. After running the above query, verify the “Back Order Qty” & “Qty to Order” fields to assign the Back Order Quantity values to Qty to Order/Qty to Invoice fields in SOP line details window or SOP line table.

Hope this helps!!!

Author

Recent Blogs

Our content is designed to keep you ahead of the curve and provide valuable information to support your business needs. Dive in and stay connected with the forefront of industry developments.

Future of retail with Dynamics 365 AI-powered ERP solutions

Behind the retail sector, ERP solutions play an important role. It could be very important

Reasons UAE Businesses Are Adopting Microsoft Dynamics 365 ERP Solutions

Where the business environment of the UAE is constantly evolving, it needs a powerful solution

Microsoft Dynamics 365 ERP Features for ROI in 2025

Want to increase productivity and boost the ROI of your business in 2025? Then using

Please fill the below details!

    download icon

    Please fill the below details!

      download icon

      Please fill the below details!

        download icon

        Please fill the below details!

          download icon

          Please fill the below details!

            download icon

            Schedule your free demo with us now!