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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales order setup
Microsoft Dynamics GP (Archived)

Sales order setup

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

Dear All,

I have a sales order ID and in this the Use separate fulfillment option is selected.  When I receive the inventory item on shipment invoice it doesnt change the qty backorder on my sales order.  Its shows it on qty on hand but not getting allocated.  I wanted to untick the use separate fulfillment process but this is kind of grayed out how to untick this.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at

    Babu, you can use something like this:

    UPDATE SOP40200

    SET USPFULPR = 0

    WHERE DOCID = 'SALES ORDER ID'

     

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Thanks Angel,

    So is this mean once I have created the order ID and used that on sales order I cannot change the setting on the sales order setup.  If I do on sql is there any other table affecting this or link I need to worry about.

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at

    That's right. It will be grayed out once you use it. I'm not aware of any other tables that need to be updated. I did this for a couple docs Id and everything has been just fine. Always make a backup of your database before running any update query.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Thanks again for the kind reply Angel,

    I will try this and let you know.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Angel,

    I made the changes and its reflecting on order setup.  But still when I go to sales order and options-Allocate or Fulfill its not getting fulfilled.  Also I tried to transfer to invoice and its say 0 transferred qty is fully back ordered.  What I am missing please let me know.

  • Suggested answer
    Angel Nuñez Profile Picture
    Angel Nuñez on at

    You'll have to manually move the quantity from the "Qty to Order" field to the "Qty to Invoice", then you'll be able to fulfill.

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Yes Angel I can do that but there are few hundred order are there which need to be invoiced and that's the reason I am looking to fulfill automatically.

  • Rosemary Profile Picture
    Rosemary 10 on at

    Hi,

    Did this order initially start as an 'order' and then transfer to invoice and what was not fulfilled, to be placed on backorder?

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Rose,

    Order still the status of order and qty is on back order and I received the items on PO but the qty is still not moving into qty to invoice.  I can change it manually but its not done automatically.  

  • Justin Thorp Profile Picture
    Justin Thorp 2,265 on at

    Hi Babu,

    This may be a silly question but, from the Sales Order is there a link to the Purchase Order (That is, does the SOP to POP "Commitment" exist)?

    If the SOP/POP link is there, when you post a shipment this should update the quantities on the Sales Order (unless someone has that sales order opened up in the Sales Transaction Entry window at the time of posting the shipment).  

    Please test this on a New Sales Order (Just to help identify if in fact there is another flag in SOP10100 or SOP10200 that should have been updated when the setup was changed).

    Thanks,

    Justin

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans