Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
General Information Default Menu Location Transaction >> Accounts Payable >> Add/Edit AP Invoice Screen Name APMAST Function The AP Invoice Screen has many uses. From this screen you can: 1. Create a new AP Invoice. 2. Create an AP Invoice from a PO Receipt, or several PO Receipts. 3. Edit an existing AP Invoice. 4. Void an existing AP Invoice. 5. Mark an invoice as approved. 6. Print a Manual [...]
[...] General Information
Default Menu Location : Transaction >> Importers/Exporters >> Accounting >> AR Invoice Import Screen Name : IMPORTINV Function: This screen imports a header and detail Excel file (XLS) into Adjutant to load the AR invoice tables. AR Invoice Import Screen
File Name(Header)/Browse: Use the Browse button to locate and select the completed AR Invoice Header import template file (in XLS format). Note - both the Header and Details files are required and must [...]
[...] General Information
Default Menu Location Transaction >> Importers/Exporters >> Accounting >> AP Invoice Import Screen Name IMPORTAPINV Function The AP Invoice Import screen allows users to import external Account Payable invoices into Adjutant. AP Invoice Import Screen
File Name(Header)/Browse: Use the Browse button to locate and select the completed AP Invoice Header import template file (in XLS format). Note - both the Header and Distributions files are required and [...]
[...] setup option is enabled. Change screens to use 15 char numbers. APAGEPOLIST - Add POs linked to AP Invoice to polist field in cursor. Only works in detail mode. APAPRPPAYZERO - Makes 0 show up in grid. APCCVENDOR2 - If enabled, AP Credit Card Vendors must use the APCCVENDOR Org Attribute, rather than the CCDATA attribute. The CCDATA attribute becomes exclusive for personal credit card data for sales. APCHECK48 - Allows 48 invoices on a check without printing an overflow stub. To use, APCHKOVERFLOW rule must be setup Text1 = Overflow [...]
General Description
Default Menu Location : Transaction >> Accounts Receivable >> AR Invoice Master Screen Name : INVMAST Function : This screen is used to view a customer invoice. You can also edit Header information, credit unpaid invoices, issue tax credits, issue refunds, pay by credit card, and print the invoice. Enter the invoice number and click Edit button to change a field on the header. Click the Select button to also enable searching by Customer PO, Sales Order#, [...]
[...] a daily basis according to the annual rate (converted to daily rate) and the daily balance of each invoice. To calculate the daily interest rate (R), the program divides the interest rate (I) by the number of days in the year (D). R = I / D For example, an annual rate of 18% is calculated as a .049315% daily rate (R = 18/365).
Remember to enter the ANNUAL RATE on the Bill To screen.
Finance Charge Calculation
The Daily Rate is used to calculate the interest on each outstanding invoice. For our example, we will assume that today [...]
General Description
Default Menu Location Reports >> Account Receivable >> Invoice Register Report Screen Name INVOICESUM Invoice Register Report Screen Function This screen generates Invoice Register Report with the Order Number, Invoice Date, and the Invoice Amount for all the customers by a specific time frame. Report Filters
Customer ID: Customer ID. Start Date: Starting Invoice Date. End Date: Ending
[...] when apply cash receipts in the Apply Cash Receipts. CHANGEDISCACCT - Enables pop-up window on AP Invoice and Cash Receipt screen to allow user to change default discount given/taken GL account. CRALLACCT - CRALLACCT DIRITEMDET - DIRITEMDET FCBYPROJ - Change FC to generate by Custno/ProjID if FCBYPROJ setup option is enabled. FCEXCLPAID - If checkbox checked, then exclude all paid invoices from FC generation. FCITEMINT - FCITEMINT GRPSHIPBYCPO - Groups Invoices by Bill To + Cust PO. GRPSHIPBYPROJ - Groups Invoices by Project ID. GRPSHIPBYSHIPTO - Groups Invoices [...]
[...] General Information
Default Menu Location Maintain >> System >> Rule Maintenance Function The Invoice Forms rule controls the valid Invoice Form types available for AR Invoice Master and Time Billing. Invoice Form codes can be set up to override the default invoice form used and/or the default sort method used on the invoice.
Invoice Forms Rule
Rule Setup – Text Fields Name:
Step One This is assuming that the invoice has already been paid.
Create a positive credit for your customer for the amount of the order, using the Apply Cash Receipts Screen. This does not need to be matched with an invoice.
AR Invoice Master - Click for full size
Apply Cash Receipts and Adjustments - Click for full size Step Two Create a second credit to your customer for the negative amount of the invoice. Apply it directly to the invoice. [...]
[...] Accounts Receivable >> Print Invoices Screen Name : PRINTINV Function : Print/Email/Fax/EDI Customer Invoice(s).
Fields and Filters
Invoice Numbers : Enter a single invoice number or a range of numbers. A range can be entered by using a colon and several specific invoices can be entered by using commas.
For example: 100,103,105:108 will print invoice number 100, 103, 105, 106, 107, and 108. All Unprinted: Check this box to print ALL invoices that have not yet been printed/processed. [...]
General Description
Default Menu Location Reports >> Accounts Receivable >> Daily Invoice Summary Screen Names DAILYINV
Daily Invoice Summary Screen Function Daily Invoice Summary generates a summary of all the different invoices for a day for a sales person. Report Filters
Custno: Enter the customer number to generate a report. Company: Enter the company name for the invoice. Start Date: Enter the start date for the report. End Date: Enter the end date for the [...]
[...] Transaction >> Accounts Payable >> Approve AP Invoices Screen Name : APAPRPAY Function: Every AP invoice must be approved to pay before a payment may be issued for it. An AP Invoice may be approved on the Approve to Pay screen or directly from the AP Invoice screen . Approving an AP Invoice does not mean a check will be written for it. It only ALLOWS a check to be written for it. See the Print Checks page for more information on this. Approve AP Invoices for Payment
Filters [...]
General Description
Default Menu Location: Reports >> Accounts Receivable >> Invoice Register Report Screen Shot: INVOICESUM Function: The Invoice Register Report is used to give a list of Invoices in the system. The report also gives the invoice date, Net Amount, Freight, Sales Tax, Invoice Total, and Balance. The report can be filtered on many various fields such as customer, date, territory, status, order type, salesperson, and account manager.
Report Filters
Customer [...]
General Information Default Menu Location : Transaction >> Accounts Receivable >> AR Invoice Master
Screen Name : AP2AR
Function : The Create AP Invoice from AR Invoice screen allows a refund check to be issued from a credit or deposit on a customer's account.
The AR2AP button is only accessible when the invoice has a credit balance (a negative amount).
AR to AP
The customer MUST be setup as a Vendor in order to pay them (must have SOLDFROM and REMITTO attributes). [...]
[...] From: Choose the option required for how the report will be generated, either aged from Due Date or Invoice Date Only x Days after Invoice Date: Exclude customers that do not have an invoice older than this number of days.
Both invoices will print if a cusotmer has an invoice older and newer than this number of days.
Print Only: Check this box to bypass Message Control and go directly to the Windows print screen Auto Process: Check this box to auto-process the Customer Statements [...]
[...] errors are encountered. Fields/Filters Required fields are indicated with an * f1 - InvNo - AR Invoice to apply the cash receipt as a payment. If left blank, the cash receipt will be created as an open credit or a deposit. *f2 - CustNo - Bill To customer number in Adjutant f3 - TranDate - Transaction Date (MM/DD/YYYY). Used for report selects to differentiate between the GL posting date and the receipt date. *f4 - PostDate - Postmark or Posted date (MM/DD/YYYY) *f5 - CashAmt - Dollar amount of cash received *f6 - RefNo - Reference number or check number *f7 [...]
General Description
Default Menu Location Transaction >> Accounts Receivable >> Create Manual Invoice Screen Name MANINV Create Manual Invoice Screen
Function Manual Invoice screen generates an invoice with a Description, Item Number, Price, Order Number, including Bill To, and Sold To information. Fields/Filters
Client: Customer number, Phone number, and Company name Bill To: Bill to customer information - Customer number, Phone number, Company name Ship To: Ship [...]
[...] the Print Checks screen in Accounts Payable. Print Checks
A single check may be issued for a single invoice from the Manual Check screen. There are several options available to you on the Print Checks screen, such as: Vendor AP Invoice Due Date AP Invoice Discount Date Payment Priority These options allow you to print checks for specific invoices that have been approved, instead of all approved invoices. After printing checks, the program will ask if you want to "Reprint [...]
[...] variety of things in Order Entry and Invoicing. Types allow you to separate orders, change the SO and Invoice form, prefixes, invoice status, revenue and COGS coding, etc. How to add a new Sales Order Type 1. Open the Rule Maintenance Screen (Maintain--> System --> Rule Maintenance) 2. Select 'Sale Order Types' from the drop down menu. 3. Click the ADD button, and fill in corresponding fields (details below). Fields
Text1 = Name (20) Text2 = Code (1) Text3 = Sales Order Form Name Text4 = SOC Questions to Exclude
Enter SOC Report [...]
General Information
Default Menu Location Transaction >> Accounts Receivable >> AR Invoice Master Screen Name INVMAST Function This screen is used to view a customer invoice. You can also edit Header information, credit unpaid invoices, issue tax credits, issue refunds, pay by credit card, and print the invoice. Enter the invoice number and click Edit button to change a field on the header.
Procedures
STEP 1: Open the Edit Invoice Header screen [...]
General Description
Default Menu Location Reports >> Accounts Receivables >> Invoice Summary by Plant Screen Name INVSUMPLANT Invoice Summary by Plant Screen Function Invoice Summary Report screen generates an invoice summary report with the [...]
[...] Number of days for the different groups on the report. Age From: The report can age the invoices from Invoice Date or Due Date. Include/Exclude/Deposits Only: This option applies to prepaid deposits (cash receipts that are not applied to an invoice and are marked as a deposit). As of: Enter a date here to run the report as of a prior date. Leave this field blank to run the report as of the current time. Invoice Status: Choose an invoice status, or select All to see all invoices.
[...]
Steps
STEP 1: TRANSACTION >> ACCOUNTS RECEIVABLE >> AR INVOICE MASTER STEP 2: Enter the invoice number you wish to void in the Invoice Number field. STEP 3: Click the Issue Credit [...]
[...] List screen displays all scanned AP Invoices with their corresponding Voucher number. The Create AP Invoice button allows you to launch the AP Invoice Screen and pass the voucher number with it. Upon saving the new AP Invoice, the scanned image will automatically be transferred and viewable on the AP Invoice screen. Recommended Process/Usage
Buy a numbering stamp, ( like this one ). Stamp each invoice when it arrives and scan it to the Vouchers folder [...]
[...] take them out of the billing process and allow them to be edited/deleted in the Time Entry Screen. Invoice Grouping
Org (Org/WorkCat/WrkOrd): One invoice per customer (Invoices will be sorted by Organization, Work Category, and Work Order number.) Org/Project (Org/Project/WrkOrd): One invoice per project and customer (Invoices will be sorted by Organization, Project, and Work Order number.) Org/Project/Phase (Org/Project/Phase/WorkOrd): One invoice per phase and customer [...]
[...]
The Posting Window field controls when transactions can be posted in the system. Any transaction (invoice, cash receipt, check, inventory transfer, production, etc) must be executed with an accounting date that falls within the posting window.
Click to open full image
Fields
Name: Name of the accounting software Note: Can not be left blank, must have one of the drop down options selected. Backend Type: Server type Note: Can not be left blank, must have one of the drop down options selected. Path to SYS Files: Location of accounting software on [...]
[...] Aging with Payments report displays the AR Aging with a Payment/Adjustment/Credit History for each invoice.
Report Filters
Customer No/Company: Enter a Customer Number or name to run the report for only one customer, otherwise leave these fields blank. Aging Groups (Days): Number of days for the different groups on the report. Age From: The report can age the invoices from Invoice Date or Due Date. Invoice Status: Choose an invoice status, or select All to see all invoices. [...]
[...] JOBREPORT1
The Project Job Cost Report displays project cost data from the Project Job Cost tab, along with invoice and payment totals. The report data is based on invoices associated with projects included on the report. In order for details to appear on this report, the Sales Order Type Overflow (SOTYPE2) rule must be set up with sales order types that create Job Cost Report data when invoiced. Note - If using Project Shipping, the sales order type of the first project record listed in the Project Shipping screen must be set up to save job cost data for the report. The entire [...]
[...] maintained in the Rule Maintenance screen by selecting Customer Transaction Codes from the drop-down menu Invoice Form: The invoice form used for this customer Invoice forms may be added/deleted in the Rules area of Adjutant by selecting Invoice [...]