Sunday, July 8, 2018

Dynamics NAV - Limit Item List on Purchase Order Item Lookup to Assigned Vendor only


  1. Edit the Purchase Line Table in the dev Environment
  2. Field No. > Properties
  3. Tablerelation>Type=CONST(Item) Line
  4. Add Table Filter> Vendor No.=FIELD(Buy-from Vendor No.)
Item Cross Reference No.
  1. This can be used to store additional vendor item numbers on an item to allow for lookup using the Cross Reference no. Column that must be added to the Purchase Order line Screen

LS Retail - Retail Purchase Order uses different lookup logic, you should use Purchase Order for regular purchases.
  1. Retail Setup - Other>PO Item Lookup Method

No comments:

Post a Comment