Enterprise Resource Planning and Integrations BlogSpot

Skip to content

General Ledger

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

Payment Accounting Issue – Exchange Rate Not Defined

  • by Yogesh Pachpute
  • Posted on January 30, 2017
  • General Ledger

Issue: Payment is not getting accounted or payment is not posting to GL. Analysis: Query the Payment, then navigate to Tools à View Accounting Events à Check the status of Event_Status on accounting event page, […]

Read More

GL Drilldown to FA, FA Drilldown to AP, AP Drillup to GL for Asset Clearing Account

  • by Yogesh Pachpute
  • Posted on January 23, 2017August 23, 2017
  • Fixed Asset

Requirement: Requirement is to identify Fixed Asset and Payables transaction related Asset Clearing Account coming into GL. This is to make the reconciliation of asset clearing account easy. Solution: Build BI Publisher report using following script […]

Read More

Query To Check GL Period Begining Balances with Previous Period Ending Balance(Compare period1_end_balance with period2_begin_balance)

  • by Yogesh Pachpute
  • Posted on January 23, 2017August 10, 2017
  • General Ledger

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 SELECT code.concatenated_segments, period1.begin_balance_dr […]

Read More

Query To Check GL Balances with JE Lines Balances (Compare period_balance with line_bal)

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

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 […]

Read More

Posts navigation

Newer posts

Categories

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

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

Join 17 other followers

Calendar

Calendar

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Apr    
Blog at WordPress.com.