Instead of customer account, Expense GL should hit for Tax amount in FOC sales

[trinath80]

Hi All

I have a below requirement.

We have a process which similar to FOC Sales.

Order-Delivery + Billing with net value 0 but Tax should be calculated on the Invoice but should not debit the customer account instead it should hit the some Expense GL account which company provide it. 

Since the product is sample customer will not pay but it is taxable and company should pay the tax to the Govt. Please let me know if you need any further details. by adding the R100 we are making the net value zero.

e.g. below 

I tried in Google to find out similar requirement post but did not find helpful solution to the above. Please share the link if the similar issue was discussed before in SCN.

Small edition to initial post. The accounting entry should be as below. Please let me if this can be achievable if yes, what setting needs to be done?

Thanks!

[sanilbhandari]

Hi @trinath80 

I saw your post which says you want the accounting entries to be shown as:

Customer A/c Dr

Revenue A/c Dr

VAT Expense A/c Dr

         To Customer A/c Cr

         To Revenue A/c Cr

         To VAT Payable A/c Cr

If there a legal requirement for such a flow? Why would you show a FOC Sale to revenue?

Ideally, for FOC sale to calculate the tax, you would move tax condition after VPRS and than do a new condition type with 100% discount after the tax condition in your pricing condition. You could make the tax condition type as accrual so that it posts the tax as you want.

The below question answered in the past, might be of help for FOC Related pricing.

Solved: Free of charge item tax calculation - SAP Community

Thanks & Regards

Sanil Bhandari

[trinath80]

Hi SAnil, sorry for late reply! we are able to calculate the tax even though net value zero based on setting in Pric procedure. There is no issue with this. Only issue customer account should not be debited for the tax amount. The account entry should be as above in initial post

[shyamsumar]

Create a new condition table with Field AUART (Sales Order Type) and relevant accounting keys and maintain respective GL account..

Follow steps mentioned in below answer to include this field in Field catalog -

https://community.sap.com/t5/enterprise-resource-planning-q-a/revenue-account-determination-based-on...

[trinath80]

Thanks Shyamsumar for your reply! We have no issue with Revenue amount which is getting nullified with same Revenue account. Here customer account should not be debited, instead some Expense GL should be debited. Not sure how the above solution helps here( creating new table with sales order type as one of the field and maintain VKOA setting)

[trinath80]

Are you talking about to define a new table with sale order type key combination in Reconciliation Account determination procedure and maintain GL with this table so system determine this GL only when FOC sales is created and for other sales normally customer account is debited?