M9-JC-1007 Revenue Posting by Cost Code - Cost Type

From BlythecoDev Wiki

Jump to: navigation, search



This Custom Solution to the Job Cost module changes the way job revenue is posted to General Ledger. Normally the revenue and deferred revenue accounts are specified by Job Type; all revenue from a job will post to these accounts. This Custom Solution allows revenue to be posted and tracked according to the Cost Code and Cost Type which generated the revenue. This functionality also exists from Sales Order when Sales Order is integrated with Job Cost.

Additional functionality is available if you have Custom Solution SO-1530: Enhanced Sales Order Integration with Job Cost installed and enabled.


Before installing any Custom Solution, please verify that the version level referenced on your installation file is the same version level as your Sage 100 (MAS 90 MAS 200) installation. (For more information please call (800) 425-9843). It is recommended to have a complete and tested backup prior to installing any application on your Sage 100 (MAS 90 MAS 200) platform.

Custom Solutions Control Center

Installing any Custom Solution will add an Custom Solutions Control Center to the Sage 100 (MAS 90 MAS 200) Library Master Utilities menu. When you open the Control Center, the following options will be available:

  • Merge Installation Files
  • Custom Solutions Setup options

Custom Office

If you customize your Sage 100 (MAS 90 MAS 200), then you must run the Update Utility every time you install this Custom Solution.


Upon completion of software installation, you will need to access the Job Cost menu option screen. After the standard MAS 90 MAS 200 option screens have been displayed, a Setup screen for this Custom Solution will appear. Check the ‘Enable Custom Solution’ box to activate this Custom Solution (Figure 1).

JC-1007 Setup Options

Answer the following prompt:

APPLY TO ACCOUNTING METHOD: Select ‘Percent Complete’ to post revenue to Percent Complete jobs, select ‘Contract Complete’ to post revenue to Contract Complete jobs, or select ‘Both.’

You should visit this Setup screen after each upgrade or reinstallation of this Custom Solution.


Cost Code Maintenance
Cost Code Maintenance has been modified with a ‘More’ button (Figure 2). Click the button to access ‘Revenue Posting by Job Cost/Job Type’ (Figure 3). Revenue and Deferred Revenue accounts can be entered and maintained for each active cost type.

JC-1007 Cost Code Maintenance

JC-1007 Revenue Posting by Cost Code-Cost Type

Job Cost, Job Billing
During Job Billing Update, these accounts are used to post the revenue to General Ledger. If an account is not entered for a particular cost code/cost type combination, then the accounts set up in Job Type Maintenance will be used. The invoiced revenue buckets are updated during the job billing update and during period end processing.

This Custom Solution does not have any effect on Miscellaneous Charges or Fixed Price Contracts since they do not bill by cost code.

Sales Order, Sales Journal Update
If you checked the Sales Order option to integrate with Job Cost, the sales revenue G/L account from Cost Code/Cost Type will default into Sales Order and Invoice Detail Entry. You can override the G/L account.

Job Close-Out Report
The Job Close-Out Report Update posts revenue from deferred revenue by Cost Code/Cost Type.

Helpful Hint

  • ‘Use Sales Order Accounts For Sales Revenue’ in SO-1530 Setup Options takes precedence over JC-1007.

Visual Integrator

The files listed below have been added or changed in the Data Dictionary by this Custom Solution for Visual Integrator purposes.
JC-1007 Visual Integrator
The Data Dictionary may contain other files and data fields that are not available without their corresponding Custom Solutions installed.

Crystal Reports and the ODBC Dictionary

The files listed below have been added or changed in the ODBC Dictionaries by this Custom Solution for Crystal Reports purposes.
JC-1007 ODBC Dictionary JC-1007 ODBC Dictionary
Be aware that the ODBC Dictionaries may contain other files and data fields that will be unavailable without their corresponding Custom Solutions installed.

What’s New

With the 12-04-06 release:

  • Added Sales Order module integration

Upgrades and Compatibility

The installation CD is labeled with the version of the MAS 90 MAS 200 module for which this Custom Solution was prepared. This Custom Solution will check its compatibility with the appropriate MAS 90 MAS 200 modules and will be disabled if an incompatibility is found. If you upgrade your MAS 90 MAS 200 modules, this Custom Solution must be upgraded as well. Your MAS 90 MAS 200 dealer can supply this upgrade.


Only changes made by Blytheco, LLC to the standard operation of Sage Software, Inc. MAS 90 MAS 200 have been documented in this manual. Operations not documented in this manual are standard procedures of MAS 90 MAS 200 processing. Standard MAS 90 MAS 200 processes, data entry screens, inquiry screens, reports, updates, etc., have not been changed unless addressed in this document.

Parts of this document may refer to the Specific Purpose Rule. When referenced, the described feature was developed for a specific client to its specifications and may not conform to generally accepted MAS 90 MAS 200 standards and procedures. These features may or may not benefit you in your application of MAS 90 MAS 200.


Copyright © 2010 Blytheco, LLC. MAS 90 and MAS 200 are registered trademarks of Sage Software, Inc.

Revision Note: 4.4

Personal tools
MediaWiki Appliance - Powered by TurnKey Linux