If you are new to Sage 300 CRE you can quickly narrow down reconciliation problems with this tip.
For this example we will use a cost account vs JC. You have run your monthly JC reconciliation report and it indicates one of you cost account is out of balance with JC.
In GL, Open an Inquiry - select the Account Inquiry, Select then Account, Use conditions to choose accounting dates. From any column use the select option to add additional data to inquiry - Add column after this column - I selected "Job" and hit enter twice. You can further condition for Job = "" or drop in excel. This will drive you to entries not related to JC in a cost account. You can use this technique throughout Sage.