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?
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?
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)
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.
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?
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)
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.
Did you like this article? Share it with your favourite social network.