M9-SO-1306 Additional Fees Posted to Item Sales Account

From BlythecoDev Wiki

Jump to: navigation, search

Contents

Synopsis

This Extended Solution modifies Sales Order Sales Journal Update to reduce what is posted to the item’s Sales account by three numeric amounts. The numerics are labeled Freight 1, Freight 2 and Galvanizing and are calculated from three user-specified detail UDFs and the line’s weight extension. The numerics will post to two specified G/L Account Numbers. These fields have no impact on the unit price or line extension.

Sage Software Extended Solution SO-1050: S/O Weight & User Defined Category Item must be installed and enabled and the Custom Office module must be activated for this Extended Solution to function.


Installation

Before installing any Extended 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.

Extended Solutions Control Center

Installing any Extended Solution will add an Extended 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
  • Extended 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 Extended Solution.

Setup

Upon completion of software installation, you will need to access Extended Solutions Setup from the Sales Order Setup menu. Select this part number, and the Setup screen for this Extended Solution will appear (Figure 1). Check the ‘Enable Extended Solution’ box to activate this Extended Solution.

SO-1306 Setup Options


Answer the following prompts:

S/O INVOICE DETAIL UDF FOR ‘FREIGHT 1’: Specify the numeric type S/O Invoice Detail UDF, which will hold the first freight.
S/O INVOICE DETAIL UDF FOR ‘FREIGHT 2’: Specify the numeric type S/O Invoice Detail UDF, which will hold the second freight.
S/O INVOICE DETAIL UDF FOR ‘GALVANIZING’: Specify the numeric type S/O Invoice Detail UDF, which will hold the galvanizing fee.

In order for you to enter these values in Sales Order Entry, you will need to have S/O Sales Order Detail UDFs of the same name established, and in order for their values to transfer to Invoice Entry, they must be appropriately data sourced.

G/L ACCOUNT FOR FREIGHT: Enter the G/L Account Number which will be used when posting the two Freight fields.
G/L ACCOUNT FOR GALVANIZING: Enter the G/L Account Number which will be used when posting the Galvanizing fee.

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

Role Maintenance
The following Task has been added to Sales Order, Setup Options:

  • Extended Solutions Setup

Please review your security setup in Role Maintenance and make appropriate changes.

Operation

During Sales Order and S/O Invoice line entry, you can manually enter the value for Freight 1, Freight 2 and Galvanizing into the specified UDFs. The values are assumed to be the ‘per unit’ value. The values in the UDFs have no impact on the Unit Price or Extension.

During the Sales Journal update three additional numeric values will be calculated:

  • Freight 1 is calculated as the extended line weight from SO-1050 divided by 100, then multiplied by the numeric held in the UDF being used for Freight 1.
  • Freight 2 is calculated as the extended line weight from SO-1050 divided by 100, then multiplied by the numeric held in the UDF being used for Freight 2.
  • Galvanizing is calculated as the extended line weight from SO-1050 divided by 100, then multiplied by the numeric held in the UDF being used for Galvanizing.

A modified Gross Profit Journal, SO_GROSSPROFITJOURNAL2_001.RPT, ships with this Extended Solution. When you run this report, the Sales Order Gross Profit Journal will print the additional account numbers and their calculated posting amounts (Figure 2).

SO-1306 Sales Order Gross Profit Journal


The following Inventory files will be written to using the line extension less the sum of the calculated numerics for the line:

  • Inventory Item Warehouse Detail: PTD Dollars Sold, YTD Dollars Sold, Dollars Sold – Next Period
  • Warehouse Item Sales History: Dollars Sold for Period
  • Customer Item Sales History: Dollars Sold for Period

The items’ Sales Account will post this same reduced value; the difference will post to the Freight & Galvanizing accounts noted in Setup.

No changes have been made to the postings to the Accounts Receivable and the COGS Accounts. The Accounts Receivable and Sales Order data files are unchanged.

Crystal Reports and the ODBC Dictionary

The files listed below have been added, or changed, in the ODBC Dictionaries by this Extended Solution for Crystal Reports purposes.

SO-1306 ODBC Dictionary

Be aware that the ODBC Dictionaries may contain other files and data fields that will be unavailable without their corresponding Extended Solutions installed.

What’s New

With the 10-30-08 release

  • Converted to the business framework
  • Changed SO-1014 UDFs to Custom Office UDFs

Upgrades and Compatibility

The installation CD is labeled with the version of the MAS 90 MAS 200 module for which this Extended Solution was prepared. This Extended 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 Extended Solution must be upgraded as well. Your MAS 90 MAS 200 dealer can supply this upgrade.


Documentation

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.


Acknowledgments

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