Inventory and item cost problem

Hi

We have a problem with my inventory.

We do house and buidling wiring.  We sold and install different type of cable and sometime it's sold foot by foot or in a package and I have an ''service'' item for that purpose.

Also since we are in canada, we buy wiring in METER but we sold it in FOOT.  When my employe enter our wiring purchase, he forgot to do the convertion.

Not a big problem because each 3 month I do the inventory and balance everything since last week....  Actually I ''lost'' 1$ for each foot of cable sold.....

We found that the system give a unit cost for each item and when we correct the inventory, it just increase the item cost.  So actually I paid my Cat6 0.135$/ft, I sold it 0.19$/ft and SAGE ''think'' the cost price is 11.50$/ft.... So each time a sold wiring, my net income is going down....

The easy solution is to create another item and replace the ''*** up'' one but it's the same problem for almost 3/4 of my item and in 1 year it will be the same thing...

Any solution for that?

Thanks

Parents
  • 0

    I just made a test:

    I bring my item to 0$ value and 0$ quantity.  Then I give him back the right quantity with the real paid price and the ''cost'' is back to normal.  Is it the right way to do it?

    I'm actually looking at my ''journal general'' and it's seem correct.

Reply
  • 0

    I just made a test:

    I bring my item to 0$ value and 0$ quantity.  Then I give him back the right quantity with the real paid price and the ''cost'' is back to normal.  Is it the right way to do it?

    I'm actually looking at my ''journal general'' and it's seem correct.

Children
  • 0 in reply to MikePML

    It's still best to create new items that have the correct relationship for the conversion between KM / Meters purchased, and feet sold.

    Then post inventory adjustments to clear off all the errors and have the correct pricing and costs. 

    If you post an adjustment to an existing item that will clear the quantities and cost off to zero, you may be able to change the item to a 'service' item and save it, then change it back to an 'inventory' item and change the relationship.  Using an item that has been modified this way may work, but it will likely prevent adjusting prior invoices, and It may do unusual things in the future, including reports that don't make sense, and even crashing the program.