Sage 100

In Sage Intelligence Reporting we frequently find that we need to clear out the Tenant cache. The error message we get back is: Problem Loading Data A row with duplicates was encountered at row number 248 for data object Accounts The Values are…

I have been trying to import invoices from one vendor through the visual integrator, I can pull up the invoices in vendor maintenance in accounts payable but the transactions are not posted to the ledger accounts. I visited invoice register to post but…

Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…

Hey all. We are moving from Mas90 4.3 to Sage100 Cloud. Finally! Over the weekend, we made a backup of our entire Mas90 directory and uninstalled some shipping link software before moving data from all companies. Long story made short, we did not get…

Hello, I'm not familiar with MAS90 but my company is very small and working on an old version of MAS90 for Windows. Is there a way to remote access from a laptop at home? A previous employee was able to dial in several years ago, but we don't use dial…

Hi, I have the code below for automatic registration/update of the production transactions. I've been getting an error on the UpdateInit method. oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister = oScript2.NewObject…

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…

Hello, I accidentally closed the update window and now I can't update my daily sales order transactions. It says "Unable to update S/O transactions while another update is currently in process." We are using Mas 90, version 4.3 Thanks for any help…

I have a client his mas90 program crashed. He has a backup. Can i get the name of a company that can help me import the data into sage 100

Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

Hello! I am trying to create an order completely with SData and Paya. I have no problems with it when I am trying to create an order with PaymentType = Check. Here is the XML for such example: <entry xmlns:atom=" ">http://www.w3.org/2005/Atom…

I'm stuck and can't quite figure out why. Below is a script I wrote to add a new line item to the CI module (I copied and pasted from several places). If SetSession("C/I", "CI_ItemCode_UI") Then writeLog("Connection Complete - Item Maintenance") Try…

Hi I am new in BOI integration with the C#, Can anyone share with me sample code for the delete a record from the Sage MAS 90 using C#.net? Or if you have any good reference document please, I google much about I did not find anything helpful. Please…

MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned. 1) MAS 90 has been set up with a role that gives me read access to all…

Hello, This might be an easy fix, but I seem to be having issues opening the SO_Shipping_bus object. Am I setting the following object up correctly? Microsoft.Win32.RegistryKey SageKey = Microsoft.Win32.Registry.CurrentUser.OpenSubKey(@"Software…

I am trying to import some data into Sage but after initiating the script object, when i try to newObject 'SY_Session', it fails. On server it works fine but on clients it fails. I checked the security settings, the user has full access to MAS90, and…

I have created a JobNumber UDF and added it to AR and AP invoice data entry line detail. Now I would like to create a User Defined Script for the actual Job Number entered during data entry to be written to the JobNumber UDF. In AR it comes from the header…

There is a system table named "CM_UDF". I want to get records from this table. The corresponding data file for this table lies in folder named "MAS_SYSTEM" which is outside the folder structure belonging to any company. Moreover, there are no business…

Sage MAS 90 Extended Enterprise Suite (Version 4.40.0.5) I manually changed the reorder method to NONE from economic quantity for about 20 items that we are phasing out and will no longer stock. The following day, seven of these items automatically reverted…

I want to get a list of all the UDF columns in a particular table eg. AR_Customer. Is there a way to get this list? There is a method which returns a list of all the columns in any particular table but I cannot differentiate between the custom ones…

Hello, I am still having an issue with imported product item numbers being skipped. I do not know what could be causing this as I have successfully imported 250,000+ items with the same number scenarios. Has anyone else had this issue and if so, how…

I would like to know if there is a way to change the default "General" cell formatting to "Text" in Sage 100 ERP (MAS90). The issue I am having is that when I use Item Maintenance to list a product line, we have many items that have leading zeros. These…