Need help for this client's stock control/stock codes dilemma...

[Pragmateq]

I'm a newbie with Sage. A client of mine is in a pickle with stock levels and stock codes - if you're able to suggest a way for them to correct the predicament they're in please let me know:

----
Sage Line 50 Version: 21.5.8.176 running on Windows 7

We have a problem !

We use Sage Line 50 V21 accounts / order / purchase / delivery package and normally it works well for us but just recently I took on a contract with a LARGE electrical outlet, and it meant I have to buy in large quantities and sell out in smaller lots.

To enable us to do so we created two product databases:

SCF ( + number) to buy in
FN ( + number) to sell in

So the admin staff create purchase orders using SCF codes, the goods arrive are logged in under the SCF code and stock levels increase as per delivery.
Then they do a sales order using FN codes for smaller amounts (usually pre packed in little bags), allocate stock then send out for delivery (Sage lets you do this but creates negative stock levels).

So now we have a situation:
SCF stock is high and growing on every load in.
FN “stock” is negative and getting more so on every delivery out.

Then at month end the admin staff have to try to adjust stock by moving it from an SCF code to an FN code!

Apart from this taking two full days the error rate is high but it also creates two operating problems:
1: During the month no one knows exactly what is in “true” stock
2: Because we don't know true stock levels during the month the girls keep on over ordering to fulfil mid month demand... so SCF stock gets higher

So the question is this...

Is it possible to adapt Sage Line 50 so that goods bought under one code, then delivered can be automatically allocated (or moved) to a different stock code ?

[brucedenney]

Yes, the "bill of materials" function transfers stock from one code (or codes) to another.

For example a Tool kit could be made from 1 hammer, 1 box and 1 Screwdriver.

You can also work it the other way so

A Small pack of 10 nuts could be 0.01 of a large box of 1000 nuts.



If doing the transfers becomes time consuming I have some 3rd party solutions that can auto transfer, there is a cost associated with this but if get rid of work it could be worth it.

[Pragmateq]

Thank you very much, I will pass this back to the client. If they wish to find out more about the 3rd party solutions I can send their business your way.

Gary.