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
Everything Else
Account Details Not...
 
Notifications
Clear all

Questions Account Details Not Matching Historical Inventory Valuation Report

 
Everything Else
Last Post by Tim Rodman 6 years ago
3 Posts
2 Users
0 Reactions
2,429 Views
RSS
Casey Hope
Posts: 25
 Casey Hope
Topic starter
May 29, 2019 2:25 pm
(@casey-hope)
Member
Joined: 6 years ago

We are comparing these two reports as I mentioned and noticed that they do not match with the Inventory Account. Is it possible that they could be calculating a different way for each other? It always seems that the Historical Inventory Balance is always about $120,000.00 less than the other. We have compared multiple reports multiple times and keep coming up with the same result. We have compared inventory items within the two reports and they seem to match, but something is still off. I have checked how the report is designed in the report designer and cannot come up with any solutions. Does anyone else seem to have this problem, idea, or are we completely missing something? 

Topic Tags
report report designer reporting
2 Replies
Casey Hope
Posts: 25
 Casey Hope
Topic starter
May 29, 2019 4:53 pm
(@casey-hope)
Member
Joined: 6 years ago

I should have mentioned for an example that for every period we check and compare that the Historical Inventory Valuation Report is always the same amount lessor in the same range (i.e. $100,000.00) than the  Account Details report. 

Reply
Tim Rodman
Posts: 3192
 Tim Rodman
Admin
June 7, 2019 10:32 pm
(@timrodman)
Famed Member
Joined: 10 years ago

So your General Ledger module balance doesn't equal your Inventory module balance?

I would go financial period by financial period until you find the first one where it occurred. It could have been a manual journal entry made to the Inventory GL Account. That would throw the General Ledger and Inventory modules out-of-balance.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Python Script Ignoring Report Global Sorting in Acumatica // Returning Incorrect Values from Endpoints
    1 week ago
  • Prevented from selecting notification template
    10 months ago
  • Timecard reports/queries
    2 years ago
  • Business Events with GI to Excel without creating a new report
    5 years ago
  • Daily Field Report
    5 years ago
Topic Tags:  report (6) , report designer (46) , reporting (13) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,518 Topics
  • 10.9 K Posts
  • 15 Online
  • 2,309 Members
Our newest member: Jason Rhodes
Latest Post: Table linkage for adding a customer location note to the SO Shipment form
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

 No online members at the moment

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.

‹›×

    ‹›×