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.

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

How to Enable Physical Negative Inventory in Dynamics 365 Finance & Operations?

Many organizations experience fluctuations in stock levels. Situations like orders passing current stock levels make

Reduce Costs and Improve Inventory Control with Business Central Warehouse Management

In today’s competitive world of business, inventory management has become increasingly important. This requires striking

Schedule your free demo with us now!