Skip to Content
avatar image
Former Member

VKOA Account determination

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 21, 2011 at 06:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 21, 2011 at 09:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 22, 2011 at 04:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded