Accounts Payable As Of Report

□	The Accounts Payable (As Of) Report provides an automatic "look-back" capability for any Date within any Month in the past for which Purchase and Payment records have been entered within the MKMS Accounts Payable System module.

•	Why is this report needed?

•	A problem occurs if the Accounts Payable Report was not run at the end of the month before new Purchases and/or Payments were recorded for the next month.

•	So, once Purchases and/or Payments are posted for the next month, a complex process of reporting and deducting these new Purchases, and then reporting and adding the new Payments, is required to recalculate what that Payables amount which would have existed at the end of the previous month.

•	This becomes even more difficult as additional months pass before calculating this Payables information for an "older" month.

•	The solution to this problem is found in the Accounts Payable (As Of) Report which provides an automatic "look-back" capability for any Date within any Month in the past for which Purchase and Payment records have been entered within the MKMS Accounts Payable module.

□	To print this Accounts Payable As Of Report, on the Main Menu Choose Reports and Select the Accounts Payable Reports.

•	Select the Accounts Payable option and Choose the Accounts Payable As Of report dialog shown below.

•	Options - Initially only the Options tab is shown (until you make your Options selections and Select Print).

HelpFilesAccountsPayableAsOfReportOptions

Accounts Payable (As Of) Report - Options tab

•	Report Date - Enter the Date from which this report is to be calculated:

•	Report as of Date (Default Today) - Using the Drop-Down Date Selection Box provided, Choose the appropriate Date.

•	Report On - Identify whether to include All Vendors (if selected as described above), or Current Vendor if the report was selected when a Vendor Information Form was already open.

•	All Vendors - The default when this report is chosen from the Accounts Payable Reports Menu when a Vendor Form is not open.

▪	This will be the only choice.

•	Current Vendor - The default when this report is chosen from the Accounts Payable Reports Menu when a Vendor Information Form is open.

▪	You may Click All Vendors, if required.

•	Selection & Content - Offers many ways to customize what and how your Accounts Payable As Of Report is listed. Choose the ones that best service your current needs.

•	Show Detail - Check this box to get line items detail for all applicable Vendors (see Which Bills below).

▪	If this is left Unchecked, you will get a one page Accounts Payable Summary format.

•	Show Address - If Checked (Show Detail must also be Checked), each Vendor's address information will be included.

•	Show Acct Status - Check this box to show the Amount in each Aging Category for each Vendor.

•	Show Individual Bills - Check this box to have each Bill listed on the report.

•	Show Bill Line Items - If Show Individual Bills is Checked (see above), you may Check this box to include the detail line items for each listed Bill.

•	Show ID's:

•	None - Click this button to exclude the Vendor's ID Number (assigned by MKMS).

•	Vendor ID - Click this button to display the Vendor's ID Number which may be Selected to open the associated Vendor Information Form.

•	Which Bills?:

•	All Accounts - By default, all Vendors will be listed regardless of the Age of the Invoice balances owed to that Vendor.

•	Past Due Only - If Past Due Only is selected, you must Choose which Vendors with whom you are Past Due are to be included.

•

Past Due

•	All Past Due Accounts - List All Vendors with whom you are Past Due.

•	Accounts 1 to 30 Days Past Due - List only Vendors with whom you are Past Due with Invoices from 1 to 30 Days Past Due.

•	All Accounts More than 30 Days Past Due - List only Vendors with whom you are Past Due with Invoices More than 30 Days Past Due.

•	Accounts 31 to 60 Days Past Due - List only Vendors with whom you are Past Due with Invoices from 31 to 60 Days Past Due.

•	All Accounts More than 60 Days Past Due - List only Vendors with whom you are Past Due with Invoices More than 60 Days Past Due.

•	Accounts 61 to 90 Days Past Due - List only Vendors with whom you are Past Due with Invoices from 61 to 90 Days Past Due.

•	All Accounts More than 90 Days Past Due - List only Vendors with whom you are Past Due with Invoices More than 90 Days Past Due.

•	Charts - Using the Drop-Down Selection List provided, you may request that a Pie or Bar Chart be included as part of this report's output.

HelpFilesAccountsPayableAsOfReportChartPreview

Accounts Payable (As Of) Report - Preview with Chart

•	Print - Click the Print button to Preview or Print (to a File or a Printer) this report.

□	Accounts Payable As Of Report Preview - The Preview tab presents the report which resulted from the Options you've selected.

•	Data Viewing options within the Accounts Payable As Of Report Preview tab:

•	Click on the Vendor's Id and the list of the Vendor Information Form for that Vendor will be displayed..

•	Click on the Vendor's Name and the list of the Bills making up the Amounts Due to that Vendor will be displayed.

•	Click the Plus Sign (É) to the left of any listed Bill and the Detail Line Items of the selected Bill will be displayed.

•	Click the Plus Sign (É) again to collapse the Bill and Detail Line Items information section.

HelpFilesAccountsPayableAsOfReportPreview

Accounts Payable (As Of) Report - Preview

•	Up Arrow/Down Arrow - hi - Moves the report one line up, or one line line down, respectively.

•	Page Up/Page Down - Moves the report to the previous or next page, respectively.

Accounts Receivable Report - Preview Buttons

•	Home - - Using either the screen Icon or your Keyboard's Home key, moves the report to the top of the first page.

•	End - - Using either the screen Icon or your Keyboard's End key, moves the report to the bottom of the last page.

•	Arrows - The arrows allow you to move back and forth, from page to page.

•	Number - Indicates the page number you are viewing.

•	You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately.

•	If you enter an invalid page number, it will be ignored.

•	Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen.

•	Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view).

•	Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen.

•	Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage.

•	When you Click the Zoom To Percentage button, the Percentage selector will be displayed.

•	You may then Click the Up or Down ‚ arrows to set the exact amount of Zoom you want.

•	Print - Click the Print button to Print (to a File or a Printer) the displayed Accounts Payable As Of Report.

•	Email - Click the Email button to send the Report to an Email Address of your choosing.

□	Data View - This view provides a tabular (spreadsheet style) presentation of the selected data.

HelpFilesAccountsPayableAsOfReportDataview

Accounts Payable (As Of) Report Data View

•	Arrows - Click the arrows to move through the record.

•	Export - Exporting the data from this Data View Form (note the "fly-over" help available on these buttons):

•	Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format.

•	Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format.

•	Export To Html - Click the third button after the arrows to export the data to an HTML formatted file.

•	Exit the Form by Clicking the Close button x on the right at the top of the Form.