Customer Journal entry

Question

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

Bennie Pienaar · Accepted 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

Sage 200 Evolution

Customer Journal entry

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING