ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents Back
 . . . . . . . . . . . . .
DrillDown Icon Accounts Receivable (AR)
DrillDown Icon Accounts Payable (AP)
DrillDown Icon General Ledger (GL)
DrillDown Icon Prerequisites
DrillDown Icon View GL Accounts
DrillDown Icon Journal Entries
DrillDown Icon G/L Release/Posting/Closing
DrillDown Icon Release and Post to GL
DrillDown Icon Prerequisites
DrillDown Icon Introduction
DrillDown Icon Fields and Definitions
DrillDown Icon General Ledger Release & Post Screen
DrillDown Icon Release Screen
DrillDown Icon Post Screen
DrillDown Icon How To ......
DrillDown Icon Reports-Variance
DrillDown Icon End of Period & F/Y Closing
DrillDown Icon General Ledger Reports
DrillDown Icon Bank Reconciliation
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
General Ledger Release & Post Screen
 
 
Allow Posting to: This field will display if posting is allowed to: Prior Fiscal Year; Prior Periods; Future Periods. This information defaults in from the G/L Post Defaults module.
Current Period This field will display the current Fiscal Year, and Accounting Period that the system is working in.  This information defaults in from the G/L Post Defaults module
Depress this button to Release ALL records that have the "Yes" radial selected.
Depress this button to Post ALL records that have the "Yes" radial selected.
Transaction Description The types of Transactions contained in the ManEx System.
Earliest Transactions to Reconcile  (FY/Period) This field will display the earliest unreleased or unposted fiscal year and period for the type of transaction.
Release/Post Method This field will display the default method of posting the transaction type. This information defaults from the G/L Post Defaults module: Manual Rel/Manual Post; Auto Rel/Manual Post; or Auto Rel/Auto Post.
Available to Release This field will display a “check mark” if there are unreleased transactions for the Fiscal Year and Period selected, otherwise it will be blank. This field will only be displayed if the default method for the transaction type is "Manual Rel/Manual Post".  
Uncheck All to Release This field will only be editable in the "Edit" mode and will default with a "check mark' if there are transactions to release for that type of transaction.  User will be allowed to uncheck the box if they do not want to release that type of transaction when depressing the "RELEASE" button at the top of the screen.   This field will only be displayed for those transactions that are set for “Manual Rel/Manual Post”.   

Click to View & Release

Click on the magnifying glass to view all records waiting to be released, the release screen will appear and user will be able to select and release records within this screen.
Available to Post This field will display a “check mark” if there are unposted transactions for the Fiscal Year and Period selected, otherwise it will be blank. This field will only be displayed if the default method for the transaction type is "Manual Rel/Manual Post" or AutoRel/Manual Post.  
Uncheck All to Post This field will only be editable in the "Edit" mode and will default with a "check mark' if there are transactions to post for that type of transaction.  User will be allowed to uncheck the box if they do not want to post that type of transaction when depressing the "POST" button at the top of the screen.   This field will only be displayed for those transactions that are set for “Manual Rel/Manual Post” or Auto Rel/Manual Post.  
Click to View and Post Click on the magnifying glass to view all records waiting to be posted, the post screen will appear and user will be able to select and post records within this screen.
 
Transaction Types:
 
General Journal Entries
Sales
The Journal Entry is created once the Customer Invoice is printed.  Accounts Receivable is increased by the total amount of the invoice.  Sales are increased by the sales price of the items sold.  If freight is charged to the customer, that value is recorded.  If sales taxes are charged to the customer, the appropriate entry is created.  Also, Finished Goods inventory is relieved and the accompanying entry to Cost of Goods Sold is created.

 If the user has created a Credit Memo, the entry to record same is created automatically, pro-rata relieving Accounts Receivable, Sales, etc. AND also Reinstating Inventory for any usable inventory returned by their customer.  Any Unusable Inventory returned can be directed to the Scrap Account.  The system also accepts General Credit Memos, and creates the entry after prompting the user for the appropriate General Ledger Account Number
Deposit Receipt 
Once any Bank Deposit is recorded in the ManEx Accounts Receivable module, the Underlying Journal Entry is created, increasing the bank balance and offsetting Accounts Receivable.  If the Cash Receipt is for a Customer Prepayment or Deposit, the Journal Entry records the information according to the default set up by the user.  Also, any Miscellaneous Receipt prompts the user for the General Ledger Account Number at the time of data entry, then the ManEx system creates the entire entry.   
A/R Write-Offs

The user elects to Write Off any portion of the Customer Invoice, the ManEx system creates the appropriate Journal Entry, reversing pro-rata the entry to Accounts Receivable and sets up the offset to Reserve For Bad Debts.

Credit Memos  If the user has created a Credit Memo, the entry to record same is created automatically, pro-rata relieving Accounts Receivable, Sales, etc. AND also Reinstating Inventory for any usable inventory returned by their customer.  Any Unusable Inventory returned can be directed to the Scrap Account.  The system also accepts General Credit Memos, and creates the entry after prompting the user for the appropriate General Ledger Account Number.
Purchasing

ManEx handles payables created via the Purchase Order module, any Miscellaneous Payables entered via the Manual A/P Entry, or a Recurring Payable in the same fashion. Once the PAYABLE is recorded in the A/P Aging area, the entries to record the payables are set up. The entry increases inventory, expenses, assets and accounts payable. 

Un-Reconciled Receipts When an inventory item is received into stock a transaction is created within the un-reconciled receipts (according to its standard cost) (this is the holder to account for received material) until the receipts are reconciled.
Checking

Once Account Payable Checks have been printed, the ManEx system automatically records the appropriate Journal Entry relieving the bank and the Accounts Payable account.ManEx provides the same type of Journal Entry if a Manual Check is recorded.The entry relieves the bank and increases the appropriate General Ledger Account Number entered by the user at the time of recording.

If the user has voided any previously printed or Manual Checks, the ManEx system automatically reverses the original entry

Debit Memos

If the user has created a Debit Memo against any Active A/P Balances, the entry to reverse the payable is created automatically, pro-rata reversing the original payable.Additionally, when the user creates a Discrepant Material Return from Inventory, a Debit Memo will forward to Accounts Payable. The applicable entry will be created debiting Accounts Payable and crediting Raw Materials Inventory.

Inventory Receiving
An entry is created at the time the user Records a Receipt via the Inventory handling function.  Raw Materials Inventory is increased with the offset as defined by the user.
 
The other way these entries are created is when the assembled product is moved to the Finished Goods work center in the Shop Floor Tracking module. The entry created by the system is to increase Finished Goods Inventory, with the offset to Work In Process.  If there was a Configuration Variance (see below) this entry is also created.
Inventory Issues

There are four types of inventory issues:

An entry is created at the time the user records an Issue via the Inventory Handling function.  Raw Materials Inventory is decreased with the offset as defined by the user. 

The other way these entries are created is when the raw material components are pulled for a Work Order.  The Entry created by the system is to increase Work In Process Inventory, with the offset to Raw Materials Inventory. 
 
When a Physical Inventory is reconciled, the user may update the Inventory Master for the Inventory On Hand.  Note that this action requires a supervisor’s password or specific Post Inventory Adjustments authorization in the Security Utility tab.  All of the Reconciled Count Numbers will update the Quantity On Hand in the Inventory Master.Additionally, the requisite Journal Entires for any variances will forward into the accounting module.

Note that Journal Entries will not be created in the following circumstances:
Consigned stock
In Store additions
Inventory Transfers

If, when a Cycle Count is reconciled with the Inventory Records, the count is different than the record, then the user is prompted whether to accept the difference or to recount and re-enter. Count Adjustments are logged to the GL Adjustment Account, if accounting is used. 

Purchase Variance
When parts are procured, the purchase order may have a price different than the standard cost. To balance the accounts payable values with the increases in inventory, the difference between the standard cost and the purchase price (based on the PO Reconciliation done in Accounting with the actual invoice) is charged to PPV, or Purchase Priced Variance. E.G., if a parts standard cost is $1.00, and the INVOICE is $1.15, then $1.00 is credited to inventory, $0.15 is credited to PPV, and $1.15 is debited to AP.    There are FIVE reports available that detail out the source of the transactions.
For more information on the four Variances see Article #3053
Configuration Variance
When the standard cost of an assembly is different from the sum of the standard costs of its components, the difference must also be addressed in WIP. E.G., if the standard cost of an assembly is $10.00, and the sum of the standard cost of the BOM components is $11.00, then upon moving the assembly from WIP to FGI, WIP is credited with $11.00, Configuration Variance is Debited $1.00 and Inventory is debited $10.00.    There are FOUR reports available that detail out the source of the transactions. 
For more information on the four Variances see Article #3053
Manufacturing Variance When the work order has had material kitted to it in addition to that called out by the BOM, or the kit is finished with missing parts (maybe freebies that didn’t get to inventory), the difference between the total issued to the work order and the total value of the BOM parts becomes the Manufacturing Variance. E.G. one batch of parts got lost even though they were kitted to the work order, and a second batch of parts was issued to the work order, the second batch would be a manufacturing variance, since they were lost in the manufacturing process. There are FOUR reports available that detail out the source of the transactions. 
For more information on the four Variances see Article #3053
Scrap

At the end of the production process, items transferring into the Scrap Work Center create an accounting entry increasing the scrap default account and decreasing WIP for the value of the number of units of the assembly at the assembly’s Standard Cost. 

Additionally, when an Engineering Change Order deletes a line item and that line item is defined as “SCRAP”, an entry increasing scrap and decreasing Raw Materials Inventory is generated.

Within Inventory Handling, the Entry created is to record the movement of Inventory from one warehouse location to another increasing or decreasing General Ledger accounts as defined by the user. 
Cost Adjustments

This entry is created in the Standard Cost Adjustment Module.  Once the rollup is completed, any adjustments to General Ledger forward to Accounting. The user is allowed to Post Changes to Standard Cost and to generate the General Ledger Entries.  Note:  This requires a high level accounting password.  

Other Costs Includes Labor, Overhead,  User Defined, and Other Costs
Accts Receivable Prepay These transactions are for an A/R Offset. 

 

NSF Checks

If checks previously deposited are returned, the entry to reinstate any Accounts Receivable balance and to lower the appropriate bank account is created automatically when the user records a returned check.

Rounding Variance If there is a small percentage assigned to run scrap, and the components are in units of Each, we can't issue fractions of a component to the work order. So we would round up to the next integer. For example, if there is a qty of 1 part per assembly (with a 2% run scrap) @ $1.00/ea and the Work Order is for a quantity of 10 we would issue 11 parts @ a total of $11.00 instead of 10.2 parts @ a total of $10.20. So we would be adding the value $11.00 to WIP, but only taking out the quivalent value of $10.20 based on the BOM standard cost. So the difference between the std cost calculation and the actual kit issuance (in the example, $0.80) would be charged to the Rounding Variance upon kit close. For more information on the four Variances see Article #3053
Accts Payable Prepay These transactions are for an A/P Offset.
 
 
 
 
 
 
 
 
 
 
 
Article ID: 5088