Support-Blog-Sage-100 This is a blog about anything related to products and services that MBA Business Software supports.Employees on the support desk will add to this blog periodically. Check here for Tips and Tricks to help you with your daily tasks.

Custom Office Enhancements in Sage 100 Cloud 2018.3

Written by Todd Martin on .

Several changes and improvements were made to the Custom Office module including:
  • Calculator Option for Numeric Fields - A calculator check box has been added to the Multi-Line Definition window. Select this check box to include the calculator button next to the field.
  • Buttons Appear in Screen Editor - In the Customizer screen editor, Calendar, Calculator, and Lookup buttons now appear as they do when using the screen in Sage 100.
  • Ability to Exclude UDFs from Selection Grids - Use the new ’Exclude from Report Selection’ check box when adding a user-defined field (UDF) to a table for a main entity, such as AR_Customer, to exclude the UDF from selection grids for reports that use the table.
exclude from report selection

©2018 Juice Marketing, LLC. https://www.juice-marketing.com. All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.

Sage 100 2017 Product Update 5 (5.40.5.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2017.5
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 2017. Smart Update will install only the programs that have been updated since your last update was installed.

Sage 100 Advanced and Premium Workstation Synchronization automatically updates the client workstations.

If you use Sage 100 Standard over a network, run WKsUpdate Standard.exe on each workstation. This program is located in the ..\mas90\wksetup folder on the server where Sage 100 2017 Standard is installed. 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 5 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 Receivable

  1. Running the Credit Card Settlement Report no longer returns a communication error.

Bill of Materials

  1. "Record <Part Number> is missing..." error no longer occurs when running the Bill of Materials Summarized Where–Used Report in Sage 100 Premium.

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. Tier Type is no longer missing from IM_ItemCost after update quantity committed.


Sales Order

  1. Error 14 _WINPROC 320 no longer appears when performing more than one Quick Print in Shipping Data Entry.


Web Services

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

New Warehouse Status Settings - Version 2018

Written by Todd Martin on .

With the release of Sage 100 Version 2018, there are new warehouse status settings available that help you better manage your warehouses and inventory. In this article, we’ll take a closer look.

Warehouse Maintenance

warehouse boxIn Warehouse Code Maintenance, a new status field has been added that allows you to set a warehouse status to one of three options including Active, Inactive, or Restricted. Since the Active status is self-explanatory, we’ll explore what it means to chose either Inactive or Restricted.

Inactive Warehouse Status

The Inactive status is intended for warehouses that are no longer in use. If a warehouse status is Inactive

Continue Reading

Sage 100 2018 Product Update 3 (6.00.3.0)

Written by Todd Martin on .

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.

Sage CRM 2018 R2 - New Features

Written by Todd Martin on .

We saw the first release (R1) of Sage CRM 2018 back in December. Now just a few months later, the second release (R2) is available and brings some great new features that we’ll take a closer look at in this article.

Sage CRM Calendar

Sage CRM 2018 R2 continues to build on what’s probably the heart of the application - the calendar. This release further extends the great enhancements in Version 2018 R1 with new filtering options in all calendar views. Action and Status filters can be added to Day, Work Week, Week and Month views and are retained for the session duration. In addition, the calendar now displays dates according to your personal settings in the Preferences area.

Continue Reading

Subscribe to Newsletter
Subscribe here for MBA Business Software's newsletter and product information to stay informed about the products and services offered by MBA.

90 Minds
90 Minds Consulting Group is an 
association of proactive consulting professionals who combine technology skills while still operating their own independent companies.

MBA Business Software
Headquarters
1117 Perimeter Center West, 
Suite E210
Sandy Springs, Georgia 30338
(P) 678-495-5700 
(F) 770-399-5772

Remote Office
Chicago, Illinois

twitterfacebookyoutubefeedlinkedinGoogle+