Customer Journal entry

SOLVED
Hello,
This was raised to me by my accountant.
We have a payment which has been allocated to the wrong customers account in A/R and we would just like to reallocate to the correct one.
We have only found the way throug separately creating a debit journal on the one account and a credit journal on the correct account, but it's not ideal.
here's the query we would like to have an answer for:
*********
Dear SAGE South Africa,
Please can you help me in the following regard.
I am using SAGE 100 Evolution.
I can't find a way to do a customer journal entry.
Journal entry:
                                      Dr                       Cr
Westcliff                   1863
     Four Seasons                                   1863
How do I implement this?
yours sincerely
***********
thanks for any help
Pedro
Parents
  • +1
    verified answer

    Hi Pedro

    No problem at all.

    The only real solution for this type of query is to do the following:  BUT BACKUP THE COMPANY BEFORE STARTING! 

    1. Go to AR | Maintenance | Transaction Types 

    2. In here open/edit the JD (journal Debit) transaction type 

    3. On the left of the screen the Debit / Credit option should be on Debit

    4. On the top right the  Debit Ledger Account should be your Receivables Control account (or equivalent account name that you use) 

    5. Below it the Credit Ledger Account should be the Suspense account 

    6. No Tax account should be selected

    7. If any changes were made, save the it (click OK)

    8. Now also check out the . AR | Maintenance | Transaction Types | JC  - Journal Credit transaction type.

    9. The JC must be the exact opposite of the JD (refer to steps 3 - 6) e.g. on the left of the screen the Debit / Credit option should be on Credit

    10. If any changes were made, save the it (click OK)

    11. Now capture a AR | Transactions | Journal Batch as follow:

        a) On the first transaction line select the wrong customer (Cust. A) for which the payment was wrongly processed earlier

        b) Select the JD transaction type on this transaction line and complete the line with the correct date, reference, description (no VAT entered on          the line) 

        c) On the second transaction line select the customer  (Cust B) for which the payment should have been processed originally, 

        d) Select the JC transaction type on this transaction line and complete the line with the correct date, reference, description (no VAT entered on          the line) 

    12. Now process the AR Journal batch 

    13. Cust A should now have a higher balance and Cust B should have a lower balance as expected. 

    Kind Regards

    Bennie 

Reply
  • +1
    verified answer

    Hi Pedro

    No problem at all.

    The only real solution for this type of query is to do the following:  BUT BACKUP THE COMPANY BEFORE STARTING! 

    1. Go to AR | Maintenance | Transaction Types 

    2. In here open/edit the JD (journal Debit) transaction type 

    3. On the left of the screen the Debit / Credit option should be on Debit

    4. On the top right the  Debit Ledger Account should be your Receivables Control account (or equivalent account name that you use) 

    5. Below it the Credit Ledger Account should be the Suspense account 

    6. No Tax account should be selected

    7. If any changes were made, save the it (click OK)

    8. Now also check out the . AR | Maintenance | Transaction Types | JC  - Journal Credit transaction type.

    9. The JC must be the exact opposite of the JD (refer to steps 3 - 6) e.g. on the left of the screen the Debit / Credit option should be on Credit

    10. If any changes were made, save the it (click OK)

    11. Now capture a AR | Transactions | Journal Batch as follow:

        a) On the first transaction line select the wrong customer (Cust. A) for which the payment was wrongly processed earlier

        b) Select the JD transaction type on this transaction line and complete the line with the correct date, reference, description (no VAT entered on          the line) 

        c) On the second transaction line select the customer  (Cust B) for which the payment should have been processed originally, 

        d) Select the JC transaction type on this transaction line and complete the line with the correct date, reference, description (no VAT entered on          the line) 

    12. Now process the AR Journal batch 

    13. Cust A should now have a higher balance and Cust B should have a lower balance as expected. 

    Kind Regards

    Bennie 

Children
No Data