FrontAccounting forum — When purchasing an item, how to choose the cheapest supplier?

Re: When purchasing an item, how to choose the cheapest supplier?

2019-06-29T18:51:37Z

I agree. Provided that something like that would be implemented in FA, I think this could greatly benefit the handling of PO's. It would at least save time that you would otherwise need to spend finding the cheapest supplier for the article(s) you're going to order. (That is, in case you work with multiple suppliers for a certain article.)

Re: When purchasing an item, how to choose the cheapest supplier?

2019-06-29T14:31:59Z

Then, FA would need some automatic means of assimilating the current purchasing price whenever it changes from the vendor end. Something like the daily Exchange rates!

Re: When purchasing an item, how to choose the cheapest supplier?

2019-06-29T08:17:16Z

I would prefer FA to show me the current purchasing price, instead of the historical price based on past PO's.

Re: When purchasing an item, how to choose the cheapest supplier?

2019-06-28T16:16:31Z

To start with, we can make a report that lists the supplier in descending order of price for a specific item. If the last purchased price is very long ago, it will distort the order's inference. Hence a last purchased date too will need to form part of the report.

Re: When purchasing an item, how to choose the cheapest supplier?

2019-06-28T15:46:23Z

In the current version of FA, is the above sketched workflow possible?

Re: When purchasing an item, how to choose the cheapest supplier?

2013-03-07T23:16:47Z

apmuthu, that is exactly what I mean.

Re: When purchasing an item, how to choose the cheapest supplier?

2013-03-07T16:17:04Z

Probably what he means is that when ordering, we may not know which supplier has the cheapest price (or whatever criterion).

A page where an item can be selected and a list of suppliers with their prices can popup and one can be chosen. Many such line item pairs with respective quantities can be entered and then all the purchase orders can be generated in one stroke!

Item1 Supplier1(with Price) Qty1
Item2 Supplier1(with Price) Qty2
Item3 Supplier3(with Price) Qty3
Item4 Suppier1(With Price) Qty4
etc.,
Generate All PO.

Re: When purchasing an item, how to choose the cheapest supplier?

2013-03-06T16:40:28Z

The thing is when you enter a PO, you already have chosen the supplier, so it doesn't really make sense to chose the supplier afterward. However you can check the supplier prices with Items/supplier prices, make up your mind and then place the appropriate orders to each supplier.

/Elax

Re: When purchasing an item, how to choose the cheapest supplier?

2013-03-02T18:02:27Z

It would be nicer to view all prices in same units of qty and currency for comparison and listed sorted in ascending prices!

When purchasing an item, how to choose the cheapest supplier?

2013-02-24T09:05:43Z

Let's take item nr. 1001 as an example. I can purchase this item from 5 different suppliers:

Supplier A: $ 0.90 / piece
Supplier B: $ 9.90 / dozen
Supplier C: $ 5.28 / box of six
Supplier D: $ 86 / per 100
Supplier E: € 650 / per 1.000

It would be nice if the Purchase Order Entry would offer an option like this:

First enter the item code.
Then show me a list of suppliers for this item, price according to "Purchasing Pricing", and price per piece (to our UOM and currency).
Then let me change the order of the list to (f.e.) cheapest supplier (per our UOM) on top.
Then let me place a Purchase Order for this supplier.

In this case, the list would look like this:

Item: 1001 (1001 - Paint can)

Supplier Price Currency Supplier's Unit Supplier's Description Price (our UOM/our currency)
B 9.90 USD per dozen Paint can (12) 0.825
E 650.00 EUR 1.000 Paint can 1.000 pc 0.858
D 86.00 USD 100 Paint can /100 pcs 0.860
C 5.28 USD box of 6 Paint can, 6 in box 0.880
A 0.90 USD a piece Paint can 0.900

As far as I can see, FA doesn't support this workflow. Or does it?