Browse By Tags

  • Importing Transactions into Project and Job Costing

    Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    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…

  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?

  • GLJED CompanyID field with incorrect company ID

    We have noticed that the CompanyID field in the GLJED table does not tie up with the actual company AUDTORG field. The bulk of the record have the correct company ID, however many have either blanks or random company ID's I have checked this at several…

  • Data Integrity Check

    Hi, We ran the Data Integrity Check and we have the following error message:"E: Database XXDAT uses an application CS that is not installed. 1 Error found in Administrative Services. Any ideas?

*Community Hub is the new name for Sage City