Enterprise Resource Planning Blog Posts by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
sagnikch
Explorer
6,899

          Tax Determination in Purchase Orders to Invoice Verification

Case 1- Purchase Order without any Taxes.

Step 1: Refer to SAP standard Condition Table 4AV, M/05.

sagnikch_0-1740297921039.png

Step 2: SAP has provided a default access sequence MWST to access the above table.

sagnikch_1-1740297921047.png

Step 3: Create new Tax condition type  ZWVS copying from MWVS. (Tcode OBQ1) and assign the access sequence MWST.

sagnikch_2-1740297921055.png

Step 4: Assign new condition type ZWVS  to the existing tax procedure TAXINN.

Tcode- OBYZ

sagnikch_3-1740297921057.png

Insert the newly created condition type ZWVS into the tax pricing procedure with account Key VST.

sagnikch_4-1740297921067.png

Step 5: Create Tax codes in FTXP and assign 0 in ZWVS.

sagnikch_5-1740297921070.png

sagnikch_6-1740297921077.png

Once tax code is created in FTXP system will automatically make an entry in the tax condition record, FV11 in the Tax Classification.

sagnikch_7-1740297921080.png

sagnikch_8-1740297921083.png

Step 6: Assign Company Code to Tax codes for Non Taxable Transactions. 

sagnikch_9-1740297921093.png

Step 7: Maintain the Tax code V0 and the corresponding input tax GL created in OB40.

sagnikch_10-1740297921095.png

Step 8: PO creation with V0 tax code.

sagnikch_11-1740297921102.png

sagnikch_12-1740297921106.png

Step 9: MIRO posted with update in Purchase Order history-  

sagnikch_13-1740297921113.png

Accounting document in MIRO. 

sagnikch_14-1740297921117.png

Case 2-

Deductible Tax

Incase User manually enters the Tax code in Purchase Order with 18% Tax value.

Step 1: Create a new tax code V1 for 18% Tax and assign 18% on Input Taxes Tax Type (ZWVS). The tax amount will be booked on the Tax GL account and credit would be taken.

sagnikch_15-1740297921126.png

Step 2: Tax code to be maintained in OB40.

sagnikch_0-1740319528950.png

Step 3: Create PO with V1 with 18% Tax code.

sagnikch_17-1740297921135.png

sagnikch_18-1740297921139.png

In PO Pricing NAVS does not get updated in this case.

sagnikch_19-1740297921151.png

Step 4: Perform MIGO and the corresponding MIGO Entries are –

sagnikch_20-1740297921155.png

Accounting Entries in MIGO –

  • Inventory Account BSX + DR.
  • GR IR Clearing WRX -CR.

Step 5:  Perform MIRO –

sagnikch_21-1740297921164.png

Accounting Entries during MIRO –

  • GR IR Clearing WRX +DR
  • Input Tax VST +DR
  • Vendor Account -CR.

Case 3- Nondeductible Tax value.

Incase User manually enters the Tax code in Purchase Order with 18%.

Tax amount will add up to the inventory cost  during GRN and no credit on Tax would be taken.

Step 1: Create a new condition type ZMWV copying from condition type MWVY and assign access sequence MWST.

sagnikch_22-1740297921170.png

Step 2: Assign the condition type to the TAXINN pricing procedure and the accrual key should be NVV.

sagnikch_1-1740319739397.png

Step 3: Create Tax Code ND using Tcode FTXP

sagnikch_24-1740297921188.png

Tax classification Condition record automatically created in FV11.

sagnikch_25-1740297921191.png

Note** No entry in OB40 is required.

Step 4: PO Creation with ND Tax Code.

sagnikch_26-1740297921198.png

sagnikch_27-1740297921201.png

PO Pricing NAVS automatically gets updated with the Tax amount.

sagnikch_28-1740297921217.png

Moreover, you have to take into account that the non-deductible tax amount is calculated with function module 'CALCULATE_TAX_ITEM' program-internally.

Step 5: During GRN the tax amount will get inventorized to the Inventory GL. 

Inventory BSX DR+

GR/IR Clearing WRX CR –

sagnikch_29-1740297921231.png

Step 6: Perform MIRO-

sagnikch_30-1740297921239.png

Accounting Entries during MIRO –

  • GR/IR Clearing DR +
  • Vendor A/C CR -

sagnikch_31-1740297921245.png

Regards,

Sagnik.