|
Understood you want to keep stock records for re-ordering. I think the answer lies simply in how/when you post to the GL. On receipt you post to a stock account (balance sheet) for stock items or to an expense (P&L) account for expense items. This could be determined by (say) the item class. Likewise that item class you be used to ignore subsequent movements in AFI so no further GL posting would be made. I don't believe it makes a jot of difference whether you use standard, FIFO or whatever. The 'variance' will simply go to the same expense account as the order cost. Price variance on later receipt of invoice will likewise go to the same expense account. Don't ask me about debits and credits: I'm not even a simple accountant, just a very simple ex-JBA consultant... Peter Joel Saltway Ltd +44 7884 306501 -----Original Message----- From: jbausers-l-admin@midrange.com [mailto:jbausers-l-admin@midrange.com] On Behalf Of tkresky@sunflowermfg.com Sent: 29 November 2002 16:30 To: jbausers-l@midrange.com Subject: RE: [SYS21] non Balance Sheet items in inventory that are standard costed First, please excuse my outburst about Geac. There are a lot of fine people there doing the best they can. I should have mentioned I'm just a simple accountant. I have some knowledge of what goes on in the Inventory module, but not a lot. The key is we want to track the inventory quantity on expense items, so we know when to reorder things. If memory serves me correctly, making something non-stock prevents you from tracking inventory. Regards, R. Tim Kresky, Controller Sunflower Manufacturing a division of AGCO Corporation ph: (785) 738-2261 x272 fax: (785)-738-2406 email: tim.kresky@sunflowermfg.com Steve Dodkins <Steve.Dodkins@ebm-zi To: "'jbausers-l@midrange.com'" <jbausers-l@midrange.com> ehl.co.uk> cc: Sent by: Subject: RE: [SYS21] non Balance Sheet items in inventory that are jbausers-l-admin@midr stand ard costed ange.com 11/29/2002 09:59 AM Please respond to jbausers-l Can't you treat the expensed items as non stock items? Steve -----Original Message----- From: tkresky@sunflowermfg.com [mailto:tkresky@sunflowermfg.com] Sent: 29 November 2002 15:39 To: jbausers-l@midrange.com Subject: [SYS21] non Balance Sheet items in inventory that are standard costed I've given up trying to get help from Geac. The 'answer' provided by AnswerLink is to hire their consultants to get the answer. Funny thing, I've asked many Geac consultants over the last 3 years about this and have yet to receive an answer from a single one of them. And, all this while trying to triple our maintenance fee! ................Man, am I frustrated. Anyhow... maybe you folks can help me with this. What I posted on AnswerLink follows: Here is our situation... We have 2 types of inventory: production and supplies. Only production inventory is shown on the Balance Sheet. Supplies are expensed as received. When the system was set up several years back, the supplies were setup as 'standard costed' items. As such, these items are being handled exactly as the 'production' standard costed items are. That is, upon receipt, an accrual is posted to the G/L and price variance recognized. Remember I said these are expensed? I don't mind the auto accrue feature but I very much mind taking purchase price variance on expensed items. So... my hope is that I can change the supplies to some other cost type (FIFO is what I have in mind) so they'll stop generating price variance. Then, the question becomes how to do that without causing heartburn to the system. Any thoughts are greatly appreciated. R. Tim Kresky, Controller Sunflower Manufacturing a division of AGCO Corporation ph: (785) 738-2261 x272 fax: (785)-738-2406 email: tim.kresky@sunflowermfg.com _______________________________________________ This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list To post a message email: JBAUSERS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l or email: JBAUSERS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/jbausers-l. _______________________________________________ This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list To post a message email: JBAUSERS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l or email: JBAUSERS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/jbausers-l. _______________________________________________ This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list To post a message email: JBAUSERS-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l or email: JBAUSERS-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/jbausers-l. __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.