Any method to require item B to Purchase if Item A showed up in Planning Worksheet

(0) Share

Report

Posted on by MahGah

15,529

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

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

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.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (1)

Report

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;

Was this reply helpful? Yes No
Verified answer

Alfredo_Iorio 1,264 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (1)

Report

Thank Inge for the idea and pointer. That gave me some idea on how to design this development. Thanks again.

Was this reply helpful? Yes No
MahGah 15,529 on at

Like (1)

Report

Hi Alfredo

Thanks for the idea. I think this will work for us. I can see how logic like substitute works here. Thanks

Was this reply helpful? Yes No