M9-AR-1138 Sales Tax Reduced by Discounts in Cash Receipts
From BlythecoDev Wiki
Contents |
Synopsis
This Extended Solution to the Accounts Receivable module adds a Discount field to the AR Sales Tax file. When an Invoice has a terms discount applied to it in Cash Receipts, Cash Receipt Journal update writes a record to this field. This record will be for calculated reduction of the sales tax.
Installation
Before installing any Extended Solution, please verify that the version level referenced on your installation file is the same version level as your 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 MAS 90 MAS 200 platform.
Extended Solutions Control Center
Installing any Extended Solution will add an Extended Solutions Control Center to the 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 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 Accounts Receivable 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.
You should visit this Setup screen after each upgrade or reinstallation of this Extended Solution.
Role Maintenance
The following Task has been added to Accounts Receivable, Setup Options:
- • Extended Solutions Setup
Please review your security setup in Role Maintenance and make appropriate changes.
Operation
If a terms discount is applied on an invoice during Cash Receipts entry, the C/R Journal update reduces the amount of Sales Tax owed for the Invoice as follows:
- A record is written to the AR Sales Tax file if the cash receipts date doesn’t equal the Invoice Date. This record will have a value in the Discounts_001 field. All the other numerics in the record will be zero. This record will use the Cash Receipt Date as the Transaction Date and the Invoice Number, Customer Number, etc. from the invoice. The tax reduction is calculated as:
- Current Tax Rate * Discount Amount * {Taxable Inv. Amount/(Taxable + Non-Tax. Inv. Amts)
The current tax rate equals sales tax amount/(taxable sales+taxable freight). This field has been added to the AR Sales Tax work file.
ODBC Dictionary
The files listed below have been added, or changed, in the ODBC Dictionaries by this Extended Solution for Crystal Reports purposes.
| File | Fields |
|---|---|
| AR_SalesTax | Discount_001 |
| AR_SalesTaxWrk | Discount_001 |
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 11-11-08 release:
- • Converted to business framework
- • No longer ships the Sales Tax Report; the Discount field has been added to the report’s work file
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
