web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Transfer from BackOrder to Order is not successful when Backorder is setup after the backorder has been created

(0) ShareShare
ReportReport
Posted on by 470

Hello,

I have a backorder that I need to transfer to an Order.  When the backorder was created, the backorder document type was not setup yet to allow transfer to Order.  I did the setup after the back order has already been created.  There is enough quantity available for the item and I have changed the Qty to Order to the qty I want to transfer to order which is the original back order qty.  When I transfer, it doesn't create the order.  I cannot delete the back order because I don't want to break the history as there are a lot of transfers that happened to this document already. 

When I did this in Test and deleted the back order, then I changed the setup to allow transfer to order after that I created the back order again.  I was able to transfer the back order to order without issues.

My question is, is there anything I need to update on my back order so I can transfer successfully to an invoice?  Since in Production, I have the backorder created first then the back order setup was changed to allow transfer to order. 

Your response is appreciated.  Thanks!

*This post is locked for comments

I have the same question (0)
  • HRF Profile Picture
    470 on at

    *** My question is, is there anything I need to update on my back order so I can transfer successfully to back to an Order?

  • Verified answer
    soma Profile Picture
    24,410 on at

    HRF,

    While creating the back order the setup details will be updated to the SOP header and line table based on the SOP setup in GP. If we change the setting after the order has been created, the SOP header and line details for the setup won't update. So, for your case you need to update the setup values to the header level and also need to verify the fields Back Order Qty & Qty to Order.

    To resolve your issue, run the below code against to your company database in SQL.

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

    Run the below query if the above query return null value 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:

    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.

    After running the above query, verify the "Back Order Qty" & "Qty to Order" fields are having the same values. 

    Hope this helps!!!

  • HRF Profile Picture
    470 on at

    Thank you so much Soma!  This worked. :)

  • soma Profile Picture
    24,410 on at

    Always Welcome.:)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans