Need help for this client's stock control/stock codes dilemma...
Posted: 24 Jul 2015, 10:25
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 ?
----
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 ?