sql-ledger-users

[SL] Statement Question

[Shawn J. (CSP) <jo...@gm...>]

Hi, 

I have a question regarding statements. I would like to send
statements to my clients, but I would like to only include this years
accounts. But when I generate the statement it show's invoices from
last year. How do I send out a statement that only shows invoices this
year.

Thanx

Shawn

[SL] Statement Question

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

   My understanding of an accounts receivable statement is that it is a
history of what's been invoiced, paid, and remains outstanding. However,
when I print an invoice for a client who's late in paying, but who paid part
of one outstanding invoice, I see only what is still due to be paid. This is
from the Accounts Receivable -> Aged page.

   Is there another report that can be used to produce a statement with the
full amounts of invoices plus the partial payments, too?

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [SL] Statement Question

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

The aged page is to analyse A/R and send out reminders or run phone lists.
"I see there are overdue invoices,would that have anything to do with the
credit crunch crisis maybe, and if so, when do you expect to pay?"

Use sales reports per customer for analyses of sales might be easier.
Or tack the box with closed transactions when running the A/R report.

Fact is, A/R type of people are normally only interested in outstanding
invoices, not in sales. Whereas sales people tend to overlook the fact a
customer might be non paying. From a sales point of view that is irrelevant,
as long as they hit the turnover targets and get the christmas bonus. Credit
controllers tend to have a different opinion there ;-)

2008/11/25 Rich Shepard <rsh...@ap...>

>   My understanding of an accounts receivable statement is that it is a
> history of what's been invoiced, paid, and remains outstanding. However,
> when I print an invoice for a client who's late in paying, but who paid
> part
> of one outstanding invoice, I see only what is still due to be paid. This
> is
> from the Accounts Receivable -> Aged page.
>
>   Is there another report that can be used to produce a statement with the
> full amounts of invoices plus the partial payments, too?
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.               |  Integrity            Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:
> 503-667-8863
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>

[SL] purchase invoice does not match vendors invoice

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

hi,

so i have several parts in the system - and i go get them from a
supplier.

now the supplier gives me his invoice on paper.

and i go to enter this invoice into sql-ledger.

one of the lines is causing the invoices not to match.

5 items at 0.95 each = 4.75

minus 30% discount - this should be 1.425 - say 1.43 rounded

which should give a total of 3.32

but sql-ledger calculates the amount after discount as 3.30

its only 2p but obviously it will not work when reconciling the bank
statements.

now i know that somtimes the VAT will differ by a penny so being
slightly different is going to happen.

what i want to know is this...

how do i change the amount to match what i actually paid the vendor?

and is SL calculating the discount differently from expected?

thanks - kevin

Re: [SL] purchase invoice does not match vendors invoice

[Jeff V. <jv...@ch...>]

On Wed, 2005-04-20 at 11:30 +0100, Kevin Bailey wrote:
> hi,
> 
> so i have several parts in the system - and i go get them from a
> supplier.
> 
> now the supplier gives me his invoice on paper.
> 
> and i go to enter this invoice into sql-ledger.
> 
> one of the lines is causing the invoices not to match.
> 
> 5 items at 0.95 each = 4.75
> 
> minus 30% discount - this should be 1.425 - say 1.43 rounded
> 
> which should give a total of 3.32
> 
> but sql-ledger calculates the amount after discount as 3.30
> 
> its only 2p but obviously it will not work when reconciling the bank
> statements.
> 
> now i know that somtimes the VAT will differ by a penny so being
> slightly different is going to happen.
> 
> what i want to know is this...
> 
> how do i change the amount to match what i actually paid the vendor?
> 
> and is SL calculating the discount differently from expected?
> 
> thanks - kevin
> 
> 
> 

This rounding issue has been brought up before and the rounding occurs
as Deiter has specified.

SL does the rounding at the per-item level.

IMHO rounding should be selectable by the user to do it at any one of
three points; 1. per-item (greatest errors from expected) 2. per-line
(extended price) on the invoice, or 3. per-invoice total. 

This would make it versatile enough to meet almost any need.