Inventory Issues

Hi,

I am currently having an issue witht he value of some of my stock. We buy a product from a company as a Z-KFE-1728-CH then when we sell one we build the product to a KFE-1728-CH. When we first started selling the products the company were still working out the price we would pay for the product so the first 4 months or so we put a zero value in the builds. Then when we started adding a value $517.39 in it would calculate the value at a higher price and staff did not adjust this to the right value. Hence now for this Z-KFE-1728-Ch product we now have a value of $99,526.42 for 64 items. as we pay $517.39 for each item the value for 64 should be $33,112.96.

Snapshots attached below.

After calling MYOB multiple times they suggested I do an adjust inventory for the difference in the two amounts ie $66,413.46. This made the current value correct. I also had to do this for 2 more products in the same company. The problem is now my account is saying the adjustment which equalled about $260,000 is throwing out our profit and loss so I have to delete the adjustments.

The accountant suggested going back through each build to change the prices to the correct amount. This does not work because then I keep getting the error message saying your inventory or value can not be zero. 

Is there anyone out there who can help me with this? Or suggest a MYOB expert in Brisbane who could come and help me?

DePez