Dynamics 365 Business Central

Question

Why am I receiving the below error message when trying to bulk upload invoices from Excel to Business Central using Sharperlight tool? I have never received this error before and I am only receiving it now for newly set up vendors.

"Buy-from Vendor No. :

The value 'V001318' is invalid.

Record 37

Input!$A$38"

Thanks in advance.

Answer 1

Dear @Georgia Griffiths,

Regarding your question about bulking upload invoices from Excel to Business Central using Sharperlight tool. For you to be assisted properly, please reach out to Dynamics 365 Business Central community forum. The reason I am asking you to post a new discussion is that in the Questions – Microsoft Q&A, we have limited resources and very few resources to test this feature and in Dynamics 365 Business Central community forum, you will get the most qualified group of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction. Thank you for your cooperation and understanding. Feel free to post your questions in the Microsoft community and we will always do our best to help you!

Have a good day!

Answer 2

The error indicates that the value in the Buy-from Vendor No. field (V001318) does not match a valid vendor number in Business Central for the company and environment that Sharperlight is writing to.

In Business Central, fields like Buy-from Vendor No. must reference an existing vendor record. When bulk-uploading from Excel via an external tool, typical causes are:

1. The vendor V001318 does not exist in Business Central.
2. The vendor exists but with a different No. (for example, a typo or different numbering format).
3. The vendor exists in a different company than the one Sharperlight is targeting.
4. The vendor was just created and the Sharperlight metadata/cache has not been refreshed, so the tool does not “see” the new vendor yet.

To resolve:

1. In Business Central, open Vendors and confirm that vendor V001318 exists and is not blocked.
2. Verify that the No. in the vendor card exactly matches the value in Excel (no extra spaces, correct case/characters).
3. Confirm that Sharperlight is pointing to the same company in Business Central where the vendor is set up.
4. Refresh/reload the Sharperlight query or metadata so that newly created vendors are recognized.
5. Re-run the upload for the affected records only (e.g., starting from Record 37 / Input!$A$38 where the error is raised).

If the vendor is missing, create it in Business Central first (or correct the vendor number in Excel) and then repeat the upload.

---

References:

• Frequently asked questions about using Business Central