ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Neg Inventory
http://www.istechforum.com/YaBB.pl?num=1319041494

Message started by AndyOB on 10/19/11 at 09:24:54

Title: Neg Inventory
Post by AndyOB on 10/19/11 at 09:24:54

Our Inventory is still boned (sorry), but were looking to fix it, but I figure before we start doing PI we need to make sure we fix whatever procedures were messing up so after the PI everything stays accurate.

Can anyone point me to some info as to why our FGI inventory is going negative? Someone mentioned something about running the Batch Finished Production, and we have been, but the inventory is still mucking up.

Is there any easy to follow flow diagrams or whatever docs that might help figure this out. Search function on these boards doesn't seem to work so I'm sorry if this has been answered before.

-Andy

Title: Re: Neg Inventory
Post by Kelloggs on 10/20/11 at 08:06:16

When you do finish Production on an item, it will add the Qty completed to you FGI, plus an entry on your inventory transactions.
Can you see it?

:)

Kelloggs

Title: Re: Neg Inventory
Post by Lynn_Pantic on 10/25/11 at 08:49:32

If FGI is going negative, then you are shipping things that you haven't made (as far as the system is concerned).

Title: Re: Neg Inventory
Post by AndyOB on 10/25/11 at 11:13:51

So where are we neglecting to say, "hey, we made this"? Gonna guess "Finished Production" should do everything.

Title: Re: Neg Inventory
Post by Lynn_Pantic on 10/25/11 at 19:59:58

It should. I would have to look at transaction details to know exactly what is going on.

Title: Re: Neg Inventory
Post by AndyOB on 11/01/11 at 11:33:32

Tell me what report to run and i'll send it to ya. :)

-A.

Title: Re: Neg Inventory
Post by Lynn_Pantic on 11/01/11 at 16:59:45

IN-E would be a place to start

Title: Re: Neg Inventory
Post by AndyOB on 11/04/11 at 10:13:44

Tada...

IN-E for 10/24 thru 10/28.

http://www.nortra-cables.com/evo/IN-E%20Report.pdf

Title: Re: Neg Inventory
Post by Lynn_Pantic on 11/04/11 at 19:12:39

That is a start but I can't tell from this report where the problem is. Better report would be IN-E with no date range but for a single item that we want to examine.

Title: Re: Neg Inventory
Post by AndyOB on 12/05/11 at 12:32:44

So I ran IN-E again with just 1 FGI part, and anywhere I did this where the Qty on hand is negative, the only inventory transaction are "Shipment" type transactions.

Does that help this issue?
-A.