ISTech Support Forum

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

Message started by Dawn on 05/10/10 at 06:08:52

Title: Inventory off
Post by Dawn on 05/10/10 at 06:08:52

We received a part in on 4/29/10 for 2120 parts for a total cost of $1011.24. I noticed in inventory this morning that in IN-A that we have 2120000 parts with a cost of $.00005 per part. I looked thru RNI and only 2120 parts for $1011.24 was received. I looked thru the GL entries and only $1011.24 was recieved in raw inventory. I looked at the part setup to see if it was setup a M instead of EA for PO's. It is set at EA. The atual PO issued is set at EA. I looked at AP-C and only the 2120 for $1011.24 is available to post an invoice against.

I'm not sure how to fix this. If I back out the PO receiving it will create a problem when invoicing as the quantities/cost will not matchup. I was thinking about a Maintain Database adjustment but I'm not sure if that will fix it with out messing things up.

Any suggestions would be great.

Title: Re: Inventory off
Post by GasGiant on 05/10/10 at 08:11:47

You would need to change the UOH in BKICLOC and the last and average costs in BKICMSTR, and I'm not sure if the Book Value would be correct or not. Have a look at it in IN-A after the changes (this will fix UOH in the master files) and run UT-K-G on the item if needed. If standard cost for assemblies in which the item is used have been rolled up, you may want to rerun BM-G, as well.

Title: Re: Inventory off
Post by Dawn on 07/29/10 at 08:17:41

I just had this happen again with the same part number. Apparently when the PO was entered it was entered as an EA with a converstion factor of 1. I double checked this myself. At some point between printing the PO and Receiving the PO the converstion factor changed to 100. This is what caused the quantity and price to change so drastically. I went into IN-B and looked at how the part was set up and it is setup as EA and conversion factor of 1. I was thinking there might be a problem with the information in the database but I don't know what file to look at.

Title: Re: Inventory off
Post by Lynn_Pantic on 07/30/10 at 13:10:43

Check PO-H and see if maybe there was a conversion factor entered against a Vendor price.

Title: Re: Inventory off
Post by Dawn on 08/05/10 at 09:15:10

No it's set to 1. I went thru looking at old purchases and there were a couple times we had to buy from another vendor for that part and their pricing was based on bags of 100. Those po's had been entered with a converstion of 100. Could it be pulling from previous PO's?