Browse By Tags

Hi All, Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script. I right clicked on the…

SMUSERTASKS - if this is too technical of a question we can ignore it(delete). As a BW user for 28 years our file SMUSERTASKS has grown to nearly 10MB and takes 4 to 5 minutes to backup or restore (SYSTEM backup) . Should this file be this large and…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…

Hello All, We are using SAGE 100. Somehow On PO qty coming in Stock status report is not Open PO Qty. SAGE is pulling a open PO qty from somewhere - SAGE ppl kindly share your thoughts In the below example, in main I m seeing a open PO qty but in…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, kindly advise me ANY BODY HERE TO HELP OUT MY…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

Here's a new problem after installing 17.1.8 update (not a problem with 17.1.7): Common Tasks - Tools - File Tools - Backup The "ts.ctl" file is in use when we try to use file tools to backup our data. The knowledgebase leads you to various methods…

Our company MAS 500 server crashed, very hard no recover. The DB was backed up to another server and I am able to restore the DB from the BAK file. The data is there, but we need to access reports and stuff. We no longer have the MAS500 server software…

How does one access Business Vision files from earlier years? The program does not seem to follow Windows convention that clicking on the word File on the upper ribbon does not give an option to locate and load a file.

The name limit for the local computer network adapter card was exceeded. We have to manually start the backup every night. Then it will complete successfully.

Sage 100 Version 5.20 Crystal 2011 for Sage Window server 2012 R2 Ok, here is an odd one. We had been having incorrect data running a Inventory List via Crystal. We have a total of 600 items. When I add a filter for Category 2 data I am getting…

Bonjour, Je suis dans ma première année financière. J'ai inscrit dans SAGE le 31 août comme date de fin d'année alors que cela aurait dû être le 31 juillet. Ma date de session est le 31 août. J'ai fait des écritures en août dont les paies. Que dois…

Sage 300 2017, MSSQL Client daily dump data, as a backup. last week, they dumped data, for strange reason, dumped data only has data up to end of 2016. No 2017 info. any ideas? thanks!

We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

We running SAGE 300 ERP and we have a problem with Qty in Bin Location not matching IC Qty. How do I get SAGE to automatically sync the Bin and IC Qty? Doing each transaction manually takes way to long. Thanks

When i click the OK, i get "Open an existing database". When I click existing, I can browse to the data base and when i click that, same result. Other computer on office network works. I got an error saying "Not able to create temp file. May be invalid…

MS SQL server 2012, Sage 300 2014 PU 3 I am trying to restore a test database using the most recent backup of its associated production database - in SQL Server Management Studio. I am restoring to another name and that task completes without errors…

I just installed Sage 50 2015 Pro. Until now I have been using Sage 2012 Pro. I'm having problems using my existing company file in the new version: It seems that Sage 50 2015 Pro is having problems connecting to the 2012 Pro version's company file…

Hello! Our legacy data includes special characters and odd formatting for part numbers that I guess we made up along the way and I want to standardise them. Is there a way to wholesale change part numbers where, for example: export part numbers…

I'm wanting to add about 600 items to an already existing list of products in our datasbase. So, I exported 3 lists: I opened I/C “Items”. I created a script that would contain all the columns we use in that first tab (of the Items Module), and the…