sql-ledger-users

[SL] Year End & Inventory Questions

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

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

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

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

Re: [SL] Year End & Inventory Questions

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

Oops ... I did leave that step out of my narration ... but I did  
indeed do that ...

My dilemma still remains why my 'mock up' from Sunday appears to have  
worked, yet my "real" setup for the running club still shows  
inventory on the balance sheet (but does not when I look at the Good  
& Services / All Items report.

I have three years worth of data in the system and am not so keen on  
keying it all in again ... is there any way to 'fix' the inventory  
issue without screwing-up the integrity of the database (any further  
than it already is).


Roy

On 13-Feb-2007, at 11:57, R Pennington wrote:

>
> 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
>
> ---------------------------------------------------------------------- 
> ---
> 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

Re: [SL] Year End & Inventory Questions

[Paul T. <pt...@wa...>]

Roy Nicholl schreef:
> Oops ... I did leave that step out of my narration ... but I did  
> indeed do that ...
>
> My dilemma still remains why my 'mock up' from Sunday appears to have  
> worked, yet my "real" setup for the running club still shows  
> inventory on the balance sheet (but does not when I look at the Good  
> & Services / All Items report.
>
> I have three years worth of data in the system and am not so keen on  
> keying it all in again ... is there any way to 'fix' the inventory  
> issue without screwing-up the integrity of the database (any further  
> than it already is).
>
>
> Roy
>
> On 13-Feb-2007, at 11:57, R Pennington wrote:
>   
Just a wild guess, but is the amount in the balance sheet anything like 
the opening stock of year one you started using SQL-Ledger?
In that case, you probably did not enter the COGS for the opening stock, 
effectively creating a non existing profit.
And the amount there should be re-classed to COGS. Year one, but I 
assume you may have closed previous years.
The correction then should be made at the earliest moment in time 
possible, COGS debit, Stock Credit.
Or just invoice out for zero as a stock correction; if the good were 
stolen or burned you would do that also..

Hth
Paul

[SL] Display VAT number

[Kevin B. <kb...@fr...>]

Hi,

How do I get the VAT number to display on the invoices which are created 
as PDF's?

Thanks,

Kevin Bailey