Welcome, Guest. Please Login.
05/28/25 at 14:09:26
News:
Home Help Search Login


Pages: 1 2 
Send Topic Print
balance sheet vs. inventory value (Read 3070 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: balance sheet vs. inventory value
Reply #15 - 05/04/05 at 11:01:52
 
OK, all joking aside, this seems a real problem. I thought we were doing all right this year, and a $28k debit to my Absorbed Labor and Overhead account is something I'm going to do only while kicking and screaming.
 
My biggest question is what could have happened so that what was good on Feb 28 is now off by $20k?
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: balance sheet vs. inventory value
Reply #16 - 05/04/05 at 11:53:31
 
Do you reset the period-end close date every month after all is posted so that no one can make posts to previous months?  If not, could someone have made a post to February?  
You could try running a GL transaction report for each month starting with feb for each of the the two accounts, and see if anything jumps out at you.
When I first started monitoring my inventory acounts, I would dump an entire months worth of transactions from the WIP GL account into an excel worksheet, and sort by work order.  I would add all issues, both material and labor, and compare to what was taken out when the work order was finished.  I took me forever, but usually at the end of the process I knew what caused the difference between wip summary  and the WIP GL account.  That may not be possible for you-  we run a real job shop where most items we build are one on and we carry little or no inventory in finished goods.  We finish at actual cost and so the numbers in and out of wip GL should match.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Cyndee Pappas
Senior Member
****


EVO~ERP 2006.1
02/28/06 update

Posts: 258
Gender: female
Re: balance sheet vs. inventory value
Reply #17 - 05/04/05 at 12:17:05
 
I had installed the 022205 update in early April and had strange numbers for end of April. Tried to install the fixed IN-F from the website, but wouldn't work (license issues). I think you may need to be on the 032505 update to use it. Anyhow, I went back to the BKINF.run dated 100404 and IN-F matches my GL.  Also re-ran today with 033105 dates and these match reports I ran before the 022205 update was installed.
 
YMMV
Back to top
 
 

Cyndee Pappas
Industrial Data Systems
EVO~ERP 2006.1 with 02/28/06 update
Client/Server Win2000 Server
Pervasive SQL 2000i

WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: balance sheet vs. inventory value
Reply #18 - 05/04/05 at 12:27:12
 
I loaded the 2/22 update on 2/27 and have had no real problems with my GL balances until this one with the unfinished finish really finishing!
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: balance sheet vs. inventory value
Reply #19 - 05/04/05 at 12:31:48
 
I do re-set the period end close every month, but not so that it would prevent this type of thing.  I run the reports (IN-F value vs GL value) a day or two before the end of the month, and at the end of the month set the close date for one month before, because there are always things that trickle in for at least two weeks after the end of the month. Maybe I'm doing this wrong, but as I recall, the ability to select a previous date in IN-F is only a recent improvement, so it originally had to be done "as of now".
 
The point is that theoretically there shouldn't be any adjustments. I realize that because of the way DBA does stuff there will be some small ones. Ten or twenty dollars here and there, or even a hundred once in a while would not seem unreasonable to me. The fact that there may be a few transactions backdated should have an extremely small effect, I should think.
 
Or tell me I'm all wet, just tell me something. Shocked
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: balance sheet vs. inventory value
Reply #20 - 05/04/05 at 13:02:55
 
Cyndee posted while I was posting, so I went and changed my IN-F back to the one dated 9/8/04. I think that was my biggest problem. As of today I'm still off a total of about $4500, but back at Feb 28 it's only $477.
 
So I may still have some setup issues that I need to track down, but there's something wrong with one of the IN-Fs.
 
Leaving all filters in IN-F cleared so that everything in inventory should be included I get the following numbers:
 
162,873.36 with IN-F dated 9/8/04
138,663.48 with IN-F dated 3/31/05
 
I haven't tried adding the numbers with a calculator to see if it's a "new math" type problem, but I quickly notice that there is one more page in the report with the old file.....
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: balance sheet vs. inventory value
Reply #21 - 05/04/05 at 13:36:49
 
I will take a very close look at the latest IN-F.  The only thing we changed (supposedly) was add filters for from/thru Primary Vendor and Customer so if you leave them blank, you should get everything but stranger things have happened.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: balance sheet vs. inventory value
Reply #22 - 05/05/05 at 06:20:53
 
I just came across the thread unders Items about things missing from IN-F. I downloaded the file dated 4/4/05. That one seems to be fine.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: balance sheet vs. inventory value
Reply #23 - 05/05/05 at 07:19:25
 
Cross another one off the list...  Thanks David.  For anybody else following this thread, the file is at www.istechsupport.com/dl/inf.zip
 
If anybody continues to have problems using this latest IN-F, please let me know.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: balance sheet vs. inventory value
Reply #24 - 05/06/05 at 12:38:02
 
was the problem with the 3/31 update or 2/22?  I haven't had any problems with this report and I have the 2/22 update.  I print always with an "as of" date, and I print by GL account.  If it was the 2/22 update that had problems then I am having trouble understanding why some of you out there have big problems and I don't.  
Which brings up another thing I would like confirmed-  If I haven't loaded the lastest update, and something is fixed and you send a separate fix for it, do you also include it in the current version of the latest update so that that when I load it I don't need the separate fix?  I am assuming you do- could  you confirm that?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: balance sheet vs. inventory value
Reply #25 - 05/06/05 at 12:52:12
 
My BKINF.RUN.BAD file is dated 3/31/05/12:32 PM. The updated (good) one is 4/4/05/10:53 AM.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lenette
Senior Member
****


That's why they call
it work!!

Posts: 459
Gender: female
Re: balance sheet vs. inventory value
Reply #26 - 12/08/05 at 08:54:01
 
I'm having differences again.  I can't determine if it is caused by the last update HOWEVER, they are very unexplainable.
 
On several occasions, I have run UT-K-I, SM-J-C and UT-K-G to balance the IN-F report against the B/S.  I have made any necessary GL enteries to force the balance.
 
Only to find a day or two later the numbers are all wacked out.  The IN-F report may show a few cents in differences between the Average & Book Values.  These differences do match the outcome of the UT-K-G report.  HOWEVER, when you try to tie them into the GL accounts in the B/S.  They are off.  For example Finished Good should have been out $0.04 instead the IN-F report was out $32.78 for the B/S.
 
I know this number isn't huge however today I did a quick check (also everthing in GL-O is posted) and I'm out $513.10 from yesterday afternoon.
 
Is anyone else having problems?  Does it matter if WOs are open?
Back to top
 
 

Version: Current (always current on patches)
Build - 05/21/19 T7-7iR11
Pervasive 12.00 - EVO seats 15 DC seats 5
DBA since 2002

Lenette Egan
McDantim Inc
Helena, Montana
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: balance sheet vs. inventory value
Reply #27 - 12/08/05 at 10:10:18
 
The only time I see real differences in my GL account balances and my inventory Value report by GL account is when( and I may be repeating myself):
 Purchases are posted to the wrong asset account either because the part purchased is a N type with the wrong class code or more recently the wrong GL account in the PO line item This past month we had problems with this at the end of the month. (before the last update 11/18 we were having errors with PO's putting the wrong account in the line item but it's been fixed) I find these by doing a detailed trial balance of the asset account in question for RP types and check the purchased parts to make sure they belong to the particular GL asset account I am looking at.
Issues , for one reason or another are done at $0 cost and the value report reflects that they are gone but the GL had no post since the total was $0.  I find these by printing all WO issues for a time period in JC-E and look for issues with $0 cost.
In Assembly ( what we call Accessories asset) and Finished Goods asset accounts, the work order has been finished and shipped but not invoiced ( or the invoice has not been posted).  Or the Finished Good cost posted to the asset account is way different from the average cost it comes out at.
We make adjustments ever month of under $30 dollars, and last month we were off by over $1000 in our Raw Materials Asset account.  It was all about Purchases not going where they should.  Thank goodness that is fixed.
Hope this helps.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1 2 
Send Topic Print