aniyanremo

 Profile Answers by aniyanremo 

• Mar 7th, 2006

 

Hi Following are the Required Validations for Autoinvoice :

 

?          AR Transaction Type Validation : Check if the Transaction type provided in data file is defined in AR transaction types(RA_CUST_TRX_TYPES_ALL)

?         Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL).

?         Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES).

?         Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to Customer Location provided in the data file is defined in AR Customer(ra_customers).

?         Primary Sales Representative Validation: Sales representative number to be hardcode to ?-3? for ?No Sales Credit.?

?         Term Name : Check if the Term name provided in the data file is defined in Payment terms (RA_TERMS)

?         Validate Sales Credit Type : Sales Credit to hardcode to ?Quota Sales Credit?

?         Inventory Item Validation:  Check if the Item provided in data file is defined in Inventory Items (MTL_SYSTEM_ITEMS).

?         Unit of  Measurement validation: Check if the UOM provided is defined in MTL_UNITS_OF_MEASURE Table

?         Invoice Tax Code Validation : Check if the Tax Code provided in data file is defined in AR_VAT_TAX_ALL_B Table.

?         Invoice GL Date Validation : Check if the GL Data of provided invoices is in open period.Used ARP_UTIL.IS_GL_DATE_VALID API to validate.

 

Tanks & Regards

a.vishwakarma2@zensar.com

geethika

• Oct 12th, 2007

 

for GL Validations

Gl_code_combination_id
SOB ID
Journal Source
Journal Catagorey
Currency Code
Period Name
Currency Conversion Type