Friday, January 29, 2010

Deferred Tax In AP

In some cases, recoverable taxes can only be accrued and accounted for after the invoice is paid. This is known as deferred recoverability. You can set up taxes with deferred recoverability by enabling the following options at the Tax Regime, Tax, Tax Status, or Tax Rate levels in E-Business Tax. Tax Regime is the most generic level. Tax Rate is the least specific. If you set the options at the Tax Rate level it will override any settings at a more generic level.

Example:
o Assume that you have following tax setup in E-Business Tax.

Tax Rate: 15%
Tax Expense Account: 01-SalesTaxA/C

Recovery Rate: 40%
Default Recovery Settlement: Deferred
Tax Recoverable/Liability Account: 01-TaxRecoverA/C
Interim Tax: 01-DeferredTaxA/C

o Create standard invoice from invoice workbench.
Invoice Amount: 1150$,  Total Tax: 150$ (15%)

Lines:
Item-------1000$
Tax---------150$

Distributions:
Item-------1000$         
RTax---------60$
NRTax--------90$

o Accounting
Invoice Accounting:
CCID-----GL Account----------Dists--------Cr/Dr---Amount($)
17347       01-ItemExpA/C          (Item)          Dr         1000
13850       01-LiabA/C                (Liability)      Cr         1000

Credits recoverable tax amount into Interim account until invoice is paid
12864       01-DeferredTaxA/C    (RTax)          Dr          60
17347       01-SalesTaxA/C        (NRTax)        Dr          90
13850       01-LiabA/C               (Liability)      Cr          150

Payment Accounting:
CCID-----GL Account----------Dists--------Cr/Dr---Amount($)
13850       01-LiabA/C                (Liability)      Dr         1000
89275       01-CashA/C               (Cash)         Cr         1000

13850       01-LiabA/C                (Liability)      Dr         150
89275       01-CashA/C               (Cash)         Cr         150

Moves recoverable tax amount from Interim account to actual Tax Recoverable account.
12864       01-DeferredTaxA/C     (RTax)         Cr         60
13394       01-TaxRecoverA/C      (RTax)         Dr         60

You can summarize these journals/accounting entries.

Wednesday, January 20, 2010

How to Set R12 Supplier Page in Read Only Mode?

o Open System Administrator resp. Navigate to Security->Responsibility->Define 
o Query responsibility name(Ex: Payables, HG Operations) you want to use that will have the Supplier page as Read Only.
o Under Menu Exclusions select Type as 'Function' and Name as 'Supplier Full Access : Buyer View'
o Save changes.

Navigation Path: System Administrator->Security->Responsibility->Define


o Now open Suppliers page and check changes.

Navigation Path: Payables Resp(Payables, HG Operations)->Suppliers->Entry
Supplier page looks like this in read only mode

Wednesday, January 6, 2010

Explain Request Groups and Request Sets in Concurrent Programs?

Grouping concurrent programs and other requests together allows you to control access and streamline processing. In Oracle Applications, you group programs and requests into request groups and request sets.

Request Groups
A request group is a collection of reports and other concurrent programs. You use request groups to implement security at the responsibility level. Request groups are normally associated with a responsibility, in which case they are referred to as request security groups. Any user of a responsibility has access to the reports in that responsibility’s request security group. Additionally, you can define a request group to have an access code. You can then define the form so that it allows users to select only those reports or concurrent programs belonging to a request group with an assigned code.


Request Sets
A request set is a collection of concurrent programs set up to run in a specified sequence from a single transaction. Request sets can also have run and/or print options, which apply to everymember of the set. Programs in a request set can share parameters; therefore a parameter value needs to be entered only once for multiple programs. Any user can create a request set.

Tuesday, January 5, 2010

Create XML Publisher Report Using Oracle Reports( RDF )

Required Files:
Oracle Report: HGXPUBTEST.rdf
Template file: HGXPUBTEST.rtf

Output Files:
Output in PDF: HGXPUBTEST_OUTPUT.pdf

XML Publisher is a simple engine. It needs only 3 input values to generate report.
1.Data to display on report(in XML format)
2.Layout model/presentation(in XSL-FO format or RTF)
3.Final output type (PDF, Doc, HTML, etc)
Points to Note:
o XML publisher doesn't care about how you are generating xml data. Only it needs is, your actual data(text file, excel file, data in DB) must be converted in xml format(calling XML Data) as input to the engine. To get this, you can write your own xml data or use Oracle Reports to generate xml data or use any other third party tools to generate xml data from actual data.
o XSL-FO stands for Extensible Stylesheet Language Formatting Objects. Used to present XML Data in readable and  user friendly format. But normal user understands very little in this, so there is an alternative i.e. user friendly RTF. You do presentation work on RTF file and give this as input to the XML Publisher engine. XML Publisher converts RTF into XSL-FO.

What is new here?
We are using Oracle Reports(rdf file) to generate XML data.

Run CP
  |
   -----------Oracle Reports(RDF)----->Generates XML Data-->
  |                                                                                 |--->XML Pub Engine-->CP Output(in PDF or etc)
   --Finds template from XML Publihser Admin resp-->RTF file-->

Summary Steps:
1. Create Oracle Report(HGXPUBTEST.rdf)
2. Define/Register Concurrent Program(HGXPUBTEST)
3. Create Template Definition and Template(HGXPUBTEST.rtf)
4. Run CP and Show XML Publisher report in PDF format(HGXPUBTEST_OUTPUT.pdf)

Step 1: Create Oracle Report(HGXPUBTEST.rdf)
1. Open Report Builder
Follow below screen shots to complete Oracle Report creation.
2. Save file as HGXPUBTEST.rdf. Compile and check for errors. Close Report Builder.
3. Now move this file to $AP_TOP/reports/US
    Or
    Keep file in local directory and set file path in profile option 'FND: Override Directory' at user level.

Step 2: Define/Register Concurrent Program(HGXPUBTEST)
1.Register Executable
Navigate to System Administrator->Concurrent->Program->Executable
Provide following information as shown in the picture.
Executable: HGXPUBTEST
Short Name: HGXPUBTEST
Application: Payables
Execution Method: Oracle Reports
Execution File Name: HGXPUBTEST
2.Define CP
Navigate to System Administrator->Concurrent->Program->Define
Provide following information as shown in the picture.
Program: HG-XML Publisher Test Report
Short Name: HGXPUBTEST
Application: Payables
Executable Name: Oracle Reports
Format: XML

CP definition looks like this after creation.


Points To Note:
o Note down Executable name. We need to use this in XML Publisher definition to refer this CP.
o XML Publisher engine needs data input in XML format. So always select format as XML.( Final output will be PDF/RTF/HTML.. as selected by you in report submission.)
o Add new CP to the Request Group, then add Request Group to your Responsibilty.

Step 3: Create Template Definition and Template(HGXPUBTEST.rtf)
1.Create Template Definition
Navigate to XML Publisher Administrator->Data Definitions
Click Create Data Definition button.

Provide following information as shown in the picture.
Code: HGXPUBTEST
Name: HG-XML Publisher Test Report(your choice)
Application: Payables(your choice)
Click Apply.

Definition looks like this after creation.
Points To Note:
Value given in the Code field must be same as the Executable name of the CP 'HG-XML Publisher Test Report'.

2.Create Template
Navigate to XML Publisher Administrator->Templates
Click Create Template button.

Provide following information as shown in the picture.
Code: HGXPUBTEST(your choice)
Name: HG-XML Publisher Test Report(your choice)
Application: Payables(your choice)
Type: RTF
Data Definition: HG-XML Publisher Test Report
Upload template HGXPUBTEST.rtf.
Click Apply

Template looks like this after creation.

Step 4:  Run CP and Show XML Publisher report in PDF format(HGXPUBTEST_OUTPUT.pdf)
1. Submit Request
If you want final output in different format(RTF, HTML, etc), click Options button and change the Format type. Default is PDF.
2.CP Output(PDF) 
Related Posts Plugin for WordPress, Blogger...