Skip to main content
Solved

Dependent Shipment parameter on report.

  • 16 September 2020
  • 1 reply
  • 138 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.

View original

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings