Back

Excel Template ready to import Sales Price

The Master Data Import Worksheet
Video 20/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 sales prices with the Excel template?

In this video, I will go through the Excel import template for sales prices.

This is what happens in the video

Sales prices are used if you want to sell your items to your customer to slightly different prices or you have a campaign or something like that.

So we have the fields in the top that we should import and you can see if they are filled out with red, it means that they are required as a minimum or they are mandatory.

If they have a grey background, it means it looks into an underlying table where data should be stored and if it is bold like this, it is an option that should always be in English captions.

So let’s go through.

We have the item number down here, which of course means you have to have items in your database.

Sales type, in this case, all customers and customer and we can look into the lookup values to see what we can choose between.

See customer, customer price group, campaign, and all customers as well as for the other things we have later on, and we have the sales code.

In this case, we have no sales code on all customers but on this single customer down here, we have a sales code and that refers to the customer number.

So the customer should also be imported.

Starting date if you have a period in your campaign for the customers.

The currency code if it’s for a limited currency you have this campaign.

The variant code refers to your items if you have any variance.

The unit of measure, not required, but if you want to tell what it’s all about, example down here, we have to tell that it is pieces because we have a minimum quantity of 10 pieces, for example.

If you have any minimum quantity that you want your customers to order, you can enter it here.

A minimum requirement for getting the reduced price, of course, and we have the unit price and that’s the price that your customers can buy your items for in this campaign.

So here we have that all customers in that period if they buy in Euro, they can buy item number 1000 for 1232 Euros.

If prices includes VAT or if it’s allowed to have an invoice discount, and we have a VAT business posting group as well we can put on.

So you can also differ where you want to have your VAT posted on each line that is overriding what is on the customer and on the item.

Ending date, if we have a date that we want this campaign to end, and if we allow line discount.

So line discount and invoice discount is related to when we do the invoice.