AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Generic I...
Discrepancy between...
 
Notifications
Clear all

Questions Discrepancy between Trial Balance and Inventory valuation

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 6 years ago
2 Posts
2 Users
0 Reactions
2,250 Views
RSS
Marcela
Posts: 1
 Marcela
Topic starter
October 2, 2020 9:27 am
(@marcela)
New Member
Joined: 6 years ago

I have a discrepancy between the numbers from Trial Balance and inventory valuation. Is there a report like the AP or AR module that I could see the difference?


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
December 14, 2020 11:56 pm
(@timrodman)
Famed Member
Joined: 11 years ago

Not that I know of unfortunately. The Discrepancy by Account (AP409010) and Discrepancy by Account (AR409010) screens are nice. It would be great if Acumatica extended them into the Inventory module.

I don't have a report already made, but for reconciliation situations like this, I like creating a report that pulls from the General Ledger and Inventory, then groups by Date. When you compare the two side-by-side, at least it allows you to see on which day the discrepancy occurred which means less transactions to sift through.

Another idea to catch discrepancies faster is to drop them on a Stuff That Should Never Happen Dashboard (click here).


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 54 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×