Results 1 to 6 of 6

Thread: Finding payment allocations to invoice/partial invoice payments

  1. #1
    New Member
    Join Date
    Oct 2019
    Location
    Kwazulu Natal
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Finding payment allocations to invoice/partial invoice payments

    Hi,
    How can I follow on Cash Book Receipt allocations?
    Payments were allocated to invoices - how can I view/run a report to see the CBR## and the invoices it linked the payment to?

  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
    Go to Process...Match Open Item, and open a customer account.

    You will see a list of invoice numbers, with a + sign to the left of each one.

    Click on the + sign to expand the line and you will see which receipts/credits have been allocated to a particular 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)

  3. #3
    New Member
    Join Date
    Oct 2019
    Location
    Kwazulu Natal
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Neville,

    Is there not a report that I can run that will show me the CBR0001 was allocated to the differences invoices and the values?
    Our invoices rarely gets paid in full at the same time. Payments come trough as per line on the invoices. ie. Product R100. Time R50 Admin fee R50
    The client will pay for 10 different invoices - different lines on 1 CBR. Makes it very complicated.

    I need a report that I could run to see which invoices and values were allocated to the different CBR's.

    Awaiting you response.
    Last edited by Dave A; 17-Oct-19 at 07:15 PM.

  4. #4
    New Member
    Join Date
    Oct 2019
    Location
    Kwazulu Natal
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Neville,
    I did reply - not sure why it is not showing up here as yet.
    I am looking for a report to run to see ALL Invoices and specific values allocated to those invoices for a specific CBR.

    We get 1 big payment - small amounts are allocated to various invoices - I would like to be able to see the CBR)))) - linked to: inv1 R500; Inv2 R200; Onv10 R100

    Hope this make sense? not sure where my previous comment/reply went?

  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
    Hi Marlise,

    I understand what you are looking for, but there is no standard Pastel report that will give you that information. However, it is possible to create a custom report using either the Intelligence module, or by creating an ODBC linked Excel report.
    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
    Silver Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    262
    Thanks
    0
    Thanked 35 Times in 31 Posts
    Hi Marlise

    View - Customers - Monthly/Periodic - Open Item History

    You can then select Matched allocations under the transaction status, Select Posted Transactions, then either Receipts (cashbook entries), or all (if you have customer journals). Select the period you want to see the cashbook transactions from. The report is quite messy, as it will list all invoices in the customer history, then at the end of the report, it will show you the receipts and the invoices they were matched to for the period you selected. You can also use this report (change transaction status to unmatched) to see what transactions have not been matched for all your customers, and go and allocate them accordingly in the Process - Match Open Item menu.

    It will probably be easiest to send the reports to excel, where you can delete or filter the records you need. The other option is a report or ODBC link, as Neville mentioned.

Similar Threads

  1. Replies: 2
    Last Post: 01-Sep-19, 07:36 AM
  2. Payment match to invoice
    By Berice in forum Accounting Forum
    Replies: 1
    Last Post: 16-Mar-16, 06:34 PM
  3. Pastel Xpress V12 - making email invoice same as print invoice
    By Isabel Bothma in forum Accounting Forum
    Replies: 2
    Last Post: 27-Mar-14, 08:28 AM
  4. Replies: 8
    Last Post: 16-Mar-14, 09:22 AM
  5. Replies: 2
    Last Post: 26-Feb-14, 10:35 AM

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
  •