I am using CO based COPA. In the Sales Order, I have a condition type to consider the freight costs (approximate value). Say, my revenue is $1000; so I am taking my freight costs as 10% ($100) which makes my net revenue as $ 900. Both $1000 & $100 flows into COPA and revenue in COPA is $900.
Now, when the frieght vendor sends the invoice, the amount is $150 instead of $100 which I post against a CC. So, in FI my net revenue is $1000 - $150 = $850 but in COPA it is $900. How do I reconcile COPA with FI under such circumstances?
Any help would be appreciated and points awarded.