Monday, November 17, 2025

Vendor GST Number

 

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