Tax posting using BAPI - BAPI_ACC_DOCUMENT_POST

[SushmitaMichael]

Introduction:

 BAPI_ACC_DOCUMENT_POST allows you to post accounting entries like GL postings and customer or Vendor postings (FB50, FB60, FB70, FB01) but we cannot do the clearing using this BAPI. Through this blog, I like to explain to you all about the tax posting and how we must handle 0% and other payable % taxes while posting.

Scenarios:

1. Customer posting with 0% and 5% tax posting.
2. GL posting with 0% and 5 % tax posting.

Procedures:

1. Go to SE37 execute – BAPI_ACC_DOCUMENT_POST.
2. Document header – To fill in all header details.
3. Account GL – To fill GL accounts with taxes depending on the scenarios.
4. Accounts receivable / Accounts payable – To fill in customer/vendor posting.
5. Account Tax – To fill for all tax line items.
6. Currency Amount – Enter amount for all line items.
7. Commit Posting – BAPI_TRANSACTION_COMMIT.

Scenario 1 – Customer Posting with 0% and 5% tax posting:

 It is mandatory to fill in all header details and account receivable details related to a customer.

For 0% tax, as it is nil tax there is no need to fill in details in the Account Tax table, but we need to provide the tax rate only in the Account GL table which should have an impact In F.12 report.

For other % taxes, it may be 5 or 10% it is mandatory to provide tax code details in the Account GL table and tax details in the Account Tax table. Let’s see the test scenario via the below screenshots.

0% Tax rate Scenario – Customer Invoice

These are some mandatory header details to be filled.

Item 1: Accounts receivables

Item 2: Account GL – As mentioned above for 0% or nil tax it is enough to maintain the tax code here.

Currency amount to be filled for items 1 – Accounts receivable to be debited & item 2 – Account GL – Revenue account to be credited. The negative sign to the amount will identify the credit value. The amount with positive will be the debit value.

For posting documents, we need to Commit the function module using BAPI_TRANSACTION_COMMIT

Se37 – Menu – Function module – Test – test Sequence.

After Executing – Press back.

Impact on F.12 Report:

5% Tax rate Scenario – Customer Invoice

Item 1 – Accounts Receivable

Item 2: GL accounts with tax rates

Item 3 – Account Tax – As I mentioned earlier other than 0% and nil Tax, the tax account details to be filled account tax table.

Currency Amount – for the tax rate payable – in currency amount table 3-line items will be maintained. First-line item will be the customer item with the debit value along with the tax amount. Second-line item will be a GL item with a credit value followed by a negative amount. Third-line item will be the tax item with a negative tax amount and in the amount base field, the tax base amount must be maintained positive.

As earlier, we need to commit and post the document.

Impact In F.12 Report:

Scenario 2: GL posting with 0% and 5 % tax posting.

Here in GL posting, we going to post both 0 and 5% Tax rates in the same document. Let’s see its impact.

Now I am going to post the revenue receipt GL posting. The entry will incoming bank GL will be debited, and revenue accounts will be credited.

Bank a/c Dr

Revenue1 a/c Cr – 5% tax rate

Revenue2 a/c Dr – 0% tax rate

Header details

Account GL – As it is revenue receipt posting, all 3-line items will be fall under this category.

In account, GL tax code (0&5%) must be entered in both revenue GL. In the Account tax table, it is enough to provide details only for tax 5%.

Item 1: Revenue1 GL – 5%

Item 2: Revenue2 GL – 0%

Item 3: Bank GL

Account Tax: The details will be maintained only for a tax rate of 5%.

Currency amount: The First line item contains a 5% tax rate for which line item 4 contains tax value and its base amount. The second line item contains a 0% tax rate revenue item, and the third line item will be the cumulative value of bank GL with debit value.

As in like the previous posting we need to commit and post the values.

Impact of Taxes on GL Posting:

Conclusion:

I hope I have explained in detail the BAPI account posting with taxes. This blog will be helpful for all who use BAPI posting along with taxes.