VKOA Account determination

[Former Member]

Hi,

In VKOA I see different tables and I am not understanding how the system will pick exact table for determiniting the account.

Example:

In VKOA I have as follows

001 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Acc Key (say ERL)

002 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Item category (XXX1) / Acc Key (say ERL)

003 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Item category (XXX1) / Order reason (001) Acc Key (say ERL)

Question

In this case if I post how will the system search for account determintaion if I post invoice which has

1) Cust Acc Assign (A1) / Mat Acc Assign (M1) / Item category (XXX1) / Order reason (001) Acc Key (say ERL) ?

2) Cust Acc Assign (A1) / Mat Acc Assign (M1) / Acc Key (say ERL) ?

I would like to know the order in which system will look........is it like first it checks 001 if not found then for 002 and if still not found in 003?...Am I right?

In my question 1, system finds both Cust Acc Assign (A1) / Mat Acc Assign (M1) in invoice and system may fetch account from ERL assigned in 001 - but I want system to take 003.

Regards,

Rao

[Former Member · Accepted solution]

The system always checks the tables in the sequence in which you specify them. Logically speaking, however, the system should always be configured such conditions tables with maximum fields (most specific conditions) are looked at first, and then go from most specific to most generic.

In your system right now, account determination will almost never reach table 003, since table 001, which is the most generic will match most of the scenarios.

I'd recommend reversing the sequence of the tables in your system, so that the most specific tables are checked first, and then come the less specific and last come the most generic table.

Rgds

Gulshan

[Former Member]

Your understanding of system behaviour abt account determination is corret. To resolve your problem you need to change sequences from most specifice to the most general.

In your case it should be like

003 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Item category (XXX1) / Order reason (001) Acc Key (say ERL)

002 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Item category (XXX1) / Acc Key (say ERL)

001 - Cust Acc Assign (A1) / Mat Acc Assign (M1) / Acc Key (say ERL)

Hope this will resolve your problem

Rgds

Dhiraj Bhaskar

[Former Member]

Hi,

Your understanding is right. System will first check 001. If no entry is found it will read 002 and so on.

If you want system to first read 003 and then 002 and then 001, you need to change the order of these tables in SPRO->SD->BF->Account Assignent/costing->Revenue Account Determination->Define Access Sequence and account determination types->Maintain Access sequence for Account determination.

Here you need to make 003 as 1st step if you want system to read 003 first.

Let me know if you still face problems with this.

Regards,

Rohan.