Skip to Content
Author's profile photo Lakshmipathi Ganesan

Statistical Condition Type but value to post in FI

General Behaviour

As you are all aware, any condition type that is not checked for Statistical check box in pricing procedure will add to the net value and post the value in FI.  On the other hand,  if it is checked, it will not post the value in FI and also it will not add to net value in the sale order / billing.

Requirement need to be addressed

Now imagine, a requirement came to you as follows:-

A particular condition type should not add to net value in sale order / billing but should post to FI.  I have come across people who immediately say it is not possible even with user exit.  But, IT IS POSSIBLE via standard configuration itself.

Solution

Go to V/06, select that condition type and execute.  There, select the below tab and check the box for “Accruals”.

Accruals.JPG

In your Pricing Procedure, don’t check the box for “Statistical” against this condition type BUT, have different Account Keys assigned at the last two columns viz.Account Key and Accruals.  Finally, in VKOA, assign the required G/L Account in the last two columns for both the Account Keys.

Now try to create a sale order and billing and check the FI posting.

G. Lakshmipathi

Assigned Tags

      45 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Hi sir thansk for posting

      Naren K

      Author's profile photo Marcin Milczynski
      Marcin Milczynski

      Useful post, but I think the sentence 'don’t check the box for “Statistical”' is incorrect. If you do not mark it as statistical, it will influence the net value of an item, wheras marking the condition as statistical in pricing procedure allows posting of accruals without influence of the accrual amount on the item net value.

      Regards,

      Marcin

      Author's profile photo G Lakshmipathi
      G Lakshmipathi
      Blog Post Author

      No it will not influence on the net value which I have tested it.

      Thanks

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member

      Dear Lakshimipathi  SIR

                this is simply super bz it is so helpful to others

      Author's profile photo Former Member
      Former Member

      Agreed. It will not affect net value since the condition was setup as accrual in V/06.

      Thanks for sharing this tip, Lakshmipathi.

      Author's profile photo Navaneetha Krishnan
      Navaneetha Krishnan

      Hi Lakshmi,

      Simple but very effective tip for consultants.

      Author's profile photo G Lakshmipathi
      G Lakshmipathi
      Blog Post Author

      Thanks for your compliments.

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member

      Dear Lakshmipathi,

      this kind of tips boost subject concentration for beginners and professionals. how we have to keen in terms client requirements and solution. Thanking you for your tips and future support also.

      warm regards,

      Jagadeesh

      Author's profile photo Vasanth Mohanasundaram
      Vasanth Mohanasundaram

      Have already used this option but Good to get to know that this is a right approach from the post.

      Scenario : Freight is calculated but not charged to the customer. Yet it should be tracked by the business and captured in FI. So we implemented the same logic and got it done.

      Author's profile photo TW Typewriter
      TW Typewriter

      Vasanth,

      Thanks for the business example!

      Author's profile photo Avik Mazumder
      Avik Mazumder

      We also Implemented similar things called BAP price(Business affiliated price) condition type which was not charged to customer as in commercial invoice but shown in Excise invoice.But the intricate details of configuration and implication is very nicely depicted in this document by the author.

      Author's profile photo TW Typewriter
      TW Typewriter

      G Lakshmipathi,

      Your blog is structured (e.g. with sections) this makes it easy to understand.

      In my opinion, a (few) business examples would have made the blog more beneficial to the readers.

      Members have asked for tips to write "functional specification documents", I would suggest them to read your blog to get some idea on how to structure material.

      Thank you for this blog!

      Author's profile photo G Lakshmipathi
      G Lakshmipathi
      Blog Post Author

      Thanks for your compliments.

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member

      Dear Sir,

      Thanks for the example. I have used the condition type as accruals assgined the account key for "Accruals".

      I have a doubt. Is it mandatory to assign account key for "Account Key"

      Author's profile photo G Lakshmipathi
      G Lakshmipathi
      Blog Post Author

      Not necessary.  But do a test scenario, take the concurrence from finance people on the postings and then move the request to production.

      G. Lakshmipathi

      Author's profile photo Former Member
      Former Member

      Well I tried.. if I am not assigning any account key.. then it doesnt post to the accrual account or then I get an error saying Item category 02000 is missing (obligatory in accounting transaction 0200/0001)

      coz it doesnt find any line item to be posted.

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      This is only possible for accrual entries as per my testing. You have to assign accrual G/L for posting otherwise system will not allow. If there is some other way please share.

      Author's profile photo Former Member
      Former Member

      Hi Laxmipathi,

      I have similar requirement for my client, but here the scenario is posting the cost to deferred G/L, (Revenue  Recognition is active), But encountered below error:

      Balance in transaction currency

      Message no. F5702

      Diagnosis

      A balance has occurred in transaction currency 'USD' with the following
      details:

      Exchange rate '00', amount '           334.80' and currency key 'USD'.

      The data in the transaction currency were transferred from the calling
      application.

      System Response

      Your data cannot be processed in FI.

      Procedure

      The error is probably in the calling application.

      Any suggestion will be very helpful

      Thanks

      utpal

      Author's profile photo Former Member
      Former Member

      Hi,

      Add one  business senario: for some export business, we need pay VAT tax of sales order first , then refund from government after get approval,  so this tax should not be charged to customer (not cumulated into net price) but need be posted into FI for tax refund usage...

      With best regrds

      Jian

      Author's profile photo Ron Barry
      Ron Barry

      Hi, I have a similar request. Can you share how did you achieve it. Was the condition type a tax condition type ?

      I am having trouble as the tax conditions does not behave as desired with the accruals settings.

      Author's profile photo Former Member
      Former Member

      Hi Laxmapati,

      This is very very useful.

      This can be of great use for VAT purpose for export to EU from czech republic.

      Regards,

      Himanshu

      Author's profile photo Former Member
      Former Member

      Thanks Sir for posting such informative document...congrats... 🙂

      Kind Regards,

      Pankaj

      Author's profile photo Rajendra Prasad Thogiti
      Rajendra Prasad Thogiti

      Thank you. this is nice...!

      Author's profile photo Former Member
      Former Member

      Hi Lakshmipathi ,

      It is very informative

      Author's profile photo Former Member
      Former Member

      thanks a lot its very use full.....

      Author's profile photo Former Member
      Former Member

      Thank you... good information..

      Author's profile photo Shiva Vasireddy
      Shiva Vasireddy

      Sir,

      Thank you for sharing

      Author's profile photo Former Member
      Former Member

      thank u ,,,,,, Lakshmipathi for sharing

      Author's profile photo Former Member
      Former Member

      Hello Mr. Lakshmipathi

      I am trying to obtain the same result but the problem is that in my accounting document the same amount is posted both for credit and for debit, so the final amount is 0. I did the following:

      - marked the Accruals flag in condition type details

      - unmarked the Statistical flag for the condition in the pricing procedure definition

      - inserted 2 different Account keys for the condition into the pricing procedure

      - configured account determination in VKOA to use a specific G/L Account (same g/l account in the last two columns) for the indicated Accrual Account key

      Tried different combinations, none worked. Basically, if I can make it just post the debit and not also the credit, it would be fine.

      Any suggestions would be greatly appreciated!

      Thank you,

      Cosmin

      Author's profile photo Former Member
      Former Member

      Hi,

      Very useful post. We had a business scenario where in we wanted to take certain cost components from material costing into the pricing to calculate statistical margins.These conditions were statistical and we needed them to be posted into accounting. We followed the same approach. I believe that the same approach will work in MM Pricing also

      Author's profile photo Former Member
      Former Member

      I have the exact requirement with a pricing procedure and condition type however the statistical indicator is still set on the PO. Any ideas? Basically I would like a pricing condition type to show up on the PO without adding to the material price but it can still be invoiced. The condition type can't be set up as a delivery cost though because reversals don't work correctly.

      Author's profile photo Former Member
      Former Member

      Hi Laxmipathi

      Thanks for the post. Our system is configured the way you mentioned and I found your post as I was trying to understand how we were able to post to FI, though a condition type was showing as statistical in the billing document. However, I saw one difference from what you mentioned in the post.

      In our system, though we maintained two different account keys in the pricing procedure, we maintained the entry in VKOA for only one account key. We maintained two different GLs (normal and provisional) for the same account key and there is no entry for the other account key. Is this set up ok?

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi all ;

      For example : Rebate related conditions ..

      Regards.

      M.Ozgur Unal

      Author's profile photo Phanikumar Valiveti
      Phanikumar Valiveti

      try with two different accounting keys like ERB& ERU .

      Update us..

      Author's profile photo Atul Kumar Dagade
      Atul Kumar Dagade

      Hi Lakshmipathi,

      Useful article for all SD folks.

      Thanks

      Atul

      Author's profile photo Andrea Brusa Restelletti
      Andrea Brusa Restelletti

      Hello,

        please, can you share the result of the posting made into accounting?

      I have done similar configuration, but the accounting document posts two lines for the amount related to the condition set as accrual: is this the standard behaviour? Is there any way with customizing to have just one line?

      Thanks and best regards,

      Andrea

      Author's profile photo Ashok Kumar Telugu
      Ashok Kumar Telugu

      Very Informative.

      Author's profile photo Former Member
      Former Member

      very useful posting

      Author's profile photo Former Member
      Former Member

      Dear Sir,

      Thank you very much for this information. This is of great help.

      Author's profile photo Former Member
      Former Member

       

      Hi Lakshmipathi

      My Requirement also same as Cosmin.  I followed all your suggested config and noticed accounting doc have entry of debit and credit.  Required  to post only Credit entry. Any suggestions would be greatly

      Thank you,

       

      Author's profile photo Almiro Sengo
      Almiro Sengo

      Very nice document, I think Its applicable in MM too.

       

       

      Author's profile photo Surajit Kar
      Surajit Kar

      Very precise & informative blog. Can anyone please share the VKOA setting & also the accounting entry.

      Thanks in advance.

      Author's profile photo Vinod Naik
      Vinod Naik

       

      The Blog is very informative. I have similar requirement where I do not need two values in the calculation of net price but needs them to be posted to accounting. But when I try to use above method I have to assign additional accounts where the values gets posted. And doing this I am able to see additional entries. Is there any way so that we can ensure that only one account will get posted for such conditions?

      Author's profile photo Ashok Sairi
      Ashok Sairi

      Dear Lakshmipathi Ganesan,

      Thanks for posting such ideas, which can help many people.

      We have the same requirement for our client, where surcharge amount should not affect the net value in the Sales Order/Billing document and the amount should post to a GL account. Same GL account amount will add to the existing report.

      Steps used:

      1)New Account key created

      2)Assigned in accrual's column in pricing procedure.

      3)Condition type activated for Accrual.

      4)Maintained the GL account for both Account keys() in VKOA.

      But, after implementing this, GL account is debiting and crediting at the same time. It means it's nullifying the amount.

      Please help..

      Author's profile photo Juloe C
      Juloe C

      Hello lakshmipathi,

      Our requirement is that the interest condition type value is included in the base price. I will follow the same procedureas you showed for the interest condition tyoe. But our other requirement is the base price should get deducted by the interest amount and that should be posted to the g/l account. How can i achieve tbat please?