Updating supplier cards through import

Question

Hi all,&nbsp;I'm trying to update supplier cards in bulk however, when I import the applicable fields are not updated - (it says the import has been completed - no error in importing)If I run it through as new information it creates duplicate cards with the required information, so I assume there isn't anything wrong with the file itself.&nbsp;I'm matching the cards using Co./Last Name as we don't have specific Card IDs&nbsp;Any suggestions?&nbsp;

mike_james · Answer

Hi&nbsp;jess23&nbsp;, what fields are you looking to update? Are you able to post a sample of the file you are importing? Note that this is a public forum.&nbsp;&nbsp;The import process cannot (for example) remove content from fields, ie make them blank.

jess23 · Answer

Hi Mike,&nbsp;These are the fields I'm trying to update;

mike_james · Answer

Hi&nbsp;jess23&nbsp;, I can't see that image unless a moderator approves it. Can you attach the image to another post?

jess23 · Answer

Hi Mike,&nbsp;Sorry about that. New to the community boards.&nbsp;Import Fields are;Co./Last NameCustom Field 1Addr 1 - Line 1Addr 1 - Line 2Addr 1 -&nbsp; CityAddr 1 - StateAddr 1 - PostcodeAddr 1 - EmailAddr 1 - Phone No. 1Addr 1 - Fax No.A.B.N.Credit LimitTax CodeTerms - Payment is Due&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- % Discount&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- Balance Due Days&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;- Discount DaysPayment MethodBSBAccount NumberAccount NameStatement TextRemittance MethodRemittance Address&nbsp;

mike_james · Answer

Hi&nbsp;jess23&nbsp;, which of those listed fields contains amended information that is not being updated?

Forum Discussion

Updating supplier cards through import

7 Replies

Related content

Since the last update Supplier invoice is not recognising the supplier preferred GST code

SUBSCRIPTION UPDATE REQUIRED

Update Contact Details

Update Superannuation details

Business unavailable due to updates

Bank feed not updating

Record Supplier Payment

Supplier Credit showing inventory error