Skip to main content
J
Japan2023
September 19, 2023
Solved

I would like to get our supplier data which is additional info.

  • September 19, 2023
  • 1 reply
  • 0 views

I would like to get the supplier data by Excel which is including below ID No.

 

<Supplier Data>

Additional info

Taxes
Business ID No. / Social Insurance No.

 

Could you please teach me how I can get it?

Thank you so much for your help in advance.

Best answer by Fiat Lux - ASIA

You can only allow to extract like this one

 

TitleCompanyNameFirstNameMiddleNameLastNameSuffixDisplayNamePrintOnCheckNameAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryWebSiteTaxIdentifierAcctNumVendor1099EmailPhoneNumberMobileNumberFaxNumberOtherNumberSalesTermCurrency
 Comcast    Comcast PO Box 1190   BostonMA02109 http://www.comcast.net 11335435FALSE[email address removed](603) 555-2000(603) 555-2001(603) 555-2002(603) 555-2003  
 Verizon    Verizon PO Box 5180   NashuaNH03060 http://www.verizon.com 43220909FALSE[email address removed](603) 555-3000(603) 555-3001(603) 555-3002(603) 555-3003  
 Mary SmithMaryL.Smith Mary Smith 1313 Mockingbird Lane   HollywoodCA90027    FALSE[email address removed](603) 555-4000(603) 555-4001(603) 555-4002(603) 555-4003  

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIAAnswer
September 19, 2023

You can only allow to extract like this one

 

TitleCompanyNameFirstNameMiddleNameLastNameSuffixDisplayNamePrintOnCheckNameAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryWebSiteTaxIdentifierAcctNumVendor1099EmailPhoneNumberMobileNumberFaxNumberOtherNumberSalesTermCurrency
 Comcast    Comcast PO Box 1190   BostonMA02109 http://www.comcast.net 11335435FALSE[email address removed](603) 555-2000(603) 555-2001(603) 555-2002(603) 555-2003  
 Verizon    Verizon PO Box 5180   NashuaNH03060 http://www.verizon.com 43220909FALSE[email address removed](603) 555-3000(603) 555-3001(603) 555-3002(603) 555-3003  
 Mary SmithMaryL.Smith Mary Smith 1313 Mockingbird Lane   HollywoodCA90027    FALSE[email address removed](603) 555-4000(603) 555-4001(603) 555-4002(603) 555-4003  
J
Japan2023Author
September 19, 2023

Dear  Fiat Lux,

 

Thank you for your comment.

There are the data field on QB supplier details as "Additional info",

But can't we take out the data by Excel or Report even put the data?
Is it mean If I would like to get the information by Excel or Report, it should be moved the data to other field which accept allow out the data?

 

Thank you so much for your help.

 

Best regards,

Terms & ConditionsAccessibility statement