The following code is to get the GST Number of the Vendor.
select vendtable1 where vendtable1.AccountNum==vendtable.AccountNum
join dirPartyLocation where dirPartyLocation.Party == vendtable1.Party
join logisticsLocation where logisticsLocation.RecId == dirPartyLocation.Location
join taxInformation_IN where taxInformation_IN.RegistrationLocation == logisticsLocation.RecId
&& taxInformation_IN.IsPrimary == NoYes::Yes;
tmp.vendorGSTINNumber = TaxRegistrationNumbers_IN::find(taxInformation_IN.GSTIN).RegistrationNumber;
No comments:
Post a Comment