Average costing: Same day invoices problems

Soulz

Hi,

I have a scenario which i require some advice:

My item is using average costing method.
On the SAME day, i post some transaction in the following sequence:
1. Purchase order of new item A: Qty = 10, Unit cost = $2 (recieved & invoiced)
2. Sales order of item A: Qty = 5, Unit price can be any amount (shipped & invoiced)
At this point of time, my cost of goods sold = $2 each & stock on hand = $10.
3. Purchase order of item A: Qty = 5, Unit cost = $3 (recieved & invoiced)

Now the problem comes after i post the second purchase invoice. My cost of goods sold for my original sales invoice is automated adjusted to $2.33 each.
Logically, my cost of goods sold should remain at $2 each since my sales invoice is already posted. But somehow, standard navision will do its own adjustments if the invoice happens on the same day.

Can anyone advise how to keep my cost of goods sold at $2 each?

Greatly appreciate...

Alex_Chow

Average cost is calculated by day.

What Navision calculated is correct because you have 2 purchases that constitute the average cost to the sales invoice.

Soulz

Alex Chow wrote:

Average cost is calculated by day.

What Navision calculated is correct because you have 2 purchases that constitute the average cost to the sales invoice.

Yes i realise that average costing is calculated by day. :?
But my sales invoice has been posted already and the second purchase invoice comes after this. If the second purchase invoice is posted on the next day or any date in future, it will not adjust my sales invoice. But it will adjust my sales invoice if the second purchase invoice is done on the same day.
Is there anyway which i can customise or do so that it will not affect my sales invoices which has already been posted? My customer does not want any posted sales invoices to be adjusted as they need to calculate their own selling price based on a certain profit margin and this will affect them if the second purchase invoice adjust their unit cost. ](*,)

ara3n

they shouldn't use avg costing method. I wouldn't recommend changing the code for costing method.

Alex_Chow

It has to be the weight average of the invoices posted for a day, How will Navision know if an invoice was suppose to be entered before or after your posting of the purchase invoice?

If your customer doesn't want average cost, then they're not on average cost, like ara3n suggested.

Customizing costing is one way to financial hell...