Re: [SL] Year End & Inventory Questions

[R P. <arc...@mt...>]

On Sunday 11 February 2007 5:24 pm, Roy Nicholl wrote:
> Followup on my previous post.
> 
> This afternoon, I setup a new installation of SQL-Ledger with a new  
> database.
> 
> I created two vendors and three customers.
> 
> I added a part and a service:
> 
> 1) Part: Long Sleeve Technical 'T'  ... cost $25.00
> 2) Service: Screening of club logo ... cost $2.00
> 
> I then created an assembly comprised of the part and the service:
> 
> 3) Club Crested long-sleeve technical 'T' ... sale price $35.00
> 
> I created a purchase order to vendor 1 for 20 units of 'part' (long  
> sleeved technical 'T').
> I then went into shipping and receiving and received the order (20  
> units)
> I then generated the corresponding vendor invoice.
> 
> Next I entered a vendor invoice from Vendor 2 for  
> 'service' (screening of club logo) for 20 units
> 
> I then checked "All Items" under Good & Services/Reports and I had 20  
> units of 'assembly' (Club Crested long-sleeve Technical T'
> 
> Now that I had an inventory it was time to sell.
> 
> Customer 1:
>    I created a sales order for 2 shirts
>    I then went under Shipping and 'ship'ed the order
>    finally I generated the corresponding sales invoice.
> 
> Customer 2:
>    I went under AR and created a 'sales invoice' for 1 shirt directly
> 
> Customer 3:
>    I went under POS / Sale and sold 1 shirt
> 
> After each of the above transactions, I went under Goods & Services /  
> Reports  / All Items and looked under Reports / "Chart of Accounts"  
> and confirmed that the inventory was adjusted appropriately.
> 
> This reflects the same process I previously followed under the Club  
> SQL Ledger setup, so I am really at a loss of how the inventory  
> balance there is incorrect.
> 
> Roy

I don't notice anything that mentions you actually used the "Stock Assembly" function...?

The vendor invoices put the parts into stock, but you have to use the "stock assembly" function to combine those parts (shirt and embroidery)
into the assembled unit (embroidered shirt).
You then sell the assembled unit on your customer invoices.

Cheers
The other Roy