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…
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…
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.