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.

Sage 100 2018 Product Update 7 (6.00.7.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2018.7
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.

Sage 100 2018.5 (and higher) users with Payroll integrated with Bank Reconciliation, will need to also install Sage 100 Payroll 2.18.5 (or higher).

Bill of Materials

  1. Gross Requirements Report is no longer excluding Option Interactions that show on other BOM Reports.
  2. Disassembly data entry component quantities are now correct on the Lines tab and update to Inventory when the Header quantity exceeds Quantity On Hand

Customizer

  1. Sales Order Number now displays in Item Maintenance on the Orders tab after adding the field to the grid with Custom Office.

General Ledger

  1. Error 45 CI_CommonPII.pvc 277 no longer occurs when accessing GL_Bank.m4t

Inventory

  1. Cost is no longer displayed when Allow Access to Costing, Receipts and Vendor Information in Item Inquiry is not selected and accessing Lot/Serial from the drop-down menu in Item Inquiry which displays Lot/Serial Transaction Inquiry.
  2. Role security to allow inactive cost code is unchecked no longer allows entry of inactive cost code in IM Transaction Entry

Job Cost

  1. Job Billing Invoice with Tax Exemption entered in Tax Detail screen now updates to A/R correctly.
  2. Copy From feature in Job Estimate Maintenance is now appending existing line detail when multiple estimates are selected.
  3. Revised Estimate does now prints for all Subcontract Vendors for a Cost Code on the Job Transaction Detail Report.
  4. Multi-Part Shadow Text now prints on Job Cost Invoices
  5. Retention amount now prints on the Subcontrator Analysis Report.
  6. Job Billing Retention bill amount is now correct if A/R Credit Memos or Debit Memos were entered.
  7. Reversal of Retention Invoice using Job Billing now adjusts the invoice in Accounts Receivable.
  8. Daily Transaction Register for Job Closeout Report with negative WIP now creates a positive debits/credits as they should appear.
  9. Error 11 JC_DailyTransactionRegister_upd.pvc line 0704 no longer occurs when updating the Job Daily Transaction Register

Library Master

  1. Aatrix / Sage check for entitlement no longer fails and Aatrix no longer remains in demo mode.

Sales Orders

  1. Sales Order Invoice Batch status no longer changes to Available when original entry user exits batch and other User selects same batch.
  2. For new Shipping Invoices, Sage 100 now correctly returns a Warning value when encountering an expired PreAuthorization, rather than returning a Failure value.
  3. No longer receive "Data is not selected for report printing" when using the Greater Than operand for Order Date when running the Sales Order and Quote History Report in Sage 100 Premium.
  4. "Error 45 SY_Service.pvc 1500" no longer occurs when adding a credit card on the fly in Sales Order entry.

Visual Integrator

  1. Visual Integrator exports a blank value in specified column causing remaining data to be shifted by one column when condition uses Operation <> is now fixed.

INTRODUCING SAGE PRODUCTION MANAGEMENT

Written by Todd Martin on .

For Sage 100 and Sage 100cloud

junction box 3482687 1920
The new Sage Production Management is comprised of features designed to replace the legacy Work Order and Material Requirements Planning (MPR) modules currently in Sage 100. Here’s a closer look at this new functionality for manufacturers.


Sage Production Management Capabilities

At a high level, Sage Production Management is a suite of manufacturing capabilities built on the Sage Business Object framework (aka “Business Framework”). That means you get a modernized platform capable of all the conveniences you’ve become accustomed to in other modules like primary and secondary data entry grids, resizable windows, batch data entry, right-click context menus, grid export to Excel, custom scripting, and so much more.

Continue Reading

Sage 100 2019 Product Update 1 (6.10.1.0)

Written by Todd Martin on .

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

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


Accounts Receivable

  1. AR Period End Processing no longer ignores Days to Retain Paid Invoices in AR Options.

Bank Reconciliation

  1. Positive Pay export file now writes out the bank account number. It adheres to the General Ledger Security Event, Allow Viewing, Printing and Editing of Highly Sensitive Personally Identifiable Information.

Bill of Materials

  1. Gross Requirements Report is no longer excluding Option Interactions that show on other BOM Reports.
  2. Disassembly data entry component quantities are now correct on the Lines tab and update to Inventory when the Header quantity exceeds Quantity On Hand.

Customizer

  1. Error 65 CM_UDFMAINT_UI.PVC 2308 no longer occurs when adding a UDF for AP_DailyPostingWork and selecting Business Object PO_Register_upd and clicking OK button.
  2. Sales Order Number now displays in Item Maintenance on the Orders tab after adding the field to the grid with Custom Office.

General Ledger

  1. Error 45 CI_CommonPII.pvc 277 no longer occurs when accessing GL_Bank.m4t.

Inventory Management

  1. Drill down in Customer Sales History screen is no longer grayed out when typing Customer # in field instead of using Lookup for Customer.
  2. Cost is no longer displayed when Allow Access to Costing, Receipts and Vendor Information in Item Inquiry is not selected and accessing Lot/Serial from the drop-down menu in Item Inquiry which displays Lot/Serial Transaction Inquiry.
  3. Role security to allow inactive cost code is unchecked no longer allows entry of inactive cost code in IM Transaction Entry

Job Cost

  1. Job Billing Invoice with Tax Exemption entered in Tax Detail screen now updates to A/R correctly.
  2. Copy From feature in Job Estimate Maintenance is now appending existing line detail when multiple estimates are selected.
  3. Revised Estimate does now prints for all Subcontract Vendors for a Cost Code on the Job Transaction Detail Report.
  4. Multi-Part Shadow Text now prints on Job Cost Invoices.
  5. Retention amount now prints on the Subcontrator Analysis Report.
  6. Job Billing Retention bill amount is now correct if A/R Credit Memos or Debit Memos were entered.
  7. Reversal of Retention Invoice using Job Billing now adjusts the invoice in Accounts Receivable.
  8. Daily Transaction Register for Job Closeout Report with negative WIP now creates a positive debits/credits as they should appear.
  9. Error 11 JC_DailyTransactionRegister_upd.pvc line 0704 no longer occurs when updating the Job Daily Transaction Register.

Library Master

  1. Aatrix / Sage check for entitlement no longer fails and Aatrix no longer remains in demo mode.
  2. Auto-Complete record types of Account and Employee in 2019 are no longer removed from User Maintenance > Auto-Complete tab after a migration is performed on a company dataset.

                   NOTE:
                   If you have the Payroll module installed, you MUST install both Sage 100 2019 PU1 AND Sage 100 Payroll 2.19.3.
                     -OR-
                   Alternatively, if you are on 2019.0 and Payroll 2.19.2 and are not able to install 2019 PU1 and Payroll 2.19.3 on your system, you can install program fix LM6008T, see Knowledgebase ID 96923 for details.


Sales Order

  1. Sales Order Invoice Batch status no longer changes to Available when original entry user exits batch and other User selects same batch.
  2. For new Shipping Invoices, Sage 100 now correctly returns a Warning value when encountering an expired PreAuthorization, rather than returning a Failure value.
  3. No longer receive "Data is not selected for report printing" when using the Greater Than operand for Order Date when running the Sales Order and Quote History Report in Sage 100 Premium.
  4. "Error 45 SY_Service.pvc 1500" no longer occurs when adding a credit card on the fly in Sales Order entry.

Visual Integrator

  1. Visual Integrator exports a blank value in specified column causing remaining data to be shifted by one column when condition uses Operation <> is now fixed.

Sage 100 2018 Product Update 6 (6.00.6.0)

Written by Todd Martin on .

The following is a list of corrections and selected enhancements added to Sage 100 2018.6
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.

Sage 100 2018.5 (and higher) users with Payroll integrated with Bank Reconciliation, will need to also install Sage 100 Payroll 2.18.5 (or higher).

Accounts Payable

  1. Corrected an "Error #12: File does not exist (or already exists) File: JC_CostType" when accessing AP Invoice History Inquiry after removing integration to Job Cost and deleting Job Cost data.

Accounts Receivable

  1. Error: "Data is not selected for report printing" no longer occurs when running Accounts Receivable Invoice History Report and entering selection for AR Customer Master user-defined field
  2. Commission Edit Register now prompts to update or post to payroll if the range includes invoices already updated with a Yes.

Avatax

  1. With The Avatax connector for Sage 100 2019 all countries in Sage 100 no longer change to ZW. Some clean up of the existing SY_Country.m4t table may be required. Two character country codes are no longer required by Avatax and should not be entered in Sage 100.

Bank Reconciliation

  1. Bank Feeds matching rule added, if no check number exists in bank feed record, we only match date and amount and use the first match. Also, most transaction types with negative values are now mapped to "Withdrawal",  positive values are now mapped to "Deposit". A log file has been added to the BRxxx, where xxx represents the company code and logs the last source values for the last download from Bank Feeds. Additionally, since A/P ACH (when post to B/R in detail) and wire transfers are written to B/R as check, if unable to find a withdrawal, matching will now look for a check.
  2. Fixed Error #60: BR_CheckDepAdjustEntry_ui.pvc 916 when exiting BR Check, Deposit Adjustment Entry after performing sort on Checks and Dep/Adjustment Tabs.

Bill of Materials

  1. Item status, selected from Drop Down list, in Production Entry no longer doubles available quantity.

Customizer

  1. UDFs are now generated in all companies on Sage 100 Premium if there are over 60 companies.
  2. Fixed Error 60 SY_SELECTION.PVC 2450 when clicking OK in UDT Maintenance selection screen.

Inventory

  1. Fixed Error 13 SY_SELECTION.PVC 1444 and Error 84 SY_SELECTION.PVC 1448 when clearing frozen items in Physical Count and "Keep Window Open After" print/preview is checked.

Job Cost

  1. Extended Price calculation has been corrected in Job Estimate printing for all Override Markup Methods and Report Types.
  2. Fixed issue with incorrect Extended Price on the Job Estimate by Cost Code Report when using the Override Markup Method.
  3. Daily Overhead Allocation Register from Sales Order now creates a Daily Job Transaction Register.
  4. Auto-complete now lists selections for the Customer No field in Job Maintenance.
  5. Job Estimate Maintenance, Item Price Lookup Unit Price changes using Override Markup Method are now saved back to Estimating Item Pricing Maintenance when answering Yes to the prompt "Do you want to save these changes back to item pricing?"
  6. Printing J/C Invoices to PDF now works for all Paperless Office Output choices. Previously all choices acted as if ‘PDF All’ was selected.
  7. Corrected missing Job Cost Code and Change Orders when printing report after updating to product update 5.
  8. Job Billing Credit Memos are now calculating sales tax.
  9. Utility for Job Billing Register updates a future period Job Billing invoice to the current period in JC_JobBillingHistory.m4t.
  10. Job Transaction Detail report now sorts PR transactions with the same transaction date properly.
  11. Issues with Retention in Job Posting Entry Cash Receipt have been resolved.


Library Master

  1. The Error: "No valid servers found" no longer occurs when starting Sage 100 ERP Advanced or Premium edition.

Purchase Order

  1. The ReceivedAmt field in PO_PurchaseOrderHistoryHeader is now updated when doing a ROG.

Return Materials Authorization

  1. Wrong Inventory GL account is no longer used on credit memo generated from RMA after Product Line change

Sales Orders

  1. Invoice Amount now includes all sales tax on the Sales Order Daily Deposit Recap.
  2. The message "The Certified Payroll Form is required..." no longer occurs when attempting to edit a Job in JC Job Maintenance that was created in Sales Order Entry.
  3. Unit Price is retained when a quote is changed to a Master Order

Visual Integrator

  1. Now able to remove fields in Import Job following a calculation that uses a Pipe (|) character.

CREATING A COPY COMPANY FOR ARCHIVE/BACKUP

Written by Todd Martin on .

At year end, it’s useful to create an archive company using the Copy Company feature. This provides a readily accessible copy (and backup) of the current year’s data even after you perform year end processing in your live company.
To make a copy company, go to:

Library Master > Main Menu > Company Maintenance

  1. Create a new company code and company name (description) that’s easy to identify and distinguish from the live/active company that you’re copying.

  2. Click the Copy button and enter the Company Code of your current year live (or “Source”) company.

  3. Select the modules you want to copy to your archive company. To create a complete archive/backup, you’ll want to copy all modules. Click Proceed. Once the process is finished, click Accept.

For good measure, you might run a trial balance in each module and do a quick spot check to make sure all the data that came over is balanced and accurate.


Watch the Video
Watch a recorded demonstration of the Copy Company process in action.

©2019 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.
Acumatica PartnerAcumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations.

Lean More
sage PartnerWhen it’s time for your business to move beyond simple accounting software, you can count on Sage to help you manage your manufacturing, distribution, and service industry processes from beginning to end. Unite your company so you can grow revenues, reduce costs, and increase profitability.

Lean More

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 Offices
Chicago, Illinois
Cape Coral, Florida

twitterfacebookyoutubefeedlinkedin