Sage 300

I have a few clients with Large Databases and in one case a Client with Multiple Companies with Large Databases. For Example the Job Cost Transactions table for 1 year of Payroll entries generates 300,000 Records. I created a SQL Query to get the…

Hi there, I will be so thankful if my thinking is correct here as it would be wonderfully simple :).. Am I correct that the table ICILOC has a complete stock list of all my items in all the different locatiosn they can be held in? Thank you once…

Hello, Looking at the Posting Journal table OEAUDD , Question: What is the difference between [UNITCOST] (item unit cost I'm assuming) and [EXTCOSTH] ? Initially, I thought EXTCOSTH was just unit cost multiplied by the quantity (and it is in some…

Hi There Can any one help with this message that a client is receiving in Intelligence: "The version of the registered DLL file [PLPLUGB.DLL] is too old for use with the application. The DLL should be version [6.0.5] or higher. The current registered…

I am having an issue with Report Designer where I have set up a Revised Budget under Budget set 2 but the revised budget is not being pulled into the Designer report. I can see the revised budget in the Budget Maintenance screen. I have reviewed the…