Accounts Receivable Retention Tracking AR-1187

Transcription

1 Accounts Receivable Retention Tracking AR-1187 Overview This Extended Solution to the Accounts Receivable module adds the ability to store a retention amount associated with individual invoices. The retention amount is considered to be the portion of the invoices current balance that is not considered due and payable. Various locations within the Accounts Receivable module will be trained to recognize the retention amount and display and print this value. Note that only the indicated locations indicated below will be modified. There may be other locations within A/R that age invoices or a customer s balance, but unless they are noted herein, they have not been modified. Sage Software Extended Solution AR-1074: User Defined Invoice Header Fields must be installed and enabled in order for this Extended Solution to function. 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. If not, find the autorun.exe 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 from telling you that it is ready. The 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 and we will assist you during normal business hours Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 1

2 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 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 Once the disk is installed, you will need to access the Accounts Receivable 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). Figure 1 Answer the following prompt: 2005 Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 2

3 A/R INVOICE HEADER UDF FOR RETENTION: Enter a numeric AR-1074 UDF to hold the Retention value. During Invoice Entry, the amount you consider to be Retention may be entered into the AR-1074 UDF specified. You should visit this Setup screen after each upgrade or reinstallation of this Extended Solution. Operation This Extended Solution to the Accounts Receivable module adds the concept of storing a retention amount associated with each invoice. The retention amount is considered to be the portion of the invoices current balance that is not considered due and payable. Various locations within the A/R module will be trained to recognize the retention amount and display/print this value. The Customer Aging and Open Invoice Inquiry The column currently titled Discount Amount has been replaced by a column titled Retention in the Customer Aging and Open Invoice Inquiry available from Customer Maintenance and Customer Inquiry (Figure 2). In this column will display the value from the UDF you specified in Setup to hold retention. This value will display only for the invoice transactions, not for payment or other transaction types. The Invoice Balance column displayed will NOT be reduced by the Retention amount. The customer aging that displays in the lower portion of the screen has been modified as follows: the last aging column (e.g. 120 days) has been eliminated and the remaining columns have been shifted to the right. The far left column is a new column titled Retention. In this column will display the sum of the values in the UDF you specified in Setup to hold retention. The remaining columns are calculated normally. Figure Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 3

4 A/R Sales Journal Update and A/R Cash Receipts Register Update During A/R Sales Journal Update and A/R Cash Receipts Register Update, if an invoice referenced in the transaction batch has its balance equal to zero, the program will zero out the AR-1074 UDF designated to hold Retention. A/R Statement Printing A new form has been added to A/R Statement Printing, containing the following fields: RETENTION AMOUNT: this is the Invoice-level value from the UDF you specified in Setup to hold the retention. ADJUSTED BALANCE: this is calculated as each Invoice s Balance less the retention UDF amount. ADJUSTED TOTAL: this is calculated as the sum of the Adjusted Balances of the transactions that printed on the statement. RETENTION TOTAL: this is the sum of the values in the UDF you specified in Setup to hold retention for the Invoices printed on the statement. A/R Aged Invoice Report The Discount Amount and Discount Due columns have been eliminated from the A/R Aged Invoice Report. In its place will print a column titled Retention. In this column will print the value from the UDF you specified in Setup to hold retention. This column will total at the same locations the aging columns total. The Due Date field will be replaced by the Customer P/O Number from the invoice. No other columns will be changed. All will print their normal, unmodified values. See Figure 5 for an example of the report. Forms Non-Graphical Forms You can maintain the new form fields for this Extended Solution by clicking the Form button. A window will pop up where you may select the form you would like to maintain (Figure 3). Select this Extended Solution to display the Form Maintenance screen (Figure 4). Figure Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 4

5 Figure 4 Figure 5 is an example of a non-graphical form. Run Date: 07/16/98 MJF Page: 1 A/R Date: 07/16/98 Time: 09:15 AM Bootes Chemists Ltd ACCOUNTS RECEIVABLE AGED INVOICE REPORT ALL OPEN INVOICES - AGED AS OF: 07/16/98 DIVISION NO: 00 MAIN DIVISION CUSTOMER/ CUST RETENTION DAYS INV DATE INVOICE NO P/O NO. AMOUNT BALANCE CURRENT 30 DAYS 60 DAYS 90 DAYS 120 DAYS DELQ Rowntree /Macintosh CONTACT: PHONE: (206) /03/ IN #AADD /13/ IN /09/ IN /10/ AA-IN CUST PO /10/ BB-IN Cust po CUSTOMER TOTALS: Figure 5 The new fields that you activate with this Extended Solution will print in addition to any other fields that have been activated in FORM maintenance. Graphical Forms No changes have been made to the Crystal Reports Work Table files. If you have elected to use graphical forms in the modules Setup, the features of this Extended Solution that affect form printing will not be available Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 5

6 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 to the standard operation of 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 2005 Sage Software, Inc. All rights reserved. Sage Software, MAS 90 and MAS 200 are registered trademarks or trademarks of Sage Software, Inc. All other trademarks are the property of their respective owners Sage Software, Inc. All rights reserved. AR-1187 (Revised 08/05) Page 6

A/P Payment Selection Based on A/R Cash Receipts AP-1108 Overview This Extended Solution modifies the A/R Cash Receipt update process to write an Amount paid on a Sales Order Invoice to a corresponding

Purchase Order Form Memos PO-1119 Overview This Extended Solution to the Purchase Order module adds the ability to enter and maintain MAS 90 MAS 200-style memos. A new report has been added that allows

EDI Advantage Integration SO-1184 Overview This Extended Solution to the standard MAS 90 MAS 200 Sales Order module adds support for the EDI Advantage program from Kissinger Associates. Installation Before

Bank Reconciliation Integration with General Journal GL-1061 Overview This Extended Solution allows you to associate Bank Codes with specific General Ledger Account Numbers by Source Journal. When that

Default Entry Control for Bill of Materials BM-1008 Overview This Extended Solution to the Bill of Materials module defaults the Parent Warehouse and Component Line referenced Warehouse Code to the Inventory

Repetitive Invoice Event Log AR-1226 Overview This Extended Solution to the Accounts Receivable module records certain Repetitive Invoice changes to a log. As a change is made to the Item Code, Quantity

Daily Amortization Utility for Service Contracts GL-1060 Overview This Extended Solution provides an amortization utility which uses a daily rate for the purpose of recognizing revenue on service contracts

Auto Generate Purchase Orders from S/O Entry SO-1489 Overview This Extended Solution to the Sales Order module adds a 'Create PO' Button to Sales Order entry Totals tab which allows you to create Purchase

P/O Forms Printing Enhancement PO-1012 Overview This Extended Solution to the standard MAS 90 MAS 200 Purchase Order module adds new features and fields to the Purchase Order Printing program. Installation

Invoice Creation in Sales Order from Purchase Order Receipts PO-1086 Overview This Extended Solution allows you to automatically create Sales Order Invoices from Purchase Order Receipts. Either Extended

Paperless Office: Electronic Forms Delivery LM-1019 Overview This Extended Solution is designed to be used in conjunction with other Paperless Office Extended Solutions as a means of delivering documents

Job Cost Reports with Commitments JC-1035 Overview With this Extended Solution to the Job Cost module, the Job Cost Code Detail Report and Job Cost Transaction Detail Report will include a new option to

Truck Management System TR-1000 Overview The Truck Management module (T/R) is a complete tracking system designed to be compatible with the MAS 90 Accounts Payable and Payroll modules. Specifically designed

Enhanced Workers Comp Processing PR-1100 Overview This Extended Solution to the Payroll module adds a Check limit to Workers Compensation Processing and an override Workers Compensation State to an employee

Reorder Information Recalculation Utility IM-1153 Overview This Extended Solution to the Inventory Management module adds a utility for recalculating the Minimum Order Quantity, Reorder Point and the Maximum

MICR Laser Checks for Accounts Payable AP-1025 Overview This Extended Solution to the Accounts Payable module allows you to print checks on your laser printer, including manual checks, with the MICR-encoding

Accounts Payable Expense Distribution Tables Use Expense Distribution Table Maintenance to set up tables with general ledger accounts and distribution percentages. The tables can then be selected in Invoice

PestPac Software General Ledger Module The General Ledger Module in PestPac allows certain transactions to be recorded and then be exported into a format that is compatible with your accounting software.

AccuPOS to MAS90/200 Integration Guide Part I - MAS90 Company Setup In order to use AccuPOS Point of Sale and have it integrate with MAS90/200 for inventory and accounting purposes, we ask that you setup

Repairing Your Accounting System Who is this paper for? This paper is for companies that have been using DBA Next-Generation for some time, but have struggled up to now with getting the accounting system

Sage 100 ERP Installation and System Administrator s Guide This is a publication of Sage Software, Inc. Version 2014 Copyright 2013 Sage Software, Inc. All rights reserved. Sage, the Sage logos, and the

Accounts Payable Invoice from Purchase Order Purchase Order Setup From Main Encompass Menu select Property Management Tab and then winpo From Main Purchase Order Menu select Setup Tab and then PO Status

REMINDER: Please remember that this document is meant to be a guideline with some ideas of ways you can use MAS 90 / 200 core accounting modules more fully. However, your settings or process may not work

Document Management System 5.6A User Guide Software Documentation This document is the software documentation for the Sage Accpac Document Management System module developed by Visionetix Software. All

Sage 100 2016 What s New Global Enhancements New Product Key Required If you use the Payroll module, you must enter your new product key when installing Sage 100 2016. If you enter a product key obtained

Accounts Payable Reference Guide Last Updated: January 19, 2009 About this Guide This Guide is for use by SedonaOffice customers only. This guide is not meant to serve as an operating or training manual,

MAS 90 MAS 200 Tips, Tricks and Frequently Asked Questions (FAQ s) Prepared by: The Fitzgerald Group August 11, 2004 This is a compilation of ideas from The Fitzgerald Group staff, from clients and from

What s New In v2013 Availability Download from Sage Software website, they are no longer shipping CD s. We will provide the CD if user has an active Sage Maintenance plan. Accounts Payable: Expanded Invoice

Workstation Options ("Options For this Computer Only") USER MANUAL Version 4 Information in this document is subject to change without notice. Companies, names and data used in examples herein are fictitious

ACHIEVE THIRD PARTY MANAGEMENT (3PL) USER MANUAL Version 6.5 PRESENTED BY ACHIEVE IT SOLUTIONS Copyright 2012-2016 by Achieve IT Solutions These materials are subject to change without notice. These materials

Overview Take Payment This is the section where you can update the payment status for an individual s registration. This is where a player can be found if they are Pending Awaiting Payment, which is the

Octopus and the Octopus Logo are trademarks of ELEOS WEB PTE LTD, registered in Singapore and other countries 1 1. Introducing the Octopus Point-of-Sale (POS) System The Octopus Point-of-Sale System, unlike

Computrace Agent Quick Reference and Best Practices Guide www.absolute.com May 14, 2008 Absolute Software Computrace Agent Quick Reference and Best Practices Guide This document, as well as the software

End of Month Closing The End of Month Closing process cuts off all sub-journal postings for the month and should be performed at the conclusion of each month. Closing the month involves up to five steps:

Sage 300 2014 Product Update 4 Release Notes Product Update 4 contains a modified version of one or more Sage 300 program components. It is not a full upgrade or a product replacement. It is valid only