Use this screen to post depreciation expense, disposals, and related depreciation adjustments and/or transfer entries to the General Ledger for depreciable assets. You can also use this screen to post disposals for non-depreciable assets. Although posting a disposal for a non-depreciable record will update the General Ledger only if you selected the Post Disposal to G/L checkbox in the Maintain Asset Master Info main screen or the Post Disp to G/L checkbox in the Maintain Asset Desc Info screen, general disposal data, such as disposal date and description, will be written to and will display in the Disposal Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset Disposal Info screen.
You can also update the Open Billing Detail table with depreciation expense data during a Fixed Assets posting if specific conditions are met at the time of posting.
All depreciable entries and non-depreciable entries for which you have selected the Post Disposal to G/L checkbox in the Maintain Asset Master Info main screen or the corresponding checkbox in the Maintain Asset Desc Info screen are posted to the General Ledger for the current fiscal year, period, and subperiod displayed in the Posting Settings screen. Only one Fixed Assets period can be open and designated as "current" at any given time. (You must enter current fiscal year, period, and subperiod information in the Posting Settings screen before you can print or post.)
After you post for the first time, you will not be able to change either the fiscal year or the period in the Posting Settings screen. In addition, once you close a Fixed Assets period, you cannot reopen it to add additional data or make changes to existing data. (You can, however, make applicable corrections or additions in the next accounting period, or you can reverse a current period depreciation and/or disposal posting in the current period.)
As a result, it is very important that you:
Check the settings in the Posting Settings screen before you post the Fixed Assets Journal for depreciation, disposals, and/or transfers for the first time.
Calculate and post depreciation for the current period before you run the period close process.
Post all disposals for the current period before you run the period close process.
For all depreciable records and non-depreciable entries for which the Post Disposal to G/L checkbox has been selected in the Maintain Asset Master Info main screen or in the Maintain Asset Desc Info screen, the Fixed Assets Journal is posted to the General Ledger for only the G/L Book. There are no G/L entries for optional Books 2-10.
Each G/L entry is identified in the Fixed Assets Journal by a four-letter type code: depreciation expense entries are labeled "DEPR;" disposals are labeled "DISP;" depreciation adjustment entries in conjunction with disposals are labeled "DADJ;" and transfer entries are labeled "TRF."
Reversing entries in the current period are posted from the Reverse Posted Fixed Assets Entry screen, in which depreciation reversals are labeled "RDEP," disposal reversals are labeled "RDIS," and depreciation adjusted related to disposals are labeled "RDAD." There is no code for a transfer reversal because you would simply make an additional transfer ("TRF") to reverse a previous transfer.
The system completes the following steps when posting depreciation expenses for depreciable assets:
The system calculates the amount to post by subtracting the Amount Posted Curr Pd from the Current Pd Depreciation. (Both fields are located in the G/L Book Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset G/L Book Info screen). Posting will not take place if the amounts in the Amount Posted Curr Pd from the Current Pd Depreciation fields both contain zeroes or if the amounts are equal.
A debit amount is normally posted to one or more depreciation expense account/org/project/ref1/ref2 combination(s) specified by the depreciation expense allocation code assigned to the Asset Master record. The debit amount(s) calculated for posting is based on the percentage allocated to each account when you set up your depreciation expense account allocation codes during initialization.
A credit amount is normally posted to the accumulated depreciation account/org/proj/ ref1/ref2 combination specified by the accumulated depreciation account code assigned to the Asset Master record.
The amount posted is added to or deducted from the cumulative total in the Amount Posted Curr Pd field in the G/L Book Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset G/L Book Info screen.
The system completes the following steps when posting disposals and depreciation adjustments for depreciable assets:
A credit amount is normally posted to the asset account/org/proj/ref1/ref2 ("ownership") combination specified in the asset account fields in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen to reverse the cost of the asset.
A debit amount is normally posted to the accumulated depreciation account/org/ proj/ref1/ref2 combination specified by the accumulated depreciation account code assigned in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen to reverse the total accumulated depreciation of the asset.
The book value amount is normally posted to the gain/loss account as a gain (debit) or a loss (credit), as appropriate, as the balancing entry. (Note that the amount posted is not necessarily the gain/loss amount that displays in the disposal transactions entry screens.)
Disposal information and posting data are written back to the Disposal Info subtask of the Maintain Asset Master Info screen and the Maintain Asset Disposal Info screen.
If a depreciation adjustment was entered for the disposal in either of the disposal entry screens, the system posts a separate DADJ entry to the General Ledger. This entry posts a debit amount (if the adjustment was positive) or credit amount (if the adjustment was negative) to one or more depreciation expense account/org/proj/ref1/ref2 combination(s) specified by the depreciation expense account allocation code assigned to the Asset Master record. The amount(s) calculated for depreciation expense posting is based on the percentage allocated to each account when you set up your depreciation expense account allocation codes. This entry also posts a debit or credit amount to the accumulated depreciation account/org/proj/ref1/ref2 combination specified by the accumulated depreciation account code assigned to the Asset Master record.
Disposal and depreciation adjustment data is cleared from the Maintain Single/ Multiple Disposal Transactions screens when the posting process is complete.
The record status in the Maintain Asset Master Info main screen and in the Maintain Asset Desc Info screen is changed from Active to Disposal.
The system completes the following steps when posting disposals for non-depreciable assets for which the Post Disposal to G/L checkbox has been selected in the Maintain Asset Master Info screen and the Post Disp to G/L checkbox has been selected in the Maintain Asset Desc Info screen:
A credit amount is normally posted to the asset account/org/proj/ref1/ref2 combination specified in the asset account fields in the Account Info for G/L Book subtask of the Maintain Asset Master Info screen to reverse the cost of the asset.
A debit amount is normally posted to the specified gain/loss account/org/proj/ref1/ref2 combination.
Disposal data is cleared from the Maintain Single/Multiple Disposal Transactions screens when the posting process is complete.
The record status in the Maintain Asset Master Info main screen and in the Maintain Asset Desc Info screen is changed from Active to Disposal.
Disposal information, such as date and description, is written back to the Asset Master record in the Disposal Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset Disposal Info screen.
The system completes the following steps when "posting" disposals for non-depreciable assets for which the Post Disposal to G/L checkbox has been de-selected in the Maintain Asset Master Info main screen and in the Maintain Asset Desc Info screen:
Disposal data is cleared from the Maintain Single/Multiple Disposal Transactions screens when the posting process is complete.
The record status of the Maintain Asset Master Info main screen and in the Maintain Asset Desc Info screen is changed from Active to Disposal.
Disposal information, such as date and description,) is written back to the Asset Master record in the Disposal Info subtask of the Maintain Asset Master Info screen and in the Maintain Asset Disposal Info screen.
You can have the system automatically generate transfer entries for posting to the G/L when you make changes to the asset ("ownership") account, organization, and/or project fields AND/OR the Accum Depr Acct Code fields in any Asset Master record screen.
In order for the system to capture change data for posting transfer entries, you must first make certain selections in the Asset/Template Change Settings screen before you make changes to Asset Master records, as follows:
Select the Asset Master Records checkbox in the Write Change Details to Audit Log for group box to indicate if you want the system to write change details to an audit log for changes made to Asset Master record and/or Asset Template record selected fields.
Because the system uses change history data from the audit log to create transfer entries for posting to the G/L, you must select this checkbox to save changes, even if this is not your preference.
Make selections as appropriate for the following fields/columns in the Asset/Template Field/Column Names subtask:
Asset Account
Asset Organization
Asset Project
Accum Depr Account Code
Make selections in the Create Transfer Entries for Posting to G/L group box, as desired.
You can select checkboxes to create transfers for posting for changes to the Asset "ownership" account, organization, and project, and/or the Accum Depr Acct Code field.
Normally, when you make a change to asset "ownership" or accumulated depreciation for balance sheet accounts, you must also make a "re-class" journal entry in the General Ledger to record the transfer of ownership. If you select the Asset ("ownership") account, organization, project, and/or reference number fields checkbox, the enabled transfer functionality automatically replaces the need for a manual journal entry.
You can also select an option related to posting transfers for Accum Depr Acct Code changes. If the change in Accum Depr Acct Code field involves no change in the associated account, organization, and/or project, you can choose to NOT have the system create a transfer entry for posting, or to have the system automatically create a transfer entry for posting.
There may be occasions in which you have assigned a different accumulated depreciation account code to a record, but the new code uses the same account, organization, and/or project as the old code; you may have made the change to assign a more meaningful code to the record or for any other reason. If there is no change to the accumulated depreciation account, organization, and/or project, there is no need for a re-classification journal entry, and therefore no need for the system to create an automatic system transfer entry.
Provided you have properly selected the checkboxes in the Asset/Template Change Settings screen and you have chosen the appropriate transfer options in this screen, the system will automatically include transfers entries for posting to the General Ledger.
Please refer to the documentation for the Asset/Template Change Settings screen for additional information.
Before posting, you must print the Fixed Assets Journal. You can print the Journal in either detail or summary format by checking or unchecking the Print Detail Journal by Asset/Item No checkbox. The Journal provides supporting detail for your journal entries, and should be retained as part of the system audit trail. (You can always print reports for all posted transactions, "after-the-fact," in both summary and detail format for one, a range of, or all prior periods, if needed.)
Although you must print the Journal before posting, you can also print the Journal without posting, to review and correct data prior to posting. If you exit from the screen or change your selections, however, you must print the Journal again before you will be allowed to post.
You can also 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 is 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
If the Proj Billing Info record is transaction-based
Please refer to the documentation for the Maintain Open Billing Detail screen in Costpoint Billing for more detailed information.
You can post depreciation, disposals, and transfers only to the current fiscal year, period, and subperiod combination designated in the Posting Settings screen. After you close the Fixed Assets period, you cannot reopen it for any reason. If you have never posted depreciation or disposals, you can still change the current fiscal year or period in the Posting Settings screen. After you post for the first time, however, you will not be able to modify the current fiscal year or period. (The subperiod to which entries will be posted always remains editable in the Posting Settings screen before you run the Posting process.)
In addition, once you close a Fixed Assets period, you cannot reopen it to add additional data or make changes to existing data. You can, however, make applicable corrections or additions in the next accounting period, or you can reverse a current period depreciation and/or disposal posting in the current period.
Before posting depreciation, compute depreciation and/or enter monthly depreciation manually for all applicable active, depreciable assets and print the Current Period Depreciation Report. Use this report to review and correct any errors or omissions in the calculation and potential posting of depreciation on an asset-by-asset basis.
For those assets for which the Auto Calculate or Auto Calculate Depreciation checkbox is not selected in the G/L Book Info subtasks of the Maintain Asset Master Info screen or in the Maintain Asset G/L Book Info screen, enter or edit the appropriate amount of current period depreciation in the Current Pd Depreciation field in the G/L Book Info (Years or Units) screen and/or amortization in the Monthly Payment field in the G/L Book Info (Leases) screen, as desired.
If you also use optional books 2-10 and you have not selected the Auto Calculate or Auto Calculate Depreciation checkbox, make sure that you manually enter current period depreciation amounts in the Other Books Info subtask of the Maintain Asset Master Info screen as appropriate. You should also review amounts already displayed in these fields as a result of prior manual entries, to insure that they are also correct for the current period.
Before posting disposals and/or depreciation adjustment entries related to disposals, you must first enter the disposal data in the Maintain Single/Multiple Disposal Transactions screens or use the Create Multiple Disposal Transactions function to create them. You must assign a Selected for Posting status to each disposal record before posting.
Before posting disposals, use the Disposal Transactions Edit Report to review disposal and depreciation adjustment information.
Before the Asset Audit Log can capture change data, you must first make the appropriate selections in the Asset/Template Change Settings screen.
Before you can post transfer entries to the General Ledger from data existing in the Asset Audit Log, you must first make changes to the Asset "ownership" account, organization, and project, and/or the Accum Depr Acct Code field, as appropriate.
You can view transfer data in the Asset Change History Inquiry screen to determine if changes to the Asset "ownership" Account, Organization, Project, and/or the Accum Depr Acct Code field exist as unposted transfers by selecting the Asset ("ownership") account, organization, project, and/or reference number fields or the Accum Depr Acct Code fields checkboxes.
You can post depreciation, disposals, and transfers only to the current fiscal year, period, and subperiod combination designated in the Posting Settings screen. After you close the Fixed Assets period, you cannot reopen it for any reason. If you have never posted depreciation or disposals, you can still change the current fiscal year or period in the Posting Settings screen. After you post for the first time, however, you will not be able to modify the current fiscal year or period. (The subperiod to which entries will be posted always remains editable in the Posting Settings screen before running the Posting process.)
The fields in this group box are non-editable. Because only one accounting period can be open and designated as "current" at any given time in Fixed Assets, you can only post entries to the G/L for the fiscal year, period, and subperiod combination displayed in the Postings Settings screen.
The current fiscal year from the Posting Settings screen displays in this non-editable field. This is the fiscal year to which all entries will be posted for this posting session. The fiscal year in the Posting Settings screen can only be changed before you post for the first time.
The current period from the Posting Settings screen displays in this non-editable field. This is the period to which all entries will be posted for this posting session. The current period in the Posting Settings screen can be changed only before you post for the first time.
The current subperiod from the Posting Settings screen displays in this non-editable field. This is the subperiod to which all entries will be posted for this posting session. When you run the Close Fixed Assets Accounting Period process, "1" always defaults into the Subperiod field in the Posting Settings screen. If you have more than one subperiod per period, and you do not want to post all entries for this posting session to Subperiod 1, you should return to the Posting Settings screen and change the subperiod before posting.
Use this group box to choose which type of entry to post. All three checkboxes in this group box default as unchecked, and you can select one, two, or all checkboxes. In order to post, you must select at least one checkbox. (Note that if you have selected both the Depreciation and the Disposals checkboxes, depreciation entries will be posted before disposal entries during the posting process.)
Select this checkbox to post current period depreciation expense entries for the G/L Book (Book 1). You can post depreciation expense many times in the current period for the same asset. As long as the current period depreciation for the asset is not equal to the amount posted, the system posts an entry for the difference between the two amounts to the General Ledger for Book 1. Depreciation expense posted from data in Asset Master records will be posted and identified as distinctive "DEPR" entries in the General Ledger.
You can review depreciation data before posting by printing the Current Period Depreciation Report.
Select this checkbox to post current period selected disposal entries for the G/L Book (Book 1). You can post a disposal only once. Disposals entered and selected in the Maintain Single/Multiple Disposal Transactions screens will be posted and identified as distinctive "DISP" entries in the General Ledger. Any depreciation adjustments entered for these disposals in the Maintain Single/Multiple Disposal Transactions screens will be posted and identified as distinctive "DADJ" entries (along with the associated disposal "DISP" entries) in the General Ledger.
You can review disposal and depreciation adjustment data before posting by printing the Disposal Transactions Edit Report.
Select this checkbox to post current period transfer entries for the G/L Book (Book 1). You can post multiple transfer entries in the current period for the same asset. Eligible transfers will be posted and identified as distinctive "TRF" entries in the General Ledger.
Before the Asset Audit Log can capture change data, you must first make the appropriate selections in the Asset/Template Change Settings screen.
Before posting transfer entries to the General Ledger from data existing in the Asset Audit Log, you must first make changes to the Asset "ownership" account, organization, and project, and/or the Accum Depr Acct Code field, as appropriate.
You can view transfer data in the Asset Change History Inquiry screen to determine if changes to the Asset "ownership" Account, Organization, Project, and/or the Accum Depr Acct Code field exist as unposted transfers by selecting the Asset ("ownership") account, organization, project, and/or reference number fields or the Accum Depr Acct Code fields checkboxes.
This checkbox is unchecked by default. If you leave this checkbox unchecked, the Fixed Assets Journal will print only a summary report of debit and credit totals for each account/org/project combination. Select this checkbox to print a detail report that includes a breakdown of each debit and credit by asset/item number for each account/organization/project.
A reconciliation report automatically prints for both the detail and summary journal report formats. The reconciliation report summarizes the posted amounts by the type of entry, including Depreciation, Disposals, Depreciation Adjustments on Disposals, and Transfers.
Depreciation Expense Data Reconciliation
The total amount listed on the journal for Depreciation Expense Accounts for entry type Depreciation should reconcile to the total amount printed in the Current Period Depreciation Report (Amount to Post column).
Disposal Data Reconciliation
The total amounts listed on the journal for entry type "Disposals" should reconcile to the column totals in the Disposal Transactions Edit Report as follows:
The Cost Accounts total on the journal should reconcile to the total of the Cost column amount(s) for Book 1 printed in the Disposal Transactions Edit Report.
The Accumulated Depreciation total on the Journal should reconcile to the total of the Accum Depr column amount(s) for Book 1 printed in the Disposal Transactions Edit Report.
The Gain/Loss on Disposal total on the Journal should reconcile to the total of the Book Value column amount(s) for Book 1 printed in the Disposal Transactions Edit Report. The system ignores disposal proceeds during posting and posts the book value (difference between cost and accumulative depreciation) as the gain/loss.
Depreciation Adjustment on Disposal Data Reconciliation
The total amounts listed on the journal for entry type "Depreciation Adjustments on Disposals" should reconcile to the column total amount(s) (for Book 1 only) from the Disposal Transactions Edit Report as follows:
The Depr Adj Depr Expense Accounts total on the Journal should reconcile to the total of the Depr Adjust column amount(s) for Book 1 from the Disposal Transactions Edit Report.
The Depr Adj Accum Depr Accounts total on the journal should reconcile with a reversed sign to the total of the Depr Adjust column amount(s) for Book 1 from the Disposal Transactions Edit Report.
Transfers Data Reconciliation
The total amounts listed on the journal for entry type "Transfers" do not reconcile to a specific Fixed Assets Report. You can, however, verify the amounts from the Reconciliation Report of the Fixed Assets Journal by viewing data in the Asset Change History Inquiry screen before posting using matching transfer selection criteria.
If you select the Print Detail Journal by Asset/Item No checkbox, the system adds up the debits and credits on an asset/item number basis. If you do not select this checkbox, however, the report only provides totals at the higher account/org/project level. Therefore, if an account/org/project combination has both debits and credits to it from several asset/item numbers, the detail report totals all the debits for each asset/item number and all the credits for each asset/item number. The summary report only prints one line for each account/org/project combination. All of the debits and credits on the summary report will be rolled up into one total, which may be either a debit or a credit. The following example details this process.
Account: 05430-001 Organization: 1 Project: 1007
Asset 00001/00001 25.00
Asset 00005/00001 -5.00
Total Debits: 25.00 Total Credits: -5.00
Account: 05430-001 Organization: 1 Project: 1007
Total Debits: 20.00 Total Credits: 0.00
The detail report divides the total for the account/org/project combination into debits and credits, while the summary report provides one total for the account/org/project, which may be either a debit or a credit, but cannot be both.
The printing status of the Journal displays in this field. When the Journal status displays "Journal Not Printed," the Post button is disabled on the toolbar. To post, you must first print the Journal using the Print button or the Print Journal/Post Depreciation button on the toolbar.
Select this button on the toolbar to post depreciation, disposal, and/or transfer entries for the G/L Book (Book 1) for depreciable records. Disposals of non-depreciable assets (for which the Post Disposal to G/L checkbox in the Maintain Asset Master Info screen was not selected) do not affect the G/L Book. As a result, the posting process writes only the disposal date and description to the Asset Master record and changes its status from Active to Disposal.
The system will validate that the Close Fixed Assets Accounting Period process has completed (that is, it is not currently being run or previously failed while being run). You cannot post any entries until the previous period's close has finished successfully.
Select this button on the toolbar to print and post the Fixed Assets Journal simultaneously. Although you can reverse a current period depreciation and/or disposal posting in the current period by using the Reverse Posted Fixed Assets Entry process, you should always, as a matter of procedure, review the Fixed Assets Journal information before posting.
Fixed Assets Posting Detail (FA_POSTING_DETL): The Fixed Assets Posting 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.
Fixed Assets Settings (FA_SETTINGS): This table stores the fiscal year, period, and subperiod displayed in the Posting Settings screen, as well as the other settings you selected in the Fixed Assets Settings screen. The Fixed Assets Posting Detail table uses the current fiscal year, period, and subperiod information contained in this table to compile a posting record for the asset.
Financial Statement Summary (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.
General Ledger 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).
General Ledger 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.
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.
Asset (ASSET): The Asset table stores the majority of data from the Maintain Asset Master Info 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 subtasks of the Maintain Asset Mast Info 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 Other Books (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 Maintain Asset Master Info 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
If the Proj Billing Info record is transaction-based
Please refer to the documentation for the Maintain Open Billing Detail screen in Costpoint Billing for more detailed information.
Asset (ASSET): The Asset table holds most of the information you entered in the Maintain Asset Master Info screen and its subtasks.
For depreciable assets, and for non-depreciable assets for which the Post Disposal to G\L checkbox has been selected in the Maintain Asset Master Info screen or the Post Disp to G/L checkbox has been selected in the Maintain Asset Desc Info 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 checkbox has not been selected in the Maintain Asset Master Info screen nor has the Post Disp to G/L checkbox been selected in the Maintain Asset Desc Info 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-10 after this information has been posted.
Fixed Assets Disposals Edit (FA_DISP_EDIT): This table contains all the disposal information entered in the Maintain Single/Multiple Disposal Transactions screens or created by the Create Multiple Disposal Transactions program. It supplies the gain/loss account, organization, project, ref1, and ref2 information for the Fixed Assets Posting 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
If the Proj Billing Info record is transaction-based
Please refer to the documentation for the Maintain Open Billing Detail screen in Costpoint Billing for more detailed information.
Asset (ASSET): The Asset table holds most of the information you entered in the Maintain Asset Master Info 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 Audit Log (ASSET_AUDIT_LOG): This table stores change data for Asset Master fields. Provided you have properly selected the checkboxes and the appropriate transfer options in the 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 (Asset Audit Log) table to indicate that the transfer has been posted.