sql-ledger-users — SQL-Ledger users

[SL] SQL-LEDGER 2.7.11 add customer PROBLEM

[Paolo A. <pja...@gm...>]

Since i updgraded my sql-ledger i cannot add a new customer.  An error
always appears.

*DBD::Pg::db do failed: ERROR: duplicate key violates unique constraint
"customer_pkey" at SL/CT.pm line 259.
*Error!

*INSERT INTO customer (name)
VALUES ('Thu Mar 1 17:15:07 200720239')
ERROR: duplicate key violates unique constraint "customer_pkey"*


*Please help!
*

[SL] GAAP and fixed asset

[Vincenzo P. <epu...@it...>]

Good morning,

My name is Enzo Puliatti. I am the Chairman of IT Synergy ( www.itsyn.com ). We have an ongoing project aimed to spread the usage of SQL-Ledger for SMEs in Egypt and we are working on many localization and customization issues. However, we have recently faced a bureaucratic
issue and we are trying to find out if there is any experience on GAAP certification for SQL-Ledger or at least a clear "how-to do". Have you done anything in this sense in your  country or are you aware of any successful or ongoing effort in this senses?

I do understand that this may be different from country to country but we would like to start from some established experience. If nobody has collected these procedure we are most willing to collect all information and share it with all you. 

For those of you that (like me) are not to familiar with accounting procedures and rules, the  idea is to be able to completely replace manual bookkeeping (or "hybrid") with a fully computerized one using SQL-Ledger. I personally don't like the idea of using SL in my company and then having the accountant manually copying the information in a different format to present it to the relevant authorities.

A second issue is related to management of fixed assets. I have seen several scattered posting about this issue without a clearly defined procedures. This topic is also not mentioned in the manual and other documentation that I have found online.

The basic question is: how to treat the purchasing, inventorying and depreciation of fixed assets and other consumable that are meant to be used for the company itself and not for resale?

Thanks and regards,
Enzo Puliatti

-- 

_____________
Vincenzo Puliatti
Chairman,IT Synergy
Cairo Smart Village, Egypt
+20 2 5371020
www.itsyn.com 

Re: [SL] Microsoft Retail Management System

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

I believe MRMS has a standard Jet database back-end.  You should be  
able to make an ODBC/DAO/ADO/whatever connection to it via MS-Access  
or your favorite SQL scripting utility and get at the raw tables.   
Crystal Reports or one of the DataViz products might be of some help  
too if they are available.


Thanks,

Michael


On Feb 28, 2007, at 12:21 PM, Bob Crandell wrote:

> Hi,
>
> I just bought SQL-Ledger and am working my way through, I'm guessing,
> the typical issues with setting up a new company.
>
> My question is how do I get all the info out of MRMS?  The inventory
> exports ok but the client list only get names and phone numbers.
> Nothing else.  I can't get to the history at all.  I don't have any
> vendors to deal with in MRMS so I get to start from scratch with  
> them in
> SQL-Ledger.
>
> I used SQL-Ledger back in the 2.4.x days.  It has come a long way  
> baby.
>
> Thanks
> Bob Crandell
> ComputerBase USA.
> http://www.computerbaseusa.com/
>
> ---------------------------------------------------------------------- 
> ---
> 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] Microsoft Retail Management System

[Bob C. <bo...@co...>]

Hi,

I just bought SQL-Ledger and am working my way through, I'm guessing, 
the typical issues with setting up a new company.

My question is how do I get all the info out of MRMS?  The inventory 
exports ok but the client list only get names and phone numbers. 
Nothing else.  I can't get to the history at all.  I don't have any 
vendors to deal with in MRMS so I get to start from scratch with them in 
SQL-Ledger.

I used SQL-Ledger back in the 2.4.x days.  It has come a long way baby.

Thanks
Bob Crandell
ComputerBase USA.
http://www.computerbaseusa.com/

Re: [SL] Retail business accounting, from scratch

[David B. <dav...@sb...>]

On Wed, 2007-02-28 at 13:50 -0500, Matt Jackson wrote:
> Hello, all.
> 
> I have been forum digging (or mailing list digging) for the last hour or so
> and am having a hard time finding information.
> 
> I am new to SQL-Ledger, and do not know if people on this list are generally
> hostile towards those (such as myself) who have not purchased the commercial
> Reference Manual (business can't afford it at this time), but any help would
> be appreciated.
> 
> I have a functional knowledge of double-entry, accrual-basis accounting. For
> example, when I sell something and get paid by PayPal (which is most often
> the case), I debit PayPal Account (the asset account) and credit inventory.
> Similarly, I would debit inentory and credit cash when I purchase something,
> etc.
> 
> 
> Here are my concerns:
> 
> 1. I have both a website and eBay sales presence. This means that:
> - My sale prices are not always the same.
Sell price can be overridden on any order to my knowledge.  Depending on
how you intend to set up the customers, you can also assign price groups
or price lists to specific customers.
> - Shipping costs are not always the same (eBay customers pay shipping,
> website customers do not)
Set up and item or service as shipping charges (or shipping & handling)
and add to the orders as needed.
> - and also, my product costs are not always the same.
Best that I can tell, SQL-Ledger handles this well.  While my product
costs don't widely fluctuate, if you keep up with receiving and vendor
invoices (meaning process in a timely manner), SL should take care of
COGS well...it does for me.
> 
> How do I enter products in my system to track, but not put a price on them
> until I actually purchase them from my suppliers? Each time I buy, the price
> of the product and shipping fluctuates, meaning my Cost of Goods Sold
> fluctuates.
You can enter items as needed.  If I set something up that I intend to
bring into stock, I typically set the item up with "Last Cost" being
equal to what the cost is when I set the item up.  As above, if you buy
the item, receive the PO and process the vendor invoice in a timely
manner, SL will calculate last cost based on that data.
> 
> I partially started with SQL-Ledger in order to have a FIFO inventory
> accounting system for cost of goods sold for tax reporting purposes.
> 
> How do I accomplish this? I am afraid right now of starting down one path
> and then it being wrong.
> 
> 2. A fine point I am confused about: I assume to enter a new order, I would
> go to "POS" and select "Sale", enter the sale and save it. However, the only
> "Record in" option I see is "Accounts Receivable." I was taught that when
> you have already received payment (cash or, say, PayPal), it goes in your
> cash or PayPal account respectively. How do I add those options to the
> "Record in" drop-down box in the POS page.
I don't use POS...I use Order Entry --> Sales Order.  POS to me equals
cash register and a line of customers.  Order Entry --> Sales Order
allows me to key an order, print a pick ticket/packing list and save the
order.  I don't open the order again until it is time to ship the
product and invoice it.  Allows you to add shipping/handling based on
real dollar amounts etc.
> 
> 3. Why is there the "Checking Account/Petty Cash" drop-down box below the
> box in question one, on that same POS page? I thought that, for example, a
> sale was supposed to credit inventory and debit cash. Or debit checking
> account. I have no accounts receivable, only received payment (paypal, check
> or cash) and inventory to send out.
> 
Are you working with a stock COA?  Never using POS in SL before, I am
likely not going to be of much help.
> 4. Inventory: I understand I can enter inventory items, however, I purchase
> the same items that fluctuate in price all the time. I wanted to use
> SQL-Ledger partially as a way to calculate Cost of Goods Sold for the tax
> year. I purchase items in batches as item types but with a "custom" price
> each time. Am I supposed to go entering products like this, by order, each
> time with a different price? How do I do this, if so?
> 
Information above should be helpful to clarify.
> Also, my "sell" price changes. On the website it is one price, though that
> might be adjusted, and on eBay the sell price is almost always different.
> How do I account for this?
> 
Same deal as above...assign price groups/price lists or override the
price at sales order entry.
> Thank you for any help!
> 
Hope that it was...

David Boyle
NAPCO (Northwest Arkansas Paper Company)

[SL] Retail business accounting, from scratch

[Matt J. <sir...@gm...>]

Hello, all.

I have been forum digging (or mailing list digging) for the last hour or so
and am having a hard time finding information.

I am new to SQL-Ledger, and do not know if people on this list are generally
hostile towards those (such as myself) who have not purchased the commercial
Reference Manual (business can't afford it at this time), but any help would
be appreciated.

I have a functional knowledge of double-entry, accrual-basis accounting. For
example, when I sell something and get paid by PayPal (which is most often
the case), I debit PayPal Account (the asset account) and credit inventory.
Similarly, I would debit inentory and credit cash when I purchase something,
etc.


Here are my concerns:

1. I have both a website and eBay sales presence. This means that:
- My sale prices are not always the same.
- Shipping costs are not always the same (eBay customers pay shipping,
website customers do not)
- and also, my product costs are not always the same.

How do I enter products in my system to track, but not put a price on them
until I actually purchase them from my suppliers? Each time I buy, the price
of the product and shipping fluctuates, meaning my Cost of Goods Sold
fluctuates.

I partially started with SQL-Ledger in order to have a FIFO inventory
accounting system for cost of goods sold for tax reporting purposes.

How do I accomplish this? I am afraid right now of starting down one path
and then it being wrong.

2. A fine point I am confused about: I assume to enter a new order, I would
go to "POS" and select "Sale", enter the sale and save it. However, the only
"Record in" option I see is "Accounts Receivable." I was taught that when
you have already received payment (cash or, say, PayPal), it goes in your
cash or PayPal account respectively. How do I add those options to the
"Record in" drop-down box in the POS page.

3. Why is there the "Checking Account/Petty Cash" drop-down box below the
box in question one, on that same POS page? I thought that, for example, a
sale was supposed to credit inventory and debit cash. Or debit checking
account. I have no accounts receivable, only received payment (paypal, check
or cash) and inventory to send out.

4. Inventory: I understand I can enter inventory items, however, I purchase
the same items that fluctuate in price all the time. I wanted to use
SQL-Ledger partially as a way to calculate Cost of Goods Sold for the tax
year. I purchase items in batches as item types but with a "custom" price
each time. Am I supposed to go entering products like this, by order, each
time with a different price? How do I do this, if so?

Also, my "sell" price changes. On the website it is one price, though that
might be adjusted, and on eBay the sell price is almost always different.
How do I account for this?

Thank you for any help!


-- 
Regards,
Matt Jackson

[SL] 10 Perl modules all Java developers should know

[Nefnifi, K. <Kas...@at...>]

=20
Interesting to know and to read.=20
There are numerous CPAN modules which are designed to import Java =
classes into Perl scripts or access Java APIs like Swing, JDBC and JNI. =
This document lists the ten most important and useful modules in this =
collection

http://downloads.techrepublic.com.com/abstract.aspx?docid=3D284128&tag=3D=
nl.e101

Best Regards / Vriendelijke Groeten / Salutations Distingu=E9es / =
Freundliche Gr=FC=DFe !!!
Kasem

Re: [SL] Mid-size consulting firm; replacement for QuickBooks?

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

The lack of a payroll module may be an issue, depending on whether  
you're using QB's right now or not.
    Otherwise it really depends on the nature of the business.  E.g.  
I wouldn't put a healthcare organization on it due to the specialized  
insurance tracking and forms required.
    This is really where the MS lock-in has held sway for so long,  
the vast majority of businesses occupy what are called "vertical  
markets", i.e. they are in niche industries.  And for the most part  
those vertical markets have a small number of applications available  
to serve the day to day business process needs which are highly  
tailored to that particular demographic and which usually require  
Windows.
    This is not always the case of course, the retail sector has a  
rich selection of applications for all platforms OSS and otherwise.   
Construction companies on the other hand have about three options and  
they are all Windows based.
    So tell us - what do you do?  :)


Thanks,

Michael


On Feb 26, 2007, at 1:02 PM, JT wrote:

> ----- Original Message ----
> From: Rich Shepard <rsh...@ap...>
> To: sql...@li...
> Sent: Monday, February 26, 2007 2:23:25 PM
> Subject: Re: [SL] Mid-size consulting firm; replacement for  
> QuickBooks?
>
>
> On Mon, 26 Feb 2007, JT wrote:
>
>> I have used SL for my own home-office based business in the past, ...
>
>    Ergo, you are familiar with it and know how extensive it is.
>
>> We will soon start to look at the Microsoft Dynamics options, but  
>> I am
>> interested in finding out the availability of professional  
>> services to
>> support an SL implementation in an organization of our size.
>
>    I don't understand. If you want a proprietary solution from  
> Microsoft,
> then pay them. If you want to replace QB with SQL-Ledger that's a  
> totally
> different situation. First, you're aware of the help and resources  
> right
> here, since this is where you posted your message. Second, if you  
> look on
> the SQL-Ledger web site you'll see that there are companies that  
> provide
> hands-on help and that Dieter is available for paid help, too.
>
>    What's your question to the list?
>
> 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
>
> My question is relative to what type of companies have adopted SL  
> as their financial system; more specifically, does this group (or  
> Dieter) know of $10M - $50M companies using SL? I am not a  
> Microsoft fan; I would greatly prefer to go with an OSS solution;  
> especialy one with the flexibility to grow with our company. Does  
> anyone know of situations where companies had to migrate off of SL  
> due to running into limitations (I imagine not). I am looking for  
> organizations in similar situations to ours.
>
> Sorry for not being more clear on my last post.
>
> Jeremy
> ---------------------------------------------------------------------- 
> ---
> 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] Mid-size consulting firm; replacement for QuickBooks?

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

On Mon, 26 Feb 2007, JT wrote:

> My question is relative to what type of companies have adopted SL as their
> financial system; more specifically, does this group (or Dieter) know of
> $10M - $50M companies using SL? I am not a Microsoft fan; I would greatly
> prefer to go with an OSS solution; especialy one with the flexibility to
> grow with our company. Does anyone know of situations where companies had
> to migrate off of SL due to running into limitations (I imagine not). I am
> looking for organizations in similar situations to ours.

> Sorry for not being more clear on my last post.

Jeremy,

   Aha! Now we have something to address. :-)

   The direct answer to your question is that it's all dependent on the
database back end. SQL-Ledger is a set of perl scripts that glue together
the user interface (a textual or graphical web browser) and a database back
end for storing the data. So, the limitations -- if any -- are with the
database and nothing in front of it. (That's assuming that your httpd can
handle the desired number of simultaneous connections.)

   Over the years the question of limits of PostgreSQL has been raised many
times. For all practical purposes, the answer is that you'll not bump up
against table row limits (some users have reported at least 10 million rows
in a table). Now, if your computer and OS cannot access tables in the
terrabyte size, you might run into troubles there.

   If, however, you have a computer with a 64bit CPU, run a 2.6,x series
kernel, have fast and large hard drives, postgres will handle what you throw
at it. Take a look at http://www.postgresql.org for more information.

HTH,

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] Mid-size consulting firm; replacement for QuickBooks?

[JT <jtr...@ya...>]

----- Original Message ----=0AFrom: Rich Shepard <rsh...@ap...>=
=0ATo: sql...@li...=0ASent: Monday, February 26, =
2007 2:23:25 PM=0ASubject: Re: [SL] Mid-size consulting firm; replacement f=
or QuickBooks?=0A=0A=0AOn Mon, 26 Feb 2007, JT wrote:=0A=0A> I have used SL=
 for my own home-office based business in the past, ...=0A=0A   Ergo, you a=
re familiar with it and know how extensive it is.=0A=0A> We will soon start=
 to look at the Microsoft Dynamics options, but I am=0A> interested in find=
ing out the availability of professional services to=0A> support an SL impl=
ementation in an organization of our size.=0A=0A   I don't understand. If y=
ou want a proprietary solution from Microsoft,=0Athen pay them. If you want=
 to replace QB with SQL-Ledger that's a totally=0Adifferent situation. Firs=
t, you're aware of the help and resources right=0Ahere, since this is where=
 you posted your message. Second, if you look on=0Athe SQL-Ledger web site =
you'll see that there are companies that provide=0Ahands-on help and that D=
ieter is available for paid help, too.=0A=0A   What's your question to the =
list?=0A=0ARich=0A=0A-- =0ARichard B. Shepard, Ph.D.               |    The=
 Environmental Permitting=0AApplied Ecosystem Services, Inc.        |      =
    Accelerator(TM)=0A<http://www.appl-ecosys.com>     Voice: 503-667-4517 =
     Fax: 503-667-8863=0A=0AMy question is relative to what type of compani=
es have adopted SL as their financial system; more specifically, does this =
group (or Dieter) know of $10M - $50M companies using SL? I am not a Micros=
oft fan; I would greatly prefer to go with an OSS solution; especialy one w=
ith the flexibility to grow with our company. Does anyone know of situation=
s where companies had to migrate off of SL due to running into limitations =
(I imagine not). I am looking for organizations in similar situations to ou=
rs.=0A=0ASorry for not being more clear on my last post.=0A=0AJeremy

Re: [SL] Mid-size consulting firm; replacement for QuickBooks?

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

On Mon, 26 Feb 2007, JT wrote:

> I have used SL for my own home-office based business in the past, ...

   Ergo, you are familiar with it and know how extensive it is.

> We will soon start to look at the Microsoft Dynamics options, but I am
> interested in finding out the availability of professional services to
> support an SL implementation in an organization of our size.

   I don't understand. If you want a proprietary solution from Microsoft,
then pay them. If you want to replace QB with SQL-Ledger that's a totally
different situation. First, you're aware of the help and resources right
here, since this is where you posted your message. Second, if you look on
the SQL-Ledger web site you'll see that there are companies that provide
hands-on help and that Dieter is available for paid help, too.

   What's your question to the list?

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] Mid-size consulting firm; replacement for QuickBooks?

[JT <jtr...@ya...>]

I have used SL for my own home-office based business in the past, and I am =
very happy with the system. My use was relatively simple: a real estate dev=
elopment over 18 months with only (1) user...me.=0A=0AI run the IS for a mi=
d-size consulting company (75 people). We currently use QuickBooks, and we =
plan to move to a larger financial system within the next 12-18 months. =0A=
=0AWe will soon start to look at the Microsoft Dynamics options, but I am i=
nterested in finding out the availability of professional services to suppo=
rt an SL implementation in an organization of our size.=0A=0ATHANKS=0A

Re: [SL] How to add a custom link to the left menu column?

[Dirk E. S. <ds...@ca...>]

> Can someone please explain how to add a custom link to the left menu
> column.
> And how to add headers for these links etc..

http://www.sql-ledger.org/misc/api.html

Second chapter is about Customized menus -

Best wishes

Enrique

-- 
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com

Re: [SL] Speed up the booking of bank accounts: filled in journal rule possible?

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

Prem Pradeep schreef:
> I experience the booking of bank account transactions as unpractical,
> because in each booking through General Ledger, the bank account has to be
> chosen from the drop down list.
> Is there a way to make this action quicker, by creating a link in which the
> bank account is already filled in in the New Journal/Tansaction page of the
> General Ledger?
> Thanks
> -------------------------------------------------------------------------
> 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
>
>
>
>   
Prem, if you happen to KNOW teh accountnumber (banks start with 11xx in 
my CoA) you can enter data, tab to  the drop down  field and type 11.

The dropdown ten skips everything from 00 til 10xx, saving a lot of 
browing and mouse actions. Same goes for say 4400  rental expenses, 
saving even more scrolling.

Hth,
Paul

[SL] Speed up the booking of bank accounts: filled in journal rule possible?

[Prem P. <pre...@gm...>]

I experience the booking of bank account transactions as unpractical,
because in each booking through General Ledger, the bank account has to be
chosen from the drop down list.
Is there a way to make this action quicker, by creating a link in which the
bank account is already filled in in the New Journal/Tansaction page of the
General Ledger?
Thanks

[SL] How to add a custom link to the left menu column?

[Prem P. <pre...@gm...>]

Can someone please explain how to add a custom link to the left menu column.
And how to add headers for these links etc..

Thanks

[SL] ERP-OSS Acceptance Study

[<sal...@ho...>]

Dear OSS-ERP user,

We are Salvador Bueno and Dolores Gallego, Assistant Professors in Business 
Administration Department in Pablo de Olavide University at Seville, Spain.  
Our research involves an analysis about Open Source Software-Enterprise 
Resource Planning (OSS-ERP) and its impact at organization. We send you this 
mail to invite your participation in our study.

Specifically, our analysis consists on development a Technological 
Acceptance Model of an OSS-ERP.  We consider you are an OSS-ERP user and we 
appreciate the time necessary for answer our questionnaire. The name of the 
participants in this study will remain anonymous.

I would be most grateful if you participate in this survey. You only have to 
answer the questionnaire in the following URL and answer online. You will 
consider for answer the distribution of OSS-ERP you use.

http://aramis.upo.es/general/centros_depart/departamentos/invest/oss/

Please do not hesitate to contact us if you have any queries regarding this 
study.

Best regards,

Salvador Bueno, Ph D.

_________________________________________________________________
Descarga gratis la Barra de Herramientas de MSN 
http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH

Re: [SL] "You are logged out!" error message

[Rich C. <ri...@sy...>]

Double check that your computer time and your server time are correct.

Usually time mismatches cause your cookies to be already expired as they 
are written.

Rich C.

Prem Pradeep wrote:
> I see the following buttons at the bottom of a General Ledger account
> report:
>
> GL Transaction - AR Transaction - Sales invoice - AP Transaction - Vendor
> Invoice
>
> However, when I klik the buttons, I get the error message:
>
> "You are logged out!"
>
> What could be wrong?
> -------------------------------------------------------------------------
> 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] "You are logged out!" error message

[Prem P. <pre...@gm...>]

I see the following buttons at the bottom of a General Ledger account
report:

GL Transaction - AR Transaction - Sales invoice - AP Transaction - Vendor
Invoice

However, when I klik the buttons, I get the error message:

"You are logged out!"

What could be wrong?

[SL] Bulk-change AP transactions

[Prem P. <pre...@gm...>]

I need to change the invoice numbers of all AP transactions and need to know
what is the quickest way to do this. Clicking on one invoice number in the
AP transactions report, gives the tranaction with the amount blanked out!

Thanks

Re: [SL] Error 403

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

> On Monday 19 February 2007 8:08 am, Ursula Courtney wrote:
>Hi Roy,
> 
>Thanks for replying.  The error comes up as soon as I put the address in the bar and hit go.  I never get to see an SQL-Ledger page.  
> 
>Thanks,
>Ursula
> 

Check to make directory and file permissions are correct.
Check to make sure your webserver is configured to allow access to that directory

Cheers,
Roy

[SL] FW: Error 403

[Ursula C. <urs...@ho...>]

Hi Roy,
=20
Thanks for replying.  The error comes up as soon as I put the address in th=
e bar and hit go.  I never get to see an SQL-Ledger page. =20
=20
Thanks,
Ursula
QOTU's QUOTE of the DAY: "Do not spoil what you have by desiring what you h=
ave not; remember that what you now have was once among the things you only=
 hoped for."> From: arc...@mt...> To: sql...@li...urceforg=
e.net> Date: Mon, 19 Feb 2007 15:23:27 -0600> Subject: Re: [SL] Error 403> =
> On Monday 19 February 2007 8:08 am, Ursula Courtney wrote:> > > > Hi ever=
yone,> > > > I installed SQL-Ledger, as per the instructions for Windows on=
 the SQL website. However, when I go to log in to admin.pl, I get ERROR 403=
. I've gone through all the steps and as far as I can tell everything is do=
ne as per the instructions. > > > > If anyone could give me some insight in=
to why this isn't working, I would really appreciate it.> > > > Thanks,> > =
Ursula> > Error 403 is a webserver error. it's usually a permissions proble=
m.> > Can you be more specific of what you did to get the error ?> Can you =
load the admin.pl page at all ? or does it give you that error after you ac=
tually enter the admin password ?> > Cheers,> Roy> > ----------------------=
---------------------------------------------------> Take Surveys. Earn Cas=
h. 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...urceforge.=
net> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
_________________________________________________________________
Get connected - Use your Hotmail address to sign into Windows Live Messenge=
r now.=20
http://get.live.com/messenger/overview=

Re: [SL] Error 403

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

On Monday 19 February 2007 8:08 am, Ursula Courtney wrote:
> 
> Hi everyone,
>  
> I installed SQL-Ledger, as per the instructions for Windows on the SQL website.  However, when I go to log in to admin.pl, I get ERROR 403.  I've gone through all the steps and as far as I can tell everything is done as per the instructions.  
>  
> If anyone could give me some insight into why this isn't working, I would really appreciate it.
>  
> Thanks,
> Ursula

Error 403 is a webserver error. it's usually a permissions problem.

Can you be more specific of what you did to get the error ?
Can you load the admin.pl page at all ?  or does it give you that error after you actually enter the admin password ?

Cheers,
Roy

[SL] Error 403

[Ursula C. <urs...@ho...>]

Hi everyone,
=20
I installed SQL-Ledger, as per the instructions for Windows on the SQL webs=
ite.  However, when I go to log in to admin.pl, I get ERROR 403.  I've gone=
 through all the steps and as far as I can tell everything is done as per t=
he instructions. =20
=20
If anyone could give me some insight into why this isn't working, I would r=
eally appreciate it.
=20
Thanks,
Ursula
QOTU's QUOTE of the DAY: "Do not spoil what you have by desiring what you h=
ave not; remember that what you now have was once among the things you only=
 hoped for."
_________________________________________________________________
Get connected - Use your Hotmail address to sign into Windows Live Messenge=
r now.=20
http://get.live.com/messenger/overview=

Re: [SL] recurring transaction

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

Kevin Bailey wrote:

>Hi,
>
>The recurring transaction has been really neatly added and is a real 
>plus to the system.
>
>However I have a query.
>
>In the manual it says that there is a difference between scheduling a 
>new transaction and scheduling an existing transaction. But I can't get 
>this difference to work.
>
>When I open the transaction page I then add in the details and click 
>update. I can now click the schedule button now and fill in details for 
>the schedule - however this schedule is not saved and does not appear in 
>the list of recurring transactions.
>
>I have to post the transaction first, then relist the transactions, find 
>the transaction and then create the schedule - but this is the same as 
>scheduling as existing transaction.
>
>What I'd like to do is to create a scheduled which starts on say the 1st 
>July 2007 - so when I log in after the 1st July I am prompted to add 
>this transaction and it gets emails out.
>
>What I think I have to do currently is to create the transaction for 1st 
>July 2007. Then create a schedule for the subsequent transactions. I'll 
>then have to manually remember to email out the invoice on the 1st July 
>- but the next transactions will be prompted for which will be great.
>
>BTW - I say transactions but I am using sales invoices (which are a 
>transaction as far as I know!)
>
>Cheers,
>
>Kevin
>
>
>  
>


To answer my own post...

It looks like that you can hit the schedule button when building up an 
invoice. After you have added the schedule you are then taken back to 
the invoice screen.

Here it is now important to hit the 'Post' button. If this invoice is 
not posted then the schedule will not exist because it has no invoice to 
base itself on.

This also means that the first invoice will show in you scheduled list.

Maybe this could be looked into - with either a message saying that the 
invoice must now be posted for the schedule to be created. Or the 
'Schedule' button should be a 'Post and Schedule'. Hmmm.... not sure.

But at maybe the doc could be brought up-to-date.

Kevin