PROCESSED CASH BOOK INTO WRONG BANK ACC BUT NOT UPDATED (PASTEL XPRESS V14)

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dido3436
    Junior Member
    • Sep 2015
    • 11

    #1

    [Question] PROCESSED CASH BOOK INTO WRONG BANK ACC BUT NOT UPDATED (PASTEL XPRESS V14)

    Ok, so I've done something rather stupid! We have 2 bank accounts for our cash books: an old bank account that is no longer used and a new one that I process into daily. I have processed lots of receipts into the old bank account, but luckily not updated yet. Is there a way to copy and paste these receipts into the correct cash book, or is the easiest thing to just debit the total amount receipted and continue from now in the correct cash book?
  • Kevin Smith
    Silver Member

    • Aug 2018
    • 262

    #2
    In the wrong cashbook, click on batch ... export. Save the file as cb.txt in a location where you can find it. Open the file in notepad. You will see your account number for the wrong cashbook, eg "8410000". Press Ctrl and H (replace). Replace "8410000" with "8420000" (the correct cashbooks GL account number) and select replace all. Save the file as CB1.txt. Open the correct cashbook, select batch import, and bring in the file. If it imports cleanly with no errors, go to the old cashbook, select batch, delete batch and confirm. In the correct cashbook, you will have to go and match each transaction again back to the invoices, if you use open item processing. Go to each line and press F3, then complete the matching. Once done, you can update the batch.
    Kevin Smith
    Sage Pastel Support Consultant
    KS Consulting
    www.ksconsulting.co.za

    Comment

    Working...