sql-ledger-users — SQL-Ledger users

Re: [SL] salespersons

[Michael G. <ge...@mu...>]

On Fri, Feb 02, 2007 at 06:09:50AM -0500, Michael George wrote:
> What determines which users show up in the "salesperson" list on
> invoices and customer records?
> 
> I have some users who don't show up in either list, and some who show up
> on the list on invoices but don't showup on the list when
> creating/modifying customers.
> 
> Very strange, I thought...

Oh, nevermind.  It's been too long since I set up users...

I just need to check the "Sales" box in their user record.

Sorry for wasting the bandwidth...

-- 
-M

There are 10 kinds of people in this world:
	Those who can count in binary and those who cannot.

[SL] salespersons

[Michael G. <ge...@mu...>]

What determines which users show up in the "salesperson" list on
invoices and customer records?

I have some users who don't show up in either list, and some who show up
on the list on invoices but don't showup on the list when
creating/modifying customers.

Very strange, I thought...

-- 
-M

There are 10 kinds of people in this world:
	Those who can count in binary and those who cannot.

Re: [SL] Access Denied

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

Rich Shepard schreef:
> On Thu, 1 Feb 2007, Rich Shepard wrote:
>
>   
>>   What have I missed? If there's nothing in the httpd error log I've no idea
>> why I see the page that shows, "Error! Access denied."
>>     
>
>    I've also searched through the mail list archives through last June
> without seeing anything relevant.
>
> Rich
>
>   
did you try to use /admin.pl instead of just getting barred? Might be a 
default set to something unpractical after upgrade.
Not nice, but it has happened before..

Re: [SL] Access Denied

[Rich S. <rsh...@ap...>]

On Thu, 1 Feb 2007, Rich Shepard wrote:

>   What have I missed? If there's nothing in the httpd error log I've no idea
> why I see the page that shows, "Error! Access denied."

   I've also searched through the mail list archives through last June
without seeing anything relevant.

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

[SL] Access Denied

[Rich S. <rsh...@ap...>]

   This has me completely puzzled, and I need to run payables since it's the
beginning of the month.

   When I try to log in to SL-2.6.23 I am denied access. Just about a week
ago -- January 23rd -- I had access problems after a system upgrade and that
was tracked down to a perl module built against an obsolete library. My last
message to the thread reported the problem was solved and that I could once
again log in.

   I've not used the application since then. Nor have I made any changes to
apache, postgres, or anything else.

   /var/log/apache/access_log shows the latest attempt:

127.0.0.1 - - [01/Feb/2007:18:16:21 -0800] "POST /sql-ledger/login.pl
HTTP/1.1" 200 311

   /var/log/apache/error_log reports nothing.

   httpd and postmaster are running processes; I restarted both.

   What have I missed? If there's nothing in the httpd error log I've no idea
why I see the page that shows, "Error! Access denied."

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Cash reports not adding up

[Michael H. <mh...@it...>]

We just found the same thing in the tax reports.  We had to specify  
"detail" to get the right (we hope!) numbers.  :/


Thanks,

Michael


On Jan 31, 2007, at 1:50 PM, John Locke wrote:

> Hi,
>
> Using SQL-Ledger 2.6.22. I'm trying to run some income reports for
> year-end tax payments to the State. I've been using Cash-basis  
> reporting
> for quite some time, but I seem to be running into a new issue.
>
> When I run an Income Statement report for each of the 4 quarters of
> 2006, I end up with about $2700 more total income reported than when I
> run the same exact report for the entire year. What could be the cause
> of this?
>
>
> I know in the past that I had to deal with open invoices at the
> beginning of a report period, but this issue seems to have gotten
> resolved sometime in the last year. Now I'm seeing the opposite
> effect--instead of having smaller amounts on the quarterly report
> compared to the yearly, I'm getting larger amounts on the quarterlies.
>
> Help?
>
> -- 
> John Locke
> "Open Source Solutions for Small Business Problems"
> published by Charles River Media, June 2004
> http://www.freelock.com
>
>
> ---------------------------------------------------------------------- 
> ---
> 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

[SL] Cash reports not adding up

[John L. <ma...@fr...>]

Hi,

Using SQL-Ledger 2.6.22. I'm trying to run some income reports for
year-end tax payments to the State. I've been using Cash-basis reporting
for quite some time, but I seem to be running into a new issue.

When I run an Income Statement report for each of the 4 quarters of
2006, I end up with about $2700 more total income reported than when I
run the same exact report for the entire year. What could be the cause
of this?


I know in the past that I had to deal with open invoices at the
beginning of a report period, but this issue seems to have gotten
resolved sometime in the last year. Now I'm seeing the opposite
effect--instead of having smaller amounts on the quarterly report
compared to the yearly, I'm getting larger amounts on the quarterlies.

Help?

-- 
John Locke
"Open Source Solutions for Small Business Problems"
published by Charles River Media, June 2004
http://www.freelock.com

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

> I can think of a simple solution: CASH is a physical box with money.
> If you also have a USD cash box (or a couple of bucks lying around in 
> the POUND cashbox) you should probably use a separate cash account per 
> currency.
> In short: The cash ledger you are using for the payment is not the right 
> one.
>   

Actually although I didnt say so in my email, I deliberately created a 
new ledger called something like "USD Payment Settlements" before I 
started.  The point of this was so that I could more easily see what 
would happen once I hit the pay button as much as to have a seperate account

However, I don't see any options to say that the cash account is in a 
particular currency?  It seems to just convert the payment into local 
currency without asking?  Am I missing an option?

In fact what happens is that I do exactly as you say and purchase USD 
from a bank who wire it to my payee and I in turn wire them sterling.

Grateful for more insight on *how* to actually enter these transactions 
please

Cheers

Ed W

Re: [SL] Accounting for fuel inventory in a small power generator

[Michael H. <mh...@it...>]

I guess that wasn't very clear, was it?  :)  The service items for  
our whiteboxes are indeed service.
    The power generating problem is a bit tougher though because  
while service items are "soft", inventory items are not.  So if one  
of my guys spends an extra fifteen minutes building a machine we can  
just absorb it and inventory is not affected.
    In the power generation case though the equation goes the other  
way, if one of his generators gets a leaky exhaust valve or something  
and nobody notices for awhile, it will subtly skew the output-power/ 
fuel ratio and he'll have burned more fuel per megawatt than usual  
which is a lot harder to "absorb" as he's paying actual money for  
that.  He'll have to either constantly tweak the ratio in his billing  
or have a periodic adjustment entry, (which I guess is not so  
different from our update "invoices" when we take inventory and have  
to account for the misc cables and things that were never actually  
billed).


Thanks,

Michael


On Jan 26, 2007, at 9:03 AM, Paul Tammes wrote:

> Michael Hasse schreef:
>> Speaking to this a little further, some of our products are
>> "whiteboxes", which are PCs assembled by us from components purchased
>> wholesale.  Our assemblies include a line item for the typical total
>> shipping cost of the components and also a figure for the calculated
>> labor cost of purchasing, assembling, etc.  In this case of course
>> we're going the other direction, taking an intangible and making it
>> part of a tangible.
>>
> In those circumstances I strongly suggest you use a service item  
> for the
> services and an inventory item for the goods.
> An assembly of goods and services should then give correct figures for
> hardware (inventory) and COGS one way.
> And as a bonus, revenue for services the other way..
>
>
> ---------------------------------------------------------------------- 
> ---
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to  
> share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php? 
> page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Cross currency invoice entry

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

Ed W schreef:
> To enter this I tried the following:
>
> 1) Enter in purchase invoice in USD.  System converts it to nominal=20
> sterling value as at 1st june 2006
> 2) Then enter Cash|Payment for this invoice and enter in $225 as at 1st=
=20
> Jan 2007.  System appears to pickup the rate at that date and puts two=20
> transactions into the cash account, one for a $225 and the other for=20
> around $106 ish (basically it seems to be doing a funny currency=20
> conversion whilst still trying to make $100 =3D=3D =A3100 to keep the l=
edger happy
> 3) Now I am stuck... Probably I have to do the reverse to actually pay=20
> this thing properly, but I don't understand what is happening.
> 4) Additionally in real life my rate is not the spot as of 1st Jan 2007=
=20
> and its slightly different, hence I need a second currency FX=20
> gain/loss...  Probably just enter this in as a transfer, but I still=20
> haven't got my head around this $1 =3D=3D =A31 thing..
>
> Does anyone else understand what SL is trying to do during the above?
>  =20
> Grateful if anyone can help unwind this mess for me please
>
>  =20
I can think of a simple solution: CASH is a physical box with money.
If you also have a USD cash box (or a couple of bucks lying around in=20
the POUND cashbox) you should probably use a separate cash account per=20
currency.
In short: The cash ledger you are using for the payment is not the right=20
one.

Your UK Cash account is setup by the system default to be in UK pounds=20
and will use any transactions including payments of invoices as being in=20
POUNDS STERLING.

Setup a US Dollar cash or bank account, and use the actual payment way=20
AND CURRENCY to record the transaction.
So either buy physical dollars from your bank, either cash or bank.=20
Deposit in USD cash or bank account.
Pay invoice from there.

That way SQL Ledger has a fair chance to get the 1$ <> 1=A3 bit right.

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

Hi

> The point is it does not *HAVE* to be entered as Accounts Payable.
>
> It may, but it also may be entered as a straight General Ledger entry,
> which avoids all this nuisance :-)-O.
>  =20

Yes, but that doesn't track my stock which is the whole point.

Lets consider it more an exercise to see how this ought to be done.

Purchase:

100 Widgets @ $1
50 bloopers @$2
Delivery @ $25

This is invoiced on 1st June 2006 (spot rate 1.8)

There are generous payment terms and it will be paid for on 1st Jan 2007 =

(spot rate 1.9)

I incur a VAT charge from UK customs when the goods enter the country=20
and hence I effectively pay out 17.5% of the value on 1st June 2006 (I=20
recover it in my tax return at the end of the quarter of course).

The point here is that if I don't show the cost of the purchased items=20
until 1st Jan 2007 then my cost of goods is inaccurate and also my=20
management accounts are incorrect and worse still I look suspicious to=20
the VAT office because I am reclaiming VAT on purchases that I don't=20
appear to have made



To enter this I tried the following:

1) Enter in purchase invoice in USD.  System converts it to nominal=20
sterling value as at 1st june 2006
2) Then enter Cash|Payment for this invoice and enter in $225 as at 1st=20
Jan 2007.  System appears to pickup the rate at that date and puts two=20
transactions into the cash account, one for a $225 and the other for=20
around $106 ish (basically it seems to be doing a funny currency=20
conversion whilst still trying to make $100 =3D=3D =A3100 to keep the led=
ger happy
3) Now I am stuck... Probably I have to do the reverse to actually pay=20
this thing properly, but I don't understand what is happening.
4) Additionally in real life my rate is not the spot as of 1st Jan 2007=20
and its slightly different, hence I need a second currency FX=20
gain/loss...  Probably just enter this in as a transfer, but I still=20
haven't got my head around this $1 =3D=3D =A31 thing..

Does anyone else understand what SL is trying to do during the above?


> The point here is that you *can* *NOT* pay or claim UK taxes on a US
> purchase.
>
> Thus you can not reclaim VAT in the UK for an invoice made out in the U=
S.
>  =20

Well, it's a technicality, but UK customs slap me with a VAT bill when=20
the goods arrive in the country.  Hence as near as damnit I pay UK VAT=20
on US purchases...  Actually it's just a passthrough cost and I get it=20
back at the end of the quarter, but I still need to fill in the return=20
plausibly or I can expect a query that I have entered everything=20
correctly.  There are bands of expected behaviour and if I am reclaiming =

vastly more than 17.5% of my nominal purchase invoices then it's going=20
to stand out...

> GL entry.
>  =20

Doesn't account for cost of goods where I am tracking the items


Grateful if anyone can help unwind this mess for me please

Cheers

Ed W

Re: [SL] Cross currency invoice entry

[Dr E. L. <el...@li...>]

Ed,


on 1/29/07 1:52 AM Ed W said the following:
> Hi
> 
> I obviously appreciate your assistance, but you appear to be *telling* 
> me things without *explaining* them?  Since I don't understand your 
> point I'm not really any further ahead.
> 
>>> a) The invoice has to get entered today in foreign currency
>>>     
>> No, it does *NOT*. Neither today, nor in a foreign currency, nor via AP.
>>   
> 
> Well, I think it does.  Can you please explain why you think otherwise?

The point is it does not *HAVE* to be entered as Accounts Payable.

It may, but it also may be entered as a straight General Ledger entry,
which avoids all this nuisance :-)-O.

>>> b) I might not pay the bill for 1-6 months time, hence I won't have an 
>>> actual rate for it until after a year end of tax quarter.  Therefore I 
>>> need to account for it on an accrual basis
>>>     
>> No, you don't.
>>   
> 
> Again, why not?  For example my vat return is going to look very 
> suspicious if I state my taxes paid, but don't offer any revenue to 
> support the tax reclaim...

The point here is that you *can* *NOT* pay or claim UK taxes on a US
purchase.

Thus you can not reclaim VAT in the UK for an invoice made out in the US.

And thus you just bang it straight of the bank account against whatever
account your purchase goes into. Even if you pay tax in the US it is
still *ALL* the same expense.

>> Since it does not involve local taxes you can do it with a GL entry when
>> you (eventually) pay.
>>   
> 
> I believe you, but I'm none the wiser on how to do this?  This was my 
> initial question really - *how* to enter it...

GL entry.

el

[SL] email orders, invoices etc

[Adrian B. <adr...@ie...>]

I am having difficulty send orders etc via email. The sql-ledger.conf is correct, i.e. $sendmail = "| /usr/sbin/sendmail -t ";

I am using Mandriva 2007
  /var/log/mailman/error.1.gz contains:
Jan 28 16:36:38 2007 mailmanctl(5178): Site list is missing: mailman
Jan 28 16:36:38 2007 (5178) Site list is missing: mailman

Where or how is the SMTP server set?

Adrian

-- 
Adrian Blake
Molonglo Radio Observatory
University of Sydney
1152 Hoskinstown Rd
Bungendore 2621
ph. 02 80042212  mobile 0407 232 978

http://150.101.125.30/pics

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

Aha, inspiration.

Presumably the expectation is that one is supposed to pay the invoice 
from an "FX Settlement" account.  This account is debited by the foreign 
currency and credited by the local currency amount.  Then I effectively 
put in a transfer to settle this payment by crediting the foreign 
currency and debiting the amount of local currency that I paid.  The net 
balance in the account is the actual fx gain/loss on the payment versus 
the rate in the system on that day and gets transferred out.

Seems awfully complicated and I'm still stumped as to how to best enter 
this payment into the system.  The SL manual is extremely vague on what 
the "FX" tickboxes do - do I need to select them?

Grateful for pointers

Ed W


Ed W wrote:
> I'm really struggling with this transaction
>
> OK, I entered my invoice in USD, but the rest of the accounts are in GBP
>
> I then entered in a payment, the rate was picked up automatically (and 
> is slightly off what I paid).  However, the checking account is then 
> credited with the USD amount and debited by the GBP amount, leaving a 
> net negative balance?  Why is this?
>
> The FX gain/loss accounts appear to be adjusted correctly and show 
> uplifts inline with the difference between the invoiced rate and the 
> payment rate.
>
> I'm sure there are others here entering FX transactions, can anyone 
> please shed some light on how to enter them please
>   

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

I'm really struggling with this transaction

OK, I entered my invoice in USD, but the rest of the accounts are in GBP

I then entered in a payment, the rate was picked up automatically (and 
is slightly off what I paid).  However, the checking account is then 
credited with the USD amount and debited by the GBP amount, leaving a 
net negative balance?  Why is this?

The FX gain/loss accounts appear to be adjusted correctly and show 
uplifts inline with the difference between the invoiced rate and the 
payment rate.

I'm sure there are others here entering FX transactions, can anyone 
please shed some light on how to enter them please

Thanks

Ed W

Re: [SL] Cross currency invoice entry

[Ed W <li...@wi...>]

Hi

I obviously appreciate your assistance, but you appear to be *telling* 
me things without *explaining* them?  Since I don't understand your 
point I'm not really any further ahead.

>> a) The invoice has to get entered today in foreign currency
>>     
>
> No, it does *NOT*. Neither today, nor in a foreign currency, nor via AP.
>   

Well, I think it does.  Can you please explain why you think otherwise?

>> b) I might not pay the bill for 1-6 months time, hence I won't have an 
>> actual rate for it until after a year end of tax quarter.  Therefore I 
>> need to account for it on an accrual basis
>>     
>
> No, you don't.
>   

Again, why not?  For example my vat return is going to look very 
suspicious if I state my taxes paid, but don't offer any revenue to 
support the tax reclaim...

> Since it does not involve local taxes you can do it with a GL entry when
> you (eventually) pay.
>   

I believe you, but I'm none the wiser on how to do this?  This was my 
initial question really - *how* to enter it...


Grateful for any pointers

Ed W

Re: [SL] New start (is the following method save ?)

[Ashley J G. <sql...@pu...>]

On Saturday 27 January 2007 09:04, Luc van Stappershoef wrote:
> Ashley,
>
> Offcourse you are right I will try and contact off list to discuss what
> is wrong

Luc, no need to take it off list - indeed, I may not be able to help you out 
depending on what the issue is. But it you can let the list know in general 
terms what the problem is then someone (quite likely not me) may have an 
easier fix that they can suggest.

You don't need to disclose any confidential details, since the names and 
figures themselves don't matter, but if you can let us know the nature of the 
problem you have hopefully someone (or several) will be able to help out.

Cheers,
	Ash

Re: [SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Ashley,

Offcourse you are right I will try and contact off list to discuss what 
is wrong


Luc

Ashley J Gittins wrote:
> On Friday 26 January 2007 04:30, Luc van Stappershoef wrote:
>   
>> Can anybody please review if this a good way to restart with booking in
>> sql-ledger?.
>>
>> Luc van Stappershoef wrote:
>>     
>>> Hello Sql-ledgerers,
>>>
>>> I have copied the database of a environment where I need to start all
>>> over again (after 3 months). But I want to keep some information (like
>>> parts, customers suppliers, ledger etc)
>>>
>>> <<snip>>
>>>
>>> It is allways very painfull to find out you have done
>>> things wrong
>>>       
>
> We can't really tell you if what you suggest is remotely sane because you 
> haven't told us what's wrong. Throwing away then re-entering a heap of data 
> sounds like a very silly thing to do if we don't know the context.
>
> What is wrong with your existing data? Perhaps it can be fixed relatively 
> easily rather than going through hours of re-entry.
>
>   

Re: [SL] Accounting for fuel inventory in a small power generator

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

Michael Hasse schreef:
> Speaking to this a little further, some of our products are  
> "whiteboxes", which are PCs assembled by us from components purchased  
> wholesale.  Our assemblies include a line item for the typical total  
> shipping cost of the components and also a figure for the calculated  
> labor cost of purchasing, assembling, etc.  In this case of course  
> we're going the other direction, taking an intangible and making it  
> part of a tangible.
>   
In those circumstances I strongly suggest you use a service item for the 
services and an inventory item for the goods.
An assembly of goods and services should then give correct figures for 
hardware (inventory) and COGS one way.
And as a bonus, revenue for services the other way..

Re: [SL] New start (is the following method save ?)

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

Hello Luc

I have done this type of thing with previous SQL-ledger versions but I have=
n't looked into the database structure for a year and a half.
When i needed to correct a large number of COGS out of order problems I did=
 the following....
=2Dmade a copy of the dataset
=2Dcleaned the orders, invoices and quotes from the copy, by truncating (re=
moving the data from) some of the tables
=2D used a perl script to copy a date range of orders and invoices from the=
 original database to the copy in chronological order.

Can you describe what you want to do in detail ?

=46rom your post I understand that you want to keep:
Parts, Customers, Vendors, Chart of accounts

Is there anything else you need to keep ?

You want to  truncate the partstax table ?... this would force you to edit =
every part to reconfigure it's tax settings.=20
Are all the parts configured wrong for tax ?
Could you keep the partstax table intact and edit the few parts with errors=
 ?


Cheers,
Roy




On Thursday 25 January 2007 12:30 pm, Luc van Stappershoef wrote:
> Can anybody please review if this a good way to restart with booking in=20
> sql-ledger?.
>=20
> Luc van Stappershoef wrote:
> > Hello Sql-ledgerers,
> >
> > I have copied the database of a environment where I need to start all=20
> > over again (after 3 months). But I want to keep some information (like=
=20
> > parts, customers suppliers, ledger etc)
> >
> > I have experimented a bit and I think the following works:
> >
> > -*Copy database*
> > -*Delete the content of all the of the following tables: *acc_trans, ap=
,=20
> > ar, assembly, audittrail, business, dpt_trans, exchangerate,=20
> > exchangerate, gifi (Does not apply in my country), gl, inventory,=20
> > invoice, JCitems, oe, orderitems, partstax ( I will need to redo this=20
> > because of mistakes), Status, Yearend
> >
> > -*The following tables I Kept intact:* Chart, customer,customertax,=20
> > defaults ( I know i need t alter a few things there when I will start),=
=20
> > department, employee, language, makemodel, parts, partscustomer,=20
> > partsgroup, pricegroup, project(was empty), recurring (was empty),=20
> > Recurringemail (was empty), Recurringeprint (was empty), shipto (was=20
> > empty),  sic (was empty), tax, translation, vendor, vendortax, warehous=
e,
> >
> >
> >  From this I want start all over again (not so much need to be entered),
> >
> >     * Orderentries,
> >     * salesbookings
> >     * financialbookings etc
> >
> >
> > I have been playing around a bit and it seems it will work, can anybody=
=20
> > comment on this exercise before I start putting in my orders, sales,=20
> > bookings etcetera. It is allways very painfull to find out you have don=
e=20
> > things wrong
> >
> > Tanks in advance
> >
> > Luc
> >
> >
> >
> >
> >
> > -----------------------------------------------------------------------=
=2D-
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share=
 your
> > opinions on IT & business topics through brief surveys - and earn cash
> > http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=
=3DDEVDEV
> > _______________________________________________
> > sql-ledger-users mailing list
> > sql...@li...
> > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
> >
> >
> >
> >  =20
>=20
>=20
>=20
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share y=
our
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>=20

=2D-=20
Roy W Pennington
Customer Support
Arch Distributors of Canada
Phone: 204.257.8161

Re: [SL] New start (is the following method save ?)

[Ashley J G. <sql...@pu...>]

On Friday 26 January 2007 04:30, Luc van Stappershoef wrote:
> Can anybody please review if this a good way to restart with booking in
> sql-ledger?.
>
> Luc van Stappershoef wrote:
> > Hello Sql-ledgerers,
> >
> > I have copied the database of a environment where I need to start all
> > over again (after 3 months). But I want to keep some information (like
> > parts, customers suppliers, ledger etc)
> >
> > <<snip>>
> >
> > It is allways very painfull to find out you have done
> > things wrong

We can't really tell you if what you suggest is remotely sane because you 
haven't told us what's wrong. Throwing away then re-entering a heap of data 
sounds like a very silly thing to do if we don't know the context.

What is wrong with your existing data? Perhaps it can be fixed relatively 
easily rather than going through hours of re-entry.

-- 
Regards,
	Ashley J Gittins
	web: 	http://www.purple.dropbear.id.au
	jabber: agi...@pu...

Re: [SL] console API

[Dr E. L. <el...@li...>]

End each line with a backslash \

el

on 1/25/07 7:25 PM William Montgomery said the following:
> I am trying to use the console API for Vendor invoices to set up our 
> initial inventory. The script below fails with:
> 
> You are logged out! <p><a href=login.pl target=_top>Login</a>
> 
> ---------
> ./ir.pl "
> path=bin/mozilla&
> login=william&
> password=my_passwd&
> action=Post&
> vc=vendor&
> type=invoice&
> vendor=My Company&
> oldvendor=My Company--24092&
> vendor_id=24092&
> AP=2100--Accounts Payable&
> currency=USD&
> defaultcurrency=USD&
> invnumber=123&
> transdate=01-25-2007&
> duedate=01-25-2007&
> runningnumber_1=1&
> partnumber_1=RZ22-4&
> description_1=Ring, Terminal, 26-22&
> qty_1=1&
> sellprice_1=14.92&
> oldcurrency=USD&
> id_1=10713&
> notes=Invoice posted from the command line&
> AP_paid=1060--Checking Account&
> paidaccounts=1&
> datepaid_1="01-25-2007"&
> rowcount=2
> "
> -------
> 
> Any ideas about what is wrong?
> 
> Thanks,
> Wm
> 
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

-- 
Dr. Eberhard W. Lisse  \        / Obstetrician & Gynaecologist (Saar)
el...@li... el108-ARIN / *     |   Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     /   Please do NOT email to this address
Bachbrecht, Namibia     ;____/        if it is DNS related in ANY way

Re: [SL] Accounting for fuel inventory in a small power generator

[Michael H. <mh...@it...>]

Speaking to this a little further, some of our products are =20
"whiteboxes", which are PCs assembled by us from components purchased =20=

wholesale.  Our assemblies include a line item for the typical total =20
shipping cost of the components and also a figure for the calculated =20
labor cost of purchasing, assembling, etc.  In this case of course =20
we're going the other direction, taking an intangible and making it =20
part of a tangible.
     The problem I could see with flipping it around for your =20
scenario is that you may end up in a cycle of constantly adjusting =20
the figure to match reality since your production rate will never be =20
perfectly even so no matter what conversion factor you decide to use =20
you'll always be a few MW (or more!) high or low at the end of a =20
billing cycle.  That said, I'm not sure that's really something that =20
can be handled by any accounting system except those specifically =20
designed for the power generating industry and those tend to run into =20=

the hundreds of thousands of dollars!
    If you're in the United States though there is a group called =20
EPRI, (Electric Power Research Institute), which you may even be a =20
member of already, who probably won't have the answer specifically =20
but could probably point you in the right direction to see what your =20
accounting options are.  Even if you're not in the US they might =20
still be able to help as they operate globally.  Their website is:
	http://www.epri.com/


Thanks,

Michael


On Nov 10, 2006, at 5:03 AM, Jeff Vian wrote:

> On Thu, 2006-11-09 at 22:12 -0600, Oscar A. Valdez wrote:
>> El jue, 09-11-2006 a las 21:49 -0600, Jeff Vian escribi=F3:
>>> On Thu, 2006-11-09 at 09:00 -0600, Oscar A. Valdez wrote:
>>>> We are a small power generator that purchases fuel and converts =20
>>>> it into
>>>> electrical and heat energy for sale.
>>>>
>>>> I've looked at the manual's section on Inventory, and it doesn't =20=

>>>> seem
>>>> like I can have a fuel inventory and periodically consume it to =20
>>>> produce
>>>> energy for immediate sale (can't be inventoried). That would =20
>>>> seem like a
>>>> Job Costing or WIP functionality that doesn't seem to be there in
>>>> SQL-Ledger.
>>>>
>>>> Am I wrong?
>>>>
>>> Just a thought from a layman. IANAA
>>>
>>> Fuel used in operations is an expense item.  You may buy it, and =20
>>> have
>>> some quantity on hand, but it is consumed as overhead in the =20
>>> production
>>> of energy.  It should not be treated as inventory for this purpose.
>>>
>>> Energy can be treated as a service, since it is not tangible =20
>>> inventory.
>>> It can be sold by the unit, similar to service hours, and cannot be
>>> stored. Invoicing goes to AR.
>>
>> But what we do is transform fuel into electricity and heat. It's an
>> industrial transformation. So fuel is our raw material, and =20
>> electricity
>> and heat our end products.
>
> Deiter made the comment that it can be used as part of an assembly,
> which would be the units of energy produced and sold.  As such, you =20=

> buy
> it, it goes into inventory, and as you sell the energy/heat it gets
> consumed and the cost becomes part of the COGS.
>
> I have a slight problem with that in that energy is not physical  and
> cannot be stocked even though the fuel is physical.  However, the
> concept seems proper. Cost of fuel is part of the cost of producing =20=

> the
> energy you sell.
>
>
> ----------------------------------------------------------------------=20=

> ---
> Using Tomcat but need to do more? Need to support web services, =20
> security?
> Get stuff done quickly with pre-integrated technology to make your =20
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache =20
> Geronimo
> http://sel.as-us.falkag.net/sel?=20
> cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=3D121642
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] New start (is the following method save ?)

[Luc v. S. <lu...@co...>]

Can anybody please review if this a good way to restart with booking in 
sql-ledger?.

Luc van Stappershoef wrote:
> Hello Sql-ledgerers,
>
> I have copied the database of a environment where I need to start all 
> over again (after 3 months). But I want to keep some information (like 
> parts, customers suppliers, ledger etc)
>
> I have experimented a bit and I think the following works:
>
> -*Copy database*
> -*Delete the content of all the of the following tables: *acc_trans, ap, 
> ar, assembly, audittrail, business, dpt_trans, exchangerate, 
> exchangerate, gifi (Does not apply in my country), gl, inventory, 
> invoice, JCitems, oe, orderitems, partstax ( I will need to redo this 
> because of mistakes), Status, Yearend
>
> -*The following tables I Kept intact:* Chart, customer,customertax, 
> defaults ( I know i need t alter a few things there when I will start), 
> department, employee, language, makemodel, parts, partscustomer, 
> partsgroup, pricegroup, project(was empty), recurring (was empty), 
> Recurringemail (was empty), Recurringeprint (was empty), shipto (was 
> empty),  sic (was empty), tax, translation, vendor, vendortax, warehouse,
>
>
>  From this I want start all over again (not so much need to be entered),
>
>     * Orderentries,
>     * salesbookings
>     * financialbookings etc
>
>
> I have been playing around a bit and it seems it will work, can anybody 
> comment on this exercise before I start putting in my orders, sales, 
> bookings etcetera. It is allways very painfull to find out you have done 
> things wrong
>
> Tanks in advance
>
> Luc
>
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys - and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>
>
>   

[SL] console API

[William M. <wi...@op...>]

I am trying to use the console API for Vendor invoices to set up our 
initial inventory. The script below fails with:

You are logged out! <p><a href=login.pl target=_top>Login</a>

---------
./ir.pl "
path=bin/mozilla&
login=william&
password=my_passwd&
action=Post&
vc=vendor&
type=invoice&
vendor=My Company&
oldvendor=My Company--24092&
vendor_id=24092&
AP=2100--Accounts Payable&
currency=USD&
defaultcurrency=USD&
invnumber=123&
transdate=01-25-2007&
duedate=01-25-2007&
runningnumber_1=1&
partnumber_1=RZ22-4&
description_1=Ring, Terminal, 26-22&
qty_1=1&
sellprice_1=14.92&
oldcurrency=USD&
id_1=10713&
notes=Invoice posted from the command line&
AP_paid=1060--Checking Account&
paidaccounts=1&
datepaid_1="01-25-2007"&
rowcount=2
"
-------

Any ideas about what is wrong?

Thanks,
Wm