SOP/POP link

(0) Share

Report

Posted on by NR-21061352-0

765

Dynamics GP requires that if you want to have SOP-POP link on an item, that the U of M must be the same on the Sales Order and PO for that item.

So if the item is purchased in Cases and sold in Each, then we have an issue and can't use SOP-POP link.

Does anyone have a workaround?

thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

You should be able to use Each UOM on the PO, if you have Each setup in the same UOM schedule as the Case.

Was this reply helpful? Yes No
NR-21061352-0 765 on at

Like (0)

Report

Hi Frank,

both Each and Cases are set up in the Schedule.

But the PO line item has to be Cases, because that is how it is purchased. They do not purchase in Each.

And on the selling side, they sell the item only in Each.

The system does not allow us to use SOP-POP link on that item because the UoM are not the same on the Sales Order and the PO.

Regards,

Natalie

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi,

Not sure if this is practical for you, but what I've done is sell a fraction of a case. Your UofM has to provide for the decimal, but that's why setting the base to the smallest measure is often not the best idea. You didn't mention how many were in a case, but if there are 12, your UofM named 'Each' could be .0833 cases.

Kind regards,

Leslie

Was this reply helpful? Yes No
NR-21061352-0 765 on at

Like (0)

Report

Thank you Leslie for taking the time to suggest a workaround.

But in our case, it would be a bit confusing to sell to the customer in a fraction of a case. I think we will simply have to accept how the software works in this area and do the best we can with the constraint.

Natalie

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Or, you could negotiate with your supplier to accept a PO for each instead of case. Maybe even put a note in the Line Comment field defining how many cases are represented by the each quantity on the PO.

Was this reply helpful? Yes No
Suggested answer

Victoria Yudin 22,769 on at

Like (0)

Report

Another option may be to print an alternate PO report. In GP it would still show EACH for the UofM, but when you print the PO it can do the conversion to CASE based on some additional logic. This might require a little more training for the end users, and a custom report possibly in Crystal or SSRS (not sure how easy this would be in Report Writer), but might be a way to still use the SOP/POP link and have the UofM show properly where needed.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

Natalie,

Your customer would still see 'Each', it's just the UofM schedule that would show the fraction of a case. Your customer would buy 1, and then behind the scenes the system would convert it to .8333 cases. My unit of measure schedule has 'Case' as the base UofM. 'Each' is defined as .8333 cases. The customer only sees 1 Each, not .8333 cases.

Kind regards,

Leslie

Was this reply helpful? Yes No