Hi all,
I found there is a cost variance when under receipt in PO with Voyage.
When it is under receipt in PO with voyage, an additional PO will be created and product receipt for return will be posted automatically.
I reconciliated the stock cost between Stock value report and TB, and found there is a discrepancy.
When I checked the voucher transactions and stock value report storage, I found the discrepancy was caused by Product receipt posted for this under receipt.
The discrepancy amount is 246.58
Voucher
Stock value
Apparently, the system doesn't update the stock value for 'Purchase expenditure, un-invoiced'.
I was checking where those amount came from.
The amount 153.42 comes form the current stock cost.
The amount 246.58 comes form the trade agreement.
When the system automatically creates and posts product receipt for Purchase credit, the system uses the price 246.58 that was set in trade agreement on PO line.
That's why 'Cost of purchase material received' and 'Purchase expenditure, un-invoiced' were posted with different amounts and makes the discrepancy between Stock value report and TB.
My question is ----- How to fix it?
Possible 1: As Purchase expenditure, un-invoiced, Purchase expenditure for product, Cost of purchased materials received and Cost of purchase materials invoiced are using the same ledger account, to prevent this issue, both Purchase expenditure, un-invoiced and Purchase expenditure for product should use a separate ledger account with Cost of purchase..., is it correct?
Possible 2: As by default, the PO is using the trade agreement price, can we change the default price from trade agreement amount to Current stock cost for Purchase credit only? For normal purchase order, the trade agreement price is still retrieved on the line by default.
543
Share
Report
All responses (
Answers (
