R11.5.10: Customer prepayments including Tax.
Our requirement is to receive a customer prepayment and then to apply this prepayment automatically to the final sales invoice generated from OM. This all works fine using the OM payment functionality to generate an automatic receipt - unless there is tax involved. If the customer payment includes tax then we have to declare this tax on our next return. The standard OM/AR functionality doesn't cover this.
An alternative tried was to use the AR Deposit functionality - again tax is not included.
Does anyone have a tried and tested approach to achieve the requirement?
Thanks.