Sage Pastel • Overview of Deleting Customer and Supplier Accounts

Comments ( 19 )

  • Chere

    A customer paid a deposit an 2014 his trip was postponed and this amount was cleared out in a 999 account how do I now reallocate this money to this customer who came and visited in 2015

    • Hi
      You go to Process… Journals… Customer journals.
      Debit the customers account with the amount, and the contra account will be the 999 suspense account.

  • Samantha


    I mistakenly captured an invoice at an incorrect amount, how do i delete it from the system.

    • Hi Samantha,
      There is no way to delete a document from Pastel on a live system. Its for audit trail purposes, and to stop any “funnies” happening, and to cover yourself.
      You have to do a credit note, for the same amount as your invoice. Try using the same date, and the same item code / GL code, and update it.
      Then make a new invoice with the correct amount.

  • Andre

    How do I transfer an outstanding balance from a customer account (that is inactive) into a bad debt account?

    • Hi Andre.
      Go to a Customer Journal.
      Choose your correct period, choose the customers account, … description…amount in credit… and contra the bad debts account.
      This will take it off their account, and onto the ledger.
      Not hard to do.

  • I have old customers who have not traded since 2010. I want to delete them but every time I try I get the message “This customer code ****** cannot be deleted because transactions or balances exist for this customer” _ I have tried every thing but nothing works. Any suggestions please. I am using Pastel Express Version 11. Many thanks

    • Hi Pat,
      In answer to your question. As you know you cannot delete anything in Pastel for 2 years.
      For audit trail purposes, and because Pastel always keeps the last 2 years available to view in that company.

      By this they mean:
      1 – You cannot have processed anything on that customer for two years (at all).
      2 – You cannot have any balances on that account.
      I know other consultants will disagree with me, but I’ve seen accounts that haven’t been touched for five years, but because they have a balance Pastel wont delete them.

      So, to make life interesting, if they have balances on their accounts journalise these out, to a zero.
      Then forget all about those accounts. And in 3 years time you will have the joy of deleting them 🙂

      Have a good easter.

  • Trisha


    There are some clients who have small credit balances but now no longer trade with us. I was thinking of doing a customer journal and using the contra account sundry income , would this be correct ?

    • Trisha


      Once i have completed the customer journal removing the credits from clients who no longer trade and using the sundry income account as contra account. Would another journal need to be done to clear the sundry income account ?

    • Trisha

      Hi Bev

      Thank you for the feedback. Would i need to do another journal to clear this from the sundry income account ?

    • Hi Trisha.
      That sounds like a good plan 🙂
      A customer journal is correct. The contra account sound right, but I ask that you always check with your accountant, or auditors as they do the financials, and each one has their own way of doing things.

    • Trisha

      Hi Bev

      Thank you for feedback. Would there be another journal that would need to be done to clear Sundry income ?

    • Hi Trisha
      Sorry for the late reply.
      No, not from your side.
      If your accountant wants to clean it up at year end, he will provide the journal entries you would need to make.

  • Howard

    Good Day,

    I am hoping you can assist here,

    It was brought to my attention that Fraud was being committed with commissions not being allocated to the correct sales person.

    It was noticed that sales figures had been ‘manipulated’ the day before month end rollover , even when the rollover period fell on a weekend when nobody should have been in the office.

    Is there a way in which to see who accessed the system to make these changes and ultimately trace the culprit?

    Will the Audit trail show this detail?

    • Hi Howard
      This reply is so late that I’m sure you found your answer already.
      My apologies.
      Good thing you picked this up.

      I have been busy lecturing Pastel to UNISA students, and this is one of the lessons that’s drummed into them, funny enough.

      The audit trail would tell you who was in that batch before it was updated, but unless everybody keeps their passwords strictly to themselves, then anybody could log in on another user and quickly change the rep codes.
      If you really want an answer, its probably better to get an IT techie to look at the IP address to see which machine was being used to access the server.
      But this means a lot of work.

      So from now on, everybody changes their passwords, and user rights get set up strictly, and they get held accountable even if they were not the culprit.

      Best regards

  • Good Day,

    In connection with deleting inactive accounts. I beg to differ. I have accounts which have been dormant for more than 4 years but Pastel would not allow me to delete these accounts.

    • Hi Anneke
      My replies are so late. I apologise.

      I have to say I beg to agree with you.
      All the documentation states it can be done, but I’ve not had it happen for me. And you end up getting this massive list of unused accounts.

      As a customer or consultant, we both don’t have access to the programmers. Its a bit like trying to get hold of a supervisor at Telk0m 😉

      We are told that if you want something changed you have to email [email protected].

      Have a good day

  • Mace . B

    Hi , I accidentally added a GL account as a bank account (cash book). I don’t want an additional cashbook how do I delete or remove it?

Give a comment

Thanks, please reply using the email I have supplied.

This site uses Akismet to reduce spam. Learn how your comment data is processed.