Skip to main content

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

Hi @Malinda278 

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


No no branches at all.. 


Can you share any other filters you may have used?


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


No sorry I lost the will to resolve it :)

 


Reply