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!!!

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.

Dynamics 365 Commerce for B2B E-Commerce Success in UAE

E-commerce solutions like Microsoft Dynamics 365 have been providing support to businesses across the world.

Microsoft Dynamics CRM in the UAE for Better Customer Service

The customer relationship is the basis of success for every business. Discover how you can

Benefits for Distributors of Integrating a Website with Microsoft Business Central

eCommerce has changed the way of doing business. In fact, it has become the default

Schedule your free demo with us now!