Results 1 to 2 of 2

Thread: Open Item - - payments allocated to the wrong invoices

  1. #1
    Bronze Member michellepace's Avatar
    Join Date
    Oct 2018
    Location
    South Africa
    Posts
    124
    Thanks
    14
    Thanked 3 Times in 3 Posts

    Question Open Item - - payments allocated to the wrong invoices

    Hi there,

    We recently converted to Open Item processing for all our customers. When we processed our cashbook (via Pastel Bank Manager > created Receipt batch) we forgot to go through each and every line and assign the payment to it's correct Customer Invoice. The result is our Age Analysis for Customers is now thrown out.

    Question:
    Is there a way to change which invoice a payment was allocated to?
    For example, if I have a customer called JONES. And his payment was automatically (and incorrectly) allocated to Invoice ABC, can I somehow go and re-allocate it to Invoice DEF? This in turn will fix up our Customer Age Analysis.


    As always, thank you.
    Michelle

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,636
    Thanks
    41
    Thanked 435 Times in 381 Posts
    Go to Process...Match Open Item, and select the relevant customer code.

    You will then see a listing of all the invoices.

    The invoices that have been matched against receipts will have a little + sign on the left to it. Click on the + sign to expand the breakdown of the original invoice and the receipt/s linked to it.

    Any receipts not yet allocated with be grouped under the Unallocated line item at the top of the list.

    In order to reallocate receipts, simply drag the receipt line items from either the Unallocated section or from existing invoice lines and drop them on top of the relevant invoice lines.
    Neville Bailey - Sage Pastel Accounting Consultant
    Phone: 031 521 0080 or 087 095 7895
    neville@accountingsoftwaresupport.co.za
    www.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. [Question] Pastel Xpress V17 Bank Manager - Matching Supplier Invoices (open Item)
    By Roanne Duncan in forum Accounting Forum
    Replies: 2
    Last Post: 03-Aug-17, 08:13 AM
  2. [Question] Balance Forward/Open Item
    By Cedric Mbeba in forum Accounting Forum
    Replies: 1
    Last Post: 04-Jan-17, 12:48 PM
  3. [Question] Open Item and Balance Forward conversions
    By LouisaEls in forum Accounting Forum
    Replies: 1
    Last Post: 22-Oct-15, 02:49 PM
  4. Creditor - open item out of balance
    By Heidivf in forum Accounting Forum
    Replies: 3
    Last Post: 15-Jan-15, 09:44 PM
  5. [Question] CORRUPTION ON OPEN ITEM FILE
    By Coolblue in forum Accounting Forum
    Replies: 2
    Last Post: 06-Feb-13, 07:47 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
  •