Following are the Validation 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.
Regards
Ashish Vishwakarma
