Fixed Asset- Split Transaction
Introduction/ Issue In this document we shall see how to perform SPLIT in Fixed asset Split Divide an asset into separate units. Use the Split Assets routine to divide an…
Read MoreFixed Asset- Depreciation
Hi All Introduction: Depreciation This Blog will explain about the Deprecation calculations What is Depreciation? Assets calculates depreciation using either the recoverable cost or the recoverable net book value as…
Read MoreQuery to get FA Mass Additions Details
SELECT DISTINCT fma.book_type_code, fma.posting_status, fma.description, fcb.segmnet1 major_category, fcb.segment2 minor_category, fma.fixed_assets_units, fma.fixed_assets_cost, (select segment3 from fa_locations where location_id=fma.location_id) location, fma.date_placed_in_service, fma.asset_number, fma.asset_key_segment1, fma.asset_key_segment2, invoice_number, po_number, vendor_number, queue_name, invoice_date, payables_cost, depreciate_flag,…
Read MoreAPI for Fixed Asset adjustments
Introduction. This API will used to adjust the Fixed asset details like life_in_months and etc. declare l_trans_rec FA_API_TYPES.trans_rec_type; l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type; l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type; l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type; l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type; l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type; l_inv_tbl FA_API_TYPES.inv_tbl_type;…
Read MoreASSET DEPRECIATION LOGIC QUERY
This query fetches the details of those assets which are partially and fully depreciated. SELECT ASSET_CATEGORY_ID ,MAJOR_CATEGORY ,OPENING_DAY_ASSET_COST ,OPEN_ACC_ASSET_COST_FY …
Read More