Script to get AP Invoice Aging for Prepayment
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 […]
AP Trail Balances SQL Query for R12
AP Trail Balances SQL Query for R12 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 […]
What is MICR? and what are common MICR Check Requirements
What is MICR? Magnetic Ink Character Recognition (MICR) is the line of numbers (ten numeric and four special symbols) on a document that relates a transaction to a specific customer’s account. Encoded checks are processed […]
Reduce CIP Asset cost by Invoice Amount
Problem Summary ————————————————— Invoice and Amount Wrongly Added to CIP Asset Solution: Summary: Reduce CIP Asset cost by Invoice Amount $386 Detailed Steps: 1) Reclassification of given invoices in AP(to create 1 positive and 1 […]
Using functions in WITH clause in Oracle 12c
The WITH Clause, or Subquery Refactoring If you haven’t heard of the WITH clause, let me take a moment to explain what it is. The WITH clause is a clause in SQL that allows you […]
How to Replace Special Characters in Oracle SQL
Options for Replacing Special Characters In Oracle SQL, you have three options for replacing special characters: Using the REPLACE function Using the REGEXP_REPLACE function Using the TRANSLATE function Each of them has their pros and […]
Spreadsheet Guidelines for EIB Spreadsheet Templates in Workday
Spreadsheet Guidelines for all EIB Spreadsheet Templates Always generate a spreadsheet template in Workday for the upload. Keep the template in its original XML Spreadsheet 2003 format. Do not save a template to any other format. Add […]
Net book value
Net book value is the amount at which an organization records an asset in its accounting records. Net book value is calculated as the original cost of an asset, minus any accumulated depreciation, accumulated depletion, accumulated amortization, and […]
What is negative depreciation in regard with fixed assets?
Depreciation is a common accounting concept that helps adjust the value of a deteriorating asset over time as it becomes less efficient. A business can depreciate an asset with an expected useful life of more […]
Accumulated depreciation or YTD depreciation projection as of specific period end.
Oracle by default does not maintain future depreciation information (Accumulated or YTD) as depreciation could change as per cost adjustment, addition or asset retirement. Often there will be requirement to write a function or package […]
Enterprise Resource Planning and Integrations BlogSpot 