Skip to main content
Solved

custom report


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.

 

 

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

7 replies

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

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


  • Author
  • Freshman II
  • 4 replies
  • April 19, 2022

Report Designer report


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • 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 Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • 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.

 

 


Forum|alt.badge.img
  • Freshman I
  • 26 replies
  • April 19, 2022

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3382 replies
  • 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. 

 

 


Forum|alt.badge.img+11
  • Acumatica Support Team
  • 785 replies
  • 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,


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