retsub35 wrote:

---

Hi all,

I am going round in circle with this so thought I would ask for some ideas:

A client runs stock module on Sage 50C. About 12 times a month workshop staff use some of the shop stock for workshop/cleaning use.

They have been using the adjustments out module just to alter the stock which needs to change. 

Any ideas on how I reduce the stock items used and at the same time charge the company the cost price of the stock under workshop consumables so it appears in the P&L as an expense.

Thanks

Jenny.

---

 Why would you 'charge the company' when the company has quite clearly already been expensed for this when they bought them?!!!!

5000 is an expense/cost code.
6000 is an expense code.

So you have two expenses in the SPL!

Adjustments are done to the SFP/SPL.


So when you code to 5000, when stock arrives how are you adjusting then in the SFP. How are you adjusting the SFP when you sell stock?

edited to correct initials

Hi Sage,

can you clarify your abbreviations SPF - stock price figure, SPL?

thanks

jenny.

Hi Sage,

I have realised I have completely over thought this process. My P&L is analysed with '5000' purchases (for resale in shop) and then '6901' workshop supplies, cleaning products '7801' charged to overheads etc. When staff take stock from the shelf that was intended for resale I wanted to shift the expense from '5000' to say maybe rags used for the workshop '6901', it also had to show that the stock was being reduced. The solution suddenly clicked this evening:

Use adjustments out to take out the stock used in the workshop or cleaning products used for the office then at month end I run a product analysis report, add up the cost price of all stock used by staff and then post a journal as follows:

credit '5000' net cost price of total amount used.

debit '6901' net cost price of rags

debit '7801' net cost price of cleaning products

Hope that makes sense, hopefully that's right, sorry to confuse!

thanks

Jenny.