Results 1 to 3 of 3

Thread: Importing Budget into Pastel Express11

  1. #1
    New Member
    Join Date
    Feb 2015
    Location
    Mpumalanga
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Importing Budget into Pastel Express11

    Hi, I want to import budgets into pastel.
    When i import the .csv file, it says the following: Line1: Account does not excist.
    The company has 20 branches.
    If i export the budget form pastel to get the layout and the format, it is as follows on the .csv:
    "0800154"
    "0800701"
    but when i open it in excel it is as follows:
    0800154
    0800701

    I have added the '0' infront but when i save it as .csv, the '0' is going away.
    Will love to get help on this.

    Tanya

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 Posts
    That's one of the irritating things about CSV files when you open them in Excel - all leading zeroes disappear!

    When you open the CSV file, insert the zero in front of the code, but with a single quotation mark in front of the zero, i.e. '0 not only 0

    Then save the CSV file but import it before you reopen it again, otherwise you are back to square one again.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

    *** 20% DISCOUNT ON PASTEL XPRESS / PARTNER SOFTWARE UNTIL 15 DECEMBER 2017 ***

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

  3. Thanks given for this post:

    Tanya Kruger (17-Feb-15)

  4. #3
    New Member
    Join Date
    Feb 2015
    Location
    Mpumalanga
    Posts
    4
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank you, was not sure if I can do that because it had the " infront.

Similar Threads

  1. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  2. [Question] Importing into Pastel
    By mtpocket in forum Accounting Forum
    Replies: 11
    Last Post: 04-Nov-15, 11:03 AM
  3. pastel importing
    By loydbk in forum Accounting Forum
    Replies: 2
    Last Post: 08-Aug-14, 08:41 AM
  4. BUDGET INPUTTING IN PASTEL PARTNER
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Mar-14, 01:28 PM
  5. Importing into Pastel Startup V12
    By ultramel123 in forum Accounting Forum
    Replies: 3
    Last Post: 11-Apr-13, 08:59 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
  •