Sage Pro 200 ERP Version 2010 Service Pack 1 Readme Addendum to Documentation – March 16, 2010 Copyright© 2010 by Sage Software, Inc. All Rights Reserved. Sage Software, Inc ® is an industry-leading developer of accounting and e-business management solutions for small and medium sized enterprises. For more information, visit us at http://www.sageproerp.com/ These instructions supplement and clarify the program documentation for Sage Pro 200 ERP version 2010, Build 3600.00, Service Pack 1. TABLE OF CONTENTS 1. General Information 2. Installation Instructions 3. Run p91314_datafix 4. Instructions of PTR 91316 5. Installation Instructions of PTR 91343 6. PTR Update Information 1. General Information Please consult with your Service Provider before installing this Service Pack. 2. Installation Instructions All updates must be installed to the appropriate Sage Pro ERP folder. 1. Copy the SagePro2010B3600_00_200_SP1.exe file into a temporary folder (for example, C:\temp\). 2. Verify that all users are logged out of Sage Pro 200 ERP and close the application. 3. Verify that you have made a complete backup of your Sage Pro 200 ERP program folders, system data and company data before installing this Service Pack. 4. Navigate to the temporary folder selected in Step 1 and run the SagePro2010B3600_00_200_SP1.exe self-extracting zip file. 5. A dialog box appears. In the dialog, change the "Unzip to folder" to your Sage Pro ERP root directory (i.e. C:\Pro2010\). 8. Then click "Unzip". This will unzip all files and folders contained in the Service Pack. 9. Follow steps in the next sections. 3. AR cash receipts issue : Run p91314_datafix P91314_datafix updates the paidamt and ipaidamt field of ARCASH table from ARMAST. 1. Start Sage Pro 200 ERP. 2. Log in as the Administrator. 3. Select File | Open | FoxPro Access. 4. Type "DO P91314_DATAFIX" without the quotes. Steps 4 needs to be repeated if there are more than one company where data correction need to be removed. 5. Press "ENTER" to return to the Sage Pro 200 ERP application. 4. Instructions of PTR 91316 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Important: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ The below note is applicable for "Weighted Average" and "Standard" cost companies only. Before applying the Service Pack please read the note below to reverse the transactions that you have made with the wrong average cost and then subsequently change to the correct average cost using IC – Change Costs/Prices option. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Note: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Weighted Average Cost Company ------------------------------------------ If you have made any transactions in SO, AR or IC through which the item was issued or received after executing "Enter Inventory Count" and increasing the quantity, the wrong average cost would have been used for those transactions. In this case you need to reverse those transactions that were executed with the wrong average cost. For example, A new item created with a qty of 10 and a cost of 100. Average cost would be 100. After running "Enter Inventory Count" and increasing the qty from 10 to 15, the Average Cost would have been wrongly updated as 66.66667 instead of 100. If an SO was created and shipped for a quantity of 25, a RETURN SO can be entered and shipped for the same quantity using "Apply To" option. Likewise for an invoice in AR, a credit memo can be created for the same quantity using "Apply To" option. Finally, using IC | Transaction | Change Costs/Prices | Average Costs, the average cost of the item needs to be changed to the correct value. Standard Cost Company ------------------------------- Use IC "Change Costs/Price" option to correct the wrong average cost that would have been changed during increasing the quantity through "Enter Inventory Count". In Standard cost company, GL entries must be manually reversed/adjusted, for any GL postings done with the wrong cost. 5. Installation Instructions of PTR 91343 (VFP Backend only) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ III. Run below steps for fixing this issue ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1. Run PRO for admin user 2. Select File | Dataviews | Maintain Dataviews 3. Enter or select Dataview ID is "PL_POITEM_VFP" and click "Edit" button. 4. Click "Build From clause" button of "Table" field in "General" page tab to open the "DataDriller - Select Tables" screen. 5. Choose ICILOC table in "Selected Tables" list box. 6. Choose ICLOCT table in "Related Tables" listbox. 7. Select "Left" option button for "Join Types" and then click the "JoinTable" button and press "OK" button. 8. Select "Settings" page tab and remove the contents from "Advanced VFP Commands" edit box. 9. Paste the below 7 lines of VFP command in the "Advanced VFP commands" edit box. SET ORDER TO ITEM IN ICITEM SET ORDER TO LOCTID IN ICLOCT SELECT ICILOC SET ORDER TO ITEM SET RELATION TO ITEM into ICITEM SET RELATION TO LOCTID INTO ICLOCT ADDITIVE GO TOP 10. Press "Save" button. 6. PTR Update Information Appl. PTR# Issue AR 91270 In Windows 7, email button in maintenance screen that launch a draft using the email id in the text box is not working AR 91314 Entering a cash receipts for the Payment on Account option does not update ARCASH.PAIDAMT. Updating from AR on the bank rec brings over a zero amount and the Cash Receipt Register shows a zero dollar amount. The AR Journal shows the payment and the customer file reflects the payment. This works correctly in Pro 7.5 AR 91317 In National Account screen the Last Applied Amount is not updated if refund has been done against a receipt. IC 91285 If a bill of material component is lotted it may not update IQIQTY with issues. It is possible for the item to go into over shipment since the quantity amount may not get updated in IQIQTY. Over shipments of lotted items in Pro are not allowed. This also causes discrepancies in the IC recalc report and the discrepancy cannot be fixed from within the program. IC 91316 Manage Inventory - Enter Inventory Counts receives inventory at a zero cost. This will happen when the count is made higher than what is already on hand. JC 91219 Cost pool overhead calculations are not calculating correctly for consecutive Misc. Job Costs. The first calculation seems to be correct but any calculations after that seem to use the amounts of the first calculation. JC 91249 Overhead posts to the wrong default account. With the Level of GL default accounts set to Job overhead postings use the main GL account setting in Job COst and not the account assigned directly to the job. JC 91265 Change Order Budgets entered as Pending or Denied show on a Job Inquiry and also appear on Job Status 1. JC 91322 While trying to add a new customer from JC applicaiton leads to fatal. PE 91358 An error 39 will occur if printing a Manufacturing Journal for a post complete that contains a component set to zero qty. This does nto happen in Pro 7.5. It only occurs in Pro 2010. SO 91218 After changing the salesperson for an invoice, the commission will be only calculated on the first line item. SO 91326 An error 1466 when deleting a line item on a sales order when SO is not linked to PE. This can be reproduced in a company that does not have PE installed. Error 1466: Connection handle is invalid. SO 91331 While trying to open the "Comssissions - Quota vs. Actual" report it gets fatal. SO 91343 When using an item pick list and entering a partial item code pressing enter and then list the error 13 will occur. This should only happen if there are more than 10,000 records. SO 91352 Fatal occurs while SO Bid is converted to order entry when 'Calculate Sales Commission' is not selected in Order entry setup information SO 91366 While printing Open Sales order report, for the sales orders which contains Deposit paid via credit card details the credit card number is not displayed in the report. Also in SQL Backend fatal occurs. SY 91273 Quick Import Option shows up for AR Manual Invoice import. SY 91300 After unchecking Quick import option, going back to the previous screen and selecting any transaction process, the import options are disabled. WO 91318 After creating a Work Order through SO, edit the SO through Change or Void Order screen, make some changes, cancel the changes and save the SO completely. The associated WO is getting deleted. WO 91362 Fatal error will displays when generate work order if Default method of explosion' is set as 'Bottom' or 'Smart'. WO 91368 Fatal error will display when trying to delete the Work Order. This issue occurs if the work order is generated through complete work order for the shortage.