The Print Posted Payment Report will list posted payments based on your criteria. You can always view information, even after being posted.
When posting Payments, the cash account is either keyed when the payment is entered, (Option G) in Payment Entry (6.4.1), or it comes from the AR Setup in SYSTEM MANAGEMENT (10.2.2.1 field 3). The location that the AR setup is retrieved from is determined by the Port Location of the port where the payments are being posted.
The following selection criteria options are available: Port Number and User ID refer to the Port or User that posted the items, Batch #, Customer Number, and Salesperson of Record.
This report may be sorted by <B>atch or <C>ustomer. If sorted by Customer, it will sort by Customer Names and print subtotals by customer.
You may select by the Beginning and Ending Date Entered.
The G/L Account Number prompt will allow you to specify only regular A/R type Payments by using the normal A/R Account Number, specify all Non-A/R type payments with the <N> option, or request payments that credited a specific Non-A/R Account. If the you press <ENTER>, the report will show all Payments regardless of which G/L Account was credited.
Also, the <D2> version of the report has an additional column on the end of the report to show Available Amount (left to Apply). This will print on all <D2> reports, but will be especially helpful when only including Unapplied Payments on the report. The Total available Amount will print at the bottom, in line with the existing totals.
You may also select by Accounting Period, Location, and Check Number.
If selecting by Check Number, enter the Check Number to search for. Enter the first part of the Number followed by a <]> for pattern matching. Enter a <[> followed by the last part of the Number. Enter a <[> followed by part of the Number, followed by a <]>. Or <*> for Wildcarding (1****6 - Starts with 1, then 4 characters, then Ends with 6).
The Date Range and the Accounting Period Selection criteria used together are very useful in isolating items that have a date that does not match the accounting period. For Example: If you posted items on the first of the month and you have not rolled yet, the previous accounting period will be assigned even though the items are in the following month-to-date.
This report may be further trimmed by choosing to Print Payments with Discounts Only.
You may print a Sales Tax Payment discount report at this menu. This report is used to calculate the total tax that should be credited due to a discount given to a customer after the original Invoice was issued, e.g. early payment discount. The report is printed after the Posted Payment Report.
You may view on the screen or print this report.
The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in Port Entry in POINT OF SALE (1.10) to enable this function.
After the report is displayed to the screen you also have the option of entering a <D> to download the report to your local hard drive. When downloading the file, the path defaults to C:\TEMP but will use the setup in Port Entry in POINT OF SALE (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.
You have the following report versions available:
<D>etail or <S>ummary Report.
<D2> for Alternate Detail showing Date, Time and Who Posted.
<S2> for Summary by Batch Number. (Which includes Check Amount, Number of Checks, Number of Unapplied Payments, Date, Time and Who Posted information.)
When viewing this report on the <S>creen and the <S>ummary option has been selected, you have the ability to select a Payment to view in detail in Payment Entry (6.4.1).
When viewing on the <S>creen or <P>rinting and selecting the <D>etail or <D2> report, you may choose to Print Applied Information on the report and/or to Only print items that have NOT been Fully Applied.
The Print Applied Information option also will display items that were applied but not directly to the item. If there are items applied to the applied item, other than the main item on the report, then those items will print underneath the applied items. These items will appear indented by one character and the applied amount will appear as a negative amount. This is helpful when reconciling the account or explaining what happened during the original Cash Apply session.
Print Comments: When the <D>etail or <D2> option is selected:
- Enter <Y> to Print Comments on the report