Dwarakanath N
September 18, 2013 3 minute read
Deferred Tax Transfer Functionality in SAP
61132,476
Deferred Service Tax transfer Functionality
Deferred tax transfer is the process wherein the tax on sales or purchases is reported only when the vendor invoice amount is paid or the customer invoice amount is received.
When the vendor invoice is booked, the service tax is calculated and taken to the Service Tax (Credit available) account {Current asset}. Once the payment for the vendor is made, a special program called deferred tax transfer program has to be run, which will transfer the amount from this intermediate or deferred account to the final or target account.
FTXP Creation of deferred and target tax codes
FS00 Creation of deferred and target GL accounts.
S_ALR_87012360 Program to transfer the amounts posted in deferred tax account to the actual tax account (Scenario: Multiple service tax lines to single target service tax line)
Program: RFUMSV25
S_AC0_52000644 Program to transfer the amounts posted to the deferred tax account to the actual tax account (Multiple service tax lines to multiple target service tax lines)
Program: RFUMSV50
a) Creation of 3 deferred Service Tax GL accounts for Base, Education cess and Higher education cess with the following parameters:
– Update the tax category with “<” (Input Tax account)
– Select the checkbox “Open item management”
– Select the checkbox “Line item display” with appropriate sort
b) Creation of 3 Target Service Tax GL accounts for Base, Education cess and Higher education cess with the following parameters:
– Update the tax category with “<” (Input Tax account)
– Do not select the checkbox “Open item management”
– Select the checkbox “Line item display” with appropriate sort key
c) Ensure to check whether the following Business Transaction Events are active in FIBF transaction code:
Path: SPRO -> financial accounting -> Financial accounting Global settings -> Tax on Sales / Purchases -> Basic settings -> India -> Activate Business transaction events (or) FIBF transaction code
Click Settings -> P/S modules -> …of an SAP application
1) 00001025 – CREATE_DEFTAX_ITEM
2) 00001030 – SET_DEFTAX_ITEM
3) 00001040 – CREATE_DEFTAX_ITEM_REVERS
4) 00001050 – CREATE_DEFTAX_ITEM_MR1M
d) Check the tax procedure, condition types and its relevant account keys. Create them if it is not available before
Path: SPRO -> financial accounting -> Financial accounting Global settings -> Tax on Sales / Purchases -> Basic settings -> Check Calculation procedure -> Define Condition types or OBYZ transaction code.
e.1) Creation of JSRT Condition type for A/P Service Tax base
e.2) Creation of JEC3 condition type for A/P ECS for Service tax
e.3) Creation of JES3 condition type for A/P HECS for Service tax
Path: SPRO -> financial accounting -> Financial accounting Global settings -> Tax on Sales / Purchases -> Basic settings -> Check and Change settings for Tax Processing
g) Updation of these condition types and account keys in Tax procedure
Path: SPRO -> financial accounting -> Financial accounting Global settings -> Tax on Sales / Purchases -> Basic settings -> Check Calculation procedure -> Define Procedures or OBYZ transaction code.
Ensure to maintain routine 166 in requirement type column for Education cess and higher education cess condition types. This is mainly to transfer the amount from deferred tax base to target tax base, deferred tax Ecess to target tax Ecess and deferred tax HEcess to target tax HEcess
Path: SPRO -> financial accounting -> Financial accounting Global settings -> Tax on Sales / Purchases -> Basic settings -> Assign Country to Calculation Procedure
Ensure to update the same tax rate in both deferred and target tax codes.
Target Tax code – TI
Here in the properties, we can update tax type as V and update COA details in tax accounts
j) Deferred Tax code – DI (Ensure to put Target tax code TI in deferred tax code properties tab in “Target tax code” field)
k) Process: Vendor Invoice Full or Partial with payment
– Company code
– Document number (Optional)
– Fiscal year
– Time Frame (Mandatory) – specifies the posting date
– Posting period, Tax code, GL account, vendor and customer (optional for further selection)
– Select Test run first and then in update run.
– Select currency translation date as Transfer Posting date
– In update run, select the posting parameters check box “Transfer Posting” and provide session name, document type, posting date and document date.
Also attached herewith document with screenshot for reference.
FollowLikeRSS Feed
Alert Moderator
Assigned Tags
SAP ERP
deferred tax
deferred tax in sap
service tax
tax
Similar Blog Posts
LTMC for Master Data Step by Step Process
By Ruthvik ChowdaryApr 26, 2019
Defer Update of SAP Business ByDesign mobile app
By Jan MatthesAug 11, 2021
Inter-company STO with SD Delivery, Billing & LIV
By Satish BabuSep 05, 2013
Related Questions
Real Estate accrual/deferral postings config
By Former MemberJun 18, 2008
SAP Accrual, Deferral & Reverse Accrual Posting Entries
By Former MemberAug 05, 2012
Deffered tax transfer amount is not displaying in j2iun
By Ajeesh .sSep 03, 2013
Join the Conversation
SAP TechEd
Tune in for tech talk. Stay for inspiration. Upskill your future.
SAP BTP Learning Group
SAP Business Technology Platform Learning Journeys.
Coffee Corner
Join the new Coffee Corner Discussion Group.
6 Comments
You must be Logged on to comment or reply to a post.
Earla Lokesh
November 11, 2015 at 8:34 am
Hi Dwarak,
This document is useful for one of my requirement. You have writtern the Deffered tax process very clearly and easy understandable way.
Thanks a lot for this information
Regards,
Lokes Earla
Like 0
Share
BHARATH KUMAR C
June 2, 2017 at 11:00 am
Hi,Many thanks for your note.Is there attachment available as mentioned.If yes please share.
Like 0
Share
Kapil Mehta
August 27, 2020 at 7:03 am
Hi We have performed configuration as per steps mentioned above. However when we execute RFUMSV50, in output we get "List contains no data". Not sure why this is happening. We checked DEFTAX_ITEM table, it contains line items. Also referred to notes 1859099 & 1800344. Please let me know how to resolve issue.
Like 0
Share
Neelam Joshi
October 7, 2020 at 7:24 am
Was this resolved?
Like 0
Share
Kapil Mehta
October 7, 2020 at 7:31 am
Yes. Few things to be ensured -
Tax code should have % in FTXP
Time frame date should include Payment posting date.
Payment should clear invoice.
T007DT-BANKO field should be blank (deferred tax rule config)
If required note 2652058 , 2692433 , 2693995 , 2779149 , 2842130 should be implemented
Like 0
Share
TVSI CONSULTANTS TVSI CONSULTANTS
September 25, 2020 at 12:43 pm
While executing the report RFUMSV50, we are also getting the same error 'Line contains no data'. Can anyone send step by step process.
Regards,
V Subramanian.
Like 0
Share