Community Hub
Community Support
Site Help
Cancel
Search
User
Site
Search
User
Browse By Tags
All tags
Data and Database
Receipt
ODBC
Accpac
sage 300
api
Batches
database
entries
invoices
Posting
queries
Sage 300 ERP
Sage 300 ERP 2014
SQL
Sage 300 - sql query for recalculating AP Balances - reconciling to GL
Jimatwork
Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
over 6 years ago
Sage 300
Databases and Operating Systems
Current fiscal period for a company in database?
roastbeast
Can someone please tell me what table/column will give me the current fiscal period for a company?
over 7 years ago
Sage 300
Databases and Operating Systems