Page 1 of 2

allocating stock by cost price

Posted: 15 May 2007, 10:08
by daz9643
I know line 50 works by FIFO when allocating stock and also when you run a stock valuation it works out the average cost price. I've looked at various add-ons and most people say its not possible to hold stock and allocate stock by the cost price.
Does anyone know of an add-on that can do this ? If not, can anyone suggest an alternative accounts package that does everything that line 50 does plus this option ?

Posted: 23 May 2007, 11:38
by brucedenney
Line 50 does not works on the actual cost price of items based on FIFO.

It is unclear what you are looking to do, or what the issue you are trying to address is.

Stock valuation

Posted: 21 Feb 2008, 15:28
by daz9643
We need to be able to value our stock by batches. If we receive 100 plugs at £1 each and then we recieve another 100 plugs at £2 each we want to be able to allocate the stock we bought in at £2 to an order before we allocate the £1 stock. We need a report which shows 100 plugs with an average buy price of £1 and another line showing 100 plugs with an average buy price of £2, we do not want one line showing 200 plugs with an average buy price of £1.50. Hope this make sense.

Posted: 01 Apr 2008, 14:06
by brucedenney
You could set up multiple product codes one for each batch.

PART001-B01 Plugs
PART001-B02 Plugs
PART001-B03 Plugs

You then sell the different products to customers, the only oddity would be that occasionally you would get 2 or more batches assigned to one order so someone ordering 100 of an item might get

25 of PART001-B01 Plugs
75 of PART001-B02 Plugs

-----------------------

Sage works on a FIFO basis, there is no way to change that, the cost of the goods is written on to the invoice when the goods leave stock.

I guess using "tools", it might be possible to change the order in which things are used. The stock transactions are not really very editable through the UI so not sure how you would identify / pick stock even so.

Unless you had simple rules, like always use the most expensive stock first, or are prepared to spend some serious money, I don't really hold out a lot of hope.

allocating stock by cost price

Posted: 01 Apr 2008, 14:14
by daz9643
hi, thats how we do it at the moment but it makes it a bit more difficult to check what stock you have available for a particular part as you have to check each record. Some of our products have more than 10 different buy prices.

Re: allocating stock by cost price

Posted: 21 Aug 2012, 09:53
by daz9643
I don't suppose this issue has been addressed by later versions of Sage ?
I notice the thread has had over 3500 views so i can't be the only person who wants to be able to do this.

Re: allocating stock by cost price

Posted: 25 Aug 2012, 20:35
by leyburnsolutions
It has not changed in later versions.

John

Re: allocating stock by cost price

Posted: 27 Aug 2012, 07:32
by brucedenney
The method of counting page views is pretty lame. If you set auto refresh every 5 seconds on your browser and leave it pointing at the topic, it will get the page count to 3500 in under 5 hours.

I doubt many people have stock that has multiple wildly varying cost prices, even if you could allocate a specific cost price you would not be able to identify which item it was when it came to shipping it.

I do not understand why you would want to pick the cost of the stock to use. The cost of the items is the cost of the items, a pick and choose system, could lead to financails being unrepresentative of the actual. I can understand wanting to average out the stock price, but can see no justifiable reason to pick the cost price when you sell an item.

Re: allocating stock by cost price

Posted: 27 Aug 2012, 10:13
by daz9643
Hi Bruce, it's not so much that we want to allocate stock at a certain buy price to an order, it's because we have to report to our franchise partners how much stock we are holding and at what price we paid. If our franchise partners did not want this information then it wouldn't be issue.

Re: allocating stock by cost price

Posted: 28 Aug 2012, 11:27
by brucedenney
I don't see anything that should stop you being able to report what stock holding you have and how much you paid for it.

The stock valuation report(s) do that already (in different ways).

If you need a detailed version that itemises each batch, see attached

Re: allocating stock by cost price

Posted: 29 Aug 2013, 15:01
by sam500600
brucedenney wrote: If you need a detailed version that itemises each batch, see attached
Hi Bruce,
I am using sage 50 Accounts Professional 2011 v17.0.15.208.
In my reports section I can not see Product detail report,
Where can I find Detailed Product Valuation report ?
Pls can you give me

Thanks,
Sam

Re: allocating stock by cost price

Posted: 03 Sep 2013, 16:33
by brucedenney
The report attached earlier does not exist in Sage 50. It is a report I wrote/modified.

Re: allocating stock by cost price

Posted: 06 Sep 2013, 16:20
by sam500600
brucedenney wrote:The report attached earlier does not exist in Sage 50. It is a report I wrote/modified.
Please can I get srt file

Re: allocating stock by cost price

Posted: 10 Sep 2013, 09:57
by brucedenney
it is not an srt file it was written with the new report designer for V2007 and later so is a .report file and will not work with versions before V2007
It was written against V2012 data but I can't see anything in it that would make it not work with earlier versions.
Let me know if you have any issues with it.

Re: allocating stock by cost price

Posted: 12 Sep 2013, 11:13
by sam500600
Thanks Bruce,

in this report is it possible to further get breakdown of USED quantity of individual record ?
means running balance after each sales transaction of balance goods.