Sage 100 2018 Product Update 3 (6.00.3.0)

The following is a list of corrections and selected enhancements added to Sage 100 2018.3
For a full list of Enhancements, refer to the What's New page inside the Product.

Product updates are cumulative; in other words, this update includes all enhancements and program corrections found in prior updates for version 2018. Smart Update will install only the programs that have been updated since your last update was installed.

Workstation Synchronization has been enhanced to update Sage 100 Standard Workstations along with Sage 100 Advanced and Premium Workstations. Sage 100 Standard Users are no longer required to run WksUpdate Standard.exe on each Sage 100 Standard Workstation. 

All Sage 100 updates must be installed on the server where Sage 100 is installed.

For eBusiness Manager users upgrading for the first time to Product Update 3 or higher, you will need to perform the following one time:

1. From the Sage 100 Server, copy the following files located in the ..\MAS90\Home folder:
   1. pvxclr4.dll
   2. Sage.Exchange.dll
   3. wsVault.dll
2. Copy the 3 files above to the server where the Sage 100 Web Engine is installed. The default location for the Sage 100 Web Engine installation is "C:\Program Files (x86)\Sage\Sage 100 20XX WebEngine\WEBENG\Home\", but this is configurable.
3. Restart the Web Engine and run as an application. Running the Web Engine as a Service is not recommended at this time. See Knowledge Base entries 82537 and 82539 for more information. Make a copy of any existing files before replacing.

Accounts Payable

1. The DiscountAmt field in AP_CheckHeader file now shows the total discount for all invoices included on the check.
2. Vendor Maintenance Invoice Inquiry feature under 'More' displays invoices generated from Purchase Order Invoice amount now matches the Net Invoice Amount displayed on the AP Invoice History drill down screen.

Accounts Receivable

1. Error "The Cash Receipts entry files are empty" no longer occurs when updating an A/R Cash Receipts batch where one deposit within the batch was transferred to a new batch.
2. Running the Credit Card Settlement Report no longer returns a communication error.

Bill of Materials

1. Enhancement made to allow for syncing of Misc Charge item fields that are changed to the bill detail tables.
2. "Record <Part Number> is missing..." error no longer occurs when running the Bill of Materials Summarized Where–Used Report in Sage 100 Premium.

CRM

1. Sage 100 Rebuild CRM no longer cuts off CRM Company Names more than 30 characters long.
2. Added information to the "Cannot Synchronize Data with Sage CRM" message to help resolve the issue when no company records exist in Sage CRM.
3. Quick Order Entry Component.exe is now being installed to the servers ..\mas90\CRM directory.
4. Import into AR_Customer does create new CRM companies automatically.

Common Item

1. In Direct Deposit Maintenance when an invalid routing/transit number is entered for the Immediate Destination a prompt now displays to accept the number.

Customizer

1. PO Receipt Header UDF now updates PO Purchase Order Header UDF.

e-Business Manager

1. The message "An error occurred while attempting to process the page you requested. Contact your account representative or the Webmaster" when processing credit cards on a website using eBusiness Manager, can be resolved by copying the following files from the Sage 100 Server and adding/replacing them on the Server running the Web Engine: pvxclr4.dll,Sage.Exchange.dll, and wsVault.dll. Then run the Web Engine as an Application, not as a Service. There is another outstanding defect regarding the Web Engine running as a Service, see Knowledge Base entries 82537 and 82539.

Fixed Assets

1. Closing date is no longer different than the Sage Fixed Assets ending date

Inventory Management

1. No longer receive "Error 43 IM_LOTSERIALTRANSINQUIRY_UI.pvc 534" after selecting a Lot/Serial number with Extension greater than 99,999,999.99 in Lot/Serial Inquiry.
2. Tier Type is no longer missing from IM_ItemCost after update quantity committed.

Job Cost

1. Fix "(Tax Code)" is not numeric" in version 2018 Job Billing Data Entry for a Fixed Contract job.
2. No longer receive "record (report Name) is missing from SY_ReportManagerMaster.M4T." when using the Designer button to open any report on the Job Cost > Estimating menu.
3. Cost Code Maintenance is no longer truncating alphanumeric Cost Code numbers that include a special character.
4. Job Estimate Printing *SUB and *TOT calculation is now correct if the line is deleted and re-entered to a different line on the grid.
5. New Comments or changes to Comment are now retained in Job Maintenance.
6. Corrected issue with Time & Material transactions not summarizing by Job in Daily Transaction Register.
7. Job Estimate Printing with Print Estimate Recap selected now calculates Overhead and Profit calculations correctly on the Estimate Recap.
8. Job Transaction Detail Report no longer inserts a Page Break between each job when "Page Break by Job" is unchecked in report options.
9. Corrected issue with Cost Code unit price and unit cost being truncated in Job Posting Entry.
10. Corrected issue with navigation buttons not refreshing Revised Contract Amount display in Change Orders tab when moving between records.
11. Error "xx-xx-xxx is not on file" after migrating data to v2018 with a Cost Code length less than 9 characters.
12. Job Trans Detail History Report no longer inserts a Page Break between each job when "Page Break by Job" is unchecked in report options. And transactions are now sorted in date order under the Cost Code.
13. The Error "The Burden Job Type generated an invalid Cost Code" no longer occurs when updating Payroll with Burden Allocation defined and using a Cost Code less than 9 characters.
14. Overhead Allocation Register (Monthly or Daily) now updates to G/L in summary format.
15. Job Billing Selection no longer duplicates Time and Material job transactions if the transaction date is less than or equal to the module date.
16. Job Billing History Report Current Balance column no longer displays ##### if the Current Balance exceeds $999,999.99.
17. Direct Cost Job Posting Register and Job Daily Transaction Register no longer prints ######## when amount is 1,000,000.00 or above.
18. The correct Cost Code description now prints on the Job Cost Code Detail Report.
19. Negative amounts entered in Job Posting Entry now post correctly to the G/L.

Library Master

1. Error: "Database Connector Error: '[Database Vendor Code:9]' no longer occurs when printing the System Configuration Listing and the Payroll module is not part of the product key.
2. The copy company process no longer completes when Sage Exchange Desktop is not installed and running.

Material Requirements Planning

1. MRP Weekly Projected Demand is now reduced by a Sales Order in the same time period if the week starts in one month and ends in another month.

Purchase Order

1. Fix incorrect overhead allocation calculation.
2. No longer receive,"Missing selection table JC_JOB" in Auto Generate from Sales Order accessed from Purchase Order.

Sales Order

1. Line messages on Sales Order Picking Sheets now print the quotation symbols instead of QUO+QUO.
2. Error 14 _WINPROC 320 no longer appears when performing more than one Quick Print in Shipping Data Entry.
3. Ship via no longer populates wrong freight amount in Shipping Data Entry.
4. Batch is no longer locked in Print/Update status after transferring invoice in Sales Order Invoice Data Entry.
5. In Sales Order Options, on the Job Cost tab, the window now displays when clicking on the Display Cost Type button.
6. PTD, YTD, JTD cost at the Cost Code/Cost Type level is no longer overstated when posting invoices from Sales Orders where multiple jobs are created on the fly.
7. Exclude from Certified Payroll Report field in JC_Job.m4t now defaults to N when a job is created on-the-fly in Sales Order.
8. Error "SO_SalesOrderQuickPrint_UI.pvc 122" no longer occurs when printing Invoice from Sales Order and Quote History Inquiry if a Sales Order form was updated from 2018.1 or 2018.2 and Line 1 Message was populated.

Visual Integrator

1. Auto generated Material Issue is now created with a batch number when importing a Completion into WO.TRNSENT with batch entry enabled.

Web Services

1. Certain Web Services APIs no longer fail after upgrading to Sage Exchange Desktop (SED) 2.0.

Work Order Processing

1. Error "The Warehouse Code is required" no longer occurs when entering a Completion transaction for a Special Item in Work Order.