Sage 300

Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…

Hi, we have 2 invoices that can be seen though SQL in the APIBH file but are not displayed in the vendor activity window. Has anyone encountered this before? Ty.

Hello, can someone point to me in which table we can get the shipping payment term for an order, such as "Prepaid". We looked at OEVIA table but don't find this information in there. Many thanks!

Can anyone advise me if you can run custom crystal reports against data that is on the Sage Online hosted offering. Also is there any way to query the SQL data through tools like SQL enterprise manager.

Hi there, Is there a document for Sage 300 2016 to direct the user as to which tables should be edited in order to change an invoice number in the AR module. thanks

Want to do training using Sage sample Data, not using multi-currency company. Kindly assist between SAMINC and SAMDAT, which one is not multi-currency?

Hi Am trying to find the names of the MS-SQL tables that GLBCHL.DLL is created from. I need to add the batch description and the entry description to the GL Transaction List. The batch description is easy, it's in GLBCH but I cannot find where the batch…

Hello, We have a customer that currently has over 90K accounts. Some 30K of them are not longer used. Any recommendations on how to clean their chart of accounts so it makes the financial reporting processing more manageable? We are thinking about…

I have a Sage 300 ERP 2012 client who is having an issue with their Bank Reconciliation. They have items that were cleared back in March 2011 that are still showing on the Reconciliation tab, even though they have done reconciliations for all periods…

Has anyone tested Sage 300 ERP 2014 on MS SQL server 2014? If yes, did it work well?

Hello, One of my reversed receipts is showing up on my "withdrawals outstanding" in the reconciliation report . Yet, when I'm on the Reconciliation working screens within Bank services, this reversed receipt is not showing up as a withdrawal outstanding…

Hi All, GLAFS table is storing all accounts balances period wise. I want to know the balance as of specific date. From which table I can get this info to design my own report. Regards, Syad