Results 1 to 4 of 4

Thread: Invoice batch import issue

  1. #1
    New Member
    Join Date
    Feb 2019
    Location
    Sedgefield
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Invoice batch import issue

    I import csv customer invoices to pastel accounting . My invoice numbers are not always in sequence but this is normally not a problem as my pastel is set to allow own invoice numbers.
    However today I imported 40 invoices. 39 were in sequence but the last 1 had an out of sequence number (relating to an export so vnb to have the correct number)
    For some reason pastel will not allow this invoice to have it's own number and keeps putting it into the sequence of the others.
    This has happened on the odd occasion before and I've managed to resolve by importing the errant invoice in a batch on its own. This time this strategy will not work. I really need the invoice to have the chosen number. Any ideas?

  2. #2
    Full Member TravisSinclair's Avatar
    Join Date
    Apr 2015
    Location
    Durban
    Posts
    42
    Thanks
    16
    Thanked 2 Times in 2 Posts
    It's likely that that invoice number has already been used in the past, which is why Pastel won't accept it. Even if you can't see an invoice with that number, the Pervasive tables may have a line with that invoice number in it. The History Header or History Lines files in the Pervasive table may need to be checked for this. This will require someone with an understanding of the Pervasive tables to work on your data. Let me know if you would like me to contact you to assist with this.

  3. #3
    New Member
    Join Date
    Feb 2019
    Location
    Sedgefield
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    TravisSinclair;169920]
    Thanks so much. You are quite correct. I picked up a duplicate invoice number from November last year that has been causing the problem.
    I changed the prefix on the current invoice from IN to INV and it imports no problem. It's not ideal but a least worst solution.

  4. #4
    Suspended
    Join Date
    Apr 2023
    Location
    Unitedkingdom
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    In order to resolve the issue of Pastel accounting automatically assigning a sequential number to your out-of-sequence invoice, you can try the following steps:

    Open Pastel accounting software and go to the invoice entry section.
    Create a new invoice entry for the out-of-sequence invoice.
    Instead of manually entering the invoice number, leave the field blank or enter a temporary placeholder number.
    Save the invoice entry without a number assigned to it.
    Open the invoice entry again and edit it.
    Now, manually enter the desired invoice number in the appropriate field.
    Save the invoice entry once again.

    By following these steps, you should be able to assign the chosen number to your invoice without it being automatically re-sequenced by Pastel accounting.
    Last edited by Dave A; 31-May-23 at 10:45 AM.

Similar Threads

  1. [Question] Sage Evolution - Inventory Import issue - Please help
    By LeRoux in forum Accounting Forum
    Replies: 1
    Last Post: 03-Jun-21, 07:39 AM
  2. Tax invoice import
    By Cath in forum Accounting Forum
    Replies: 2
    Last Post: 14-Feb-18, 08:52 AM
  3. [Question] Import error on invoice batch
    By connie347 in forum Accounting Forum
    Replies: 0
    Last Post: 02-Nov-17, 01:47 PM
  4. [Question] Pastel Batch Import Posted In The Wrong Period
    By Zaid Ismail in forum Accounting Forum
    Replies: 3
    Last Post: 07-Jul-16, 12:13 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
  •