Skip to main content
Solved

custom report

  • April 19, 2022
  • 7 replies
  • 140 views
C
Freshman II

How long should it take to make an open orders custom report ??

Best answer by Naveen Boga

@Cetylite  Instead of going for a new custom report. There is already a Default Acumatica report available to fetch Sales Order Details.

Please find the screenshot for reference.

 

 

    7 replies

    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • April 19, 2022

    @Cetylite  You wanted to create a simple GI for the Open Orders? OR the Report Designer report?

    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    C
    Freshman II
    • Cetylite
    • Author
    • Freshman II
    • April 19, 2022

    Report Designer report

    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • April 19, 2022

    Hi @Cetylite  You just wanted to show all the OPEN orders from the system OR you wanted to add a filters like below.

    1. Order Type
    2. Order Nbr
    3. Customer
    4. Order Date
    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • Answer
    • April 19, 2022

    @Cetylite  Instead of going for a new custom report. There is already a Default Acumatica report available to fetch Sales Order Details.

    Please find the screenshot for reference.

     

     

    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
      S
      Freshman I
      Forum|alt.badge.img
      • sarah
      • Freshman I
      • April 19, 2022

      How could we add the Customer Ship To Location to this report?

      Sarah Bond
      Naveen Boga
      Captain II
      Forum|alt.badge.img+20
      • Naveen Boga
      • Captain II
      • April 20, 2022

      @sarah  Hoping you wanted to show the below default Location from the Customer record.

      If yes, in the report, you can join the BAccount/Customer table with the Location table using BAccount ID and Location ID to fetch the Location name. 

       

       

      Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
        V
        Acumatica Employee
        Forum|alt.badge.img+12
        • vkumar
        • Acumatica Support Team
        • April 20, 2022

        Hi @Cetylite 

        You may refer to the Reports designer documentation to get an understanding on using Reports designer. Here is the online help link:
        https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=e15a22db-126f-40f7-a362-e02a4ea7e4ad

        Also, you can give us a list of columns you want to see on your report. We can try suggest any existing best report (like the one @Naveen Boga has suggested) you can either directly use or can customize further. 

        Regards,

        VijayKumarU
          Terms & ConditionsAccessibility 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