Another line item in accounting

[Former Member]

Hi Freinds,

Currently in accounting document generated for billing document am getting two line items ( one credit for G/L( say GL01) against posting key 50) and second for debit against posting key 01.( scenario for periodic billing)

Now business wants to add another line item for tax against another G/L say GL02.

I know G/L01 is added in VKOA that's why am getting that account in accounting document ( though GL02 is also added against some AAG).

Now how can I get three line items in accounting document for periodic billing , what changes do I need to do in VKOA against GL02 and or GL01.

REgards

Ashu

[Former Member · Accepted solution]

Hi,

The settings for the tax amounts in the accounting document can be done by creating Tax condition types with condition class : "D", Calculation type: "A", condition category "D". Then attach the condition types in your pricing procedure with Account Keys. Now for each account key goto "OB40" and maintain the Accounts along with the tax codes.

Also maintian the Tax categories for both material and customer through SPRO--> S&D --> Basic Function --> Taxes --> Define tax relevancy of master records.

The conditon records maintained in VK11 will be with tax codes and the tax categories maintained in the customer master and material master.

Acess sequence and condition table may have to be created depending on the requirements.

Regards,

Deepak

[Former Member · Accepted solution]

Hi Deepak,

Thanks for your reply,

Tax condition types with condition class : "D", Calculation type: "A", condition category "D" has been created, now while assigning assigning it to pricing procedure what account ket do I need to choose ( is it ERL)?

And when am assigning it to pricing procedure getting information message ( no VT632)that standard proposal for cond type CTX1 Mand=X

REq=010 Basfor=016; Acct key=MWS

And for which key do I need to maintain entry in OB40 ( as in OB40 am getting a lot of transaction)?

CTX1 has already been maintained under SPRO--> S&D --> Basic Function --> Taxes --> Define tax relevancy of master records.

REgards

Ashu

[jignesh_mehta3 · Accepted solution]

Hello Ashu,

You will have to maintain MWS in Pricing Procedure in Account Key Column again CTX1.

Now most probably you will be using Tax Code in the Condition Record for CTX1.

OB40 select MWS & put Tick mark in Tax Code Check Box. Then maintain GL account for required Tax Code.

This will ensure that Tax Amount is posted in Seperate GL Account.

You can take advise from FI person for Tax Code & GL Account Details.

Hope this helps...

Thanks,

Jignesh Mehta

[Former Member · Accepted solution]

Hi Friends,

Thanks for your replies,

I did the changes suggested by you , getting CTX1 in sales document. I did changes in VKOA as well, assigned Act GL01 to Act Key ERL and GL02 to MWS ( for both KOFI and KOFK), but still not getting two lines in accounting.

Also I have assigned the CTX1 to pricing procedure but it is allowing me to enter manually (why not CTX1 is populating automatically). And I entered say for example 10% and getting value in sales document but while creating billing document am not getting CTX1 ( do I need to maintain it in copy control) or some where else? And when entering CTX1 in billing document and trying to save getting message that error in account determination in table T030K ( message no FF709), but have already maintained in T030K for chart of accounts 1000 and accounting key MWS

And business has updated that The first part is the posting of the tax and the second is the call out to Sabrix for the calculation.

So am I missing any configuration or not getting results because SABRX is not connected to system.

REgards

Ashu

Edited by: ashutosh p on Mar 4, 2011 7:42 AM

[sarthak_mohantysd · Accepted solution]

Hello ashutosh,

Please refer the below procedure for Tax calculation process :

1. First ensure to maintain a TAX CODE with help FI consultant, check the T-code "FTXP".

2. After you have set the Tax code then go to the t-code OB40 to set the corresponding G/L account for this Tax code in context with account key MWS and you need to maintain these data for a specific Chart of Account.

3. Condition Type for Tax i.e CTX1 should be added up to the Pricing procedure and the account key should be MWS.

4. Then set out the condition record for the Condition Type CTX1 if you don't want manual entering of value. Please note that condition record needs to be set in respect to Tax code.

5. Please record the G/L account in VKOA for the respective combination applicable to the business process.

nd I entered say for example 10% and getting 
value in sales document but while creating billing 
document am not getting CTX1 ( do I need to maintain it in 
copy control) or some where else?

Kindly check the copying control setting for the tax value not being populated at Billing level: Pricing type: D or Price source -- Order.

Best Regards,

SARTHAK