HI,
PAYABLES FAQ ---2
1. Q: How do I setup the supplier for electronic payment?
? goal: How to Setup a Supplier for Electronic Payment in Release 11i
? fact: Oracle Payables 11.5
? fact: APXVDMVD - Enter Vendor
fix:
In order to use Electronic Payment functionality in 11i, you will need to
perform the following steps:
1) Create your new supplier and supplier site.
You will need to leave the Payment Method under the Payment tab to something
other than ELECTRONIC. If you try to select ELECTRONIC, when saving, the
system will require you to enter the supplier bank account and at this point,
it would not have been created.
Navigation: Suppliers-Entry
2) Create your new bank account for this supplier/supplier site.
From the alternate region, select the Supplier Assignments tab and enter the
supplier and supplier site here.
Navigation: Setup-Payments-Banks
3) If you go back and re-query the supplier site, this bank account information
will appear in the Bank Accounts button, however, you will still need to change
the Payment Method under the Payments tab to ELECTRONIC.
Navigation: Suppliers-Entry
Your other option of creating and linking your bank account information is:
1) Create your new bank account for this supplier/supplier site.
Navigation: Setup-Payments-Banks
2) Create the supplier and supplier site and link this new bank account at the
supplier site level, under the Bank Account tab. You will also need to set the
Payment Method to ELECTRONIC under the Payments Tab.
Navigation: Suppliers-Entry
.
2. Q: How do I setup banks for suppliers?
A: Please review the following steps
1. In the Banks window query an existing Bank.
2. Choose the Bank Accounts button. Enter the Bank Account Name and Bank Account Number. Enter the EDI
ID number. Optionally enter an Account Type and Description. Optionally change the account currency, which
defaults from your functional currency. If you want to use Bank Account validation, enter Check Digits.
3. Select Supplier as the Account Use.
4. In the Supplier Assignments region list the supplier, and optionally list supplier sites, that use the account to
receive electronic payments.
5. Optionally enter account holder information in the Account Holder region. Optionally enter contact information
in the Account Contacts region.
6. Save your work.
7.all appropri In the Bank Accounts region of the Suppliers and Supplier Sites windows, verify for each supplier
and site thatall appropriate bank accounts are listed. For suppliers and supplier sites with multiple bank
accounts, designate as the primary bank account one bank account per period and per currency.
3. Q: How do I resolve the following error: AP_VEN_NUMERIC_NUM_REQ when creating a new supplier?
Problem Description
-------------------
In Oracle Payables, you try to create a new supplier. You navigate to
Suppliers -> Entry, create a new supplier, fill in the supplier name, supplier
number, and save it. You get the following message:
AP_VEN_NUMERIC_NUM_REQ
Solution Description
--------------------
This is a setup issue. You will get AP_VEN_NUMERIC_NUM_REQ, when you have set
Type = Numeric, but you have filled in some characters (rather than numbers) in
the Supplier Number field.
Navigate to Setup -> Options -> Financials, Supplier Entry region.
If Entry = Automatic, you can only set Type = Numeric, you do not
need to enter Supplier Number when you create a new supplier, when
you save the supplier, the system will automatically generate a
numeric number for you.
If Entry = Manual, you can set Type = Numeric or Alphanumeric.
If you set Type = Numeric, you should not fill in any character in
supplier number field, it should be a number.
Additional Search Words
-----------------------
APXVDMVD, SUPPLIER, VENDOR, AP_VEN_NUMERIC_NUM_REQ
4. Q: Why am I unable to view supplier bank information at the supplier site level?
In Oracle Accounts Payable, you attempt to view supplier bank information
at the supplier site level.
Navigation path is:
Suppliers -> Entry -> Alternate Region Site -> Alternate Region Bank Accounts
No bank information appears in this region even though a supplier bank has been
defined.
Navigation path is:
Setup -> Payment -> Banks -> Bank Accounts -> Alternate Region Supplier
Assignments
Solution Description
--------------------
When setting up the supplier bank you must populate the vendor site field in
order to see the supplier bank account information at the supplier site level.
5. Q: How Do I Identify Duplicate Suppliers?
Identifying Duplicate Suppliers
Although the system will not allow you to enter duplicate supplier names, you may
inadvertently define the same supplier using two different names. For example, you
might enter Oracle Corporation and Oracle Corp, or you might enter a contracter
under his name and his company name. You might also create duplicate suppliers if
you import suppliers from another accounts payable system.
If you want to know if a supplier exists, you can query the Supplier in the Suppliers
window or submit the Vendor Listing by Supplier Name. When you enter an invoice,
check the list of values for the Supplier field to see if your supplier exists
before you enter a new supplier.
Suggestion: To avoid entering duplicate suppliers in Payables, consider developing
and using standard naming conventions for suppliers, and restricting who can enter
new suppliers.
Submit the following reports periodically to review your suppliers and identify
duplicates:
Vendors Report. Lists detail supplier information. Report provides multiple selection
criteria and lists suppliers in alphabetical order.
Vendor Audit Report. Lists active suppliers whose names are the same up to a number
of characters which you specify, and ignores case, spaces, special characters,
etc. The report lists all sites of each possible duplicate supplier.
Then you can run the Supplier Merge Program and Merge the duplicates Suppliers.
6. Q: How do I merge Vendors/Suppliers?
Supplier Merge Program
Use Supplier Merge to combine two or more suppliers that you identify as duplicates.
You can update purchase orders and invoices for the old supplier to refer to the
new supplier. The Supplier Merge window also allows you to merge supplier sites
so that any sites assigned to an old supplier can be reassigned to the new supplier.
When you merge suppliers you transfer invoices, purchase orders, or both from
one supplier and site to another supplier and site. You can transfer to a new
supplier and site unpaid invoices only, or all invoices (including paid and partially
paid invoices). Payables will not transfer invoices if the merge would create a
duplicate invoice for a supplier.
For best auditing results, transfer both paid and unpaid invoices to a new supplier
and site so you can identify duplicate payments easily. Also, transfer both purchase
orders and invoices to a new supplier and site, so all invoice and purchase order
information refers to the same supplier.
After you have merged suppliers, Payables automatically prints the Purchase Order
Header Updates Report and the Vendor Merge Report as an audit trail of your supplier
merge activity. The Vendor Merge Report also lists duplicate invoices that it did
not merge, if you had any. You can then update the invoice number if the invoice
has not been paid or posted.
Prerequisites
Identify duplicate suppliers.
If you transfer invoices, the New Supplier Site must be a pay site.
If you transfer purchase orders, the New Supplier Site must be a purchasing site.
To merge suppliers using Supplier Merge:
1. In the Supplier Merge window, select which invoices to transfer from the Old
Supplier to the New Supplier: All, Unpaid, or None.
2. If you want to transfer all purchase orders from the Old Supplier to the New
Supplier, select PO.
3. Enter the Old Supplier Name and Site and the New Supplier Name. Payables will
transfer information from the Old Supplier to the New Supplier.
If you want to reassign the Old Supplier Site to the new Supplier, select Copy
Site and do not enter a New Supplier Site. During the Merge, Payables enters
the merge date as the inactive date for the Old Supplier Site and creates a new
site for the New Supplier with the information you selected to transfer.
If you want to merge the Old Supplier Site information with the New Supplier
Site information, do not select Copy Site, and enter one of the New Supplier's
existing sites in the Site field. During the merge, Payables enters the merge
date as the inactive date for the Old Supplier site and combines all of the
information you selected with the New Supplier Site information.
4. Choose Merge. Payables submits a concurrent request to run the Supplier Merge
Program, which transfers the information from the Old Supplier to the New
Supplier, and also runs the Purchase Order Header Updates Report and the
Vendor Merge Report.
5. Review the log file and reports after the request completes.
7. Q: How do I define Address Style default for Country or Territory?
? goal: Change Address Style used as default in Supplier Site Entry form
? fact: Oracle Payables
? fact: APXSUDCC - Maintain Countries and Territories
fix: To define Address Style default for Country or Territory: 1. Navigate to Payables->Setup->Countries 2. Query corresponding Country name. 3. Select desired Address Style. 4. Save changes. Important: Changing the Address Style may cause data loss if suppliers or other items dependent on this default have already been set up using the original value. If the original address style has data not referenced in the new style, this data will be lost.
1. Q: Why can#65533;t I enable the Multiple Currency Payment check box?
A: You have not enabled the "Use Multiple Currencies" Payables Option and/or your bank account currency is not in your functional currency.
[top]
2. Q: Why are the Receivable Options and More Receivables Options choices not available from the alternate region drop down box?
A: Oracle Receivables is not fully installed. You will not see these choices if Oracle Receivables is not installed or is a shared install.
[top]
3. Q: Why doesn#65533;t "Supplier" show up in the list of values for "Account Use" in the Bank Account Form?
A: You have not enabled the #65533;Use Multiple Supplier Banks#65533; Payables Option in the Payments alternate region.
[top]
4. Q: Why do I get a #65533;Choose Valid Combination#65533; message when I attempt to select an account, and why is the List of Values button disabled for the GL Account fields for my new organization?
A: You need to select a set of books. Make sure you select the correct set of books for the System Profile Options GL:Set of Books Name and GL:Set of Books ID. And select the correct set of books in the Payables in the Set of Books screen (Setup -> Set of Books -> Choose).
[top]
5. Q: When creating a payment document, do I need to specify a #65533;Last Available#65533; number?
A: If you intend to only have one payment document, there is no need to specify a #65533;Last Available#65533; number, so you will never reach a maximum. You should specify a "Last Available" number only if you want to create another payment document for that bank account.
[top]
6. Q: Do Bank Branch Numbers have to be unique?
A: Yes, to allow BACs and funds transfers.
[top]
7. Q: Do Bank Account Numbers need to be unique?
A: Within a Bank Branch, Bank Accounts must have a unique number for the same currency and account use. They must also have a unique name for the same currency and account use.
[top]
8. Q: Why can#65533;t I update the Last Available field for the payment document?
A: Most likely, the document is in use by a payment batch or Quickcheck. Cancel any batches that are not confirmed or already canceled or Quickchecks that are not formatted, which are using this payment document.
[top]
9. Q: What are the MetaLink keywords I should use when searching for Bank Setup on MetaLink?
A: APXSUMBA
10. Q: The questions listed in this guide do not address my question
A: If the FAQ list for Bank Setup does not answer your question, please click here to log an iTAR.
Use the Bank Setup Template.
-------------------------------------------------------------------------------------------------------------------------------------------
Q: Can you account for a payment without accounting for an invoice?
A: You must account for the invoice prior to accounting for the payment. If you try to account for the payment you will receive the following error in the log file: Cannot Account for GENERIC bank account#65533;s check number XXXXXX because the Invoice that it pays, is NOT accounted.
[top]
Q: What does the Unaccounted Transaction Sweep Report do?
A: The Unaccounted Transaction Sweep Report shows which transactions will be re-dated to the next open period if you run the Unaccounted Transaction Sweep program. Please see the What does the Unaccounted Transactions Sweep Report Do? for a more detailed explanation.
[top]
Q: Which Tables are Updated by the Payables Aco****ing Process (APACCENG)?
Note 161341.1
A: The Payables Accounting Process APACCENG writes to the following tables:
ap_accounting_events_all
ap_ae_headers_all
ap_ae_lines_all
For invoices it updates the accounting_event_id in ap_invoice_distiributions_all
For payments it updates the accounting_event_id in ap_invoice_payments_all
For clearing events it updates the accounting_event_id in ap_payment_histroy_all
[top]
Q: Are there accounting entries created for payments and payment cancellation when they have the same accounting date?
Note 168542.1
A: If the payments is voided before accounting for the payment the system will change the payment and payment cancellation to accounted YES, however, the accounting entries are not viewable. The Payables Create Accounting process does not create entries in ap_ae_lines_all for these transactions. To prevent this you must account for the payment prior to voiding the transaction.
[top]
Q: How to do you run APACCENG - Payables Accounting Proces with Debug Flag on?
A: Please reference Note 190146.1 which provides the steps to turn on the debug flag if that parameter is not visible from the concurrent manager.
[top]
Q: How do I open the next payables accounting period?
A: Please review Note 202779.1 to assist in the resolution of this issue.
[top]
Q: Why is there an invalid account and how do I fix it?
A: Please review Note 167748.1 which explains this issue.
[top]
Q: What reports should I run before closing the period?
A: Run the following reports:
? Invoice On Hold Report - review holds and release any accounting holds
? Unaccounted Transactions Report - review the transactions that need to be posted or swept to the next period before closing
[top]
Q: What are the keywords I should use when searching for Accounting 11i on MetaLink?
A: Use the short name for the process, APACCENG, along with any words specific to your accounting issue, e.g. prepayment, cancel, invoice, fatal error.
[top]
Q: What articles, white papers, or manuals should I read for more information on creating accounting in 11i?
A: Please see the Create Accounting 11i Setup and Usage Guide for a complete list of available documents.
1. Q: What the difference between EDI Payment Outbound (820) and EFT payment program?
A: Both EDI Payment Outbound and EFT Payment program are used to pay invoices with payment method of Electronic Payments.
EDI Payment Outbound is using ECEPYO.sql. You will need to install the EDI product to use this outbound program. It provides several payment methods, like ACH and BACS, and several payment formats, like CCD and CCP.
EFT Payment program is using APXPBFBC.rdf. The Oracle Payables Application includes this program. This program formats and creates a BACS output file that is fitted for 1/2 inch tape media.
[top]
2. Q: What is EDI Invoice Inbound 810?
A: EDI Invoice Inbound 810 loads invoices from a flat file into open interface tables ap_invoices_interface and ap_invoice_lines_interface. You then use Payables Open Interface Import to import the invoices.You need to install the EDI product to have this functionality.
[top]
3. Q: What is EDI Payment Outbound 820?
A: EDI Payment Outbound 820 is used to make electronic (EFT) payments, but provides several payment methods, like ACH and BACS, and several payment formats, like CCD and CCP.
[top]
4. Q: What EDI processes does Oracle Payables use?
A: Oracle Payables has two EDI processes:
EDI Invoice Inbound 810 - ECEINI.sql - to import Invoices
EDI Payment Outbound 820 - ECEPYO.sql - to create electronic payments
[top]
5. Q: What are the setup steps for EDI Invoice Inbound 810?
A: 1) Check setup in UNIX
===================
cd $ORACLE_HOME/dbs
grep -i utl_file_dir init.ora
For Example, you get:
utl_file_dir=/sqlcom/inbound,/sqlcom/outbound,/sqlcom/log,/sqlcom/out
2) Check Profile Options
=====================
Using the System Administrator Responsibility navigate to Profile -> System
Set the following:
Site = Yes,
Profile Option "ECE:Inbound directory" = /sqlcom/inbound
Save
Note: (1) and (2) have to be the same directory (/sqlcom/inbound in this example).
3) Copy the Flatfile to the directory defined
==================================
For Example: Flatfile Name = ECEINI.dat
Copy ECEINI.dat into the directory which Profile Option "ECE:Inbound directory" is defined.
cp ECEINI.dat /sqlcom/inbound
4) Verify Flatfile (part 1)
========================
For Example: Your Flatfile = ECEINI.dat
a. Delete the 810 records from your ECE_OUTPUT file-
In SQL*Plus as the apps user:
delete from ECE_OUTPUT
where run_id = 810;
commit;
b. exec ECE_UTILITIES.verify_flatfile(810,'INI','/sqlcom/inbound', 'ECEINI.dat');
The exec should return: PL/SQL procedure successfully completed.
c. select text from ECE_OUTPUT
where run_id = 810;
Make sure all the lines are left adjusted.
5) EDI and Supplier form Setups
============================
a. Using the EDI Gateway Responsibility navigate to Trading Partners
Set the following where Supplier = GE_Capital, for example:
Group = ECEINI GE_Capital
Partner = GE_Capital
Document = Invoice Inbound
Document Type = Standard Invoice
Translator Code = TR_CODE
Save
b. Using the AP Manager Responsibility navigate to Suppliers -> Entry
Query on Supplier = GE Capital, go to Site,
Go to Electronic Data Interchange region, Set:
EDI Location = LOC_CODE1
6) Verify Flatfile (Part II)
=========================
Select text from ECE_OUTPUT
where text like '%0010%'
order by text;
For Example:
Rec: 0010 Pos: 10 Width: 2 Col: COMMUNICATION_METHOD Val= ED
Rec: 0010 Pos: 20 Width: 1 Col: TP_TEST_FLAG Val= P
Rec: 0010 Pos: 30 Width: 6 Col: TP_DOCUMENT_ID Val= INI
Rec: 0010 Pos: 40 Width: 5 Col: DOCUMENT_TYPE Val= INVOI
Rec: 0010 Pos: 50 Width: 2 Col: TP_PURPOSE_CODE Val=
Rec: 0010 Pos: 60 Width: 35 Col: TP_DOCUMENT_CODE Val= EDI_INV01
Rec: 0010 Pos: 70 Width: 30 Col: TRANSLATOR_CODE Val= TR_CODE
Rec: 0010 Pos: 80 Width: 35 Col: TP_LOCATION_CODE_EXT Val= LOC_CODE1
Rec: 0010 Pos: 90 Width: 74 Col: TP_DESCRIPTION Val=
Rec: 0010 Pos: 100 Width: 80 Col: TP_REFERENCE_EXT1 Val=
Rec: 0010 Pos: 110 Width: 80 Col: TP_REFERENCE_EXT2 Val=
Rec: 0010 Pos: 120 Width: 15 Col: TRANSACTION_DATE Val=
Rec: 0010 Pos: 130 Width: 15 Col: RUN_ID Val=
Rec: 0010 Pos: 140 Width: 10 Col: TRANSACTION_CONTROL1 Val=
Rec: 0010 Pos: 150 Width: 10 Col: TRANSACTION_CONTROL2 Val=
Rec: 0010 Pos: 160 Width: 10 Col: TRANSACTION_CONTROL3 Val=
Please make sure:
TRANSLATOR_CODE = TR_CODE
TP_LOCATION_CODE_TEXT = LOC_CODE1
7) Verify Flatfile (part III)
=============================
a) Load the flatfile ECEINI.dat into WordPad or NotePad.
b) Using the EDI Gateway Responsibility, Navigate to Output Definition
Query on Transaction = INI, Level = Invoice Header or Invoice Line
c) From SQL*Plus, run:
select text
from ECE_OUTPUT
order by text;
You will get the following, for example:
Rec: 0010 Pos: 20 Width: 1 Col: TP_TEST_FLAG Val=P
Rec: 0010 Pos: 30 Width: 6 Col: TP_DOCUMENT_ID Val=INI
Rec: 0010 Pos: 40 Width: 5 Col: DOCUMENT_TYPE Val=INVOI
Rec: 0010 Pos: 50 Width: 2 Col: TP_PURPOSE_CODE Val=
Rec: 0010 Pos: 60 Width: 35 Col: TP_DOCUMENT_CODE Val= EDI_INV01
Rec: 0010 Pos: 70 Width: 30 Col: TRANSLATOR_CODE Val=TR_CODE
Rec: 0010 Pos: 80 Width: 35 Col: TP_LOCATION_CODE_EXT Val= LOC_CODE1
Rec: 0010 Pos: 90 Width: 74 Col: TP_DESCRIPTION Val=
Rec: 0010 Pos: 100 Width: 80 Col: TP_REFERENCE_EXT1 Val=
Rec: 0010 Pos: 110 Width: 80 Col: TP_REFERENCE_EXT2 Val=
Rec: 0010 Pos: 120 Width: 15 Col: TRANSACTION_DATE Val=
Rec: 0010 Pos: 130 Width: 15 Col: RUN_ID Val=
Rec: 0010 Pos: 140 Width: 10 Col: TRANSACTION_CONTROL1 Val=
Rec: 0010 Pos: 150 Width: 10 Col: TRANSACTION_CONTROL2 Val=
Rec: 0010 Pos: 160 Width: 10 Col: TRANSACTION_CONTROL3 Val=
Rec: 1000 Pos: 10 Width: 10 Col: INVOICE_NUM Val= qtest1
Rec: 1000 Pos: 20 Width: 20 Col: INVOICE_DATE Val= 19991110000000
Rec: 1000 Pos: 30 Width: 10 Col: INVOICE_AMOUNT Val= 100.00
Rec: 1000 Pos: 40 Width: 10 Col: INVOICE_TYPE_LOOKUP_CODE_INT Val= STANDARD
Rec: 1000 Pos: 50 Width: 10 Col: TERMS_NAME_INT Val= Net30
Rec: 1010 Pos: 10 Width: 10 Col: INVOICE_CURRENCY_CODE Val=USD
Rec: 1010 Pos: 20 Width: 10 Col: VENDOR_NUM Val= 1001
Rec: 1010 Pos: 30 Width: 10 Col: VENDOR_SITE_CODE Val=ORLANDO
Rec: 3000 Pos: 10 Width: 10 Col: ITEM_LINE_TYPE_CODE+L270 Val=ITEM
Rec: 3000 Pos: 20 Width: 10 Col: INVOICE_LINE_NUMBER_EXT Val=1
Rec: 3000 Pos: 30 Width: 10 Col: QUANTITY_INVOICED Val=100
Rec: 3000 Pos: 40 Width: 10 Col: UNIT_PRICE Val=1
Rec: 3000 Pos: 50 Width: 10 Col: AMOUNT Val=100.00
Rec: 3010 Pos: 10 Width: 10 Col: PO_NUMBER Val=6363
Rec: 3010 Pos: 20 Width: 10 Col: PO_LINE_NUMBER Val= 1
Rec: 3010 Pos: 30 Width: 10 Col: PO_SHIPMENT_NUM Val= 1
Rec: 0010 Pos: 10 Width: 2 Col: COMMUNICATION_METHOD Val=ED
*** Compare (a), (b), (c), you can modify the flatfile ECEINI.dat in WordPad if any position is wrong.
Run ECEINI EDI Invoice Inbound
=================================
a. Using the EDI Gateway Responsibility, navigate to Import Programs
b. Set Name = EDI Invoice Inbound.
c. Submit the request.
[top]
6. Q: What is the setup steps for EDI Gateway Payment Outbound 820?
A: 1) Profile Options Setup
==================
Using the SysAdmin responsibility, Navigate to Profile -> System
Find Profile = ECE: Output file path
Set the Site = <Path for output file directory>
Example: Site = /u13/appl/f1070161/edi
2) init.ora setup
==============
Add an environment variable "utl_file_dir" in $ORACLE_HOME/dbs/init.ora
Example: utl_file_dir = /u13/appl/f1070161/edi
This path needs to be exactly same as the path you have defined in Profile Options.
3) Format Program Setup
====================
Using the Payables responsibility, navigate to Setup -> Payment -> Format
Payment Format = EDI Outbound Program
Payment Method = Electronic Payments
Currency = USD
Build Payments = Build Payments Program
Format Payments = EDI Outbound Program
4) Internal Bank Account Setup
===========================
Using the Payables responsibility, navigate to Setup -> Payment -> Banks
Set up a Bank Account as follows:
Bank Branch Type = (Select from LOV)
Account Use = Internal
Account Type = EDI
Create a new Payment Document to use where Payment Format = EDI Outbound Program
5) Supplier Bank Account Setup
===========================
Using the Payables responsibility, navigate to Setup -> Payment -> Banks
Create a new Bank Account, set:
Bank Branch Type = (Select from LOV)
Account Use = Supplier
Account Type = EDI
Go to Supplier Assignments region,
Fill in Supplier Name, Site, Effective Dates From, set Primary = Yes
Save it.
6) Supplier Site Setup
===================
Using the Payables responsibility, navigate to Supplier -> Entry
Query the supplier, go to Site.
a) Go to the Bank Account Region. Make sure that the Supplier Bank has been filled in here. Make sure that Primary is set to 'Yes'.
b) Go to Electronic Payment Region, set:
Payment Method
Payment Format
Remittance Method
Remittance Instruction
Transaction Handling
7) Trading Partner Setup
=====================
Using the EDI Gateway responsibility, Navigate to Trading Partners
Define a trading partner as follows:
Assignment Region: fill in Supplier, Site, EDI Location, Bank Branch, EDI Location.
Contact Region: fill in contact information.
Detail Region: set Document = Payment/Remittance Outbound, EDI = Yes.
Invoice for EDI 820
===================
For a test, create a payment batch that will pick up all invoices where Payment Method = Electronic Payments.
Set Payment Method to Electronic for all of the invoices you would like AutoSelect to select.
1. Q: How do I generate Draft Accounting in Global Accounting Engine (AX) Release 11i?
A: To generate accounting entries in Draft Mode in the Submit Posting Manager window :
1. Choose AX Payables Responsibility
2. (N) Accounting > Post Transactions
3. Translate events and transfer to GL should be checked
4. Check the Draft Mode check box
5. Press the Submit button to start the processing
Please note the following:
1.Before you can create draft accounting entries, you must define the AX Draft Accounting category and draft
accounting sequence for draft accounting entries.
2.You cannot transfer draft accounting entries to General Ledger.
For further info please reference the Global Accounting Engine User's Guide Release 11i page 3-2.
[top]
2. Q: How do I create Entries and Adjustments in Global Accounting Engine (AX) Release 11i?
A: Navigation :
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments
[top]
3. Q: How do I review Draft Accounting Entries in Global Accounting Engine (AX) Release 11i?
A: You can review and modify as many times as desired Draft Accounting Entries until you are ready to finalize the accounting.
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments
Refer to Global Accounting Engine User's Guide Release 11i page 3-3.
[top]
4. Q: How do I change AX Accounting entries from draft to permanent in Global Accounting Engine (AX) Release 11i?
A: Once you change the status of an accounting entry to permanent, you cannot change the accounting entry's status back to
draft.
1. For accounting entries created through the AX Posting Manager, run the Posting Manager in Permanent Mode
2. For manually-entered adjustments in the Journal Entries window while the Journal entry check box was unchecked, check the
Journal entry check box
Refer to Global Accounting User's Guide Release 11i pages 3-4 and 3-12.
[top]
5. Q: How do I generate Permanent Accounting in Global Accounting Engine (AX) Release 11i?
A: For accounting entries created through the AX Posting Manager :
1. Choose AX Payables Responsibility
2. (N) Accounting > Post Transactions
3. Translate events and transfer to GL should be checked
3. Do not check the Draft Mode check box
4. Hit the Submit button to run the Posting Manager
For manually-entered adjustments in the Journal Entries window :
1. Choose AX Payables Responsibility
2. (N) Accounting > Enter Adjustments by checking the Journal Entry Complete check box
Refer to Global Accounting User's Guide Release 11i pages 3-4 and 3-8.
[top]
6. Q: Is there a diagnostic script available to track an AP invoice through AX to GL for Release 11i?
A: Please reference note 198354.1 to assist in the resolution of this issue.
[top]
7. Q: Is there a diagnostic script available to track an AP payment through AX to GL for Release 11i?
A: Please reference note 198413.1 to assist in the resolution of this issue.
[top]
8. Q: Is there a script that will collect data in AX and GL for a given event?
A: Please reference the Oracle Support Services Diagnostics Tests- Main Catalog and select Release 11i, Global Accounting Engine to locate the Event Data Collection script. Whenever there is an issue with an event in AX that doesn't get translated or posted this test can be used to collect the relevant data for that particular event in AX and GL. The outcome of the test can help support and /or development to diagnose the cause and provide a solution. The test focuses on AX events originating from Accounts Receivables ( such as transactions, receipts, adjustments, customer merge ) and Accounts Payables ( such as invoices, checks and supplier merge ).
Data is collected from following tables :
AX_SETUP_GLOBAL
AX_SETUP_POSTING_BOOKS
AX_TRANS_PROGRAMS
AX_EVENTS
AX_DOCUMENT_STATUSES
AX_SLE_HEADERS
AX_SLE_LINES
AX_BALANCES
GL_INTERFACE
GL_JE_LINES
This test only gathers info from AX and GL. It does not show data from AP, AR. To be complete an additional data collection test should be run to collect data from AP or AR depending on the nature of the event. Your support representative will ask for that if needed.
[top]