Wednesday, July 8, 2015

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.





No comments:

Post a Comment