Costpoint Essentials Online Help

Table Information for the Post Fixed Assets Journal Screen

This screen makes use of the following tables:

  • FA_POSTING_DETL - Posted Transactions Detail (FA_POSTING_DETL): The Posted Transactions Detail table stores all the detailed information related to the journal entries created by posting depreciation, disposals, depreciation adjustments related to disposals, and transfers. This information includes asset/item number, fiscal year/period/subperiod, transaction type:[depreciation (DEPR), disposal (DISP), depreciation adjustment related to a disposal (DADJ), or transfer (TRF)], the transaction amount, and account, organization, and project information.
  • FA_SETTINGS - Fixed Assets Settings (FA_SETTINGS): This table stores the fiscal year, period, and subperiod displayed on the Configure Posting Settings screen, as well as the other settings you selected on the Configure Fixed Assets Settings screen. The Posted Transactions Detail table uses the current fiscal year, period, and subperiod information contained in this table to compile a posting record for the asset.
  • FS_SUM - Financial Statement Summary Acct Balances (FS_SUM): The system inserts a summary record into this table for each account/organization to which depreciable assets have been posted. This record contains the account, organization, and FY to which posted, along with a total cumulative transaction amount for each period. (If more than one FA posting has occurred in a single period, the system increments (or decrements) the total amount for the period on a cumulative basis.) No detailed data, such as asset/item number, posting sequence number, entry type, and so on. is written to this table.
  • GL_DETL - Transaction Posting Detail (GL_DETL): The system inserts a summary record into this table that matches the entry in the General Ledger Posting Summary table. Account, organization, and project information is not duplicated in this table, which contains both the entry user ID and the posting user ID, as well as the posted amount and a transaction description ("FA Posting"). No detailed data, such as asset/item number, entry type, and so on, is written to this table. Rows in this table are linked to rows in GL_POST_SUM via the level key columns and the source key (which is always "210" for Fixed Assets entries).
  • GL_POST_SUM - Transaction Posting Summary (GL_POST_SUM): The system inserts a summary record into this table for each account/organization/project to which depreciable assets have been posted. This record contains account, organization, and project information, fiscal year, period, subperiod, a posting sequence number, journal code "FA, " and the cumulative posted amount for the period.  No detailed data, such as asset/item number, entry type, and so on, is written to this table.
  • REF_SUM - Reference Summary (REF_SUM): The system inserts a summary record into this table for each reference number to which depreciable assets have been posted (if you use reference numbers). This record contains the account, reference number, and FY to which posted, along with a total cumulative transaction amount posted for each period. (If more than one FA posting has occurred in a single period, the system increments (or decrements) the total amount for the period on a cumulative basis.) No detailed posting data, such as asset/item number, posting sequence number, entry type, and so on. is written to this table.

Additional Tables Affected by Depreciation Expense Postings - Asset Master (ASSET): The Asset Master table stores the majority of data from the Manage Asset Master Information screen and its subtasks. When you post depreciation expense, the system adds the amount posted in the current session to previous amount(s) already posted for the period (if applicable) and displays the total cumulative amount posted for the period in the Amount Posted Curr Pd field in the G/L Book Info tab of the Manage Asset Master Information screen. The posting process reads the current period depreciation amount and the amount posted stored in this table to calculate the amount to post on an asset-by-asset basis. Once posted, the values in the Amount Posted Curr Pd field and the Current Pd Depreciation fields will be equivalent.

Asset Master Other Books Info (2-10) (ASSET_OTH_BK_DEPR): This table stores data for optional Books 2-10, as utilized. Although there is no interface with the G/L for these books, each "posting" process for depreciation expense increments or decrements the current period depreciation expense amount that displays in the Other Books Info subtask of the Manage Asset Master Information screen.

Open Billing Detail (OPEN_BILLING_DETL): This table serves as the source table for the calculation of standard bills, giving you the ability to automatically bill depreciation expense generated as a result of posting a depreciation adjustment associated with a disposal.

You can update the Open Billing Detail table with depreciation expense data during a Fixed Assets posting if specific conditions are met at time of posting, as follows:

  • If the account to which depreciation will be posted has been associated with a Project Account Group that has been assigned a Labor or Non-Labor function;

(Although a labor account would be considered inappropriate for charging depreciation expense, note that there are no Fixed Assets rules regarding the types of accounts to which deprecation can be posted.)

  • If the project to which depreciation will be posted has been set up as a billable project in the Project Billing Master at that project level or higher; and
  • If the Proj Billing Info record is transaction-based.

Please refer to the documentation for the Manage Open Billing Detail screen in Costpoint Billing for more detailed information.

Additional Tables Affected by Disposal and Depreciation Adjustment Postings - Asset Master (ASSET): The Asset Master table holds most of the information you entered on the Manage Asset Master Information screen and its subtasks.

For depreciable assets, and for non-depreciable assets for which the Post Disposal to G\L check box has been selected on the Manage Asset Master Information screen or the Post Disp to G/L check box has been selected on the Manage Asset Description Information screen, when you post a disposal, the system updates the asset table with the disposal price, date, description, type, fiscal year, period, subperiod, disposal post date, user ID, and posting sequence number. The status of the asset is also changed to Disposal.

For non-depreciable assets for which the Post Disposal to G/L check box has not been selected on the Manage Asset Master Information screen nor has the Post Disp to G/L check box been selected on the Manage Asset Description Information screen, when you post a disposal, the system updates the asset table with the disposal price, date, description, type, and changes the asset status to Disposal.

Asset Disposals (ASSET_BOOKS_DISP): This table contains disposal and depreciation adjustment data, if applicable, for Books 1 to 10 after this information has been posted.

Asset Disposal Info Prior to Posting (FA_DISP_EDIT): This table contains all the disposal information entered on the Manage Disposal Transactions screen. It supplies the gain/loss account, organization, project, ref1, and ref2 information for the Posted Transactions Detail table, in addition to the disposal date, amount, description, and date. The amount to post for the depreciation adjustment is also stored in this table.

Data is retained in this table until you close the current accounting period, at which time the data corresponding to the posting is deleted from this table. (Data is retained when you reverse a posted disposal in the current period.)

Open Billing Detail (OPEN_BILLING_DETL):  This table serves as the source table for the calculation of standard bills, giving you the ability to automatically bill depreciation expense.

You can update the Open Billing Detail table with depreciation expense data during a Fixed Assets posting if specific conditions are met at time of posting, as follows:

  • If the account to which depreciation will be posted has been associated with a Project Account Group that has been assigned a Labor or Non-Labor function;

(Although a labor account would be considered inappropriate for charging depreciation expense, note that there are no Fixed Assets rules regarding the types of accounts to which deprecation can be posted.)

  • If the project to which depreciation will be posted has been set up as a billable project in the Project Billing Master at that project level or higher; and
  • If the Proj Billing Info record is transaction-based.

Please refer to the documentation for the Manage Open Billing Detail screen in Costpoint Billing for more detailed information.

Additional Tables Affected by Transfer Postings - Asset Master (ASSET): The Asset Master table holds most of the information you entered on the Manage Asset Master Information screen and its subtasks. The posting process for transfers does not affect any data in the ASSET table because the actual Asset Master data was updated during the Change process.

Asset Change Audit Log (ASSET_AUDIT_LOG): This table stores change data for Asset Master fields. Provided you have properly selected the check boxes and the appropriate transfer options on the Configure Asset/Template Change Settings screen, the system will automatically include transfers entries for posting to the General Ledger. As part of the posting process (to prevent the same transfer event from being posted more than once), the system sets a flag in the ASSET_AUDIT_LOG table to indicate that the transfer has been posted.