Browse By Tags

In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…

Hi, I would like to ask question regarding customized table in company database. Lets say we have DB called SAMLTD. For customer requirement, I need to add another table ' CUSTOM ' in SAMLTD to store information. Then I have to sync this information…

I want to make multiple Slip Entries.

I am in need of a purchase order import template. I have tried using the help section to create one with no luck. Our consultant doesn't have one and I cannot work backwards by exporting because I get the following error: Can someone please send me…

When MRP Generation is running, does it look at the open PO's, what does it look at? Does it look at Header or Detail line tables? Or does it go by the PO Log? Reason for asking is that I see a lot of entries in the PO Log that are not in the Header/Detail…

Just out of curiosity does anyone have older macros from 16 and before that has been brought over to 17 and was able to successfully use them with 18.2?

I am trying to add a client to Timeslips that was an inactive client in Quickbooks. Previously, I could make the client active in QB and then add them from Unassigned QB customers to TS by adding them in the linked TS Clients and QB customers portal.…

I have been able to find the import layout for AR Invoice Import but it looks as if this is using contract based type billing for the imports. Is there anyway to import an invoice as a quick bill with standard items on it?

Sage300 CRE Version 17.1 Rev6 We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the…

We have one user of the Purchasing Module POIV that gets the error Not Responding when opening the program. It hangs on configuring database. This doesn't happen with our Win7 users only the Win10 user. We are using Sage300CRE version 16.1. Any ideas…

can any one help i had to update my sage accounts 50 because i moved my computer and all of a sudden the sage couldnt recognise the computer. so i was advised to cahnge and upgrade to v25 of which once i had done that my main computer worked. what i…

For some reporting purposes I need to normalize the bill of materials exactly how it shows in the BM_SummarizedReportWRK report into a SQL table. How do I do this? I've been attempting to backwards engineer from the regular and accessible Bill Of Materials…

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…

Hello, I am trying to do a SQL query to see which users have had activity on a specific company ABC by doing a SQL query on the SY_ActivityLog table. When I do a query where CompanyCode = 'ABC', I get MOST of the users that have had activity on ABC…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

I recall reading articles years ago about BV and its reliance on Pervasive 10 which reached its end of life a few years ago, and crystal reports which i think is no longer a thing? I recall there being a limitation with BV that all database access would…

The Sage 300 CRE C: drive filled up and caused the Data folders to look as if the rights had been removed. It was caused by .slg files like this: "C:\Users\Public\Documents\GlobalSettings\SageReplicator\4148 - 131882004005307603.slg" There were only…

I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are. So, if a formula is being used, is it used in another formula, report, etc. I have 100's of formulas & reports…

Merged over 3,300 items to code "Z_Discontinued" after months of working with staff to make sure all items on list were approved for merging. Now they need 2 of the 3,300 items restored, historical data. I created the original item numbers and setup…

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.

Created a New Company for testing purposes - copied all applicable files into new company per online instructions. Everything in new company seems to look OK, except the GL accounts had a different format (the - and . appear to have been removed). In…

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…