Skip to main content
Solved

Report Parameters - Display only Inventory Items on Purchase Receipts


Forum|alt.badge.img

Hello,

 I created a report that print labels for items on purchase receipts. I want to have the ability to select one inventory item off of that PO receipt to be reprinted. I added a parameter for InventoryID from the POReceiptLine.Inventory ID field. However, when I open the dialog window, the system shows all the items in the system and not just the items on that Purchase Receipt. I would like to filter the Inventory ID field to just the items on the Purchase Receipt. Is it possible without customization? 

 

 

Best answer by etrojan28

@Laura02 

The feedback from support is that this is not possible. Not all data fields can be made to depend on another. If the Report.GetFieldSchema did not work as expected when specifying a dependent data field, that indicates that it is not possible to make that particular data field dependent on the other.

 

View original
Did this topic help you find an answer to your question?

5 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • August 24, 2024

Hello,

Did you compare your report Parameters to similar parameters used in standard Acumatica Reports?  Here is an example using Receivables → Printed Forms → Invoice/Memo Report. In Invoice/Memo report, we first choose Document Type and then Reference Number lookup reflects only reference numbers that match the document type we selected:

 

I hope this example helps you.

 

Laura


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3101 replies
  • August 25, 2024

Hello,

In addition to above example, here is some additional information from an Acumatica post by Irina.

 

https://community.acumatica.com/report-designer-237/how-to-add-dependent-parameters-to-a-report-89

Laura


Forum|alt.badge.img

Hi @etrojan28 , you may try adding conditions to VisibleExpr on Details section as shown below:
 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 42 replies
  • August 27, 2024

@Laura02 Thank you for the reply. 

Below, is how I have the parameters setup. The POReceiptLine.InventoryID is dependent on the ReceiptNbr. However, when I run the report the parameter for InventoryID shows all items in the system not just the items on the PO Receipt which is selected above it on the report.  Something I’m missing? This is where I’m having the issue. 

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 42 replies
  • Answer
  • August 27, 2024

@Laura02 

The feedback from support is that this is not possible. Not all data fields can be made to depend on another. If the Report.GetFieldSchema did not work as expected when specifying a dependent data field, that indicates that it is not possible to make that particular data field dependent on the other.

 


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