Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Discrepancy Between GL Trial Balance and Inventory Valuation report
02-12-2016, 08:48 AM
Post: #1
Discrepancy Between GL Trial Balance and Inventory Valuation report
Hi all;

An issue was noted with the Trial Balance report were since Aug 2015 balance were not correct. To fix, the values in ChartDetails were cleared, all GLtrans records set to posted=0 and let the system rebuild ChartDetails. This fixed the issue for all accounts except the Inventory Valuation (account 1400).

I would appreciate any input to help understand and resolve this issue.

Regards
Ian
Visit this user's website Find all posts by this user
Quote this message in a reply
02-12-2016, 08:54 AM
Post: #2
RE: Discrepancy Between GL Trial Balance and Inventory Valuation report
Hi, Ian,

Would you like to give more details about the meaning of inventory valuation incorrect?

Thanks and best regards!

Exson
Find all posts by this user
Quote this message in a reply
02-12-2016, 09:37 AM
Post: #3
RE: Discrepancy Between GL Trial Balance and Inventory Valuation report
(02-12-2016 08:54 AM)Exsonqu_Qu Wrote:  Hi, Ian,

Would you like to give more details about the meaning of inventory valuation incorrect?

Thanks and best regards!

Exson

Hi

I am not saying any report values are not reported correct (after rebuilding ChartDetails) but that there is a discrepancy between the value for 1400 as reported in Trial Balance and the Inventory Valuation report and I cannot explain it.

Ian
Visit this user's website Find all posts by this user
Quote this message in a reply
02-12-2016, 06:31 PM
Post: #4
RE: Discrepancy Between GL Trial Balance and Inventory Valuation report
Hi, Ian,

Is there any service items have been used?

Thanks and best regards!

Exson
Find all posts by this user
Quote this message in a reply
02-12-2016, 06:49 PM
Post: #5
RE: Discrepancy Between GL Trial Balance and Inventory Valuation report
Ian, does the balance in that account agree with the total of the transactions in the gltrans table?

Thanks
Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)