Results 1 to 4 of 4

Thread: Pastel Partner 12 cashbook updates from csv

  1. #1
    Email problem
    Join Date
    Dec 2013
    Location
    Cape town
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pastel Partner 12 cashbook updates from csv

    Keep getting Run Time Error 9 when trying to update cash book payments, using Pastel partner 12. Any suggestions please

  2. #2
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,242
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi Cecile - this could be a problem with the Cashbook batch.

    To resolve the error, you need to export, delete and then import the cashbook batch.

    First make a backup - so that you can restore if anything goes wrong.

    Step 1: Exporting the batch

    On the cashbook screen, click on the Batch button.
    Select Export.
    Click on the magnify glass next to the white block under Export File Name.
    Select a location where to export the file to and next to File Name type in receipts.csv (if exporting the receipts batch) and payments.csv (if exporting the payments batch.)

    Step 2: Deleting the batch:

    On the cashbook screen, click on the batch button.
    Select Delete Batch.
    Click Yes on the Delete this Batch screen.
    Click Yes on the "Are you sure?" prompt:


    Step 3: Importing the batch

    On the cashbook screen, click on the batch button.
    Select Import.
    Click on the magnifying glass next to the white block under Import File Name.
    Select the file you exported earlier, click Open, Process.
    If there was open item matching on the batch then Press F3 on each line and match again as everything would have been unmatched

    Now try to update the cash book again.

    If the above did not resolve the problem, then you might need to delete the batch (as explained under Delete) and re enter the batch.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  3. #3
    Email problem
    Join Date
    Dec 2013
    Location
    Cape town
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No Luck!

    Hi, I have tried the above but had no luck. I import very large payment csv batches, which I convert to comma delimited with an Excel macro. has always worked very smoothly. The file is enourmous and I would hate to re-convert, and allocate eash transaction again.

    Is there anything I can look for in the batch that could be causing the problem?

  4. #4
    Platinum Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,242
    Thanks
    207
    Thanked 310 Times in 268 Posts
    Hi Cecile - the only thing that I could suggest then, is that you only import the first half of it and try updating. If the first half crashes, then - restore your database - import the first quarter, and try again.

    By trial and error you may find which section is causing the error and then whittle it down until you find the offending entry.

    I know that it sounds like a major hassle - but it should be considerably easier than allocating each transaction again.

    Just make sure that your original file is backed up so that you can restore each time.

    Neville Bailey is the expert on things Pastel around here. Perhaps you could ask him to have a look at your batch file and offer a suggestion.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

Similar Threads

  1. Pastel Cashbook entry in wrong period.
    By Vinruby in forum Accounting Forum
    Replies: 2
    Last Post: 16-Sep-13, 10:28 AM
  2. processing auction deposits into pastel cashbook
    By PASTEL01 in forum Accounting Forum
    Replies: 5
    Last Post: 03-Aug-13, 05:11 PM
  3. automatic price & stock updates from Pastel Partner to MySQL website?
    By Salad_Dressing in forum Accounting Forum
    Replies: 46
    Last Post: 03-Aug-12, 02:41 PM
  4. pastel cashbook
    By tinach in forum Accounting Forum
    Replies: 6
    Last Post: 04-Jul-12, 07:20 AM
  5. Pastel Cashbook receipts
    By Vinruby in forum Accounting Forum
    Replies: 2
    Last Post: 28-Jul-11, 03:00 PM

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
  •