Controlling Accounting when Creating Receipt via AR_RECEIPT_API_PUB.CREATE_CASH
A prospect asked this question during an API Wizard Demo:
"Can we control the GL Accounting for a receipt
created via API as we can by choosing Receipt Class when entering a
Receipt Batch in Oracle forms?"
Answer:
Yes. In Oracle, a Receipt Class is comprised of some basic
information, the most important of which is the 'Receipt Method'. It is
the Receipt Method that actually controls the GL accounting, not the
Receipt Class (but since a Receipt Method is associated with a Receipt
Class and the user selects the Receipt Class when creating a batch in
Oracle, it is more familiar). Receipt Methods can be associated with
one or more Bank/Branch/Account combinations.
The key GL accounts which can be defaulted for a Receipt Method
include: Cash, Bank Charges, Unapplied Receipts, Unidentified Receipts,
On-Account Receipts, Unearned Discounts, Earned Discounts, and Claim
Investigations.
The public API AR_RECEIPT_API_PUB.CREATE_CASH allows you to pass the
Receipt Method as well as Bank info, providing the same control of GL
Accounts as when entering a batch using a Receipt Class.
By the way, there are several other things you can do with ar_receipt_api_pub, including procedures: apply, apply_in_detail, unapply, process_payment, create_and_apply, create_payment_extension, reverse, apply_on_account, unapply_on_account, unapply_other_account, activity_application, activity_unapplication, create_misc, apply_open_receipt, unapply_open_receipt. There's so much you can do with ar_receipt_api_pub. Unfortunately, as many of you know, the one thing it can't do is create a receipt batch. It's been on the Oracle enhancement list for a while, hopefully they get to it soon!
Working with Oracle APIs, Open Interfaces, Reports, Excel, BI to get stuff done! API Wizard (www.api-wizard.com) is a productivity tool for Oracle EBS data entry, data updates, and reporting for Oracle and Oracle EBS using a Microsoft Excel user interface and a powerful Oracle backend. The purpose of this blog is to share our knowledge working with Oracle APIs and interfaces - so that whether you're using API Wizard or building custom integrations, you can leverage what we've been working on.
Subscribe to:
Post Comments (Atom)
Popular Posts
-
Oracle Projects API (PA_PROJECT_PUB) and Function Security A customer wanted to work with project module APIs to perform standard project ...
-
Working with Purchase Order Import (Import Standard Purchase Orders - POXPOPDOI) A prospective customer wants to use API Wizard to load pu...
-
Where do I find info about Oracle EBS Public APIs? This is a question that I get multiple times each week in my role at API Wizard (a soft...
-
Oracle EBS API to create a Phone Number (contacts) in R12 HZ_CONTACT_POINT_V2PUB.CREATE_PHONE_CONTACT_POINT This API is relatively easy to...
-
WIP Discrete Jobs and wip_job_schedule_interface / Allow Explosion and Scheduling One of our customers was working with a process to creat...
-
Vendor Site trx failed: Inconsistent data entered as compared to TCA records. Working with supplier site API ap_vendors_pub_pkg.create_ven...
-
At long last, EBS customers can enter physical inventory counts and adjustment approvals through a new public API. Phyiscal Inventory count...
-
NLS_LANGUAGE what a pain... Oracle EBS issue I have a customer who has a report that works great in the U.S. but when they rolled the repo...
-
Creating Project Tasks with pa_project_pub - Issue when parent task created in form vs. create with API The Oracle Projects public APIs pa...
-
Controlling Accounting when Creating Receipt via AR_RECEIPT_API_PUB.CREATE_CASH A prospect asked this question during an API Wizard Demo: ...
No comments:
Post a Comment
Please add your feedback, experience, or questions!