x Want to participate? Join the group to interact

Sage 300

Welcome to the Sage 300 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.

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
Import Inventory Control Preferred Vendor flag is not working, how do you mass update preferred vendor in the vendor details?

peterr

I am struggling with importing the preferred vendor field in IC Vendor Details, even when I export and force the field to Yes (Check box) on re-import it still does not update the required field. When I check the ICITMV table that field does not even…
- Answered
- over 8 years ago
- Sage 300
- Operational Suite