AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
AR Tran - Tie total...
 
Notifications
Clear all

Questions AR Tran - Tie totals to Standard Report?

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 years ago
2 Posts
2 Users
0 Reactions
1,492 Views
RSS
Rob Cushen
Posts: 24
 Rob Cushen
Topic starter
August 1, 2019 12:16 pm
(@robcushen)
Eminent Member
Joined: 5 years ago

Hi,

Am I correct to assume that the ArTran table represents lines on an Invoice?

If so, which standard report in Acumatica may I use compare "totals" to my GI ?

For example, if I multiply Unit price * Qty (negative qty if TranType = CRM) to get total sales, what report in Acumatica should tie out for a given period? 

Thanks!

 


1 Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
August 16, 2019 8:19 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Hey Rob,

You are correct!

I would recommend using one of the "Sales Profitability" reports to tie-out the totals. If you take a look at any of these reports in Report Designer, you'll see that they are based on ARTran.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 50 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Tim Rodman Julian Schrenzel David Edmonson Michael Ricke
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×