STOCK CONTROL USING ESTLITE

Software related questions, and
suggestions for new features or improvements.
Post Reply
User avatar
Bagpuss
Posts: 835
Joined: Wed 18 Jun, 2008 1:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

STOCK CONTROL USING ESTLITE

Post by Bagpuss » Wed 28 Mar, 2018 10:49 pm

I've been using Estlite quite a few years now and am more than happy with it, does anyone use it to keep track of moulding stock and if so, how effective is it ? I never bothered looking into it but thought this might make my life a bit easier when it comes to placing orders for moulding.
Amy words of encouragement ? :clap:

Thanks in advance,
Adam / Bagpuss
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )

User avatar
JohnMcafee
Posts: 1080
Joined: Sun 10 Oct, 2010 10:58 am
Location: Belfast
Organisation: Scenes
Interests: Picture Framing
Putting the world to rights
Location: Belfast
Contact:

Re: STOCK CONTROL USING ESTLITE

Post by JohnMcafee » Fri 30 Mar, 2018 3:27 pm

While it is possible to set the system to predict the quantity of material that you will likely use for a given job, there is just no way to predict actual wastage day to day, job to job, or batch to batch - so you end up having to make manual adjustments to keep the thing accurate. This is the nature of the beast though, any automated system that the bespoke framer tries to set up will be plagued with the same difficulties.

That said, some folk may find that the extra effort to keep the stock record up to date to be worthwhile as the pay-off is realised at the point of sale where EstLite will notify you immediately if you do not have enough stock to complete the job as you price it. And if EstLite finds that you do not have the stock to complete the job it will go on to interrogate the suppliers database for availability and provide you with the information that will allow you to make a realistic decision on expected job completion.
"A little learning is a dangerous thing"

(Also known as John, the current forum administrator)

User avatar
Steve N
Posts: 2464
Joined: Sat 21 Jul, 2007 3:32 pm
Location: Bath, in the wild wild west
Organisation: Frontier Picture Frames
Interests: Walking our retired Greyhond,art, falling asleep on sofa in front of the telly
Location: Bath, Somerset
Contact:

Re: STOCK CONTROL USING ESTLITE

Post by Steve N » Mon 02 Apr, 2018 10:58 am

I agree with the first part of John's reply,
when you get your stock delivered you will have to manually enter each length of moulding, then when you are cutting , you will have to update the records each time, also take into account any damaged bits you have cut around to make your frames.

The other week I had some moulding come in which was only 6ft in length, total amount was just over what I ordered, which was more than I really wanted, I was just stocking up on a popular moulding, but if I had ordered only what I needed for that job, I wouldn't have been able to do the job, but the computer would have said "Yeah you have enough "

If you employ staff, you can have one doing 'stock inwards', another couple cutting and updating the records as they work, but I think if you are a 'One Man Band' outfit, you could find better way to fill your time - like making frames!

I just make a cut list each week, and on Monday morning, working from that list, just get each moulding required on the bench, if I can't find it, I add it to my order list.
Steve CEO GCF (020)
"Just because you seen it on the internet, does not make it true or right" -Abraham Lincoln
Proud to sell Ready Made Frames
http://www.frontierpictureframes.com
http://www.designerpicturemounts.com/

User avatar
Bagpuss
Posts: 835
Joined: Wed 18 Jun, 2008 1:59 pm
Location: Upminster, ESSEX, UK
Organisation: Adam The Picture Framer
Interests: TBA
Contact:

Re: STOCK CONTROL USING ESTLITE

Post by Bagpuss » Tue 03 Apr, 2018 10:31 pm

Thanks for your comments gents, much appreciated. After all these years, I'm still trying to come up with a simple and accurate way of keeping on top my stock and at the same time not over ordering and adding to my mountain of unused moulding : ( I've been doing some Chop orders recently from Lion, not a lot but certainly for the more expensive "chunky" mouldings, I quite like this and will probably be doing more in the future :clap:

Thanks, Adam / Bagpuss
My real name is Adam Laver aka "Adam The Picture Framer", just in case you were unsure ; )

Post Reply