Auto Invoice interface
This interface is used to import Customer invoices, Credit memos, Debit memos and On Account credits.
Pre-requisites:
- Set of Books
- Code combinations
- Items
- Sales representatives
- Customers
- Sales Tax rate
- Payment Terms
- Transaction Types
- Freight Carriers
- FOB
- Batch Sources
- Accounting Rules
- RA_INTERFACE_LINES_ALL
- RA_INTERFACE_SALESCREDITS
- RA_INTERFACE_DISTRIBUTIONS
- RA_INTERFACE_ERRORS (details about the failed records)
- RA_BATCHES
- RA_CUSTOMER_TRX_ALL
- RA_CUSTOMER_TRX_LINES_ALL
- AR_PAYMENT_SCHEDULES_ALL
- RA_CUSTOMER_TRX_LINE_SALESREPS
- RA_CUST_TRX_GL_DIST_ALL
- RA_CUSTOMER_TRX_TYPES_ALL
- Auto invoice master program
- Check for amount, batch source name, conversion rate, conversion type.
- Validate orig_system_bill_customer_id, orig_system_bill_address_id,
- Validate if the amount includes tax flag.
Some important columns that need to be populated in the interface tables:
RA_INTERFACE_LINES_ALL:
- AGREEMENT_ID
- COMMENTS
- CONVERSION_DATE
- CONVERSION_RATE
- CONVERSION_TYPE
- CREDIT_METHOD_FOR_ACCT_RULE
- CREDIT_METHOD_FOR_INSTALLMENTS
- CURRENCY_CODE
- CUSTOMER_BANK_ACCOUNT_ID
- CUST_TRX_TYPE_ID
- DOCUMENT_NUMBER
- DOCUMENT_NUMBER_SEQUENCE_ID
- GL_DATE
- HEADER_ATTRIBUTE1–15
- HEADER_ATTRIBUTE_CATEGORY
- INITIAL_CUSTOMER_TRX_ID
- INTERNAL_NOTES
- INVOICING_RULE_ID
- ORIG_SYSTEM_BILL_ADDRESS_ID
- ORIG_SYSTEM_BILL_CONTACT_ID
- ORIG_SYSTEM_BILL_CUSTOMER_ID
- ORIG_SYSTEM_SHIP_ADDRESS_ID
- ORIG_SYSTEM_SHIP_CONTACT_ID
- ORIG_SYSTEM_SHIP_CUSTOMER_ID
- ORIG_SYSTEM_SOLD_CUSTOMER_ID
- ORIG_SYSTEM_BATCH_NAME
- PAYMENT_SERVER_ORDER_ID
- PREVIOUS_CUSTOMER_TRX_ID
- PRIMARY_SALESREP_ID
- PRINTING_OPTION
- PURCHASE_ORDER
- PURCHASE_ORDER_DATE
- PURCHASE_ORDER_REVISION
- REASON_CODE
- RECEIPT_METHOD_ID
- RELATED_CUSTOMER_TRX_ID
- SET_OF_BOOKS_ID
- TERM_ID
- TERRITORY_ID
- TRX_DATE
- TRX_NUMBER
No comments:
Post a Comment