SAP Knowledge Base Article - Public

1950757 - How to Differentiate Tax Returns Posting to Payable's or Receivable's G/L Account.

Symptom

You need VAT being accounted in separate G/L Accounts, when it regards Tax Payable account, depending on if it is a VAT receivable or payable.

Environment

SAP Business ByDesign.

Reproducing the Issue

  1. Go to Tax Management WoC.
  2. Go VAT Returns view.
  3. Show the reported tax with relevant payment.
  4. Choose the relevant Reported tax return.
  5. Click View button.
  6. Scroll-down the screen and open the related Journal Entry.

You will see that postings will happen to the same G/L Account for Tax Payment even if the tax return is either receivable or payable.

You may verify the concerned G/L Account  by following the below steps:

  1. Go to Business Configuration work center.
  2. Go to Overview view.
  3. Search for Charts of Accounts, Financial Reporting Structures, Account Determination.
  4. Open the activity and go to the Tax ledger.
  5. Go to Tax Payments tab.
  6. Refer to the Tax Payable column.

Cause

It is the expected system behavior VAT payable/receivable being accounted to the same G/L Account.

For the Tax Payments, Tax subledger, configuration, the system does not allow adding a second G/L Account for this tax account determination, since it is not possible to further differentiate this account via account determination groups. Therefore, the net payable or receivable will be moved only to the same G/L Account maintained as per the steps in the above section of this KBA (Knowledge Base Article).

Resolution

It is currently no possible to move the net payable or receivable to different accounts.

If you need the payable and receivable in separate G/L account, this has to be done manually through a Journal Entry Voucher.

Journal Entry Vouchers can be created via

  1. General Ledger work center.
  2. Journal Entry Voucher subview, under Journal Entry view.  

 

Keywords

Tax Payment. Tax Management. Receivable. Payable. VAT. Sales and Use. Tax Return. , KBA , vat , g/l accounts , SRD-FIN-GL , General Ledger , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1811