A/P - Setup/Reports/Other FAQ
Frequently Asked Questions about A/P Setup, Reports, and Other items
How do I change the default bank for my Accounts Payable account?
The way to change the default bank account for an Accounts Payable account is to access Account Maintenance [F11]. Find the A/P account and select the bank that will be attached to the A/P account in the A/P Bank field. Then hit [F10] on your keyboard or click on Save at the bottom of the screen.
What report(s) show insurance information from the vendor Sub-Accounts?
In the Accounts Payable module, there are insurance reports located in the Reports section on the Insurance/W-9 tab.
The Insurance Expiration Report/Letter is a form that a company can use to request insurance information from their sub contractors. It also has the ability to print a report of when insurance expires based on information recorded in Sub-Account Maintenance [F12]. A default letter is already setup in WPFORMS. You can edit the default insurance letter in the Utilities module > Default Forms > Letter Templates. Also have the ability to specify if a MSA (Master Service Agreement) is required and/or received.
The next report is the Vendor's Insurance Listing for vendors setup in Sub-Account Maintenance, that have insurance information filled in on the Insurance Tab. It only reports if General Liability or Workers Comp insurance is filled in. The report is intended for your company's insurance carrier to verify that your vendors carry insurance.
The third report is the W-9 Letters. This utility provides the ability to print a batch of vendor letters based on missing Tax-IDs. Usually a W-9 letter is printed immediately after adding them via the Print W-9 Letter button in Sub-Account Maintenance. However, this batch printing can be used to print and/or reprint a W-9 for all vendors with a blank Tax ID.
How do I correct an error message-"No Accounts Defined?"
Receiving the No Accounts Defined message when trying to enter an Accounts Payable invoice means that a payable account has not been set up in your chart of accounts located in the Account Maintenance [F11]. Normally this is the result of a simple mistake of not selecting the account type to be a payable on the account that you have designated as your payable account. Simply find the payable account in Account Maintenance [F11] and change the account type to be a payable account ensuring that you associate an A/P Bank (bank code). If the A/P account has not been entered into the chart of accounts, add it in selecting the account type to be a payable account and associate an A/P bank (bank code) to it.
I need to run a report that shows our contract labor that would receive a 1099 and how much each vendor has been paid for a specific time period. How do I run this report?
- Bank Reconciliation > Reports > Checks by Payee-make sure that the Include only Payees with 1099 code option is set to "Y." Also make sure that the Check Date Range From/Thru range is set to the date range you desire.
- Accounts Payable > Reports > Invoice Tab > I-1 Invoices by Vendor.
How can I see A/P Invoice History at the Sub-Account level?
F12-Sub-Account maintenance
Selecting the Invoice history button (on the A/P Options tab) will take you to a grid with all the invoice/check history for this Sub-Account. The history screen will show a line for each check written as an expandable item. It will also show invoices entered, but not yet posted or in routing process. Click on the invoice, and the coding for the invoice will be displayed. If invoice has an associated scanned doc, the doc icon will display in the Doc box. Click to view the document.