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

How can i setup a purchase price on an item per vender per location?

(0) Share

Report

Posted on by laurabowie

I have a client that has three separate warehouses and they may buy the same item from a Vendor who charges differently depending on which warehouse it is for.

For example they have bread that they buy from Vendor1 and it costs 35p if it is for their Berlin warehouse (location) but is 56p to go to Dusseldorf. Can anyone advise how I can set this up in BC as currently all I can see is that for an item we can enter different prices per Vendor but not location as well. It looks like the only way would be via customisation and adding the location to the purchase price list on the item.

Can anyone advise whether it is possible without customisation at all? or have I missed something entirely?

Thanks in advance

Laura

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

I looked and you are right it is not possible to define price per vendor/location. At least I could not find a method for it.

Some idea could be:

1) Use Item Variant then have variant such as Berlin / Dusseldorf. this was you can setup different price for variant. the downside is you will have a item variant in inventory.

2) Create Buy From - Bill Vendor. Like have one vendor but have Berlin / Dusseldorf vendor as well. But select top vendor in these two new vendors as HQ then all bill will go to them. Now you can set different pricing for each vendor. Also, in stockkeeping you can define which vendor for witch location.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Laura,

You are correct that the Item Purchase Prices, from a Vendor, cannot be setup by Location. However, they will be noted and reflected using the SKU setup so you will see that a Unit Cost in 1 Location will be different from another.

Are you wanting this just to have the prices setup? I would say setting the Vendor up separately, like MahGah noted, would be the simplest solution, if you want to enter the Purchase Prices. Then you have no issue but you will have to make sure you select the correct Vendor, per Location.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
TOCDCO 98 on at

Like (1)

Report

Just pointing out that the pricing uses the vendor that is getting the bill assigned. So if I have PARENT-SUB and I have invoices going to PARENT. Then when I choose to get a PO and select SUB, the pricing for PARENT is used since that is the location invoicing with.

Was this reply helpful? Yes No
RustyAustralis 202 on at

Like (0)

Report

It sounds like your vendor is using freight inclusive pricing terms hence the variation based on location. You could in theory always price ex-warehouse and add shipping separately.

we ourselves have a tenant customisation where we have an additional table that adds/removes price surcharge or discount depending on destination location - this is set by default at location, but can have exceptions for items.

questions would be:

- do all items have same difference in pricing between locations

- do you also drop ship or always stock your own warehouse

- how often do your prices change

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

In the inventory setup you can also define that average cost price should be calculated per location.

So the system will always calculate the correct cost depending on the location you are selling from.

Was this reply helpful? Yes No
TOCDCO 98 on at

Like (0)

Report

no that’s calculating cost averaging…

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

And that is exactly what i said it was.

Was this reply helpful? Yes No
TOCDCO 98 on at

Like (0)

Report

Which doesn’t help solve anything in this thread really

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

And I guess we disagree on that.

My point is that even if you can not have a separate price list for purchase prices per location. The system will handle that there is actually a difference in the cost price per location posted through purchase invoices. In that way the system makes sure that the cost of goods soled always is correct and according to what is posted on the purchase invoices.

Was this reply helpful? Yes No