Results 1 to 7 of 7

Thread: Exporting and Importing Inventory Master File in Pastel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,774
    Thanks
    44
    Thanked 452 Times in 397 Posts
    Hi Herman,

    That is strange that you are unable to export the inventory masterfile. I do it for my clients quite regularly, and I don't have any issues. Perhaps there is some data corruption? If you want, you are welcome to send me a backup of your database so that I can check it out.

    Even if you can export the masterfile, there are certain fields, including the inventory codes and the group codes, that will not update when you import the file back into Pastel. This is because these fields integrate with other data tables in the database. If you want to change any inventory codes, and you are using Partner (not Xpress), then you can use the Change...Renumber Codes option to do so. With respect to changing Inventory Group allocations, you will need to do them for each inventory record, one at a time.

    Due to the large number of inventory items that you have, perhaps you should consider starting an entire new company and take on opening balances, after importing the cleaned up masterfiles for customers, suppliers and inventory.
    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)

  2. Thanks given for this post:

    HermanS (20-Feb-14)

Similar Threads

  1. [Question] Pastel - Inventory
    By elaine25 in forum Accounting Forum
    Replies: 17
    Last Post: 04-Mar-24, 09:09 AM
  2. [Question] importing inventory items into pastel
    By StenetteFarrell in forum Accounting Forum
    Replies: 11
    Last Post: 10-Nov-15, 07:04 AM
  3. Exporting from Pastel V12 to excel
    By Tat in forum Accounting Forum
    Replies: 2
    Last Post: 18-Feb-14, 08:26 AM
  4. [Question] Pastel Inventory
    By Nadz in forum Accounting Forum
    Replies: 1
    Last Post: 25-Oct-13, 07:00 AM
  5. [Question] exporting data in pastel to excel
    By bernardshap in forum Accounting Forum
    Replies: 5
    Last Post: 28-Aug-12, 01:19 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
  •