AutoInvoice Date Derivation: GL Date, Invoice Date, Due Date, Ship Date, Billing Date, Rule Date

During the process of AutoInvoice you can enter the General Ledger (GL) date and the Transaction date for a particular transaction explicitly in the relevant columns of the RA_INTERFACE_LINES_ALL table or you can allow the AutoInvoice process to derive the dates.

If the dates are provided, AutoInvoice will typically use them. There are a few scenarios where dates cannot be provided as input parameters; these scenarios are discussed in section 2.e titled GL Date Validation.

If the dates are not provided, they will be derived. Date Derivation of the General Ledger date and Transaction date during the process of AutoInvoice depends on the following:


1. The columns that are populated in the RA_INTERFACE_LINES_ALL table, namely:


GL_DATE
TRX_DATE
SHIP_DATE_ACTUAL
SALES_ORDER_DATE
RULE_START_DATE

2. Selection of the Derive Date Option in the Accounting Information Tab of the Transaction Sources window.

3. Whether or not Invoicing Rules and Accounting Rules are used.

4. Setting of the GL Date in a Closed Period option in the AutoInvoice Options tab of the particular Transaction Batch Source.

5. Default Date entered while submitting the AutoInvoice Program.

Once imported as a transaction in receivables, the GL date used by AutoInvoice is stored in the table.column: RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE.



Note: The GL date discussed in this note is for the initial accounting entry booked to record the creation of the invoice. For invoices with rules, Revenue Recognition will generate additional accounting entries and may impact the dates seen by users when reviewing transactions in Receivables.

Auto Invoice Errors: Invalid salesrep number (SALESREP_NUMBER) ((Null)) ,Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Error:

Errors: 1)Invalid salesrep number (SALESREP_NUMBER) ((Null))
           2)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Fix:


To correct data in the AutoInvoice Interface Table using the Interface Lines form:

a. Under AR Receivables responsibility, navigate to Control, Autoinvoice, Interface Lines Query
all lines in the interface tables getting reported validation error.

b. Press the Sales Credits button and verify the values for the
Salesrep Number and/or Sales Credit Type Name fields. Correct values for all rows.

Issue occurred while AGIS Intercompany Invoices, Follow the below process to correct those issues..

Issues description (Autoinvoice Import Program log output):

Errors:   1)Invalid salesrep number (SALESREP_NUMBER) ((Null))
          2)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))

Solution:

1. Make sure that the allow sales credit check box is not checked:
1.1. Navigate to Receivables manager --> Setup --> Transactions-->Sources form.
1.2. Query source 'Global Intercompany'.
1.3. Uncheck allow sales credit check box.
1.4. Save.
1.5. Re-run autoinvoice.


2. If it continues to fail with this message please check if Require Salesperson is checked at
setup -> system -> system Options -> Miscellaneous Tab


3. The following errors can also occur if the autoinvoice batch source is setup incorrectly.
Errors:
A)Invalid salesrep id (SALESREP_ID) ((Null))
B) Invalid sales credit type id (SALES_CREDIT_TYPE_ID) ((Null))

3.1. If after applying Patch 7007819 these errors occur, then do the following :-
3.2. Log on as receivables
3.3 Navigate setup, transactions sources
3.4 For the operating unit you are using, query back the name Intercompany
3.5 Use the > arrow to access the Sales Credit Validation tab.
Under this tab, the Salesperson must be set to ID and the Sales Credit Type must be set to ID.
If value is checked then you must check ID.
3.6. Once ID is checked, then re-run autoinvoice for this batch and see if it is imported successfully.

Error Auto Invoice: arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

Error:
Error while running AR auto Invoice import program

arcsai() Not all AutoAccounting types are defined Error calling arcdsu_do_setup() Error calling raaini()

Fix:
Please setup the Auto Accounting for all the Accounting Types.

N: Receivables -> Setup -> Transactions -> AutoAccounting

The minimum mandatory types are below:

1.FREIGHT
2.REC
3.REV
4.SUSPENSE (AutoInvoice Clearing)
5.TAX
6.UNBILL (Unbilled Receivable)
7.UNEARN (Unearned Revenue)


Use below script to identify the missing auto accounting types;

SELECT GL_DEFAULT_ID,

TYPE FROM RA_ACCOUNT_DEFAULTS_ALL

WHERE ORG_ID = &orgid 

AND TYPE IN 

('FREIGHT', 'REC', 'REV', 'SUSPENSE', 'TAX', 'UNBILL', 'UNEARN');