I want to print Receivable Statements for current period balances only. On the Print For: I also selected Exclude Fully Applied Payment. Fully applied payments are included on the statement along with credit balances.
*This post is locked for comments
Hi,
No problem. Just don't put anything in the Summarize To field. However, I sense that all you want is a list showing only the outstanding invoices. You cannot get this from the RM Statements that come with GP. What I would do is to create a SmartList or Refreshable Excel report that only shows the data you want.
Kind regards,
Leslie
That still does not give me what I am looking for. I do not want BBF. I want to see all open invoices.
Hi Happy1,
Are you filling out the 'Summarize To' field? Let's assume that you are. I'll take Aaron Fitz for example. I summarized until 04/01/2017 and cut it off on 04/30/2017. I selected to print for 'Current Period Balance' and 'Exclude Fully Applied Payments'. I will get any payment made this month that was applied to an invoice included in the beginning balance and any invoice created this month. Overall, Aaron Fitz owes us money.
Current Period Balance will get you a statement for any customer that overall owes you money at the end of the period. If the customer doesn't owe you money at the end of the period, no statement will print. No statement prints even if the customer had transactions during the period.
If you Exclude Fully Applied Payments, you will not see payments you made this period that have been fully applied to an invoice that was created this period. You WILL see payments made this period that were fully applied to invoices dated before the 'Summarize To' field.
You will always see invoices created this period, even if they were paid off this period. The only time you will not is if at the end of the period the customer overall doesn't owe you any money.
If you select to print for credit balances, then you will get a statement for any customer who overall has a credit balance, it doesn't refer to individual items. If a transaction this period has a credit balance, you are going to see it on the statement.
I hope this helps. Let us know how you wanted the statement to look.
Kind regards,
Leslie
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
