G/L Account not posted

[Former Member]

Dear all,

Pls tell me why G/L Account is not posted in group Cust.grp/MaterialGrp/AcctKey and Cust.grp/AcctKey, MaterialGrp/AcctKey. It's only posted in group General and Acct Key. I also checked Account assignment in Customer Master and Material Mater.

Thank you,

[Former Member · Accepted solution]

Hi Quang,

Check in pricing Procedure that

1.weather u have maintained A/c Keys accordingly.

2. Put Reqt=2 corresponding to A/c Keys ERL & ERS.

3. Put Sub total =9 corresponding to Net Total.

Try this n revert if not resolved.

Regards

Amit Gupta

[Former Member · Accepted solution]

Hi Amit Gupta ,

Pls tell me more detail to maintain pricing Procedure! What's TCode or path?

Thank you very much,

[Former Member · Accepted solution]

Hi Quang,

Go to V/08.

1.Select your pricing Procedure.

2. Go to control Data .There u can view all condition types.

3. Check ur condition types and corresponding A/c Keys.

4. Let Suppose u hve maintained A/c keys ERL ,ERS, & ERF in pricing proc.

5. Make sure that in VKOA. U mainatain all G/L accounts for corresponding A/C Keys.

6. As in ur screenshots u have maintained

VKOFICOAVHDQS01-03-ERL511211

Similarly u have to maintain for

VKOFICOAVHDQS01-03-ERS G/L A/c

VKOFICOAVHDQS01-03-ERF G/L A/c

In VKOA.

Revert if not resolved.

Regards

Amit Gupta

[Former Member]

Dear all,

Thanks for all of your supports. I should close this thread, it's too long.

Thanks & best regards,

[Former Member]

Hi,

I am very sorry to write this but may i know what is the prime issue of raising this thread?

As, i am finding this thread too long for discussion.

if the issue is resolved, close the thread with comment and post new thread with another issue/ query.

Thanks for the cooperation,

Amit

[Former Member]

Hi Amit Yadav,

I also think same to you, but it has relation with Account determination problem in this thread.

If you have suggestion, pls leave your message.

Thanks & Regards,

[Former Member]

Quoting one of your replies:

"

Hi,

Sorry for reply late.

No, our scenario type is MTS.

It's seem correct. But now, when i view Document flow, billing status is not clear. Pls tell me what happen?

http://i358.photobucket.com/albums/oo30/vquang124/DocFlow.jpg

Thanks,

Edited by: Quang Le Vinh on Sep 5, 2008 10:54 AM

"

Whats remaining in the issue?

Hope, you won't take my suggestions in other ways...

Best Regards,

Amit.

[Former Member]

Hi Amit,

I have checked it. And Pricing Proc used is RVAA01.

This is screen shot link:http://i358.photobucket.com/albums/oo30/vquang124/RVAA01.jpg

Hi Antima,

I don't see account assignment group in item detail of material. Pls tell me exact location.

Thanks & Best regards,

[Former Member]

Hi Quang,

Go to your billing document using VF02 or VF03. Select the line item for the material and in menu... Goto>Item>Item Detail. Here you have on Accounting subtab where it shows the Account Assignment Gp field.

As per my analysis your transaction has not picked up the data for this field. There can be only one reason for the same that the organisation level for your transaction and material master differs.

Check and revert.

Rgds,

Antima

[Former Member]

Hi Antima,

I have just choosen it. And when i save, it still shows message: Document 90000010 has been saved (pricing error)

Whats problem?

Thanks & Regards,

[Former Member]

Hi Quang,

Go to the change mode of billing document and try to release the document to accounting. expand the error message and post the screen shot of the same.

In the billing document did you check for Material Account Assignment Gp?

Rgds,

Antima

[Former Member]

Hi,

Pls see these screen and leave your mind:

http://i358.photobucket.com/albums/oo30/vquang124/VF02-3.jpg

http://i358.photobucket.com/albums/oo30/vquang124/VF02-4.jpg

I also check customer acct assignment group.

See you again tomorrow,

Thanks & Regards,

[Former Member]

Hi Quang,

Can you put the screen shot of error.

Rgds,

Antima

[Former Member]

Hi Quang,

In ur pricing procedure screen shot i can see ERL & ERS...

& in ur Acc determination screen .. u haven't maintained

ERS. So maintain ERS & other A/c Keys With there G/L Accounts in VKOA ---Table -1

Amit

[Former Member]

Hi Amit,

I have assigned GL account for AcctKey ERS in Table 5.

http://i358.photobucket.com/albums/oo30/vquang124/Table5.jpg

Rgds,

[Former Member]

Dear,

If i assign GL account in Table4, it is posted to FI, and ERS account is also posted. But it is incorrect with our bussiness.

http://i358.photobucket.com/albums/oo30/vquang124/DisplayAccountingDoc.jpg

Rgds,

[Former Member]

Hey Quang,

Your problem is not wrt any configuration. Its only related to master data and transaction. So check that again.

Rgds,

Antima

[Former Member]

Okey,

Thanks for all of your support. I have just changed KOFI to KOFK. it's seem resolved. Let's me check.

Regards,

[Former Member]

Hi Quang,

We generally use KOFI for MTS and KOFK for MTO sales. Is your scenario MTO type?

Rgds,

Antima

[Former Member]

Hi,

Sorry for reply late.

No, our scenario type is MTS.

It's seem correct. But now, when i view Document flow, billing status is not clear. Pls tell me what happen?

http://i358.photobucket.com/albums/oo30/vquang124/DocFlow.jpg

Thanks,

Edited by: Quang Le Vinh on Sep 5, 2008 10:54 AM

[Former Member]

Hi,

Billing "not clear" as might be the collection entries haven't been made.

Once collection against Invoice is done, same will be resolved.

Best Regards,

Amit.

[Former Member]

OK, let's me check again.

Thank you,

Regards,

[Former Member]

Dear Quang,

U can clear payments by using transaction f-28.

Enter Customer Account No & bank data and clear payments accordingly.if its dummy scenario u can use bank account 100000.Try this n revert

Regards

Amit Gupta

[Former Member]

Hi everybody,

Anyone pls kindly upload screen shots of Revenue Account Determination in your system on website http://photobucket.com/ ?

And post the direct link in this thread pls!

Thanks a lot,

Edited by: Quang Le Vinh on Sep 4, 2008 6:08 AM

[Former Member]

Hi,

Based upon inputs (screenshots), provided by you, there is an entry missing for combination:

Charts of Accts: COAV

Sales Org: HDQC

*Acct Assignment Grp (Customer Master): ???

**Acct Assignment Grp (Material Master): ???

Acct Key: ERL

***G/L Account (Debetor's A/c): ???

in G/L A/c assignment in VKOA in Table 1 (Cust Grp/Material Grp/Acct Key).

Note:

*for the material entered into Sales Order. Assign A/c Assignment Grp in Material Master (Tab: Sales Org 2)

**for the Sold-to-Party, entered into Sales Order. Assign A/c Assignment grp in Customer Master (Tab: Sales Area Data --> Billing Document).

• G/L to be posted for debetors. Consult FI-Personnels.

Once entry maintained into VKOA, Cancel the Bill doc and re-create Invoice.

Moreover, System must get an error while saving Sales Order for G/L missing in Incompletion log. If its not, chk Incompletion Procedure for Sales Order Type:

To do So, Define Lof of incomplete items for Group

B - Sales - Item

for Work Area: 11

and attach to Sales Order type in VOV8.

Hope this will resolve your issue.

Best Regards,

Amit.

[Former Member]

Hi Amit Yadav,

In combination, i have asigned Accout Assignment group

Acct Assignment Grp (Customer Master): 01

Acct Assignment Grp (Material Master): 03

Pls, see screen shots that have just updated once again.

Edited by: Quang Le Vinh on Sep 4, 2008 9:09 AM

[Former Member]

Hi,

Have you chosen correct Condition Type (KOFI or KOFK) and Chars of Accts?

Best Regards,

Amit.

[Former Member]

Hi Quang,

You have maintained VKOA settings for the Cust Gp/Mat Gp/A/c key whereas during transaction you have put the screen shot of combination Mat Gp/A/c key. So if you can take the screen shot of first combination in Account determination Analysis then the missing link will be more clear.

Rgds,

Antima

[Former Member]

Hi,

I chosen KOFI. I think it was no problem. Because, it is still posted when i assigned GL account in Table4 (General) and Table5 (AcctKey).

[Former Member]

Hi Quang,

Sorry for asking you to check basic setting but just check the material master and customer master whether the Account Assignment Gp which you have assigned is in same sales area as you are using in transaction.

Rgds,

Antima

[Former Member]

Hi,

Pls see:

VKOA - Table1: http://i358.photobucket.com/albums/oo30/vquang124/Table1.jpg

Customer Master: http://i358.photobucket.com/albums/oo30/vquang124/untitled3.jpg

Material Master: http://i358.photobucket.com/albums/oo30/vquang124/untitled4.jpg

[Former Member]

Hi Quang,

All the assignment and respective data seems correct in the screen shots.

Now if you can just put the screen shot of analysis by going to VF02 or VF03 transaction enter your billing document number then go to Menu Environment--> Acc.determ.analysis --> Click on Revenue accounts now system will give the analysis details. Select the item 10 in that and paste the same screen shot.

Rgds,

Antima

[Former Member]

Hi Antima,

I have just check. It seems OK

http://i358.photobucket.com/albums/oo30/vquang124/VF02.jpg

[Former Member]

Hi Antima,

I am sorry. I have create billing again and check Revenue account, i see a warning icon.

http://i358.photobucket.com/albums/oo30/vquang124/VF02-1.jpg

Help me pls,

Thanks

[Former Member]

Quang,

Try to send send screen shot of ur pricing proc in V/08.

Regards

Amit Gupta

[Former Member]

Hi Amit,

Currently, i also don't know what is the pricing Procedure that be have using.

Pls see some screen shots and give me your mind:

AEB000:

http://i358.photobucket.com/albums/oo30/vquang124/AEB000.jpg

AEB001:

http://i358.photobucket.com/albums/oo30/vquang124/AEB001.jpg

RVAA01:

http://i358.photobucket.com/albums/oo30/vquang124/RVAA01.jpg

Thanks & Regards,

[Former Member]

Hi Quang,

As I can notice thru the screen shots is that there is some problem with the Material Acct Gp. Can you check the Item Detail whether the Material Account Gp has been picked in billing document or not.

Rgds,

Antima

[Former Member]

Hi Quang,

To check ur pricing Proc...Simple check In order at header level in Sales Tab....There u can find ur Pricing Procedure and subsequently u can see the details maintained in V/08.

Let Me know if it matches with ur screen shot attached.

Regards

Amit Gupta

[Former Member]

_

Edited by: Quang Le Vinh on Sep 4, 2008 11:36 AM

[Former Member]

Okey,

Pricing Proc using is Standard RVAA01.

Screen shot link: http://i358.photobucket.com/albums/oo30/vquang124/RVAA01.jpg

[Former Member]

Quang,

I mean to say ...To know ur pricing procedure ... u have to go to Sales order for which account determination problem is coming.

Then go to header data and view Sales Screen.

There u can find ur pricing proc used in that document.

Select that pricing procedure and view details using transaction V/08.

Regards

Amit

[Former Member]

Hi Quang,

Also check whether in the item details of material, it has picked Account Assignment Gp that you have mentioned in your material master.

Rgds,

Antima

[Former Member]

Hi Quang,

I think there is problem in material master only. Please check that the Material Account Assignment Gp that you have maintained is for which organisation level...Plant/Sales Org/Div and then check your transaction whether you are using the same Plant/SO/Dist Ch combination.

Please check these 2 things and I am sure your problem will be solved.

Rgds,

Antima

[Former Member]

In Pric Proc RVA001 there are A/c Keys ERL, ERS,ERF,ERB,MWS

So maintain this n try ur luck in VKOA Table 1

VKOFICOAVHDQS01-03-ERL511211

VKOFICOAVHDQS01-03-ERS G/L A/c

VKOFICOAVHDQS01-03-ERF G/L A/c

VKOFICOAVHDQS01-03-ERB- G/L A/c

VKOFICOAVHDQS01-03-MWS- G/L A/c

Regards

Amit Gupta

Edited by: Amit Gupta on Sep 4, 2008 12:07 PM

[Former Member]

Hi Amit,

I also done exactly as you said, but i doens't work.

In screen shot http://i358.photobucket.com/albums/oo30/vquang124/Table1.jpg I have showed it.

[former_member183879]

Hello,

Please check the mapping of GL accounts to the relevant combination of Cust.grp/MaterialGrp/AcctKey or some other combination. If it is not maintained in Revenue account determination, then no GL account will be determined at that level.

First check the customer group is filled in the relevant customer master for the relevant c.code and Sales area

Similarly check for the material group for relevant org level.

Also check if the condition type is mapped to the correct account key in the pricing procedure.

If all these things are correctly mentioned and the GL account is mapped to this combination, the GL account posting should happen without any problem.

Hope this helps.

[former_member204513]

Dear Quang,

Please check in these areas

Go to VF02 or VF03 transaction enter your billing document number then go in to that here you go to Menu Environment>Acc.determ.analysis>Click on Revenue accounts now system will give the analysis details here you can find the reason according to that you can proceed further.

Checkl the Revenue account determination configuration steps in IMG Path is Spro>IMG>Sales and Distribution>Basic functions>Account Assignment/Costing-->Revenue Account Determination

-->Check Master Data Relevant For Account Assignment

-->Define Dependencies Of Revenue Account Determination

-->Define Access Sequences And Account Determination Types

-->Define And Assign Account Determination Procedures

-->Assign G/L Accounts (here you chek have you assigned G/L accounts to the correct combination or not.)

I hope it will help you,

Regards,

Murali.

[Former Member]

Hi Murali,

I go to Environment>Acc.determ.analysis>Click on Revenue accounts and see a yellow warning icon on MaterialGrp . I don't see more detail information, so i don't know what problem. Pls help me.

Pls see screenshots on link:

http://i358.photobucket.com/albums/oo30/vquang124/untitled1.jpg

http://i358.photobucket.com/albums/oo30/vquang124/untitled2.jpg

Thank you very much

[Former Member]

more screenshots:

http://i358.photobucket.com/albums/oo30/vquang124/untitled1.jpg

http://i358.photobucket.com/albums/oo30/vquang124/untitled2.jpg

Edited:

http://i358.photobucket.com/albums/oo30/vquang124/untitled3.jpg

http://i358.photobucket.com/albums/oo30/vquang124/untitled4.jpg

Edited by: Quang Le Vinh on Sep 4, 2008 8:56 AM

[Former Member]

Based on your screen shots,What is the material account assighnment group assighned to your material..Is it 1 or 3.

Regards

Sree.Manam

[Former Member]

Hi,

I tried both of 1&3 are not posted.

Thanks,

[former_member204513]

Dear Quang,

As per your message I came to know that this related to Material account assignment group issue so ,

Please check the Material account assignment group in the material master then with that account assignment group combination you assign the G/L accounts in VKOA transaction.

I hope it will help you,

Regards,

Murali.

[Former Member]

http://i358.photobucket.com/albums/oo30/vquang124/untitled1.jpg

Account assignment group is missing in Customer / Material Master data, when transaction was created. Check the Account assignment group in Customer / material master and if not maintained, maintain the same.

As a workaround, check if it is possible to maintain the same in change mode in billing and if not possible, take a help of Abaper and maintain the same in Billing Transaction in debug mode.

Regards,

Rajesh Banka

[Former Member]

Dear all,

Anyone kindly give me suggestions pls?

Thank you very much,

[Former Member]

Check the customer group in the customer master and the material group in the material master. Then go to config and check if an entry using that combinatione xists or not