Results 1 to 9 of 9

Thread: General Ledger Creating Sub Accounts

  1. #1
    Email problem
    Join Date
    May 2015
    Location
    Cape Town
    Posts
    9
    Thanks
    1
    Thanked 0 Times in 0 Posts

    General Ledger Creating Sub Accounts

    I want to create a sub account for 2750/000 Interest Received, it has transactions (which I've done before a seriously long time ago). In Pastel help it says the following:

    "If you have a main account that has transactions, and you need to create a sub account for this main account, you can do so.
    Main accounts that have sub accounts cannot have transactions.
    The system transfers the transactions from the main account to the first sub account you create."

    I think, cool, this is what I remember. So I go ahead and try it out, but alas, it comes up with this:

    "you cannot create sub account for this main account, as it in use in an open batch"

    Went to check and there are no open batches?

    Am I missing something?

    Assistance desperately needed

    Thanx
    Caroline

  2. #2
    Email problem
    Join Date
    May 2015
    Location
    Cape Town
    Posts
    9
    Thanks
    1
    Thanked 0 Times in 0 Posts
    By the way, I've been using Pastel for some 20+ years, love it. I usually work things out for myself and I don't need their hectically expensive "support" for the once in a Blue Moon when I get stuck :b

  3. #3
    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 Caroline,

    It is possible that your company folder may contain a "phantom" open batch file, which would cause you to receive the message that there are open batches, even though you don't have any.

    Open your company folder and check if there are any files with a name containing the characters btn and with the numeric file extension, for example accbtn01.001. Cut and paste any such files out of your company folder and see if that solves the problem.
    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)

  4. #4
    Email problem
    Join Date
    May 2015
    Location
    Cape Town
    Posts
    9
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi Neville

    Thank you for replying! I've checked the folder and it has no file containing btn. I've copied what is in the folder, please see below:

    Click image for larger version. 

Name:	Craiter.jpg 
Views:	463 
Size:	94.4 KB 
ID:	5581

  5. #5
    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 Caroline,

    I see that there are three files starting with accbtr - move them out of the company folder and see if that solves the problem.
    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)

  6. Thanks given for this post:

    Carolinedj (11-May-15)

  7. #6
    Email problem
    Join Date
    May 2015
    Location
    Cape Town
    Posts
    9
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Neville, thank you so much!!! You're a star!! It worked

    Greatly appreciated.

    Caroline

  8. #7
    New Member
    Join Date
    Jan 2020
    Location
    Welkom
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I'm a bit late to this party, but I have the same problem, only I can't see any of the btn/btr files you mentioned that I need to remove. I attached a screenshot of the files I have

    Click image for larger version. 

Name:	Capture.jpg 
Views:	217 
Size:	70.0 KB 
ID:	7755

  9. #8
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Go to view - open batches. It will show you what batches are open. Because there are no batch files reflecting in your list, the account could have been used in your Customer or supplier document batches (Invoice, Credit Note, etc). If you update all open documents does it still give the same error?

  10. #9
    New Member
    Join Date
    Jan 2020
    Location
    Welkom
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    No open batches. I updated everything, and ran a data integrity when the problem first started. It's still giving me the error. Also, it's not just on one code, I have two that give me the same error at this stage. Don't know if I'll come across more.

Similar Threads

  1. [Question] Importing General Ledger Journal into Pastel Xpress V 12
    By Stevie Mac in forum Accounting Forum
    Replies: 18
    Last Post: 02-Mar-20, 07:24 AM
  2. Pastel General Ledger importing
    By osbert in forum Accounting Forum
    Replies: 8
    Last Post: 10-Dec-15, 10:23 PM
  3. Balancing Suppliers Accounts-Creating Journals
    By Lavine in forum Accounting Forum
    Replies: 0
    Last Post: 01-Apr-15, 04:14 PM
  4. Debtors Ledger and General Ledger
    By Simimano in forum Accounting Forum
    Replies: 1
    Last Post: 15-Apr-13, 03:24 PM
  5. Create General Ledger accounts for take-on balances
    By Elize7 in forum Accounting Forum
    Replies: 5
    Last Post: 23-Jun-12, 09:26 AM

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
  •