The Official Portal for the State of Georgia

MobileMobile | FAQ | Site Map | Jobs | Online Services | Contact Us  

Home > Financial Systems > PeopleSoft Financials > Asset Management > Queries

Queries

08/15/2001 - Two New Queries

Two new queries have been created to help agencies balance their Agency series of reports. The Agency series of reports runs off the "transaction date". This includes the Agency Inventory Report, Agency Transactions Processed, Agency Detail/Summary Recon, Agency Reconciliation Summary and the Agency Acquisition Cost Totals reports. The "transaction date" is accessed if you click on the "Edit Trans Info" box. Users are currently able to backdate the transaction date to an accounting period that is not open. However, the transaction date and the accounting date default from the current date and you would normally not need to change these dates. The only exceptions would be at State and Federal year-ends when we leave June and September open into the next month. In those cases you would change both the transaction and accounting date to 06/30/20XX for June and 09/30/20XX for September.

If the transaction dates on any of your transactions such as express adds or adjustments were backdated to accounting periods that are closed, your beginning balances on your reports will be affected. We have a query that will show any transactions where the transaction date is less than the accounting date. The query is 0AM_BAL_AGY2_TRANDT_LT_ACCTDT. If you are trying to reconcile any of your agency reports you may want to run this query. It will prompt you for your business unit and the transaction through date. For example, if the report you are working with was run through 07/31/2001, you would want to run the query through the same date. If you get any transactions on this query where the dates are different but still in the same month they are probably not a problem. However, if the accounting date is in a different month than the transaction date, this is probably a reconciling item. You can also see from the date/time information on the query when the transaction was actually entered.

We also have another new query, 0AM_BAL_AGY1_RPT_BY_TRANS_DATE. It will prompt you for your business unit, a beginning transaction date and ending transaction date. This will give you similar information you would get on the Agency Detail/Summary Recon report (AM0XXX406). This query is also useful to help you locate problem transactions.

The Agency reports in Asset Management include all assets. This would be any asset that was flagged as an asset in accounts payable or any express add regardless of the profile. This includes small value profiles such as SMALLCOMP and SMALLVALUE. The G/L reports such as the G/L Inventory, G/L Recon Detail/Summary and the G/L Recon Summary do not include these small value profiles. That is the primary difference between the Agency and the G/L reports in Asset Management.

Open and save or print a Word doc showing the panels, using Express Add.

08/03/2001 - New Queries Created
The List of AM queries now includes:

07/27/2001 - AM to GL Query

The List of AM queries now includes:
0AM_BALGL9_ASSETS_W_PRG_DES, to help you balance your assets in the general ledger module to the asset management module. It includes similar asset activity that you would find on the G/L Recon Detail/Summary Report. However, it also includes additional information such as the program code and the program code description. This will help you identify assets purchased with Federal funds.

06/15/2001 - Updated run-only queries

The List of AM queries now includes:

georgia.gov | Agencies | Privacy/Security | Notices | Accessibility | Español | Survey | Contact georgia.gov