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

for GL Validations

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