Skip to main content
Question

AR report filters causing a problem


Forum|alt.badge.img

AR report by Customer MC

 

Does anyone have any ideas why the filters shown on the attached report will not allow the report to run with the warnings below. I have picked up the customer name from the drop down list so it must exist…? Thanks

 

 Expand All    Collapse All

Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:47:00 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:47:00 Screen: AR.63.30.00    
 Details:
Information: The item BAccountID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:47:00 Screen: AR.63.30.00    
 Details:
Information: The item CustomerID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:47:00 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:33:32 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:33:31 Screen: AR.63.30.00    
 Details:
Information: The item BAccountID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:33:31 Screen: AR.63.30.00    
 Details:
Information: The item CustomerID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:33:31 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:32:05 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:32:05 Screen: AR.63.30.00    
 Details:
Information: The item BAccountID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:32:05 Screen: AR.63.30.00    
 Details:
Information: The item CustomerID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:32:05 Screen: AR.63.30.00    
 Details:
Information: The item BAccountID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:30:47 Screen: AR.63.30.00    
 Details:
Information: The item CustomerID is not found (restricted:False,external:True,value: )  Send
  Raised At: 21/02/2023 13:30:47 Screen: AR.63.30.00    
 Details:
Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:30:19 Screen: AR.63.30.00    
 Details:

 

Error: A column has been specified more than once in the order by list. Columns in the order by list must be unique.  Send
  Raised At: 21/02/2023 13:30:19 Screen: AR.63.30.00

5 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • February 21, 2023

Hi @Malinda278 

Do you have Branches in your instance? That may be causing an issue if you did not select a branch. 


Forum|alt.badge.img
  • Author
  • Freshman II
  • 37 replies
  • February 21, 2023

No no branches at all.. 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2183 replies
  • February 21, 2023

Can you share any other filters you may have used?


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • March 20, 2023

Hi @Malinda278  were you able to find a solution? Thank you!


Forum|alt.badge.img
  • Author
  • Freshman II
  • 37 replies
  • April 25, 2023

No sorry I lost the will to resolve it :)

 


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