Link a Purchase order to a sales order

[Former Member]

I am looking for a way to link a specific Purchase order to a Sales Order so that when the Purchase Order is received the items are allocated to that specific Sales Order and another sales person cannot sell the murchasedise. I know you can create a po from a sales order but it seems like when the po is copied to a goods receipt, anyone can invoice those items on a different sales order/ a/r invoice?

Thanks,

Don Shields

[former_member583013 · Accepted solution]

Hi Don,

What you are looking for is more of a hard allocation of Items to a SO. This functionality does not exist in B1 today.

If you want to manually create some processes and validation for this, it could be done.

1. Use Batch numbers management for items and linking a Batch to a SO and use the same Batch number in the Goods Receipt.

I have provided an ellaborate solution for this on this forum last year

You may check this thread in the meanwhile

[Former Member]

The link between these two documents is not easy. You may need SDK programming. First, you can try to create UDF and use SBO_SP_TransactionNotification to achieve your goal. Otherwise, there are nothing in out of box solution.

Thanks,

Gordon