Re: [SL] Year End & Inventory Questions

[Roy N. <RNi...@NB...>]

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

On 11-Feb-2007, at 16:52, Roy Nicholl wrote:

> All,
>
> I have setup a local running club to use SQL Ledger and, for the most
> part, it has worked well ... save two issues:
>
> 1) I have an issue with inventory which I have been unable to
> resolve.  We created two assemblies: one being a club technical shirt
> and the other a running shell (jacket).  In both instances the
> assembly was comprised of the clothing item + the cost of screening a
> logo on the item.  We have sold all of the shirts/jackets and when I
> go into "Goods & Services", "Reports" "All Items", the quantity for
> each assembly is correct (0).  Yet the balance sheet still shows
> inventory on hand ...  what have I done wrong?
>
> 2) In addition to the 'general operations' of the running club, it
> also presents two large road races each year: a marathon in the
> spring and a 10K in the autumn.   I have setup SQL Ledger such that
> the Marathon and 10K events are separate 'Departments' ... each
> department is its own profit/cost centre and has its own back
> account.  This worked just wonderfully until we tried to do a year
> end.   The "year end" function appear to work globally ... i.e. it
> sweeps all departments/divisions together and drops the retained
> earnings into a single account.   Is there a way I can perform the
> year end function on a per division/department basis?  ... or will I
> have to pull everything apart and re-implement them as separate
> 'companies' (highly inconvenient)?
>
> Roy
>
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier.
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users