Results 1 to 7 of 7

Thread: Pastel Supplier Invoices Matching - Remove Credited Invoices

  1. #1
    New Member
    Join Date
    Jan 2015
    Location
    cape town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Pastel Supplier Invoices Matching - Remove Credited Invoices

    Hi There,
    I'm currently working on Pastel Xpress 2009.
    When I do the cash book, Pastel has been set up to match the supplier payment to invoices. On the list it pops up on some of my suppliers there has been invoices that's been credited, but the credited invoice is still in that list to match. How do I remove those invoice as it becomes very difficult to know what to match and what not.
    Click image for larger version. 

Name:	cats.jpg 
Views:	1949 
Size:	62.9 KB 
ID:	5391Click image for larger version. 

Name:	cats.jpg 
Views:	1949 
Size:	62.9 KB 
ID:	5391

  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
    That's odd.

    If you have already matched those invoices with a previous payment, they should not still be showing when you match the next payment.

    Have you already updated the previous payment batch? If not, then go back to that payment line item and press the F3 function button to make sure that the payment was matched properly to the invoices. If you have already updated the payment batch, then go to Process...Match Open Items and check if the payment was correctly matched against the invoices and correct it if necessary.
    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. #3
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Umkomaas
    Posts
    2,850
    Thanks
    249
    Thanked 371 Times in 327 Posts
    Hi steffie,

    There are two reasons why they keep appearing. The one is that the payment has gone through the cash book as a general ledger entry not as a Supplier. This would then have to be fixed using a "Return Debit" or a Supplier Journal Entry.

    The other reason is that they have not been matched up correctly. I have copied the instructions that Neville Bailey gave to someone else in another place which should be of help to you.

    Remember to always backup before you do corrections so that if things do not work out as planned you can always restore your backup and try again.

    Go to Process...Match Open Item and then browse for the customer/supplier account that you want to fix.

    At the top of the next screen you will see a line item named Unallocated. Click on the + sign on the left, in order to expand the list of unallocated receipts/payments. Select the first unallocated transaction and drag and drop it onto the invoice that it relates to. Save the record.
    No act of kindness, no matter how small, is ever wasted. - Aesop "The Lion and the Mouse"

  4. #4
    New Member
    Join Date
    Jan 2015
    Location
    cape town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question

    Thanks guys for trying to help, but I feel I haven't explained the problem properly.

    I've got 2 suppliers, Gbay Internet and Gordon's Bay Security, and I have by accident entered a Gordon's Bay Security invoice under Gbay Internet. I have done a credit note for it as soon as I noticed it (I unfortunately have already batched by then) but even after the credit note, the invoice is still in the list to match to a payment.

    Is there a way to remove it from the list?

    Click image for larger version. 

Name:	cats.jpg 
Views:	1537 
Size:	57.6 KB 
ID:	5406

  5. #5
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    In order to reverse a supplier invoice, you need to process a Return & Debit note, not a credit note - I presume that you did that, and that you matched the R&D note to the invoice?
    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)

  6. #6
    New Member
    Join Date
    Jan 2015
    Location
    cape town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question

    Quote Originally Posted by Neville Bailey View Post
    In order to reverse a supplier invoice, you need to process a Return & Debit note, not a credit note - I presume that you did that, and that you matched the R&D note to the invoice?
    Hi Neville, yes I did do a Return and Debit, and have entered the invoice number in the "original invoice" block. Is there a different way of linking the 2 so that the invoice does not show up in open items on the cashbook?

  7. #7
    New Member
    Join Date
    Jan 2015
    Location
    cape town
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question

    I've just done a Return and Debit for a supplier again. Put the correct invoice number in the "original invoice" block, batched it and went and check, and the invoice is still available to match in the cash book. I need to know how to remove all these invoices that has been credited to not show as a matching item when doing the cashbook, pleassseee??

Similar Threads

  1. Posting supplier invoices to projects in Pastel
    By TravisZA in forum Accounting Forum
    Replies: 4
    Last Post: 13-Feb-23, 05:48 AM
  2. [Question] Pastel Xpress (Start-up) - How to correct SUPPLIER invoices
    By Tato in forum Accounting Forum
    Replies: 5
    Last Post: 25-May-15, 12:23 PM
  3. [Question] Supplier Invoices and vat
    By Jforssman in forum Accounting Forum
    Replies: 7
    Last Post: 23-Nov-12, 08:07 AM
  4. Pastel - Multiple invoices at once?
    By mother in forum Accounting Forum
    Replies: 6
    Last Post: 18-Jul-11, 09:59 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
  •