Ok I think my original setup should of worked as it now is working fine using a BASE unit in mL and a transaction unit in BOTTLES! It seems “remnants” of previous attempts were still lurking in the background? Any new fresh Items work fine so all I can say is you need to be careful on the initial setups.
** COMMENT - When I say remnants I refer to the fact that even though I had nothing in the Transaction Unit Line - I could not get rid of the 750 “Multiplier” no matter how many times I saved and existed as an example.
Yes, when you change the Item setup it will do “odd” things, so you want to be sure you do it right the first time. Still, after such a change, you can make corrections to physical inventory using the End of Day record once the Workperiod is closed.
It won’t let you blank it out once it has be en set. To get rid of it, set the Transaction unit to blank, and set the Multiplier to 0 (blank will not work here), then Save.
This was never a bug or issue it’s designed that way and it’s unlikely to be fixed due to how reporting works. You can define a new item and spell it the same maybe add one character to it. Use that new item from this point forward.
However it’s important you explain your problem so we are sure it’s the same.
Secondly, is there away i can capture purchases without using portions, I only want to know at the end of the month how much I have paid to each supplier, i am not really interested in the consumption rate and related cost as i will do that later
Probably because the Item is in the Purchase records and/or the Consumption records.
Inventory Item Purchases have no related Portion. That is, an Inventory Item does not have a Portion Property. A Portion is a Product Property, and us normally used in Inventory Recipes.
So your Inventory Purchases (quantity of an Inventory Item, and the Cost to Purchase) is generally constant for the Unit of the Item that you Purchase. The Product Cost is different. It is calculated from the Recipe, the quantity of Inventory Items the Recipe consumes, times the Price of the Inventory Item Base Unit used in the Recipe.
The direct answer to your question is “YES”. Inventory Purchases are what you have “paid to each supplier”, and in that case, the “Cost” is what you have Paid Out.
Define Inventory Items. Purchase Inventory Items using an Inventory Purchase Transaction. That’s it.
This Report will show your Purchases. Modify it as necessary for your needs: