Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Can't block or delete GL Account (not control, no transactions, no balance)

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question Can't BLOCK old GL account

    Hi there,

    Software: Sage 50c Pastel (aka Pastel v.19)

    I need to block the below GL sub-account "2000/005 Electricity". When I try to block it I get the error "This general ledger account has a sub account that is used in an open batch and therefore cannot be blocked" But I don't have any open batches. And, I'm trying to block a SUB-ACCOUNT 2000/005... so I'm not sure why the error tells me I'm trying to block a GL Account which has a Sub-Account ?

    Question: Does anyone know what I need to do in order to be able to block this GL Sub-Account? 2000/005

    Click image for larger version. 

Name:	Screenshot2.png 
Views:	322 
Size:	43.4 KB 
ID:	7526


    Thanks in advance,
    Michelle


    UPDATE: Ok... I think I have the answer after reading the help file:
    However, even a supervisor cannot block an account if it is a control account, or a main account whose sub account is a control account, or if you are using the account in an open batch when you attempt to block it.
    The SUB-ACCOUNT I'm trying to block is a control account. I *think*.

    Click image for larger version. 

Name:	Screenshot3.jpg 
Views:	277 
Size:	82.7 KB 
ID:	7527
    Last edited by michellepace; 06-Apr-19 at 06:38 PM. Reason: formatting

  2. #2
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question Can't block GL Account (*not* a Control Account)

    Hi there,

    Software: Sage 50c Pastel (aka Pastel v.19)

    Here I'm trying to block a GL Account I don't want to use anymore. I don't have any open batches (I checked via View > Open Batches) and this GL Account isn't a control account. Does anyone have any ideas as to why I still cannot block this GL Account? I don't even have a balance for it.

    Click image for larger version. 

Name:	Screenshot4.png 
Views:	272 
Size:	45.1 KB 
ID:	7528

    Thanks once again in advance,
    Michelle
    Last edited by michellepace; 06-Apr-19 at 06:38 PM. Reason: software

  3. #3
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts

    Question Can't block or delete GL Account (not control, no transactions, no balance)

    Hi there... sorry I know this is the 3rd time I'm posting about this. I've kept it into three different threads because it seems to be 3 different scenarios.

    I'm at my wits end trying to work out the logic of not being able to DELETE or at least BLOCK this particular GL account.
    - there is not a balance
    - there are not any transactions (View > Detailed Ledger > Transactions .. nothing there for this account)
    - this is not a control account

    Why then can't I delete or block it? Is there some logic I'm missing perhaps?

    Click image for larger version. 

Name:	Screenshot4.jpg 
Views:	322 
Size:	59.8 KB 
ID:	7529

    Thanks again,
    Michelle

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Michelle,

    There are a couple of possibilities that could be causing this.

    There is possibly that there is some old document history in the system that has reference to that sub-account, which is preventing you from deleting the account. Pastel maintains all document history in perpetuity, unless you choose to purge old document history from time to time. You can purge old document history by going to Change...Delete History/Clear Files...Delete/Consolidate Transactions...3+ Years Ago.

    Another possibility is that there may be some stray open batch files in your company folder that should have disappeared after updating them, but have not. After confirming that there are no open batches under View...Open Batches, open your company folder and look for any files with the name accbtn*.0** and then delete them.

    If neither of the above yields a positive result, let me know and we can set up a quick TeamViewer session so that I can have a more detailed look.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  5. #5
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    You also need to check if there are recurring batches which may reference these accounts.

  6. #6
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts
    Hi Neville, thank you for your reply.

    Quote Originally Posted by Neville Bailey View Post
    There is possibly that there is some old document history in the system that has reference to that sub-account, which is preventing you from deleting the account. Pastel maintains all document history in perpetuity unless you choose to purge old document history from time to time. You can purge old document history by going to Change...Delete History/Clear Files...Delete/Consolidate Transactions...3+ Years Ago.
    I've did this a month ago. It really shrunk the size of my newly created backups!

    Quote Originally Posted by Neville Bailey View Post
    Another possibility is that there may be some stray open batch files in your company folder that should have disappeared after updating them, but have not. After confirming that there are no open batches under View...Open Batches, open your company folder and look for any files with the name accbtn*.0** and then delete them.
    I was holding out hope for this one but unfortunately the only files I can see that come close to the name you described is ACCBTR1.001 and ACCBTR27.001. I've attached a screenshot just in case I'm missing something.

    Quote Originally Posted by Neville Bailey View Post
    If neither of the above yields a positive result, let me know and we can set up a quick TeamViewer session so that I can have a more detailed look.
    Thanks Neville, that's very kind of you indeed. I'll chat with the ladies at work next week and see when we can have all our batches cleared out again and get in touch via private message to arrange. Thank you very much!

    Click image for larger version. 

Name:	screenshot - files.jpg 
Views:	269 
Size:	48.2 KB 
ID:	7542

  7. #7
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by michellepace View Post
    I was holding out hope for this one but unfortunately the only files I can see that come close to the name you described is ACCBTR1.001 and ACCBTR27.001. I've attached a screenshot just in case I'm missing something.
    Those files refer to recurring batches. You have one recurring batch using Entry Type 1 and another using Entry Type 27 - have a look at each of those recurring batches to see if there is any reference to the sub-accounts that you want to delete.


    Quote Originally Posted by michellepace View Post
    Thanks Neville, that's very kind of you indeed. I'll chat with the ladies at work next week and see when we can have all our batches cleared out again and get in touch via private message to arrange. Thank you very much!
    Whenever you are ready...
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  8. #8
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    131
    Thanks
    15
    Thanked 3 Times in 3 Posts
    Hi Kevin and Neville, sorry but I actually don't know what a recurring batch is or where to find it. I can only guess that perhaps one of our cashbook mappings is mapping to the old GL account 3850/011 which I want to block and/or delete.

    Quote Originally Posted by Neville Bailey View Post
    Those files refer to recurring batches. You have one recurring batch using Entry Type 1 and another using Entry Type 27 - have a look at each of those recurring batches to see if there is any reference to the sub-accounts that you want to delete.
    Neville I'm pulling at straws here... do you mean that it has something to do with my Nedbank and Investec cashbooks since they are entity type 1 and 27? I've checked their cashbook mappings but see nothing mapping to 3850/011 (the GL account I want to block/delete). I'm not familiar with re-occurring batches, where else can I have a look?

    Click image for larger version. 

Name:	Entity Types 1 and 27.jpg 
Views:	240 
Size:	66.7 KB 
ID:	7546

    In a desperate attempt... Neville I "deleted" the files ACCBTR1.001 and ACCBTR27.001 as shown in the screenshot below. I then tried to block the accounts I wanted to, and I could. What was surprising is that the last modified date of these files is 2015. My Pastel company only needs to go back 2 years.

    Click image for larger version. 

Name:	Files.jpg 
Views:	231 
Size:	48.7 KB 
ID:	7547

    So Neville and Kevin my question is now this:
    If I only need two years history, and both ACCBTR1.001 and ACCBTR27.001 were last modified in 2015... can I simply and safely delete those files and thus my problem of not being able to delete old GL Accounts is solved! ?


    Or I might be completely off track again
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Entity Types 1 and 27.jpg 
Views:	183 
Size:	66.4 KB 
ID:	7545  
    Last edited by michellepace; 08-May-19 at 03:37 PM.

  9. #9
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Yes - they can be deleted safely. If the recurring batch was being used, you would have updated entries to those GL accounts, and then you wouldn't have been able to delete the accounts. If you deleted a recurring batch in use by another user, it would have to be recaptured. Those transactions aren't committed to the database until the batch is updated.

  10. #10
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Michelle,

    It is possible that the two recurring batches were set up some time ago, and have not been used. The fact that you don't know what they are seems to confirm that. Perhaps someone else worked on your set of accounts before you and used recurring batches?

    Recurring batches are "template" batch structures that you can use to populate regular batches on a recurring basis, normally monthly. In the case of the cashbook batches, they can be found by clicking on the "Batch Type" field at the top of the journal, and then selecting "Recurring batch entry". If you have removed those two files, nothing will show.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

Page 1 of 2 12 LastLast

Similar Threads

  1. VAT Control Account opening balance in Pastel
    By gcbsouth in forum Accounting Forum
    Replies: 5
    Last Post: 07-Feb-19, 04:58 PM
  2. [Question] Data Integrity - Verify Balance & Transactions OUT of balance
    By kevvie in forum Accounting Forum
    Replies: 2
    Last Post: 27-Jun-18, 01:49 PM
  3. [Question] Pastel Tax type report and Balance as per Tax Control Account
    By Heidivf in forum Accounting Forum
    Replies: 2
    Last Post: 23-Oct-15, 01:59 PM
  4. [Question] Vat control account balance, pastel
    By Jackievdw in forum Accounting Forum
    Replies: 6
    Last Post: 19-Feb-14, 10:55 AM

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •