sql-ledger-users

Error Creating New Customer Invoice...

[David R. <dr...@su...>]

Hello all,

V1.8 so far has lived up to all the expectations and more! Many thanks to 
Dieter and all who labor in the testing process.

I have an error that comes up when I try to enter a customer invoice (listed 
in full below). It happens only when billing a PART or ASSEMBLY, *NOT* when 
billing a SERVICE.

I corrected the problem with the following change to IS.pm
LINE 500: AND i.qty < 0			(change to specify 'i.')
LINE 501: AND (i.qty + i.allocated) < 0	(change to specify 'i.')



========================================================
Error!

SELECT i.id, i.qty, i.allocated, i.sellprice,
(SELECT c.accno FROM chart c
WHERE p.inventory_accno_id = c.id)
AS inventory_accno,
(SELECT c.accno FROM chart c
WHERE p.income_accno_id = c.id)
AS income_accno,
(SELECT c.accno FROM chart c
WHERE p.expense_accno_id = c.id)
AS expense_accno
FROM invoice i, parts p
WHERE i.parts_id = p.id
AND i.parts_id = 12356
AND qty < 0
AND (qty + allocated) < 0
ORDER BY id
ERROR: Column 'allocated' is ambiguous 
=============================================
-Dave Ratte
Superior Circuit Technologies, Inc.
321-254-4201 x 204
dr...@su...

Invoice Adjustments: Simple ways?

[alta <al...@al...>]

What is the best way (simplest and quickest way) to adust the 
monetary value in an invoice form.

For example, suppose a customer takes the 2% early-pay discount, or 
they under-pay a small amount.  How do I easily adjust the sql-ledger 
books to show the invoice fully paid?

This happens often, so I am looking for an efficient way with 
sql-ledger.  In my previous system I had an invoice field for 
adjustments, which was simple, clear, and fast.

In asking this question, I have a hunch my novice bookkeeping skills 
are showing through.  Your suggestions appreciated.

Thanks ... Reed

-- 
Reed White  -  ALTA RESEARCH  -  www.alta-research.com
Phone: 877-360-2582  -  Email: al...@al...

Re: Invoice Adjustments: Simple ways?

[Dieter S. <dsi...@sq...>]

Yes, the simple way is to add an expense account (Sales Discount) and
check the 'Deposit' box under 'Receivables'.

Now when you add a payment, you enter the amount the customer paid you in
your bank / cash account and add another payment with the difference using
the 'Sales Discount' account.

You can apply the same for vendor discounts, but you add a 'Purchase
Discount' account in the income section instead and flag it as a payment
account.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On Sun, 6 Jan 2002, alta wrote:

> 
> What is the best way (simplest and quickest way) to adust the 
> monetary value in an invoice form.
> 
> For example, suppose a customer takes the 2% early-pay discount, or 
> they under-pay a small amount.  How do I easily adjust the sql-ledger 
> books to show the invoice fully paid?
> 
> This happens often, so I am looking for an efficient way with 
> sql-ledger.  In my previous system I had an invoice field for 
> adjustments, which was simple, clear, and fast.
> 
> In asking this question, I have a hunch my novice bookkeeping skills 
> are showing through.  Your suggestions appreciated.
> 
> Thanks ... Reed
> 
>