|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Evo-ERP and DBA Classic >> Items >> Drastic Inventory Drop http://www.istechforum.com/YaBB.pl?num=1165964809 Message started by LJ on 12/12/06 at 15:06:49 |
|
Title: Drastic Inventory Drop Post by LJ on 12/12/06 at 15:06:49 We experienced a drastic inventory drop in value in one day of over $38,000. While it would be wonderful to have shipped that much, that is not the case. I am going through inventory transactions trying to find the culprit. 1. Is there any other place I should be looking besides Adjustments, Finished work orders and values? 2. Is there a quicker report to run to look through for what must be an error. 3. Is there anything else that might cause such a change? |
|
Title: Re: Drastic Inventory Drop Post by lmk223a on 12/13/06 at 05:48:02 1. Is there any other place I should be looking besides Adjustments, Finished work orders and values? 2. Is there a quicker report to run to look through for what must be an error. You may ask your accountant to run GL-E for the time period in question for the respective GL accounts for inventory and search for large value or unusual transactions. |
|
Title: Re: Drastic Inventory Drop Post by cathyh on 12/13/06 at 09:42:31 Have you compared your inventory value report(s) to last known good one(s) for big changes? |
|
Title: Re: Drastic Inventory Drop Post by LJ on 12/13/06 at 10:08:06 We don't use the accounting side of DBA so can't really look at that part of. We did issue a large number of WO's that day, but all items are WIP. Am I correct that this should not effect value as those items are still part of inventory. So far, that is all I found. Thanks. |
|
Title: Re: Drastic Inventory Drop Post by Cyndee Pappas on 12/13/06 at 11:59:49 LJ wrote:
What report(s) are you looking at? WIP is not included in IN-F. Try JC-E, JC-M or JC-P |
|
Title: Re: Drastic Inventory Drop Post by LJ on 12/13/06 at 12:29:02 I was looking at IN-F. So IN-F does not really give you a true reading of your inventory value then? It sounds like you have to run IN-F and then add the WIP value? |
|
Title: Re: Drastic Inventory Drop Post by lmk223a on 12/13/06 at 14:01:10 LJ wrote:
Yes, IN-F excludes Work In Process (Labor, Material Issued and Loads) |
|
Title: Re: Drastic Inventory Drop Post by LJ on 12/13/06 at 15:25:02 Is there any report that gives you a complete inventory value, including WIP? Since WIP materials are still technically in house, why are they not included in the Inventory Value? |
|
Title: Re: Drastic Inventory Drop Post by lmk223a on 12/14/06 at 06:00:22 JC-M will provide a summary of Work In Process activity (material, labor, load, extra costs, outside processes, and show the value of goods transferred to finished production, but the remaining WIP value is not a pure material inventory value. It includes labor, loads, extra costs and outside processes. JC-P will provide a summary of material issued to WIP by component by work order. However, if a subassembly has been issued to a higher level work order, the material value of this subassembly will also include labor, load, etc. and is not a pure material number. I use JC-P for evaluating material remaining in Work In Process, since it is the best report available and has proven to be reliable. I just review it for negative value inventory and $0 value inventory, and make adjustments as required. Hope this helps. ::) |
|
Title: Re: Drastic Inventory Drop Post by cathyh on 12/14/06 at 08:49:05 Inventory issued to a work order may still be in house but it is no longer available so you would not want to include in your raw materials inventory value. You have different kinds of inventory value- raw materials, WIP, and Finished Goods. Raws and Finished Goods (which includes Assemblies) can be captured in IN-F, but WIP is captured in the JC module. One way, depending on how many assemblies you have issued to work orders, is to print to file JC-P, import into Excel, and exclude assemblies from the list before summing. If you don't have too many assemblies you can manually subtract them, or if they are well separated by part number, you can exclude them from the report by entering a range of components that are just raws. |
|
Title: Re: Drastic Inventory Drop Post by CCKEITH on 12/14/06 at 14:36:28 Okay now I'm confused! I too thought that IN-F would include the total inventory value. I also thought I should subtract the WIP total found in JC-M if I wanted the value of inventory other than WIP. What report(s) do I use if I want to get a snap shot of the inventory values on a given date (including WIP)? I want the WIP value to include all of the materials, labor, overhead, etc that has been accrued to the outstanding WOs. I also want a report of all the materials and finished goods in inventory that are not currently on WO's (WIP). |
|
Title: Re: Drastic Inventory Drop Post by David Waldmann on 12/15/06 at 04:29:13 CCKEITH wrote:
On a given date just use GL-A for your three accounts - Raw, WIP and Finished. As of a given date I don't know how to find out what was in WIP. The current IN-F recalculates backward to a date in the past. |
|
Title: Re: Drastic Inventory Drop Post by cathyh on 12/15/06 at 08:23:06 In-F has an as of date, as does JC-M and JC-R for materials in WIP. IN-F does not have materials issued to work in process(WIP) only materials (and labor) included in finished product (no longer in WIP). According to other posts on JC-R, that program has been fixed so that materials number is only materials and not labor parts (I think- I don't use that program much). On the JC-M or JC-R, enter an as of date and leave everything else to DBA. The program fills in the appropriate dates. So you can run IN-F for all inventory (raws, assemblies, finished goods) as of a given date, and run JC-R for materials and/or labor in WIP (after you get the patch for JC-R). |
|
Title: Re: Drastic Inventory Drop Post by CCKEITH on 12/15/06 at 09:36:52 Cathy - Thanks for the information. I have the JC-R patch and it is working well. Finally the inventory figures make sense! |
|
Title: Re: Drastic Inventory Drop Post by kevind on 02/15/07 at 14:00:45 What are the differences in numbers from JC-R vs JC-M?? |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |