Your expectations will be met only if every single transaction has a tracking code.
With tracking code exception report, there is no transaction without tracking code for the period. Does it mean that credit note cost of sales can not affect tracking code?
As I have explained several times already, in this particular case, there was no cost of sales to deduct because the previous sales invoice was filled with items you did not purchase. This is an unusual characteristic that can occur with average cost inventory valuation.
Your explanation is well understood. Thank you for this.
@Tut Please sorry to tag you again on this topic, it is generating issues capable of undermining effectiveness of manager software if not resolved. Credit note 120 created on 19.03.2020 was deducted from the sales group but fail to deduct from the cost of sales on the the tracking code. The reason you gave previously was not the case here. Below are picture of the screen:
Please post a screen shot of a drill-down on the quantity owned for the inventory item GINO THYME 3.5G from the Inventory Items tab.
Also, did you enter a delivery note for goods (with negative quantity) to record receipt of the item from the credit note?
This is the drill down of inventory owned from inventory items. Also I did not active delivery note for goods.
To understand what happened, you need to look back further in time. Credit notes deduct amounts from the cost of goods account (Cost of Sales - Gino Spices in this case), by looking at the most recent sales adding up to the same quantity. You normally sell this inventory item a few at a time. But on 19/03/2020, you issued a credit note for a large quantity, 256. So you will need to examine the quantity owned history to determine which sales invoices and receipts account for 256 prior units sold.
I suspect you will discover the same situation as the first case we discussed, but not in so short a time period. If past sales do not furnish a basis for crediting the cost of 256 units on 19/03/2020, Manager will delay posting.
This is serious! I have checked the past sales of the item and their was sales of 200 and 100 to the same person in two different time prior to 19/3/20 and the person return this 256 from it. Even other credit notes of 2 or 3 qty that was done during the month did not reflected, It does not even have credit side column and all credit notes for the month did not reflect also.
Please I discovered from my findings that the credit notes deduct amount from the total cost of sales of all the tracking code but it does not deduct from individual tracking code.
That is not what matters. Manager does not track cost of goods to the individual customer level. It tracks average cost and uses the current average cost when it debits the cost of goods. It uses the most recent sales to any customer when it credits cost of goods from a credit note.
We have exchanged 31 posts on this topic. I have modeled your situation as well as I can. (I cannot reproduce the entire history of any of these inventory items.) All I can tell you is:
- No matter what income account I specify for an inventory item, its sales are posted there.
- No matter what expense account I specify for an inventory item, its cost of goods is posted there for all sales.
- When I issue a credit note, the appropriate income account is debited by the amount of the credit note. And the cost of goods account is credited by the cost of goods from previous sales.
- As long as I properly apply the same tracking code on both sales invoice and credit note, all the above actions are properly reported in a profit and loss statement covering the time period for that tracking code.
In summary, Manager is doing what it should. This is also what you think it should be doing. The fact that it is not means you have errors somewhere in your setup or transactions. I am sorry, but I cannot devote any more time to tracking them down for you. You will have to find them on your own. I suggest creating a test company and starting with simple transactions. Add complexity until you find the problem.