BAPI_ACC_DOCUMENT_POST

[Former Member]

I'm having an issue with some Italian Withholding Tax requirements.

In the BAPI, it accounts for the Withholding Tax Code in the AP line item, not the detail record.

The company we are interfacing with claims that they can have Withholding Tax applied at a Detail line level.

I tried to create an ACCOUNTTAX line for the Withholding code, but received an error.

Does anybody know how I might be able to handle the Italian Withholding Tax at a Detail line level rather than a AP line level. (Right now I'm just posting on entry for the ACCOUNTPAYABLE line, that holds the entire Vendor Invoice amount).,

thanks

[Former Member]

hi

Try to use the bapi for incoming invoice

Max

[Former Member]

Thank you for your response.

It looks like this BAPI "AcctngInvoiceReceipt" still has the 'Withholding Tax Code' listed at the AP level. This does not allow me to apply this tax code to the line level.

Any other ideas, or am I looking at something incorrectly?

thanks

[Former Member]

Hi Brett,

Did you check the BAPI for an importing parameter to pass the withholding tax information. In that the with holding tax information can be passed.

Regards,

Hari

[Former Member]

Thank you,

I can try that. The difficult part is that there is logic built into the BAPI to properly process that Withholding Tax Code in the AP line. I've tested it and it works correctly to allocate the Withholding Tax amount for that Vendor.

If I pass it in another field, that logic will no longer work.

[Former Member]

sorry but I can't see the system now

But the withholding tax data have to be transfered to an own parameter, the tax data to another one.

I remember the Bapi for incoming invoice works fine

You can also try to check inside the bapi bapi_acc_document_post here u should see an user-exit (bye), perhaps u can pass withholding tax data there

Max

[Former Member]

Thanks for the response.

The Withholding Tax Code works great when I apply it at the Vendor level. I've tested it out, and it is properly calculating the Withholding amount, and allocating it for Withholding. Then when the Payment is made, the systems moves that Withholding amount to a specified account.

The problem is with this Italy requirement to have different Withholding taxes on different Line items on the invoice. I'll check for that UserExit you are describing. Aren't those specific to the SAP instance of the company you are working with?

thanks again!

[Former Member]

hi

I need to check my system but I can't now

It's not strange a vendor has several withholding tax for italy it's strange to use different withholding tax in different items of the same document

I'll try to check it

[Former Member]

I agree it seems odd.

It doesn't even look like SAP allows different Withholding Tax Codes for the same invoice. In FB60, it looks like the only place to enter a Withholding Tax code is at the Header level.

Maybe it's not possible.

If you find out anything more, please let me know.

thank you!

[Former Member]

Hi

The problem is enjoy trx FB60 allows to create only one item vendor, u should use the old trx in order to create several vendor items for the same document:

- FB01 or F-43.

Now the withholding tax are item data, not header (see the table WITH_ITEM where the data are stored).

If the extended withholding tax is active for the company (and it 's usually active), SAP allows to assign several withholding tax codes to a vendor.

I'm italian and I've been working as SAP consultant for 10 years: I've never seen your situation: different withholding tax codes for different items of the same document.

Probably the BAPI can't manage it, but it can do it by old trx FB01: that means u can try to solve by FI standard BI RFBIBL00.

The vendor data items transfered to file for BI have to be transfered by structure BBSEG and BWITH, so if a item has several withholding tax code the file should be:

- BGR00 (session data)

- BBKPF (header data)

- BBSEG (vendor item 1)

- BWITH (withholding tax code 1 item 1)

- BWITH (withholding tax code 2 item 1)

.....................................................................

- BBSEG (vendor item 2)

- BWITH (withholding tax code 1 item 2)

- BWITH (withholding tax code 2 item 2)

.....................................................................

- BBSEG (g/l item)

- BBSEG (g/l item)

.......................................................................

U need to check how the withholding tax is assigned to vendor master data (table LFBW): if the flag field LFBW-WT_SUBJCT is set, it means that withholding tax code is mandatary and you need to load it in the document.

If you don't need to use the mandatary withholding tax code in your posting: u need to tansfer it as blank record: i.e. without base amount:

CLEAR BWITH.
BWITH-STYPE = '2'.
BWITH-TBNAM = 'BWITH'.
BWITH-WITHT = LFBW-WITHT.
CLEAR BWITH-WT_WITHCD.
WRITE 0 CURRENCY BBKPF-WAERS TO BWITH-WT_QSSHB.

TRANSFER BWITH TO <FILE>.

Max

[Former Member]

Thank you this was very helpful.

They have agreed to only pass one Withholding Tax at the Invoice Header level, and not the detail level.

thanks