Tax processing key like NVV to post against expense account in separate line item

[former_member399126]

Hi Experts,

I would like to know if is possible to post a document with tax account key NVV (or a similar one with posting indicator 3 "Distribute to relevant expense/revenue item") in this way:

Let´s suppose a tax rate of 0,5% for input tax:

Expense account                1000         

Expense account                     5

                                                                      Vendor               1005

Currently, using posting indicator 3 the document look like this

Expense account                1005

                                                                      Vendor                1005

The tax is included in the expense account, but is shown in same line item.

Please, suggest if possible to post the tax in the same vendor expense account, but in separate line item.

The option of using posting indicator 2 is not feasible, since it assigns fixed GL accounts per tax code, and in this scenario we need same expense account of vendor invoice, which may vary..

Thanks in advance,

Pablo

[nileshkumar_gupta]

Hello Pablo,

NVV: Input tax not deductible and assignable:

No separate line item is created for the tax amount. The tax amount not deductible is added to the G/L account line subject to tax. In case of several G/L account lines the tax amount is added to the particular positions proportionately.

[former_member198650]

Hi Pablo,

It is the standard design, either you can post to separate line item or relevant exp/revenue.

Regards,

Mukthar

[former_member399126]

Hi Mukthar,

Thanks for your reply. Then, is not possible to post into same invoice relevant exp/revenue, but in separate line item.

Regards,

Pablo

[ajaycwa1981]

Hi Pablo

To post it in a separate line item, you must keep it as a deductible condition.. In that case, it gets posted as a Balance Sheet item.. And then you can reclass it in P&L Account

OR

May be you can assign a P&L item in OB40 and check.. Never tried that

Br, Ajay M

[Former Member]

Hi,

I need to create a dop down option status in that need to fill the value

Status = Status should have dropdown 3 drop down values like, Trip Completed/Open (3 and 0), Trip Completed and To be settled (3 and1), Trip Approved/To be settled (4and1) and Trip Approved/Settled (4and 2).

If we select any value and execute the report Trip details need to be identified & fetched from the table PTRV_CHANGE from Fields (ANTRG and ABREC).

i have created the drop down option but not getting how to fetch the values.Please help it out.

  CASE so_stat.

    WHEN 'A'.

      READ TABLE lt_ptrv_change INTO ls_ptrv_change WITH KEY pernr = ls_ptrv_head-pernr

                                                             reinr = ls_ptrv_srec-pernr.

      IF sy-subrc = 0.

      ENDIF.

  ENDCASE.

DATA : v_id TYPE  vrm_id,

            values TYPE  vrm_values.

  DATA : BEGIN OF vrm_value,

           key(40) TYPE c,

           text(80) TYPE c,

         END OF vrm_value.

  vrm_value-key = 'A'.

  vrm_value-text = 'Trip Completed/Open '.

  APPEND vrm_value TO values.

  vrm_value-key = 'B'.

  vrm_value-text = 'Trip Completed/To be settled'.

  APPEND vrm_value TO values.

  v_id = 'SO_STAT'.

  vrm_value-key = 'C'.

  vrm_value-text = 'Trip Approved/To be settled '.

  APPEND vrm_value TO values.

  vrm_value-key = 'D'.

  vrm_value-text = 'Trip Approved/Settled '.

  APPEND vrm_value TO values.

  v_id = 'SO_STAT'.

  CALL FUNCTION 'VRM_SET_VALUES'

    EXPORTING

      id              = v_id

      values          = values[]

    EXCEPTIONS

      id_illegal_name = 1

      OTHERS          = 2.

  IF sy-subrc <> 0.

* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

  ENDIF.

[former_member399126]

Hi Ajay and all,

I have a tax processing key with this settings:

Tax Type: 2 Input Tax

Not deductible: (no flag)

Posting indicator: 3

The tax is being included in the expense account, in same line item.

To enter account in OB40, I have to change posting indicator to "2". But if I do that, I'll be able to enter only one tax account per tax code. So, it is not useful for the requirement. 

What I'm looking for is to post in the same invoice expense account, but in separate line item. Which seems not possible.

Regards,

Pablo

[ajaycwa1981]

Hi Pablo

Yes, you can enter only one Tax account per tax code.. This will be a temporary account

Then you need to re-class it from this account to relevant Expense account posted in the doc.. You will have to develop a Z program for that

Br, Ajay M