on 01-04-2023 4:30 AM
Dear Experts,
We tried to fetch the withholding tax details by joining OCRD and OWHT tables for individual business partners and returning with no data.
Can anyone be of any help as to how can we retrieve or fetch the data?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Business Partner's 'withholding tax %' is a column of the OCRD table. Try :
SELECT
Cardcode,
CardName,
DdctPrcnt
FROM OCRD
If you need 'Withholding Tax Deduction Group', that is DdgKey which is link to ODDG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.