General Description Default Menu Location Reports >> General Ledger >> Financial Report Writer Screen Name GLREPORT Financial report writer Header tab screenshot Financial report writer Columns tab screenshot Function Financial Report Writer has the ability to generate different reports based on GL postings. Report Header Tab Report Name: Unique name to identify the report. Heading: [...]

Setting the AR GL account by sales order type — 1.2%

[...] Default Menu Location Maintain >> System >> Rule Maintenance Function The accounts receivable (AR) GL account used during the invoicing/shipping process and the point-of-sale (POS) can be established based on the sales order type. To utilize this feature, you need to update the Sales Order Type Overflow rule with the sales order type(s) and AR GL accounts you want to post against. Once the rule is updated properly, all orders with a matching SO Type will post the AR amounts to the specified GL account. [...]

AR Invoice Import — 1.2%

[...] 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 [...]

Adjutant End of Year Guide — 1.1%

[...] are committed from the ‘Completed Counts’ tab, an accounting batch is created for any inventory value adjustments and the inventory records are updated with the current count. For more information on the Cycle Count screen, refer to the following Wiki : CLEAN UP UNBILLED PO RECEIPTS The Unbilled PO Receipts report should be run throughout the year as a regular procedure to spot check for purchase order receipts that may need attention or correction. However, at end of year, it is important to perform a deep-clean of the report [...]

AR Aging with Payments Report — 1.1%

General Information Default Menu Location Reports >> Accounts Receivable >> AR Aging with Payments Screen Name ARAGINGPAY Function The AR 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): [...]

Sales Margin Report — 1.1%

Default Menu Location Reports >> Sales Force >> Sales Margin Report General Description Sales Margin Report screen allows users to generate detail sales report either by period or by date range. When generating a report, users can either generate a report for a specific customer by entering a customer code or leaving a blank in the "Customer Number" field to generate a general report for all the customers. Fields/Filters [...]

MBMA Quarterly County Shipments Report — 1.0%

General Description Default Menu Location Reports >> MBMA >> MBMA Quarterly Report Screen Name MBMAREPORTING NOTE - The MBMA Quarterly Report may need to be added to your default menu/menu prompts. Contact your consultant if you need assistance with this step. MBMA Quarterly Report Overview The MBMA Quarterly Report (Shipments by County) produces either a detail or a summary report showing the MBMA order items shipped/invoiced in the [...]

MBMA Monthly Report — 0.9%

General Description Default Menu Location Reports >> MBMA >> MBMA Monthly Report Screen Name MBMAMONTHLY NOTE - The MBMA Monthly Report may need to be added to your default menu/menu prompts. Contact your consultant if you need assistance with this step. MBMA Monthly Report Overview The MBMA Monthly Report produces either a detail or a summary report showing the MBMA order items processed in the specified reporting month. Sales Order [...]

Project Summary — 0.9%

[...] Description The Project Summary provides an active project summary or an active work order summary report. Report Filters Project#: The project number is automatically passed when the screen runs from the Project Screen or enter or select project number Project Name: The project name is automatically passed when the screen runs from the Project Screen or enter or select SrvOrd Primarily blank Start Date: Start date End Date: End date Report Selection Project: Run report [...]

Project Job Cost Report — 0.9%

General Information Default Menu Location Reports >> Project Management >> Project Job Cost Report Screen Name 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 [...]

Sales Order Report — 0.8%

Default Menu Location Reports >> Order Entry >> Sales Order Report Sales Order Report General Description Sales Order Report screen generates information on an open sales order. Fields/Filters Date Range: Time frame for the report Customer: Customer code Item: Item code SO Type: Sales Order Type Sales Person: Sales Person for the report Account Manager: Account manager for the report Warehouse: Warehouse [...]

Non Stock Not Shipped Report — 0.8%

[...] Default Menu Location Reports >> Item Control Screen Name invnonstock Function The purpose of this report is to provide a list of non stock items that have not been shipped. The screen has a second, Results tab which allows for edits to the report lines from a grid view. The screen will default in report mode which generates a detail or summary listing as shown below. Non Stock Not Shipped Report Non Stock Not Shipped Filters Tab With the Show Report [...]

Project Review Report UDF Questions — 0.8%

[...] Information Default Menu Location Maintain >> System >> Rule Maintenance Function The Project Review Report UDF Questions rule controls which Project Attribute UDF details can show up on the Project Review Report. Up to 10 UDF Report Codes can be set up in the rule. The Order value is used to tie each code to the corresponding report expression number. Rule Setup – Text Fields UDF Rpt Code: Enter the report code value (from the 'UDFs/Forms/Decision [...]

Task Status Report — 0.8%

[...] Function This screen is used to generate reports detailing the status of service orders. Task Status Report Fields/ Filters Client: Enter the client's name. Leave this field blank to display service orders for all clients. ShipTo: Enter the Ship To name. Leave this field blank to display service orders for all Locations (ShipTos). Like Match: This checkbox will allow the ShipTo field to act as a contains search instead of a singular organization search. Start Date: Enter the start date for your report. Leave this field blank to [...]

Cash Receipts Report — 0.8%

General Description Default Menu Location Reports >> Accounts Receivable >> Cash Receipts Report Screen Shot PRINTCASHAR Function The Cash Receipts Report is used to show payments received into the company. The report has various filters that are used to report on specific customers, accounts, dates, or invoices. Report Filters Custno: The Company ID in the field Company: The Company name (long name) to report [...]

Salesperson Collection Report — 0.7%

[...] General Information Default Menu Locator Reports >> Accounts Receivable >> Salesperson Collections Report Screen Name ' ARSP90 Salesperson Collection Screen Function Sales Person Collection Report screen allows you to see the status of aging AR reports. Report Filters Age From: [...]

General Ledger Report — 0.7%

[...] Reports >> General Ledger >> General Ledger Screen Name GLGENLEDGER Function This screen will produce a report that shows activity in the General Ledger within the specified ranges. How To Run the Report Enter in the Start and End periods Enter in the Start and End GL Acct ranges Select either Detailed or Summary view Apply desired filters. Data Fields & Buttons Start Period - The period the report will start from End Period - The period the report will end on Start GL [...]

Customer Bookings Report — 0.7%

General Information Default Menu Location Reports >> Order Entry >> Customer Bookings Report Screen Name BOOKINGREPT Function Customer Bookings Report displays Sales Orders by type, by company, and their spending per year. Click here for screenshot Fields/Filters Date Range: Specific time frame for the report Custno: Customer number or customer code Order Type: Order type for the report Sales Person: Sales person for the report Whse: Warehouse [...]

Financial Report Set — 0.7%

General Description Default Menu Locator Reports >> General Ledger >> Financial Report Set Screen Name GLREPSET Click here for a screenshot Function The Financial Report Set is a direct to print set of reports created through the Financial Report Writer . Report Operations Create a new report set by selecting [...]

Invoice Register Report — 0.7%

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 Invoice Date. Terr: Customer Territory (on SOLDTO screen). [...]

Bank Reconciliation — 0.7%

[...] BANKREC Function : The Bank Reconciliation screen provides an interface to reconcile Adjutant AP and AR transactions to your bank's current balance. The Bank Rec screen may also be used to enter Manual Cash Adjustments. Filters The Filter tab of the Bank Rec screen controls what is displayed on the Checks/Deposits/Adjustments tab. The user may select a Checking Account, Date Range, and Status. Leaving the Date Range blank will return all records for the selected checking account and status. The Group [...]

Auto Process Schedule — 0.7%

[...] Name : AUTOSCHVIEW Function: The Auto Process Schedule screen is used to set up automatic batches and report sets. Auto Process Schedule - Click for full size Schedule The Schedule shows a daily view of each report set and batch that is scheduled to run. You can scroll through each week by using the corresponding forward and backward buttons. The CID drop down will filter the schedule by the CID you select. Otherwise, it will show all CIDs. Double-click on any Report Set record on the screen to view more [...]

Invoice Register Report — 0.7%

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 [...]

Customer Sales Analysis Report — 0.7%

Default Menu Location Reports >> Sales Force >> Customer Sales Analysis Report Click here for screenshot General Description Customer Sales Analysis Report screen generates an analyzed report for customers by different salesperson. Fields/Filters Customer ID: Customer code Start Date: Beginning date for the report End Date: Ending date for the report Sales Person: Sales person for the report Item: Item code Standard [...]