Welcome, Guest. Please Login.
05/13/25 at 15:55:52
News:
Home Help Search Login


Pages: 1
Send Topic Print
Inventory off (Read 956 times)
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Inventory off
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.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1517
Gender: male
Re: Inventory off
Reply #1 - 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.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: Inventory off
Reply #2 - 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.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Inventory off
Reply #3 - 07/30/10 at 13:10:43
 
Check PO-H and see if maybe there was a conversion factor entered against a Vendor price.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: Inventory off
Reply #4 - 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?
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Pages: 1
Send Topic Print