Results 1 to 3 of 3

Thread: CSV Import Invoices Pastel - Comments / Remarks Disappearing

  1. #1
    New Member
    Join Date
    May 2016
    Location
    Durban
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    CSV Import Invoices Pastel - Comments / Remarks Disappearing

    Dear Community

    I have created an import (.CSV) for Pastel Partner Invoices, and it almost works.

    For all the lines that I place with the 7 = Comments/Remakrs, it does not import.

    I have tried putting it before and after the 6 = GL Code line and it still does not bring it through.

    The other strange thing, is that the I place the Exclusive Amount and Choose 1 for 14%, The .CSV has this and yet it only brings in the Exclusive amount

    Customers - 20160606 - 0756.csv

  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
    I've had a look at your CSV file.

    There is missing data in your Detail lines.

    For each Detail line:

    Column B must have 0
    Column C must have 1
    Column D must have 0
    Column E must have 0
    Column G must have 0
    Column H must have 0
    Column I must have 0
    Column J must have '
    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
    May 2016
    Location
    Durban
    Posts
    7
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Thumbs up Solved

    Quote Originally Posted by Neville Bailey View Post
    I've had a look at your CSV file.

    There is missing data in your Detail lines.

    For each Detail line:

    Column B must have 0
    Column C must have 1
    Column D must have 0
    Column E must have 0
    Column G must have 0
    Column H must have 0
    Column I must have 0
    Column J must have '
    Hi Neville

    You are indeed correct. ;-) Everything imports.

    In fact at first I was having an excel export problem where the apostrophe was not showing in the .CSV, so I doubled up on the Apostraphe's and viola..

    Thanks Neville.

Similar Threads

  1. Import excel into Pastel
    By nikkidv in forum Accounting Forum
    Replies: 5
    Last Post: 20-Jul-17, 01:34 PM
  2. [Question] Pastel Xpress V11 CSV file layout to import Invoices
    By Braam in forum Accounting Forum
    Replies: 1
    Last Post: 06-Jun-16, 08:41 AM
  3. Pastel Forms Designer & Customer Invoices Import
    By DieBeer in forum Accounting Forum
    Replies: 6
    Last Post: 27-Jul-15, 09:16 AM
  4. [Question] Pastel Supplier Invoices Matching - Remove Credited Invoices
    By steffie250 in forum Accounting Forum
    Replies: 6
    Last Post: 10-Mar-15, 01:23 PM

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
  •