Report Daily Vendor Receivables Activity
(Daily Receipts and Adjustments)
Access
This report provides an audit trail of all daily activity pertaining to vendor receivables. Daily activity may consist of cash receipts (payments or on account postings), manual postings and / or automatic postings. The report is broken into sections representing each type of activity, i.e., cash receipts (sorted by bank), adjustments, bill-back postings, volume rebate postings, customer service order postings and AP bill postings. If the Vendor Receivables module is active, this report will be generated automatically during the Day Ending process. The end of day version will report all activity that has occurred since the last end of day.
The run-time options for this report are:
Date CodeClick on the Arrow button to view a list of date codes, then select the code that best indicates the time period on which to base your report.
Start DateIf you select CUS at the Date Code field, you activate this field. Use this field to specify the start date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
End DateIf you select CUS at the Date Code field, you activate this field. Use this field to specify the end date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
As Of DateIf you select CUS (custom) at Date Code field, you activate this field. Use this field to specify the as-of date for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.
If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.
Report on Date TypeThis field indicates the type of date or date range (selected in the Date Code, Start and End Date fields) that the report is to be based on. Select Transaction Date if the report is to be based on the dates of the transactions. Select System Date if the report is to be based on the system date.
Include ReceiptsCheck the box at this field to include VR cash receipt and customer service receivables activity on this report.
Include AdjustmentsCheck the box at this field to include vendor receivables manual posting activity on this report.
Include Automatic PostingsCheck the box at this field to include activity that occurred due to automatic system postings. Automatic postings occur when Vendor Receivables are created for bill backs, vendor rebates (via Volume Rebate Posting Entry) or warranty reimbursements (via Customer Service Order Entry). Additionally, this section will include postings that occurred as a result of modifications to AP Bills with bill back items.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer ( PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.
