Unable to get The Matching Criteria In Reconciliation Open Interface For R12

Issue:

Unable to see the Open Interface tab in the Cash Management in available Form to match the Open interface transactions for reconciliation.




Fix:

Enable the "Use Reconciliation Open Interfaces" check box under "Open Interface Controls" in Bank Account Control screen.


1. Navigate to Bank account Enquiry screen : Setup -> Bank -> Bank Account

2. Find your bank and select for Update option.

3. Click on "Account Control"

4. Enable the "Use Reconciliation Open Interfaces" check box

5. Click on Finish Button

Now we can able to get the Open Interface Option enabled in available window.

Not Able To Select Settlement Script At CE Bank Accounts Access Options/treasury settlement generate screen, NO list of values

Issue:

Not Able To Select Settlement Script At CE Bank Accounts Access Options, NO list of values




Fix:
1. Before you can select settlement script in the CE Bank Accounts: Bank Account: Account Access Options page from the "Procedure Name" LOV, you need to define it as a Lookup code:
Navigation path:
Treasury ->Setup->Miscellaneous->Lookups, Lookup Type is "XTR_SCRIPT" and insure that you enable all the scripts:
BNZ_EFT Settlement Script - Bank of New Zealand EFT
SWT_EFT Settlement Script - SWIFT 100
X12_EFT Settlement Script - X12 820

2. Insure that: Bank Account access is setup for Treasury for the Legal Entity (LE) and not for Operating Unit (OU) as is being done for Payables and Receivables.

If Treasury is enabled for OU then you will have to uncheck Treasury from the operating unit and
added access to LE for Treasury.

3. Insure that, it has selected in your in the company profile under Settlement script

Treasury -> Setup -> company profile -> Settlement Scripts

4. Once above is done you should be in a position to select these at:
Bank Account >>Update Bank Account: Account Access Options

APP-OFA-47333: You Cannot Perform this transaction because the asset is fully retired. Choose a book in which you have not yet retired the asset, or reinstate the asset

Issue:

APP-OFA-47333: You Cannot Perform this transaction because the asset is fully retired. Choose a book in which you have not yet retired the asset, or reinstate the asset, and then perform the transaction. If you wish to cancel or undo the retirement, Please query it first.

Solution:-

Reinstate the retired asset.

1. Navigate to Inquiry > Transaction History.

2. Enter the Book & Asset Number of the asset.

3. Press the Find button.

4. Mouseclick the Transaction type field for the retired asset. (It is important to be in the correct field or the Reference Number retreived will not be correct).

5. Make a note of the Reference Number.

6. Go to the Asset Workbench and query the asset.

7. Click the Retirements button.

8. Once the Retirements screen is displayed:

a. Press F11 to query or select Query>Enter on the menu bar.

b. Enter the Reference Number noted above.

c. Press CTRL F11 to perform the query or select Query>Run from the menu bar.

9. Once the information appears on the screen, verify that the information is correct and press the Reinstate button.

10. Run the Calculate Gains and Losses program.

This general ledger account is not authorized for use in Treasury. Please authorize this general ledger account for use in Treasury by company: &COMPANY_NAME

Issue:

This general ledger account is not authorized for use in Treasury. Please authorize this general ledger account for use in Treasury by company: &COMPANY_NAME

Solution:

The following setup of the GL account needs to be done in Treasury:

In Treasury>SETUP>Journal Entry actions>Select company and define: Cash account. Save.

You must first define the dealer information for the sing-on user before you can access any treasury functions

Issue:

You must first define the dealer information for the sing-on user before you can access any treasury functions



Fix:

Please create the Treasury user attached with FND user by navigating

Treasury -> Setup -> System -> User access Level

Latter you can add the company access and deal access details

Auto Invoice Errors: Invalid salesrep number (SALESREP_NUMBER) ((Null)) ,Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Error:

Errors: 1)Invalid salesrep number (SALESREP_NUMBER) ((Null))
           2)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Fix:


To correct data in the AutoInvoice Interface Table using the Interface Lines form:

a. Under AR Receivables responsibility, navigate to Control, Autoinvoice, Interface Lines Query
all lines in the interface tables getting reported validation error.

b. Press the Sales Credits button and verify the values for the
Salesrep Number and/or Sales Credit Type Name fields. Correct values for all rows.

Issue occurred while AGIS Intercompany Invoices, Follow the below process to correct those issues..

Issues description (Autoinvoice Import Program log output):

Errors:   1)Invalid salesrep number (SALESREP_NUMBER) ((Null))
          2)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Solution:

1. Make sure that the allow sales credit check box is not checked:
1.1. Navigate to Receivables manager --> Setup --> Transactions-->Sources form.
1.2. Query source 'Global Intercompany'.
1.3. Uncheck allow sales credit check box.
1.4. Save.
1.5. Re-run autoinvoice.


2. If it continues to fail with this message please check if Require Salesperson is checked at
setup -> system -> system Options -> Miscellaneous Tab


3. The following errors can also occur if the autoinvoice batch source is setup incorrectly.
Errors:
A)Invalid salesrep id (SALESREP_ID) ((Null))
B) Invalid sales credit type id (SALES_CREDIT_TYPE_ID) ((Null))

3.1. If after applying Patch 7007819 these errors occur, then do the following :-
3.2. Log on as receivables
3.3 Navigate setup, transactions sources
3.4 For the operating unit you are using, query back the name Intercompany
3.5 Use the > arrow to access the Sales Credit Validation tab.
Under this tab, the Salesperson must be set to ID and the Sales Credit Type must be set to ID.
If value is checked then you must check ID.
3.6. Once ID is checked, then re-run autoinvoice for this batch and see if it is imported successfully.

Error Auto Invoice: arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

Error:
Error while running AR auto Invoice import program

arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

Fix:
Please setup the Auto Accounting for all the Accounting Types.

N: Receivables -> Setup -> Transactions -> AutoAccounting

The minimum mandatory types are below:

1.FREIGHT
2.REC
3.REV
4.SUSPENSE (AutoInvoice Clearing)
5.TAX
6.UNBILL (Unbilled Receivable)
7.UNEARN (Unearned Revenue)


Use below script to identify the missing auto accounting types;

SELECT GL_DEFAULT_ID,

TYPE FROM RA_ACCOUNT_DEFAULTS_ALL

WHERE ORG_ID = &orgid 

AND TYPE IN 

('FREIGHT', 'REC', 'REV', 'SUSPENSE', 'TAX', 'UNBILL', 'UNEARN');