Hi,

How to get the effective Business Partner Tax Number in Report?
Below scripts would display the first Business Partner Tax Number and did not consider whether it is the effective Tax number or not.

|Declaration
domain tcfovn r.fovn

before.tfacr200.itbp.10:
before.layout:

SELECT tctax400.*
FROM tctax400
WHERE tctax400.bpid = :tfacr200.itbp
ORDER BY
tctax400._INDEX1
AS SET WITH 1 ROWS
SELECTDO
r.fovn = tctax400.fovn
SELECTEMPTY
r.fovn = ""
ENDSELECT

Please help.

Thanks.

There is a standard dll function for this in txtaxdll4100..

Hello,
use tctaxdll4100

Library tctaxdll4100

DLL for Tax Numbers by Business Partners

(22 Functions available)

e.g.

tctax.dll4100.business.partner.has.tax.id( domain tccom.bpid i.business.partner, domain tcccty i.country, domain tcdate i.trans.date, ref domain tctax.txnb o.tax.number )




or

in your select:

bpid, Country, efdt, exdt

Regards