Skip to main content
Solved

Run report action does not pass values to the report

  • April 11, 2023
  • 8 replies
  • 250 views
L
Captain II
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

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.

    8 replies

    F
    Jr Varsity I
    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. 

    Chris Hackett
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • 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.

     

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    F
    Jr Varsity I
    Forum|alt.badge.img

    What is the error you get?

     

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

     

    Chris Hackett
    L
    S
    Semi-Pro III
    Forum|alt.badge.img+9
    • sweta68
    • Semi-Pro III
    • 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

    Chris Hackett
    F
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • April 12, 2023

    Thanks.

    You are correct!

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

    Thanks!

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    P
    Freshman I
    • panap
    • Freshman I
    • May 16, 2023

    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 ?

    Chris Hackett
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • 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!”

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • May 22, 2023

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

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsCookie settingsAccessibility statement
    About Acumatica ERP system
    Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
    © 2008 — 2024  Acumatica, Inc. All rights reserved