BWAccess APV city state import

Posted By Steve Rice 5 months ago

I am importing an Accounts Payable Vendor to BusinessWorks. The file is a comma delimited file. The definition says to send city and state abbreviation a City, ST for example Hastings, MN. When importing, this adds the city as "Hastings" and the Zip code as "MN". Zip code is the next field. Since we are adding a comma for the state abbreviation to a comma delimited file, BWAccess saves the state abbreviation as the zip code.

Please advise how to write this data so that the city saves to the City field and state abbreviation field to the State field.

Thank you.

Top Replies

Coleen Graber 5 months ago +1

Steve-

I would try sending them as separate fields for city and state. Despite the examples in the article, the import instructions for importing vendors, on the Vendor Import Format page, it has the city…

0 Vince Settipane 5 months ago

Do an limited (10 records) EXPORT of the Accounts Payable Vendor as a test file. It should help line up those commas.

BusinessWorks expects a Comma separated Text file with quotation marks surrounding for the data. /U,"DATA","DATA", etc

I aslo have on a CSV editor CSVed 2.57 (freeware) 2023 - medium learning curve

https://home.hccnet.nl/s.j.francke/csved/index.html

File view in CSVed

File view in Notepad++
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Coleen Graber 5 months ago

Steve-

I would try sending them as separate fields for city and state. Despite the examples in the article, the import instructions for importing vendors, on the Vendor Import Format page, it has the city and state as separate fields.

Here is a link to the import instructions: How to import vendors

Sincerely,

Coleen
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage BusinessWorks

BWAccess APV city state import

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING