ISTech Support Forum - Trial Balance vs. Inventory Value

Welcome, Guest. Please Login.

	06/07/25 at 15:51:57 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›

Pages: 1

Trial Balance vs. Inventory Value (Read 1224 times)

skgofokc Browser Posts: 10 Gender:	Trial Balance vs. Inventory Value 03/04/10 at 15:57:14 What would cause inventory G/L balances (Gl-E) for raw materials, finished goods & WIP to be substantially different than inventory value (IN-F)?
Back to top	Sheryl K. Gipson Western Plastics LLC Oklahoma City, OK DBA Classic Version 2004.1 IS Tech Support Update 12/21/2008 IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: Trial Balance vs. Inventory Value Reply #1 - 03/04/10 at 17:16:04 IN-F does not include WIP; that is supported by JC-M. As for IN-F and the Raw Materials and FG, the biggest culprit I have seen is incorrect use and classification of Non Inventory (Type N) parts. Type N parts never have on-hand quantity and are never reflected in IN-F but their transactions do hit the GL.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

skgofokc Browser Posts: 10 Gender:	Re: Trial Balance vs. Inventory Value Reply #2 - 03/05/10 at 07:58:28 IN-F allows you to print by GL account. Is the something we should refrain from doing?
Back to top	Sheryl K. Gipson Western Plastics LLC Oklahoma City, OK DBA Classic Version 2004.1 IS Tech Support Update 12/21/2008 IP Logged

dameng Senior Member DBA / EVO Software Consultant Posts: 275 Gender:	Re: Trial Balance vs. Inventory Value Reply #3 - 03/08/10 at 14:43:58 not refrain, but use as a comparison of values to see if you get the same results or not. sometimes it's a good way to find out, if you have type N parts expensing to the Inventory defaults instead of an expense account.
Back to top	Dave Mengelkamp Digital Consulting 760.832.2536 davemeng@earthlink.net IP Logged

Dawn

Full Member

I love YaBB 1G -
SP1!

Posts: 156
Gender: female

Re: Trial Balance vs. Inventory Value
Reply #4 - 03/17/10 at 09:45:27

I was having issues with this for awhile as well until I realized that the date you print inventory value on actually matters. Just because you put in 2/28/10 as the date ended that you want it take the actual values from the date you printed it. Say I wanted to print it today. It will be off. I don't know why but when I make a point to print it on the actual day I want it ended on, its almost right on. Wink

Dawn
Classic - 7/5/10 update

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: Trial Balance vs. Inventory Value Reply #5 - 03/17/10 at 15:03:58 Assuming you have the IS Tech updates installed, there is an option in IN-F for printing as of a prior date. It takes the current value as a starting piont and reverses out transaction back to arrive at the as-of date value.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Dawn Full Member I love YaBB 1G - SP1! Posts: 156 Gender:	Re: Trial Balance vs. Inventory Value Reply #6 - 03/31/10 at 12:22:08 I just had this issue yesterday. One of our item numbers did not have an assigned location which in turn would not calculate the book value because the book value was negative even though there was 180 parts in inventory. Just a place to lookl.
Back to top	Dawn Classic - 7/5/10 update IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Accounting

‹ Previous topic | Next topic ›