Add context menu item to existing list with selection context

(0) Share

Report

Posted on by sjsbls

Not sure if this is possible, but putting it out there just in case.

We've got a set of requirements to essentially be able to raise a simple purchase order from the Job Planning Lines list. The user should be able to select multiple lines > click the overflow menu and create a PO including the items from those lines, provided they're all from the same vendor.

Just wondering how I'd be able to go about creating an action that would be able to get the context of what lines have been selected?

Also, would it be at all possible to add fields showing the vendor names (lookup from Item No. > Vendor) to the existing planning lines list? I hope I wouldn't have to go down the line of using a temp table but not sure if there's any other way, admittedly in-experienced with BC/AL.

Any help would be much appreciated, thanks!

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Vinita_Kas 336 on at

Like (0)

Report
Copy link

Link copied!

Hi There

Did you try the requisition worksheet

it does combine your orders if of the same material and if you have a preferred vendor that is put up in the item card it would create orders with that Here is an example I found from a thread which had similar question

3 sales orders

SOR0001 - JW2010 – QTY 100 – DUE 06/01/2010

SOR0002 - JW2010 – QTY 100 – DUE 06/01/2010

SOR0003 - JW2010 – QTY 100 – DUE 07/01/2010

Item Card Settings example

In stock = 50

Reordering Policy = Lot-for-Lot

Reorder Cycle= 30D (this is number of days)

Safety Lead Time = 10D (this is optional)

Safety Stock Qty = 30

Go to Requisition Worksheets

Click Functions – Calculate Plan

Item Tab – No. = JW20101 Options Tab – Start date 06/01/2010 – End Date 07/01/2010 – Click OK.

This returns 1 line suggesting an order for QTY 280 – which is (SO = 300)+(safety Stock =30)-Instock = 50.

Does that help?

Regards

Vinita

Was this reply helpful? Yes No