Results 1 to 3 of 3

Thread: Pastel Partner to Excel Auto mapping

  1. #1
    Email problem
    Join Date
    Mar 2009
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Red face Pastel Partner to Excel Auto mapping

    We need to export our sales orders or invoices AUTOMATICALLY into the attached Excel file layout, which will then be FTP’d to another premises and imported into a system called Ancosys.

    We will not be able to format each invoice manually as this will take way too long considering our volumes, thus causing delays in deliveries and potential errors.

    Please advise asap how to go about doing this.
    Attached Files Attached Files

  2. #2
    just me duncan drennan's Avatar
    Join Date
    Jun 2006
    Location
    Cape Town
    Posts
    2,642
    Thanks
    119
    Thanked 94 Times in 77 Posts
    If no one here is able to help, then you might be interested in Neville Bailey's Double Entry forum which is specifically for Pastel and these type of issues (also free access).
    [SIGPIC]Engineer Simplicity[/SIGPIC]
    Turn ideas into products | The Art of Engineering blog

  3. #3
    Full Member
    Join Date
    May 2009
    Location
    Fourways
    Posts
    25
    Thanks
    0
    Thanked 2 Times in 2 Posts
    hi

    Not sure if I am understanding correctly. you have a system using Pastel, you want to export data, and then re-import that data into a system called Ancosys. Is that correct or is it the other way round. If it is the first way, is the excell file the structure that is need for Ancosys. does the system say if the file needs to be tab, 'Comma' delimted, or just and ASCII file.

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
  •