Back

Importing Purchase Price

The Master Data Import Worksheet
Video 23/25
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Master Data Information" which is available at Microsoft AppSource. Click to visit AppSource. Master Data Information
Open Playlist
Presenter: Jesper Nielsen, Senior Consultant, Head of Onboarding, Team Manager BC

How to import purchase prices in the master data import worksheet?

Now, I want to import the purchase price from different vendors.

This is what happens in the video

So I go to the master data import worksheet and I select new and I say import data.

So I have to choose the templates with the purchase prices and that will be the purchase price and I have to select the Excel file where I have the data stored and that would be the purchase price right there.

Choose my import template where I have the data stored that sheet in Excel and I say, okay.

So here I have my purchase price templates and action message is create and I have the lines accept action message where the lines were the checkmark are going to be handled when I say okay in a minute.

So I go to new and I say carry out actions.

Update existing master data and it says that import is successful on all lines so we can go to item called 1310 and we can search the item, we can see that the prices have got in 1310.

So I have more options and on navigate, I have special purchase and discounts and we have the three prices in here on the minimum quantity that we imported.