S/O Invoice Payment Terms - Sage

1 S/O Invoice Payment Terms SO-1039 Overview This Extended Solution to the Sales Order module adds new FORM fields to Sales Order Invoice printing and the A/R Invoice History Printing Option for Sales Order Invoices. Depending on your Setup, it also may change the way the Terms Discount is calculated. Installation Before installing this Extended Solution, please verify that the version level(s) printed on the CD label are the same as the version level(s) of the MAS 90 MAS 200 module(s) you are using. For further information, please see the Upgrades and Compatibility section below. Check your Shipping Manifest for a complete list of Extended Solutions shipped. For detailed installation instructions, please refer to the Sage website at: Installing Your Extended Solutions under Windows From a CD If you have the autorun function turned on for your PC, the installation program will start up automatically.

2 If not, find the file on your CD-ROM drive and double-click it to start the installation program. Follow the on-screen instructions. From the Sage FTP site When your Extended Solution is ready to be downloaded, you will receive an email from telling you that it is ready. The email will contain the Customer Name, Cross Reference, a case-sensitive Password, a link via which you can download your Extended Solution, instructions and a Shipping Manifest. If you have any problems with this order, please email and we will assist you during normal business hours. 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: Extended Solutions Manuals Remove Extended Solutions Unlock Extended Solutions Merge Installation Files Extended Solutions Setup options Sage Software, Inc.

3 888-856-2378 2005 Sage Software, Inc. All rights reserved. SO-1039 (Revised 07/05) Page 1 Setup Once the disk is installed, you will need to access the Sales Order Setup menu option screen. After the option screens have been displayed, a Setup screen for this Extended Solution will appear. Check the Enable Extended Solution box to activate this Extended Solution (Figure 1). The manual for this Extended Solution, if it has been installed, can be viewed by clicking the Manual button next to the Enable Extended Solution check box.

4 It can also be viewed via the Extended Solutions Control Center (see Installation, above). Figure 1 Answer the following prompts: CHANGE Terms CALCULATION TO USE: Choose Amount Subject to Discount, Gross Sales Amount or Net Sales Including Tax Amount, or choose None to use Terms Discounts. SO-1014 LINE ITEM UDF FOR Terms DISCOUNT PERCENTAGE: If you have SO-1014 installed and enabled, you can enter an SO-1014 Line Item UDF for Terms Discount Percentage. SO-1014: User Defined Fields For Sales Order must be installed and enabled in order for this option to function. You should visit this Setup screen after each upgrade or reinstallation of this Extended Solution. Sage Software, Inc. 888-856-2378 2005 Sage Software, Inc.

5 All rights reserved. SO-1039 (Revised 07/05) Page 2 Operation If an A/R Terms Code does not have discounts activated, then the new FORM fields (see FORMs) are not printed for that Invoice . The Payment Terms Message Block allows for the entry of six lines of text (35 characters each) and is maintainable from the new SO-1039 Option Setup screen (See Setup). Special variables may be inserted into the text that are replaced during printing by the actual data based on the A/R Terms Code for a particular Invoice . The following fields are available for use as variables in the Payment Terms Message Block: Early Payment Date, Discounted Pay Amount, and amount Saved by Early Payment . Also available are Tax Amount Calculation on the Discount Amount [discount amount * current tax rate * (taxable amount / {taxable + non-taxable amount})], Discount Amount Plus Tax Calculation on Discount Amount (Discount plus tax calculation on Discount Amount), and Line Terms [(Qty * Unit Price) * UDF].

6 Terms CALCULATION OPTIONS Standard Terms Discount Option If you wish to use this Extended Solution to print only the discount variables and/or the text block and do not want to change the calculation of the Terms discount amount, do not use the Amount Subject to Discount or Gross Sales Amount options (see Setup above). Amount Subject to Discount Option If you are using the Amount Subject to Discount option, the Terms discount amount will be calculated by applying the Terms discount percent to the Amount Subject to Discount on the S/O Invoice totals screen (see Helpful Hints for more information). This Extended Solution doesn t affect the calculation of the standard trade discount amount. Gross Sales Amount Option This feature was developed for a specific client to its specifications and may not conform to generally accepted MAS 90 MAS 200 standards and procedures.

7 These features may or may not benefit you in your application of MAS 90 MAS 200. If you are using the Gross Sales Amount option, the discount is calculated by line item for three line types, 1-Regular Items, 2-* Special Items and 5-Miscellaneous Items, all other line types are ignored. The calculation for the Discount Amount uses this formula: Discount Amount = (Qty Shipped * Unit Price) * Terms Discount Using the Gross Sales Amount option changes the way that sales figures are calculated for the following reports: Daily Sales Recap By Item Daily Sales Recap By Warehouse By Item Daily Sales Recap By Product Line Daily Sales Recap By Warehouse Daily Sales Recap By Customer Daily Sales Recap By Division Sage Software, Inc.

8 888-856-2378 2005 Sage Software, Inc. All rights reserved. SO-1039 (Revised 07/05) Page 3 Daily Sales Recap By Warehouse By Product Line Monthly Sales Recap By Product Line Monthly Sales Recap By Warehouse Monthly Sales Recap By Warehouse/Product Monthly Sales Recap By Division Customer Sales History Recap For all items sold on a Sales Order Invoice , the sales figure is calculated net of the line item discount and net of the Invoice s Terms discount printed in rounded, whole percentages. Selecting Gross Sales Amount also changes the way Sales Subject to Commission is calculated on the Salesperson Commission Report.

9 For Items with commissions sold, the amount subject to commission is calculated net of the line item discount and net of the Invoice s Terms discount. The subsequent Gross Profit and Profit Percent fields reflect the modified Sales Subject to Commission amount. Also, selecting Gross Sales Amount changes the S/O Sales Journal Update, so that the Terms Discount amount is calculated using the same formula as the Sales Invoice FORM printing does. This discount amount will be saved in the A/R Open Invoice file so that it will appear on all reports and screens that display the Discount Amount. Net Sales Including Tax Amount Option If you are using the Net Sales Including Tax option, the Terms Discount is calculated by applying the Terms Discount percentage to the following formula: Discount Amount = Amount Subject to Discount - (Discount Amount + Sales Tax) Note that the Amount Subject to Discount and the Discount Amount come from the Invoice Total screen and are not related specifically to Terms Discounts.

10 SO-1014 UDF for Terms Discount An option has been added to Setup to enter an SO-1014 numeric UDF to hold the Terms Discount. During Sales Order Invoice Printing, the sum of the Line Item Terms Discount Amounts will be available for printing in the text portion of this Extended Solution. This field will be calculated as: (Qty * Unit Price) * UDF = Line Item Terms Discount Amount There will be no on-screen display of this calculated amount. The line item extended amount will remain the same. This calculated amount will replace any standard Terms Discount Percentages and will be updated to History. All FORM fields with ** in front of them will also be available for printing. The Line Discount option in Sales Order Setup must be set to N in order for this feature to function.