Hi Mike
That is ok if your order becomes a sale in a short time.
My S/O can be up to 12 months before they become a sale. Reconciling my deposit-held account can sometimes be frustrating, but that is what it is.
What I have come up with is:
1. Create your sales order as usual.
2. Create a customer service invoice with tax as (NT)
(I use the s/o no. with a C, e.g. 123C, to keep track if needed)
with the deposit amount to the liability account for customer deposits.
In the following line, do a (-)credit for the same amount to the bank account where the money was deposited.
This will be a nil invoice. It puts the deposit into the deposits held and the banking account to be reconciled.
3. When the S/O becomes a sale.
a. I use the S/O no. as the invoice no.
b. Create a credit invoice for the deposit amount to Customer deposits held. Tax (NT)
c. Allocate credit to the customer's invoice.
The Customer Held account has two entries, DR and CR.
The invoice has the correct balance after the deposit has been allocated.
I hope this helps
