Welcome to the Sage 500 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…
Hello Everyone, We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best…
The cost tier is an important costing feature provided by IM which allows the system to track the actual cost at which an item was purchased every time.
Sage 500 stores the cost in table timCostTier . Here is the schema for that table:
A cost…
We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
Each Sage 500 transaction is associated with a unique transaction type number. This number follows the transaction in module’s transaction tables as well as in GL posting tables. Here is the list of all transaction types loaded when Sage 500 database…
If you need to have an archived Sage 500 database you probably want to limit the access to that database by general users. In this situation restricted access mode can be employed to limit connections to high-level users only. SQL Server's restricted…
On the customization of the SO form, can we access the db connection that Sage is on for updating the temp tables, which otherwise are not accessible from another connection.
This month I want to explain a Database Snapshot and how using it can save you time. Here is the scenario. Say you have a development environment. Lets also say you are testing new modifications. You make updates(Inserts,Updates, Deletes)to the database…
