Help with Sage
Discussion
We are having some issues at work that have been high lighted in the stock check.
We buy a part from a company. The part comes in 3 pieces. All three parts are raised on the order in sage. The three parts come together to make one part. We only receive one part but still mark all three parts as received.
This is where the issue is. When we come to book these parts out to jobs we are only booking one part out (Dont ask why but it has always been done like this. Booking out the other two parts everytime would stretch the stock controller more than we would like)
Is there anyway with sage to book these parts in as one?
We buy a part from a company. The part comes in 3 pieces. All three parts are raised on the order in sage. The three parts come together to make one part. We only receive one part but still mark all three parts as received.
This is where the issue is. When we come to book these parts out to jobs we are only booking one part out (Dont ask why but it has always been done like this. Booking out the other two parts everytime would stretch the stock controller more than we would like)
Is there anyway with sage to book these parts in as one?
Can't help with your specific problem but this site is a fantastic resource,
http://www.sageforum.co.uk/
Well worth taking a few minutes to register.
http://www.sageforum.co.uk/
Well worth taking a few minutes to register.
Broccers said:
Get the supplier to invoice you for one part only - not that hard Id say ;-)
If only is was that easy.The company we buy from is a internal company (Within the american corporation that owns us). This corporation likes to see all transactions. Its simply not possible to "Hide" these parts. If that makes sense
You need to set up the three components up as "sub products", each with an individual cost. The finished product consisting of the three "sub" products then needs to be set up. The sub products need to have individual cost prices, which in total add up to the cost price of the finished product. You book in the 3 subs then transfer them to finished products. Sage will automatically destock the subs and increase the finished products by the quantity your "transfer".
Acouple of potential trip ups are:-
1) if your sub product stock level (on sage) is less than the quantity you transfer to finished products it won't allow you to do it. Therefore your subs stock when first put into sage must be accurate and your new deliveries must be accurately recorded onto the goods inwards.
2) If your purchase order for subs states a price which is different to the price already on record for that sub it will think you have x sub A at £a and y sub A at £b. when you transfer a quantity to finished products, if greater than x quantity, it will automatically change the cost price of the finishd product to reflect the higher total price of the subs combined. This will throw out you stock valuation by the difference times the quantity. Not a problem if you only have a few subs to each product and a few products.
Unfortunely I have several hundred products and each has several sub products and this can inflate my stock level by £300k or £400k, which of course artifically inflates my P&L by that amount and the tax man rubs his hands!!!!!!!
Acouple of potential trip ups are:-
1) if your sub product stock level (on sage) is less than the quantity you transfer to finished products it won't allow you to do it. Therefore your subs stock when first put into sage must be accurate and your new deliveries must be accurately recorded onto the goods inwards.
2) If your purchase order for subs states a price which is different to the price already on record for that sub it will think you have x sub A at £a and y sub A at £b. when you transfer a quantity to finished products, if greater than x quantity, it will automatically change the cost price of the finishd product to reflect the higher total price of the subs combined. This will throw out you stock valuation by the difference times the quantity. Not a problem if you only have a few subs to each product and a few products.
Unfortunely I have several hundred products and each has several sub products and this can inflate my stock level by £300k or £400k, which of course artifically inflates my P&L by that amount and the tax man rubs his hands!!!!!!!
Gassing Station | Business | Top of Page | What's New | My Stuff