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.
[...] Unbilled PO Receipts utility is also available for quickly writing off the PO Clearing values to an offset GL account. Depending on the scenario, the correct clean-up procedure may or may not involve creating accounting, or it may or may not involve voiding or reversing an existing record. Pay close attention to each situation and take the appropriate action to correct each situation individually. For more information on the Unbilled PO Receipts report, refer to the following Wiki : RECONCILE & BALANCE KEY GL ACCOUNTS
There are several general [...]
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 [...]
[...] 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. [...]
[...] 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 - [...]
[...] out the used coil. This should work with the AMSSCRAP2D Rule to apply the scrap amount to a correct GL Account. AMSMACHASUSER - When enabled, will display the machine as the user ID in the History tab of Item Master for jobs completed through AMS/Connex integration. AMSORDERSQL - Directs OrderIN, BundleI, and coilin into the correct SQL tables instead of files. Eclipse will have to updated to read from these SQL datatables instead of the .del files. AMSPUNCHISP - If set, then use RCODE = P as leading punch question. AMSSCRAP - If set, changes AMS process when running [...]
[...] 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 [...]
[...]
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 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 : Transaction >> Importers/Exporters >> Accounting >> GL Budget Export Screen Name : GLBUDGETEXP Function: Exports an existing general ledger budget to excel so that it may be modified and then re-imported using the GL Budget Import screen. You can also export a blank budget in order to create a new one in the same manner. GL Budget Export - Click for full size
Fields Starting GL Account: Enter a starting GL [...]
[...] Information on Payment Priorities can be found here . AP Invoice Master Invoice Detail Tab GL Distribution Tab General Information The GL Distribution Tab is there to assign the correct corresponding accounts for the invoice. AP Invoice Master GL Distribution Tab Account Numbers The GL Dist tab specifies the GL Account Distributions of your Invoice amount. The Control Account is the Payables account specified on the CID Maintenance screen, [...]
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, the GL Distribution records are assigned a Temporary [...]
[...] Complex pricing for purchasing and sales is easily maintained through separate item pricing and product groups. The Item Control module also allows you to maintain costs on several levels and automatically update costs based on multiple variables. It handles an unlimited number of warehouse locations, serialized items, and lot-controlled items and allows for the inclusion of freight in/out, direct, and indirect costs of the item. Attach notes to any item that automatically print on purchase orders, quotes, sales orders, and invoices. Easy-to-use search features make finding [...]
General Information
Default Menu Location Maintain >> General Ledger >> GL Types and Ranges Screen Name GLRANGE Function The GL Ranges can be viewed and edited from this screen. These Ranges define the categories of the General Ledger and how the Types are broken down in reporting.
The range numbers CANNOT overlap and MUST be set up at the same time the GL Accounts are imported.
GL Types and Ranges Screen Fields and Filters
Type Descrip Defines the type GL [...]
[...] 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: The heading to print on the top of the report. Sequence:
By Account Number
By Sequence Number - Uses the sequence number assigned on the GL Account Maintenance screen. Roll Up Groups
Double click the underline text to create a roll up group. Right click the underline text to show your new roll up group and select. [...]
[...] clicking OK. Fields/Filters
Required fields are indicated with * *Active - Enter Y to mark the GL account active. Enter N to import an inactive account. If this field is left blank, the GL account will not import. *GLAcct - GL account number. GL Account must match the GL Mask formatting established in CID Maintenance, [...]
General Information
Default Menu Location Maintain >> General Ledger >> GL Roll-up Groups Screen Name GLROLL Function The GL Rollup Groups are used as part of the Financial Report Writer . When creating a new rollup group check off the [...]
[...] FRACCPAC - FRACCPAC GENBATCHPOST - Asks user if they want to post new batches after generating batches. GL,INTERCOMP - GL,INTERCOMP GLFOX - GLFOX GLMAS500 - MAS 500 GL is being used. This setup option will also create a Journal Entry import file that may be imported to MAS 500. GLGENNEW - Runs one query per column in the financial report writer, then pulls row data out of the result set from this query. GLPOSTDATE - GLPOSTDATE GLRNOCLOSEENT - GLRNOCLOSEENT GRPSHIPBYCPO - Groups [...]
[...] 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 [...]
[...] Level establishes the indentation level of the line item. Node Levels are -1 for headers, 0 for sub-groups, and then 1 through 3 for increasing levels of indentation for the line items. Creating a new checklist in the Project Checklist rule is most easily accomplished using the Rule Detail Import from a spreadsheet.
Importing rule details is an advanced user function and should only be performed with the help of a support consultant. There is a high potential for data loss or data damage if the import is not performed correctly.
Details on the setup and field by field [...]
General Information
Default Menu Location Maintain >> General ledger >> GL Report Groups [...]
[...] not shipped report kill list rule (which removes the line from the report) and simultaneously make a GL adjustment to credit the non stock GL account and debit the extended cost of each selected line to the account selected. The Selected column is how you choose the rows to adjust and the Adj Date may be overwritten from the current date to reflect the GL period and year for the GL adjustment. The GL [...]
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 number Start Date: Filter to specific date End Date: filter to specific date Start Period: Filter to period End Period: Filter to period Period fields can be cleared [...]
General Information
Default Menu Location Maintain >> General Ledger >> GL Account Screen Name GLACCT Click here for a screenshot Function The GL Account screen allows new accounts to be entered. The Import From Acct button imports from the accounting general ledger chart of accounts . Master Tab
To add a new account, select the "Add" button in the upper right hand corner of the screen. enter all account info, then click the blue save button: Column Header: Used for identification, reports and other processes. Short Description: [...]
General Information
Screen Name: CLEANPG Function: The Clean Price Groups screen will look for invalid price groups made with [...]
[...] methods on the POS screen: CASH, CC, CHECK, NSF (for insufficient funds processing), and OTHER. Cash GL Account (Text2,30) = Specify the default cash general ledger account for the selected POS Cash Code. AR GL Account (Text3,35) = The AR GL account specified here is intended for use ONLY with the NSF cash code to process insufficient funds transactions in either the POS Processing screen or the Apply Cash Receipts screen. A unique AR GL Account tied to the NSF code will create any [...]
General Information
Default Menu Location : Transaction >> General Ledger >> Close GL Period/Year Screen Name : GLCLOSE Function: The Close GL Period and Year screen is used to close a period, year or to re-close prior year. The Current GL Period and Current GL Year are stored in the CID record and are automatically loaded onto the screen. Closing a Period changes the current fiscal period. You can still post entries into a closed period that is not locked. Locking a Period [...]
General Information
Default Menu Location Transaction >> General Ledger >> GL Journal Entry Screen Name GLJEBATCH Function The General Ledger module is completely integrated with all modules and is the key to maximizing the efficiency and accuracy of your financial data. Batch Header Tab
Journal Entry Batch Header Tab Batch Number Posting Year/Period Control Total The total amount for the specific entry, to ensure debits and credits balance. Reference Notes Reverse Rev Year/Period Batch Entries Tab
GL Batch Entry [...]
General Information
Default Menu Location Maintain >> General Ledger >> GL Segment Values Screen Name GLSEGMENT Function The GL Segment Values are used in building reports in the Financial Report Writer . GL Segments Fields/ Filters
Select a Segment: This is a drop down selection created using the GLSegments rule. The segment is the [...]
[...] Fields
APINVNO: AP Invoice number BIDPO: Bid PO/Vendor Inquiry BOL: Bill of Lading GLBATCH: GL Batch number INVNO: Invoice number LOTNO: Lot# on PO Receipts (only if POAUTOLOT setup option is selected) PONO: Purchase Order RFQNO: Customer Quote SONO: Sales Order/Work Order TASK: Service Order (if TASKNEWSEQ setup option is selected) WONO: Production Work Order Accounts
The Accounts tab contains the system default GL accounts for many different transactions. It also allows you to setup the GL [...]
[...] 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 Acct - The GL account that the report will start on End GL Acct - The GL account that the report will stop on Detailed - If this is selected, [...]
