Showing posts with label AGIS. Show all posts
Showing posts with label AGIS. Show all posts

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.





Tuesday, June 30, 2015

Unable to get Intercompany transaction notification from Recipient user for inbound transaction


Please check your workflow background engine and agent listener are working fine,

Follow the below process step to ensure workflow services up and running,,,

1) Start the Workflow Agent listener Service:

a. Workflow administrator Web Applications Responsibility.
b. Workflow Manager.
c. Click on Service Components icon.
d. Click on the Workflow Agent listener Service link (Container column).
e. Select Workflow Agent listener Service.
f. Select Start from the list of values (top).
g. Click on go.
h. Wait until the Workflow Agent listener service is "Activated".

2) Retest the issue

Friday, January 23, 2015

Definitions Used in Intercompany Accounting

 
Intercompany Accounting Basics:
Intercompany Journal
This is a journal entry which has transactions for at least 
two different companies (or balancing segment values).

Intercompany Journal Out of Balance
An out of balance intercompany journal is one which does not have equal
credit and debit totals for each group of lines by company.

Balancing Segment
This is the accounting flexfield segment that has the balancing segment 
qualifier assigned to it. Typically the balancing segment stores the company 
values. However, it could represent the cost center, the department or some
other values.
The terms balancing segment and company segment are usually interchangeable. 
It is mandatory that one segment of your accounting flexfield be designated
as the balancing segment.

Intercompany Segment
The intercompany segment is the accounting flexfield segment that has 
the intercompany segment qualifier assigned to it. This qualifier is only 
available in release 11i and is optional.  This segment shares the same
value set as the balancing segment.

Clearing Account
A clearing account is a temporary account that holds amounts to be 
transferred to another account. 

Clearing Company 
This is the company value used to clear payables or receivables transactions. 
General Ledger uses this company to balance intercompany transactions.

Trading Partner
Trading partner is the company against which the line transaction is made.

Transaction Types
Transactions types are the classifications for journal entries based on
the number of companies involved in the credit and debit side
of the transaction.

The different transaction types are:

One to One: Two different companies in the journal. One company 
has the net debit balance and the other has a net credit balance.

Many to One: Different companies have net debit balance and one 
company has net credit balance.

One to Many: One Company has net debit balance and more than one 
companies have net credit balance.

Many to Many: Two or more companies have net debit balance and 
two or more companies have net credit balance.