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
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
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.
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.
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
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
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
You should be able to use Each UOM on the PO, if you have Each setup in the same UOM schedule as the Case.
#1
André Arnaud de Cal...
293,001
Super User 2025 Season 1
#2
Martin Dráb
231,833
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
