Last Cost of the item picking value before discount is applied
In ARL 2020.3 version, when you use the Disc% when receiving a suppliers invoice the last purchase price isn't correct. It uses the Price before discount and not the Total divided by the qty
We are aware of the scenario where it behaves the same in AR Classic(v19) versions as well.
But this caused the Items list and items profit margin report are incorrect AT THE VERY LEAST THEY SHOULD MAKE USERS AWARE OF THE PROBLEM. I have hundreds of items with incorrect last cost. The cost of an item is the price less the discount. This is reflected in the cost of goods sold in the MYOB software but not the last cost, it is incorrect and an error in the software
Hi Tejasa
In terms of the Last purchase price of an item, the system will pull the value that was shown in the Price field on the last entered purchase of that item. As its a direct copy of the Price field, discounts added to that item will not be factored into the value as these don't impact the price field for they occur after the price of the item is added to the purchase.
To my knowledge, this is not an area that we are looking into for the future. Although, should you be requiring the Last purchase price to include those discounts, after recording the required transaction you are welcome to enter another purchase for that item with the required amount as the price. The user can then delete this purchase and it will retain the last purchase price from the now deleted purchase.
