Enterprise Resource Planning and Integrations BlogSpot

Skip to content

General Ledger

Payroll Journal Entries

  • by Yogesh Pachpute
  • Posted on August 11, 2017August 11, 2017
  • General Ledger

Payroll journal entries are used to record the compensation paid to employees. These entries are then incorporated into an entity’s financial statements through the general ledger. The key types of payroll journal entries are: Initial […]

Read More

Asset Trace or Single Asset Diagnostics

  • by Yogesh Pachpute
  • Posted on July 5, 2017July 5, 2017
  • Fixed Asset

Asset Trace or Single Asset Diagnostics Run the program “Generate Asset Trace” FA responsibility:  Other > Requests > Run  Generate Asset Trace                  It will span following two […]

Read More

How to Setup the New Manage Accounting Exception Program (Sweep) in Receivables?

  • by Yogesh Pachpute
  • Posted on May 5, 2017May 5, 2017
  • General Ledger

Goal: How can I setup the new Consolidated Review and Manage Accounting Exception Program in Receivables? Also referred to as the Sweep program. Solution: Please perform the following: For Release 12.1, in order to enable […]

Read More

How to disabled GL Account and All associated GL Code Combinations.

  • by Yogesh Pachpute
  • Posted on April 25, 2017January 4, 2018
  • General Ledger

Execute Following action plan to disable GL Account and all associated GL code combinations. Query GL Account Value Set through Flexfield à Validation à Values Then uncheck “Enabled” check box and save the changes Then […]

Read More

API to create Code Combination and get CCID

  • by Yogesh Pachpute
  • Posted on April 21, 2017
  • General Ledger

It may not always be the case that Account codes will be created by user from the front end. There may be scenarios sometimes where we need to have programs that will be creating the code combinations. […]

Read More

API to Get and Create GL Code Combination Id

  • by Yogesh Pachpute
  • Posted on April 21, 2017August 23, 2017
  • General Ledger

1) Key Assumption is “Allow Dynamic Inserts” should have been enabled for GL Accounting Flexfield Structure One May have to use apps initialize, but mostly not required if called from concurrent program. 1 2 3 […]

Read More

GL Daily FX Rate Upload

  • by Yogesh Pachpute
  • Posted on April 17, 2017April 17, 2017
  • General Ledger

Following are 3 key programs that can be used to upload GL Daily Conversion Rates. A) XXCB FX Rates Data Load Program B) XXCB FX Rates Validation Procedure Program C) Program – Daily Rates Import […]

Read More

Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc.

  • by Yogesh Pachpute
  • Posted on April 12, 2017August 11, 2017
  • General Ledger

Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. 1 2 3 4 5 6 7 8 9 10 11 12 13 […]

Read More

Drilldown from GL to AP for Liability and Prepayment and Expense account

  • by Yogesh Pachpute
  • Posted on April 12, 2017August 11, 2017
  • General Ledger

–Query to get GL Batches, Journal and Lines for Liability Account for a single GL period for source Payables and Category Purchase Invoices if you want include payment category then comment out category equals Purchase […]

Read More

How to find SubLedger accounting package being used for custom or standard subledger accounting engine

  • by Yogesh Pachpute
  • Posted on February 23, 2017August 11, 2017
  • General Ledger

Use following query to find the accounting package is being used 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 […]

Read More

Posts navigation

Older posts
Newer posts

Categories

  • AR Reconciliation (8)
  • BI Publisher (3)
  • Cash Management (4)
  • Cloud Enterprise Structure (2)
  • Concurrent Processing in R12 (4)
  • Conversion (2)
  • Cost Management (1)
  • Fixed Asset (23)
  • General Ledger (24)
  • GRC (6)
  • iExpense (21)
  • Linux Server Security and Maintenance (1)
  • Microsoft Windows Configurations (6)
  • Oracle Cloud Fusion Financial (11)
  • Oracle Cloud Security (1)
  • Oracle Database (2)
  • Oracle Fusion HCM (10)
  • Oracle Fusion HCM Technical (5)
  • Oracle Fusion Technical (10)
  • Oracle Installations (3)
  • Oracle Inventory (2)
  • Oracle SQL (4)
  • Order Management (2)
  • Payables (47)
  • Payables Period Close (10)
  • Payables Reconciliation (10)
  • Payments (29)
  • Payroll (1)
  • Perl and Unix Scripting (1)
  • Purchasing (4)
  • Receivables (17)
  • Receivables Period Close (15)
  • Receiving Subledger (3)
  • RMCS (1)
  • SubLedger Accounting (26)
  • Supply Chain Managment (1)
  • TCA – DQM (1)
  • Uncategorized (2)
  • Useful SQL Scripts (4)
  • Workday (7)

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Calendar

Calendar

January 2023
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Aug    
Blog at WordPress.com.
  • Follow Following
    • Enterprise Resource Planning and Integrations BlogSpot
    • Join 34 other followers
    • Already have a WordPress.com account? Log in now.
    • Enterprise Resource Planning and Integrations BlogSpot
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...