Skip to Content
This question has been flagged
2 Replies
1379 Views
Avatar
Silvana Ubriaco 
Hello! 

We are having a problem that we don't know how to solve.

We enter a purchase order with some costs zero and some incorrect.

For this reason the margins on sales are incorrect.

We use average cost for all our products.


Needed :

1) Cancel the purchase order entered with the incorrect costs.

2) enter a new purchase order with the correct costs.

3) Recalculate the margins. I currently have more than 200 invoices with the incorrect cost.

Can someone guide me?

Thank you


Avatar
Discard
Avatar
Silvana Ubriaco
Author Best Answer

Thank you for your response!!!


If I use the option 1, how can I recalculate the margins of the invoices already emited?
I have a lot of products already saled with wrong cost and I need to coorect thems.

Thank you very much Silvana


Avatar
Discard
Balagopal R

For the Margin recalculation, I am not sure. But if you are using the second option, the COGS entries will be posted automatically even for the sold quantities.

Better you test it in some local database before doing it in the live

Silvana Ubriaco
Author

I cant use the second option because mi purchase order has lots of products, some of them with cost zerro and others with wrong cost.
Thaths why I have a lot of invoices with margin zero and others with wrong margin.

I need to correct and recalculate.

And Y don't know how.

Avatar
Balagopal R
Best Answer

Hello,

You can use 2 options,

Option 1

Return the Receipts (Incoming shipments) with the wrong cost items. Basically it same as canceling the Purchase order. Then you can enter the correct PO


Option 2

Enter the correct costs as a Landed cost against the incoming shipments. So, the valuation will be updated on all products. Kindly note, the landed cost will be applied to all the items on that shipment.

Avatar
Discard