Skip to main content
Solved

Report to show details about AR Transactions

  • February 15, 2024
  • 3 replies
  • 100 views

Forum|alt.badge.img

Hello Guys, as always thanks in advance for any help provided here.

 

My controller is asking if there is a way to look at a report that just show AR transactions, and NOT   “SO transactions”. He says that all orders originate from SO, then they go to AR, and from there they end up in GL. He wants to know a way to pull JUST transactions that were done in AR (modifications, dollars changes, etc) that were done specifically in AR.

 

 

He wants to be able to filter out by the Types or AR transactions done in AR, linked to the SO transaction.... so he can then compare, and match with GL. That shows the SO that originated from, but shows the changes made in AR.

Does that makes sense?

 

We have another Vendor we use for reporting called DataSelf that is only looking at the SO, not the AR. And they are having some discrepancies

Best answer by dcomerford

You could filter then out by the CreatedByID not being SO301000 or SO302000. Also the ARTran table has some SO fields so SOOrderNbr so you could exclude based on that. 

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

3 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • 636 replies
  • Answer
  • February 15, 2024

You could filter then out by the CreatedByID not being SO301000 or SO302000. Also the ARTran table has some SO fields so SOOrderNbr so you could exclude based on that. 


estebanperalta54
Captain II
Forum|alt.badge.img+4

Hi @jorgep17 You can use the sales profitability analysis GI (ScreenId=AR601000) that comes out of the box. This will give you detail for invoice lines, you can then join to ArTran to SoLine to get so lines details. I have a GI for this this that I’m happy to attach.


Forum|alt.badge.img
  • Semi-Pro II
  • 81 replies
  • February 20, 2024

The ARInvoice table has a field called OrigModule which indicates where the originating module is (AR, SO, etc). You can use that as the filter in your GI/Reports.


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