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.
[...] screen (no assignments necessary). ALTPRINTBOX - Toggle between Getprinter and Printer Prompt type report form calls when enabled. ALTPROBCODE - Allows the user to edit the description of the Standard Task used in the Task Entry Screen. AMS - Integration with an AMS roll former controller (Eclipse Software) is being used. AMSADDCOIL - If set, then coil will be adjusted into the system to meet AMS demand. AMSADDSEIP - Automatically creates an Interplant Shipping Event during the assembly process from Connex usage if the Production Work Order (PWO) is an Interplant [...]
[...] Sales General Description
The County Sales reports allow tracking of missing MBMA county codes. Report Filters
Date Range: Sales order date Order Type: Sales order type Sort Orders: Customer Number, County, State Report Style: Summary, Detail Type of Report to Run
By Customer Number: CountyCode By County Summary: CountyCodeC By State Summary: CountyCodeS By State Detail: CountyCodeD By Customer Number - CountyCode
Standard Report Fields (Header - CountyCode)
Company [...]
[...] 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 and remove any lingering purchase order or accounts payable issues that have remained on the report throughout the year and need attention. This end of year deep clean can have several benefits:
[...]
[...] available as a jump screen from reports with the SaveRS button. Screen Name : SAVERS Function: Saves Report Options (dates, forms, filters, etc) so that a report can be included in a Report Set. Report Sets can be run manually from the Run Report Sets screen or they can be automatically processed by adding them to the Auto Process Schedule . Save Report Options - Click for full size Instructions
Before pressing the SaveRS [...]
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. [...]
Default Menu Location
Reports >> Project Control >> Comparative Job Cost Report Please note that this is a custom report and may not be on your menu. General Information
The Comparative Job Cost report compares five categories for each Department: Estimated Weight Estimated Cost Actual Weight Standard Cost Actual Cost The categories are summed at the bottom of the report. Department Information
There are seven Departments shown on the report: [...]
General Information
Default Menu Location Reports >> General Ledger >> GL Distribution Report Screen Name GLDIST Function This report displays the distributions amongst the GL Accounts. GL Distribution Report Report Filters
Starting Batch Number: Filter to specific batch number Ending Batch Number: Filter to specific batch [...]
[...] Information Default Menu Location Maintain >> System >> Rule Maintenance
Function The Inventory vs. GL Dump Accounts rule controls which general ledger accounts are included in the overnight inventory reporting and reconciliation features, commonly referred to as the Nite Inventory process. Each GL account set up in this rule will be processed nightly, and will have account balances and transaction details stored in the data tables used for the Nite Inventory and Nite Usage reports. This rule controls which accounts have transaction vs. [...]
[...] 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 [...]
[...] bill. Inv Date - Invoice Date Post Date - Post Date Amount - Amount of the bill. 1099 Amount - Report payments made in the course of the invoice to a person who is not an employee or to an unincorporated business. Due Date - Due date of the invoice Disc. Date - If an invoice has a discount for paying by a certain date, this is where one would put the due date for the discount. Exc from Disc. - The amount that is excluded from the discount. Ref # - Reference # Pay Priority - Select the priority of the payment. One can set a default payment priority for a vendor [...]
[...] general ledger information that can be used to research historical inventory values, inventory usage, and GL Balances on a given day in history. This allows users or consultants to generate a snapshot of the data as it was that night. This archived historical data can be useful in case of audits or researching reconciliation for inventory accounts. The Nite Inventory process is a system service that must be set up by ABIS personnel in order to start tracking nightly inventory and GL reconciliation data. Contact your ABIS consultant if you want [...]
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 [...]
[...] options is the batch for Invoicing (Sales Order shipment or Time Entry billing). Many things affect which GL accounts will be debited or credited when creating an invoice. There are typically 5 accounts affected during invoicing: 1. Accounts Receivable - AR is debited in the amount of the invoice. 2. Revenue - Revenue is credited in the amount of the invoice less sales tax. 3. Sales Tax - Sales Tax is credited in the amount of the tax on the invoice. 4. Cost of Goods Sold - COGS is debited based upon the cost of the items on the Sales Order. 5. Work in Process - [...]
[...] 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.
Rule [...]
[...] Location Reports >> Accounts Receivable >> AR Aging Screen Shot ARAGING Function The AR Aging report displays Accounts Receivable aged into four different periods. The time period groups will default to 30-60-90-120 days, but can be changed by the user. Fields/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 [...]
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 [...]
[...] 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 [...]
General Screen Name - MGLTBATCH Use - The Update TBatches screen is used to find and correct GL Distribution lines linked to Temporary Batches (T Batches). During the General Ledger batching process, the GL Distribution records are created first, then the Batches are created, then the Distributions and Batches get matched together. In between the process of creating the GL Distribution records and creating the Batch records, [...]
[...] f7 - Balance - AP invoice open balance f8 - UDRef - AP invoice reference # f9 - APAcc - AP payable GL account stored in the APMAST table. This is used for selecting AP invoice records by payable account on some reports. This value should match the account flagged as the control account in the AP Invoice Distribution import. f10 - PurDate - AP Invoice Date value. Generally the date marked on the invoice. (MM/DD/YYYY) f11 - TranDte - AP invoice Post Date value, or the date that the invoice was posted. (MM/DD/YYYY) f12 - DueDate - AP invoice [...]
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 [...]
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 [...]
[...] 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 [...]
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 [...]
[...] 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): Number of days for the different groups on the report. Age From: The report can age the invoices [...]
[...]
General Information Default Menu Location Maintain >> System >> Rule Maintenance
Function The GL Accounts for Inventory rule controls is a companion rule with the Inventory vs. GL Dump Accounts (INVDUMP) rule. Both rules together control which general ledger accounts are included in the overnight inventory reporting and reconciliation features, commonly referred to as the Nite Inventory process. This rule controls which GL accounts have their data sent to the nightly historical tables. Each GL [...]
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 [...]
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). [...]
[...] 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 [...]
General Description
Default Menu Location Transaction >> Importers/Exporters >> Accounting >> GL Budget Import Screen Name IMPORTBUDGET Function The GL Budget Import screen imports an Excel spreadsheet which can be viewed in the Budgets tab of the GL Account screen.
Import Budget Screen
Fields/Filters
File Name/Browse: Use the Browse button to locate and select the completed GL Budget import template file (in XLS format) Export Template: Generates a blank GL [...]
General Information
Default Menu Location : Maintain >> General Ledger >> GL Groups Screen Name : TRANCAT Function: GL Groups are used to drive revenue and costs to sub-accounts in the general ledger. Working hand in hand with Transaction Categories , the GL Group will mask over a particular part of the account number to offer more options in driving revenue and costs to the GL. GL Groups may be applied to: Sales Order Types, Warehouses, Departments, [...]
