Results 1 to 10 of 10

Thread: Pastel Xpress Purchase Order Import

  1. #1
    New Member
    Join Date
    Nov 2011
    Location
    Cape Town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Xpress Purchase Order Import

    Hi everyone

    I have an Purchase Order application that is tacking all my PO, linked to suppliers and also linked to the warehouse, however now with the Business using Pastel Xpress I need to re-enter all the Purchase Orders every time the application created an PO, is there a way for my to import a PO as a batch to Pastel using an csv or something like that at end of each day?

  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
    Yes, it is possible to do so, provided that you have the correct CSV layout.

    To import a document batch

    1. Click the Batch button and choose the Import or Export option. The Export/Import window opens.
    2. The system uses the company directory for the import or export file. Enter the file name to use. You can use the Zoom icon to select an import file.
    3. Click the Process button to initiate the operation.
    4. If you are importing, the system validates the entire import file prior to processing. If the system detects an error, the entire import aborts - no records are imported. The system displays the error(s) it detects. You can correct these and then re-import the entire file.

    I have attached an PDF file, explaining what the layout requirements are.

    Another way of getting the layout is to export an existing PO into CSV format - you can then see how the CSV file must be structured.
    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. Thanks given for this post:

    geraldenek (10-Nov-11)

  4. #3
    New Member
    Join Date
    Nov 2011
    Location
    Cape Town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    WOW thank you so much Neville, will put this to the test

  5. #4
    Silver Member geraldenek's Avatar
    Join Date
    Jul 2008
    Location
    Somerset West
    Posts
    229
    Thanks
    19
    Thanked 112 Times in 80 Posts
    importing csv files save a lot of time and i find that not a lot of people working on pastel make use of it. It is such a great way to do things actually.
    Geraldene Kapp
    Professional Tax Help
    www.mytaxhelp.co.za

  6. #5
    New Member
    Join Date
    Nov 2011
    Location
    Cape Town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    HI everyone, sadly it looks like one is not allowed to import a purchase order batch or am I being blond, I am new-ish with Pastel Accounting.

  7. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by GerhardvdHeever View Post
    HI everyone, sadly it looks like one is not allowed to import a purchase order batch or am I being blond, I am new-ish with Pastel Accounting.
    You should be able to import the PO batch - perhaps your CSV file is incorrectly formatted?

    What error messages did you get when you tried?

    If you want, send me a copy of your CSV file.
    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)

  8. #7
    New Member
    Join Date
    Nov 2011
    Location
    Cape Town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville

    I do have an PO csv file (exported one form the PO form), but when I want to import the only options for importing is:
    1. Import General Ledger Accounts
    2. Not Used (don't know what this is for)
    3. Import this year budgets
    4. Import next year budgets
    5. Import customer accounts
    6. Import inventory items
    7. Importing selling prices

    That is the only option I could select to import a file

  9. #8
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    You are in the wrong place altogether! The steps you have tried are for importing masterfile data, not documents.

    Open the Purchase Order batch screen (as though you are about to create a PO manually).

    At the bottom left of the screen, click on Batch, and then Import.

    The rest should be easy...
    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)

  10. #9
    New Member
    Join Date
    Nov 2011
    Location
    Cape Town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Neville

    Thank you so much for all the help, however I remark that in the detail record layout a note from pastel has been made that I should make the field of the cost code to zero, could I have my own amounts as well own item codes and description, for I do not want to have all the items and it's codes in Pastel.

  11. #10
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by GerhardvdHeever View Post
    ...could I have my own amounts as well own item codes and description, for I do not want to have all the items and it's codes in Pastel.
    The PO will not import if you insert inventory codes in the CSV file that do not already exist in Pastel. You can, however, input your own description, even if it's different to the default description in Pastel for that item code.

    Perhaps you can create one inventory item code in Pastel and then use that same code in your CSV file, but with different descriptions?
    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)

Similar Threads

  1. Replies: 3
    Last Post: 19-Jul-18, 11:49 AM
  2. [Question] How do I print a sales order with bin numbers in Pastel Partner?
    By J7J in forum Accounting Forum
    Replies: 9
    Last Post: 23-Jan-18, 03:06 PM
  3. [Question] Importing Sales Order detail into Pastel Partner
    By J7J in forum Accounting Forum
    Replies: 5
    Last Post: 19-Feb-14, 11:49 AM
  4. [Question] Excel Genie - Partner and Xpress
    By J7J in forum Accounting Forum
    Replies: 1
    Last Post: 14-Apr-11, 03:05 PM
  5. [Question] Residual Car Purchase
    By AmithS in forum General Business Forum
    Replies: 3
    Last Post: 15-Oct-10, 09:46 AM

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
  •