Resolving unallocated deposits status - MYOB EXO
We are in the process of consolidating our GL reports and one last area in the GLReceivablesReconciliation report is "Unallocated Deposits". It appears that on closer inspection of the function being used via the clarity report that is displaying all entries when 'deposit_status = 1'.
According to EXO Documentation, this value is set to 1 if the payment is a deposit. We have some entries in DR_TRANS table that have a deposit_status 0, 1 or 2. So where is it referencing this value from? Is this just the "Payment Type" value being used??
Hi suretek
I found this posting in another forum board so will repeat it here. Hope it helps:
Sales Order with Deposit, post to the GL
Dr Bank
Cr Deposits Received Control
(At this point the deposit status is 1)
Convert to debtor invoice and allocate deposit to invoice, post to the GL
Dr Debtors Control
Cr Sales
Cr GST
Dr Deposits Received Control
Cr Debtors Control
(At this point the deposit status updates to 2)
Steve.
