Skip to main content
Answer

Dependent Shipment parameter on report.

  • September 16, 2020
  • 1 reply
  • 158 views

Hello,

I’m working on a report that must print the labels for a specific shipment, I have Shipment Nbr, Item ID and Lot Nbr parameters, and I would like to have the report knowing the Inventory ID or LotNbr once the Shipment Nbr value on parameter is entered.

The report is working fine if I know the lots or inventory id associated to the shipment, but I would like to have those values displayed associated to the Shipment #.

 

Do you have any guidance on it?

 

Best answer by BenjaminCrisman

Francisco, unfortunately there isn’t really an out of the box solution for this currently and would likely require a new custom SQL view to make sure only the Lot# associated to the shipment are visible.

It is important to make sure that you have selected all the primary keys for the DACs used to ensure that the values seen are correct.

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • September 18, 2020

Francisco, unfortunately there isn’t really an out of the box solution for this currently and would likely require a new custom SQL view to make sure only the Lot# associated to the shipment are visible.

It is important to make sure that you have selected all the primary keys for the DACs used to ensure that the values seen are correct.