Resolving unallocated deposits status - MYOB EXO

[suretek]

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??

[Steve_Marriott · Accepted solution]

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.