You’re offline. This is a read only version of the page.
15,428
Hi
We have many parts that they use together 95% of the time. They are all purchase item. But it is a chance they get out of sync for on hand for some reasons. Is it anyway that we setting BC the way that for example anytime Part A shows up in Planning Worksheet to order (PO) then Part B also shows up as well? I mean this way purchaser does not need to remember all "related" parts to manually add to the PO.
Thanks
We developed something similar in a recent project, we called it Complimentary Items.
Every main item has a number of complimentary items that are assigned using a page similar to the item substitution.
We have included a ranking score and a Qty Per field E.G one unit of item A gets 5 pieces of item B.
The requirement was for sales and we enabled a few subpages to get the complimentary items in the sales order, and check availability by location and price lists.
Eventually, we expended the code so that the planning worksheet gets the complimentary items in the lines together with the main one. The complimentary items are non-inventory, this makes it easy to copy the lines in the planning worksheet because we don't need to calculate planning parameters.
You could use another item no. at the item card. F.ex Common Item no. if you don't do inter company transactions where you need that.
Then subscribe to an event in the create PO from Req. worksheet process and and start to check if the items common item no. also is on the req. worksheet or not. If so add it either to the req. worksheet or directly on the PO.
That saves you for doing much extensions on the item table and you can use one simple codeunit to handle it all.
Maybe you can use one of these event subscribers?
[EventSubscriber(ObjectType::Codeunit, Codeunit::AddOnIntegrManagement, 'OnAfterTransferFromReqLineToPurchLine', '', false, false)]
local procedure OnAfterTransferFromReqLineToPurchLine(var PurchOrderLine: Record "Purchase Line"; var ReqLine: Record "Requisition Line");
begin
end;
[EventSubscriber(ObjectType::Codeunit, Codeunit::"Req. Wksh.-Make Order", 'OnAfterInsertPurchOrderLine', '', false, false)]
local procedure OnAfterInsertPurchOrderLine(var PurchOrderLine: Record "Purchase Line"; var NextLineNo: Integer; var RequisitionLine: Record "Requisition Line"; var PurchOrderHeader: Record "Purchase Header");
begin
end;
Thanks Kim
My struggle is now with modification. I am not sure what that modification looks like? I mean how I can force Planning Worksheet to show the second item or how make the second item to show up in PO. Any idea?
Thanks
MahGah, there really is nothing to drive the purchase of two parts when one is needed to be reordered. I thought about assembly orders and production orders but there are ramifications to use those for an unintended purpose. I think you are looking at a modification.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (