A/C document

[Former Member]

Hi all,

when iam trying to create an invoice document and when iam clicking the accounting button the error is dispalyed as a/c doc not yet been created

pls help me what to do.

[Former Member]

Hi Narsimha,

Read through the following:

account determination is an important integration between SD & FICO modules. whenever a sale takes place, the system automatically posts the various prices and discounts and freights to the respective GL accounts through the account keys.

The account key is assigned to the respective GL account. Also in the pricing procedure we have a column called as account key(second last column). There we assign the account key. For eg., in Std SAP for basic price we have acct key ERL, for discounts ERS, for Output tax MWS, for freight ERF, etc. These account keys are basically defined by the FICO consultant and then the SD consultant assigns the respective account keys against the respective condition type in the pricing procedure.

The customer group is nothing but the grouping of various customers like wholesaler, retailer, etc. This is basically useful while maintaining pricing like for X group basic price is 10Rs, for Y group it is 15Rs. like that. Similarly material group is a grouping of materials like Ball pens, ink pens, gell pens, etc.

When you create the condition table and select these fields and save it and when you assign this table to your access sequence, the system searches for the condition record according to this key combination. For that you have to maintain the condition record in VK11.

now you are done with pricing. you create the sales order. delivery and invoice. Now for the system to generate an accounting document when you save the invoice in VF01 you have to maintain the account determination correctly otherwise the system will give an error - "error in account determination."

For doing account determination you have to go to :

IMG-sales & distribution-basic functions-account assignmentcosting-revenue account determination.

In this you first have to maintain the customer account assignment group and material account assignment group. This group for the customer means for which customer whether domestic or foreign etc. For material whether finished, semi finished, raw material, etc. You can also maintain as per name of the division.

This account assignment group you have to assign in customer as well as material master. In customer master (XD01) -sales area data- billing you have customer acct asst group, make an entry here. In material master (MM01)-sales:sales org.2 you have account asst group, make a proper entry here also.

Now in the above IMG path only you have access sequence, condition type, procedure. maintain everything and assign properly the procedure to the billing document type.

Now go to transaction code VKOA. You will see 5 tables. first is customer group/material group/acct key. When you double click on this it will show as following:

Application, condition type, chart of accounts, sales org., customer acct asst group, material acct asst group, acct key, G/L acct, provision acct. depending upon your customer type and material type you have to maintain all the columns and the respective G/L accounts. Like this do it for the remaining 4 tables.

Now whenever you make a sales order, delivery and invoice and when you save the incoice the system will automatically post the price, discount, tax, freight to the respective G/L accounts. This will make an accounting document which will show the exact value of price, discount, tax, freight for that particular transaction.

Follow the procedure that i mentioned.

I hope I have answered your Query. Please reward valuable points if solution found useful.

Regards,

Allabaqsh G. Patil

[Former Member]

hi,

kindly see whether ur Revenue account determination has done properly.

if not use this path.

IMG- SD- BASIC FUNCTIONS - ACCOUNT ASSIGNMENT & COSTING - SELECT REVENUE ACCOUNT DETERMINATION.

SELECT CHECK MASTER DATA RELEVANT FOR ACCOUNT ASSIGNMENT.

THEN SELECT MATERIAL ACCOUNT ASSIGNMENT GROUP.

SELECT NEW ENTRIES.

MAINTAIN Z1 - TRADING GOODS

Z2 - FINISHED GOODS

Z3 - SERVICES.

THEN SELECT CUSTOMER ACCOUNT ASSIGNMENT GROUP.

SELECT NEW ENTRIES.

MAINTAIN Z1 - DOMESTIC REVENUES

Z2 - FOREIGN REVENUES.

THEN APPLY THE CONDITION TECHNIQUE.

1. STEP. SELECT ACC. SEQUENCE FOR ACCOUNT DETERMINATION.

2. STEP: SELECT NEW ENTRIES. AND MAINTAIN

Z000 - ACC SEQ. FOR A/C. DETERMINATION. CONTINUE & ENTER AND

3. STEP: SELECT THE Z000 AND THEN SELECT ACCESSES FORM THE MENU. AND AGAIN SELECT NEW ENTRIES. THEN MAINTAIN

ACCESS NO AS 10 AND THE TABLE AS 1

ACCESS NO AS 2O AND THE TABLE AS 5. ENTER. AND SELECT THE

ACCESSES AND SELECT FIELDS. AND AGAIN RE- ENTER.

4. STEP : SAVE THE ACCESS SEQUENCE.

5. STEP: SELECT CONDITION TYPE FROM THE SAME MENU PATH.

6. STEP: SELECT NEW ENTRIES. AND MAINTAIN

CONDITION TYPE AS Z000 - DESCRIPTION AS ACC. DET. TYPE AND ACC.SEQ. AS Z000. AND SAVE.

7. STEP: SELECT ACC. DET. PROCEDURE FROM THE SAME MENU., SELECT DEFINE ACCOUNT DET. PROCEDURRE.

8. STEP: SELECT NEW ENTRIES. AND MAINTAIN

PROCEDURE AS Z00000 AND DESCRIPTION AS ACC. DET. PROCEDURE.

9. STEP. SELECT Z00000 and then select control data and again select NEW ENTRIES. AND MAINTAIN AS

STEP AS 10 ,

CNTR AS 0

C.TYPE Z000 AND SAVE.

10. ASSIGN THIS PROCEDURE TO UR BILLING DOCUMENT AND SAVE.

11. FINAL STEP: SELECT DEFINE AND ASSIGN ACCOUNT KEYS.

STANDARD ACCOUNT KEYS ARE.

A. ERL. - SALES REVENUE - 800000

B. ERS - SALES DEDUCTIONS - 888000

C. ERF - FREIGHT REVENUES - 809000

D. MWS - OUTPUT TAX - 175000

E. ERB - REBATE SALES DEDUCTIONS - 884000

F. ERU - REBATE ACCRUALS. - 884010 89000

G. EVV - CASH CLEARING. - 100000.

12. STEP: ASSIGN THIS ACCOUNT KEYS FOR THE FOLLOWING COMBINATIONS.

SELECT NEW ENTRIES. AND MAINTAIN

V + Z000 + INT + S.ORG + Z1 +Z2 = 800000. LIKE THAT U MAINTAIN FOR ALL YOUR ACCOUNT KEYS.

13. STEP: AFTER ALL YOU HAVE MAINTAIN THE ACCOUNT ASSIGNMENT GROUPS IN THE CUSTOMER MASTER UNDER SOLD TO PARTY / PAYER IN THE BILLING TAB AND IN MATERIAL MASTER UNDER SALES ORGANISATION 2.

PL. REWARD POINTS IF IT IS SOLVED.

REGARDS

KR

[Former Member]

Hi

Plz. go through ur sales order change mode click double on item, and select every condition one by one with analysis tab which is at bottam side.

[jiteshmehta]

in vf02 enter your invoice nr and click on green flag, check if it gives any error

or else A/cing doc will be created

Regards

Jitesh

[Former Member]

check if revenue account determination has been done properly.

Account keys have been assigned correctly.