Skip to main content
Solved

Run report action does not pass values to the report


Forum|alt.badge.img+5

Hello,

I added RUN REPORT actions to the shipment screen.  As a test, I am just printing the standard sales order.  When I click my new action on the shipment screen, it pops up the sales order, but it is blank.  The action is not passing the values of the sales order I intend to print.

 

Best answer by sweta68

Hi @ltussing03 ,

In my opinion, you missed something while mapping the parameters, if a hardcoded Sales Order number is passed in the Value of "OrderNumber" parameter, the report displays the expected output. If the Customer Order number is different from the Sales Order number, it is possible that the report may not match, and the data may not be displayed correctly. Therefore, it may be necessary to pass the Customer Order number as a parameter instead of the Sales Order number. 

Regards,

Sweta

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

8 replies

Forum|alt.badge.img

Hi there,

Are your parameters correct? Looks like you’re sending the shipment type to the order type and the customer order number to the Order Number. 


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 280 replies
  • April 11, 2023

Thanks for the reply!

I was typing “type” and didn’t notice it defaulted to the shipment type!

 

Order type is not available from the selection, so I hardcoded “SO” for type and now I get an error.

 


Forum|alt.badge.img

What is the error you get?

 

And are you sure that the customer order number mapping is correct?
 

 


Forum|alt.badge.img+9
  • Semi-Pro III
  • 229 replies
  • Answer
  • April 12, 2023

Hi @ltussing03 ,

In my opinion, you missed something while mapping the parameters, if a hardcoded Sales Order number is passed in the Value of "OrderNumber" parameter, the report displays the expected output. If the Customer Order number is different from the Sales Order number, it is possible that the report may not match, and the data may not be displayed correctly. Therefore, it may be necessary to pass the Customer Order number as a parameter instead of the Sales Order number. 

Regards,

Sweta


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 280 replies
  • April 12, 2023

Thanks.

You are correct!

The customer order number is not the same as the sales order number!

Thanks!


  • Freshman I
  • 1 reply
  • May 16, 2023
frederickodendaal77 wrote:

What is the error you get?

 

And are you sure that the customer order number mapping is correct?
 

 

Can mapping to find joining DAC fields ?


Forum|alt.badge.img+5
  • Author
  • Captain II
  • 280 replies
  • May 22, 2023

frederickodendaal77,

 

Thanks for the reply.

This is resolved and was a silly mistake by me.  Please see my note posted above.

“The customer order number is not the same as the sales order number!”


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2689 replies
  • May 22, 2023

Thank you for sharing your solution with the community @ltussing03 !


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