Playlists Manage
Log in to create a playlist or see your existing playlists.
Log inHow 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.