Small and medium business | Business Central, N...

Upload vendor part numbers and price list

(0) Share

Report

Posted on by Yacht master Jim

i would like to upload a vendor product part number and price list into my system

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Marco Mels Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

What is the question related to this, is there an error?

Thanks.

Was this reply helpful? Yes No
Suggested answer

JAngle 152 on at

Like (0)

Report
Copy link

Link copied!

A few of ways to achieve this all of which could be done with configuration packages - link here: https://docs.microsoft.com/en-us/dynamics365/business-central/admin-how-to-prepare-a-configuration-package

On an item you have the "Vendor Item No." on the item table itself

Or you can use the Vendor Item Catalogue, which you reach from the item card with the button shown as "Vendor". I like this one as it gets used in the planning worksheet, requisition worksheet or order planning pages:

The last place you can use is the Item Cross Reference Table which has a few more fields to use but it means you can add items to a purchase order with it instead of your internal number:

Was this reply helpful? Yes No
Yacht master Jim 5 on at

Like (0)

Report
Copy link

Link copied!
Thank you for the response. This got us in a better direction. Let me provide more detail:

We have a new vendor price list which includes "Items" that are non-stocked and "Items" that are stocked. Our goal is to upload the new vendor price list via a configuration file. We believe our Pro Services vendor used Configuration File "BIN CONTENT" to upload our original multi-vendor inventory list we carry in stock on shelf (eg. Bin).

Here is the BIN Content screen:

How do we upload a vendor list to update our current stocked (aka on shelf BIN items) and non-stocked Items, while at the same time updating the pricing for items already uploaded into Business Central with the current vendor pricing? Our goal is to have every vendor part number as an Item in Business Central so we can search and price each Item when building Quotes and Sales Orders.

Was this reply helpful? Yes No