Results 1 to 4 of 4

Thread: Importing Cashbook Payments Batch into Pastel

  1. #1
    New Member
    Join Date
    Jan 2014
    Location
    Durbanville, Cape Town
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing Cashbook Payments Batch into Pastel

    I need some help in checking the format of my import batch. I used the Pastel help to get the format of the csv file yet I keep getting errors when I import. IT IS DRIVING ME CRAZY - if I wasn't already crazy LOL. Anyone who has successfully imported a cash payments batch into Pastel please have a look at my source file and my error messages and PLEASE help me!
    Thank you a MILLION in advance
    Attached Files Attached Files

  2. #2
    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 Anemari,

    I have had a look at the layout of your CSV file, and I can see that there are a number of mandatory columns that are not present, i.e. columns M through to R.

    M = Exchange Rate (set to 1)
    N = Bank Exchange Rate (set to 1)
    O = Batch ID (set as 0)
    P = Discount Tax Type (set as 0)
    Q = Discount Amount (set as 0)
    R = Home Amount (same as in column G)

    I have attached a modified version of your CSV file for you to try.
    Attached Files Attached Files
    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)

  3. #3
    New Member
    Join Date
    Jan 2014
    Location
    Durbanville, Cape Town
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville
    THANK YOU THANK YOU THANK YOU!!! It worked a treat!! Too thrilled for words! Thank you so much!!!!

  4. #4
    New Member
    Join Date
    Jan 2014
    Location
    Durbanville, Cape Town
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville
    May I be a pest and ask you if you have a csv file for AP imports? I used the help on Pastel and they have numerous fields for the header as well as the detail lines - this will take me hours to figure out!?
    Yours HOPEFULLY
    Anemari
    : )

Similar Threads

  1. Pastel Cashbook receipts
    By Vinruby in forum Accounting Forum
    Replies: 3
    Last Post: 27-Apr-18, 12:24 PM
  2. PASTEL V12 - SALES INVOICES DELETING FROM BATCH
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 18-Sep-13, 10:25 AM
  3. [Question] Pastel Cashbook Payments to incorrect account code year end Feb 2012
    By Anne in forum Accounting Forum
    Replies: 6
    Last Post: 12-Dec-12, 10:55 AM
  4. Replies: 1
    Last Post: 10-Dec-12, 11:37 AM
  5. pastel cashbook
    By tinach in forum Accounting Forum
    Replies: 6
    Last Post: 04-Jul-12, 07:20 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
  •