I would like to have some help in understanding how Good Receipts can affect the Cost of Goods Sold. The example is: I have a Purchase Invoice from a supplier who has shipped their items to me. Let’s say 10 glasses. When the glasses arrive I see that 2 are broken or missing. The supplier might send…

You have combined quite a lot of questions into your post. Let’s start with the idea that if goods arrive broken, you should get a credit note from your supplier, not write anything off. The credit note will reduce the quantity in inventory and adjust the average cost as required. If you are using…

Hi @Tut . Thank you for the feedback. [image] Tut: Let’s start with the idea that if goods arrive broken, you should get a credit note from your supplier True, but sometimes the value is not worth the pain of asking for a Credit Note. More importantly there is the case of lost/stolen items fo…

[image] mauroskov: does Manager only uses the received quantity to calculate the average cost Yes, because if you are using goods receipts, the items are not in Inventory on hand until the goods receipt is entered. Now, if you are not using goods receipt, Manager assumes you have it in stock …

So Goods Receipts are only used when they are activated in “Customize”? Could they be deactivated at this stage when we have already several of them in our database?

no. you cannot disable a tab when you have transactions in them. you can delete all the transactions in the tab and then disable it.

@Tut I think I have an issue here with the above example. Based on my Excel calculations (which I use for pricing purposes before computing all data in Manager) the cost of the items should be at least 50% higher than what they are in Manager. And usually what I have in Excel and what I have in Man…

I have no idea what your Excel spreadsheet shows, so I cannot speculate on differences. What I can tell you is that average cost of inventory takes into account costs properly added, such as transportation. But it does not include costs of goods not received.

Thanks @Tut Yes I think we must have done something wrong and we have to recheck. Manager is always accurate in its calculations. I have another question related to this, sorry for bothering you so much… I started to use Manager in 2017. My main concern was again to get the right cost of goods i…

Actually I tried something and I do think there is a problem here. I added a Purchase Invoice for one of the items I am having troubles with. I added 1.000.000 RWF (€1.000) just to try. By doing this, the avarage cost increases by about 1.850 which is almost exactly 1.000.000 / devided by 534, whic…

@mauroskov , I believe the solution to your problem (if I understand everything you wrote correctly) lies in understanding differences between Manager and your previous accounting system. As you set up your starting balances for inventory items in Manager, you enter the quantity on hand and the aver…

Good receipts vs. Purchase orders vs. Items write-offs

Topic		Replies	Views
Inventory Average Cost	8	654	January 9, 2021
Cost of goods in bonded storage	6	2203	June 2, 2020
Purchase invoice & Goods receipt	6	2112	July 16, 2022
Zero cost of returned goods while having quantity	20	1411	December 4, 2022
Inventory on hand vs. bonded vs. to be received	14	326	May 30, 2023

Good receipts vs. Purchase orders vs. Items write-offs

Related topics