AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

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

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
Comparison of subto...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Comparison of subtotals in both a subreport and main report

Acumatica Report Designer
Last Post by LT8675309 5 months ago
1 Posts
1 Users
1 Likes
167 Views
RSS
LT8675309
Posts: 14
 LT8675309
Topic starter
September 9, 2022 5:16 pm
(@ltussing)
Member
Joined: 1 year ago

Hello,

I have an integration with a 3rd party EDI provider into Acumatica.

I need the ability to compare the incoming EDI (derived from non-standard Acumatica tables) total amount of the EDI sales order with the Acumatica sales order total amount.

 

Example:

EDI sales order total = $50 (data stored in custom tables)

Acumatica Sales Order total = $51

Print this record on my new custom report because the sales order TOTALS don’t match.

 

Discounts are involved which are causing the discrepancies I need to report.

 

  1. I have written a report that accurately reports the Sales Order number and the total from the EDI tables.

I intend to use this as a subreport.

The total is in a group footing as it sums up the individual lines of the order.

This part works.

 

  1. I can write a main report that will accurately calculate the total of the actual Acumatica sales order.

However, this too will have the order total in a footer as a subtotal.  (main report)

 

So I have a subtotal on a group in a subreport that I want to compare to a subtotal field on a main report.  I only want to report the sales order if there is a difference between the 2 sales order totals.

 

This seemed doable until I actually tried to put this together.

Any advice?

THANKS!

Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 1 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×