Dynamics GP–Auto SOP POP commitments

I’d wrongly assumed it to be possible to commit a single sales line qty to multiple purchase order lines until it is fully committed. Frustratingly it does not work this way.

  • Any single sales line may only be linked to one purchase order line
  • Multiple sales lines can be linked to a single purchase order line
  • Units of measure must be the same on both sides, no buying boxes and selling each!
  • The check box must be set to allow commitments in the purchase order
  • The site IDs must match on both sides

This came about when I was developing a SQL script to automatically create the links between sales and purchase orders. As we accumulate sales orders we aggregate them into purchase orders against our suppliers adding in replenishment stock and stock required for manufacturing at purchase order time.

Once all the purchase orders have been generated ideally I want to link up the sales orders using identified priorities.

I also discovered that when the units of measure differ between the purchase and sales orders, a link is not permitted. This is all pants (technical term).

WilloWare Inc. have done some work in this area. Looks like they have their own table with a few forms over it that also hook into GP at critical points.

A new SOP-POP Multi-Link module gives you the ability to link a PO Line to a partial quantity of a sales line; link multiple PO Lines to the same sales line so that as different purchase orders are placed, or as a single PO is partially received, quantities can be allocated to one or more sales lines. Additional features include: Batch ID’s on sales orders are automatically changed when they are fulfilled by the receipt of a linked PO Line. The new module will integrate into Binary Stream so that split documents maintain existing SOP-POP Links. http://www.willoware.com/custom/files/DS0068.pdf

As we use our own custom bespoke SOP item allocation service, it is possible that I can cook something up to do this properly with all the flexibility we need. First I’ll wait to see what pricing Willoware come back with.

[updated 28th May 2015]

We decided we needed the flexibility that owning the code would give us, so have embarked on our own solution for this to provide a more flexible version of SOP-POP linking.