Skip to main content
Solved

Dependent Shipment parameter on report.

  • September 16, 2020
  • 1 reply
  • 140 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
Did this topic help you find an answer to your question?

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 691 replies
  • 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.


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