I have a challenge...can someone familiar with the Sage 300 database tables give me some advice?
I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable.
When I search through the Sage 300 AOM and see the Common Services (CSFSC) table, I realize that I'm going to need more detail-level information. I'm looking for a flag that would indicate whether a certain period is locked for what modules.
Does anyone know where to find this info in the database?