Forum Discussion

suretek's avatar
suretek
Contributing User
6 years ago

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.

     

  • 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.