Re: [SL] automatically posting recurring transactions

[Andreas S. <as...@ac...>]

hi,

using SL 2.6.21-2 (debian), I am using SQL Scripts.
One to generate "recurring" transactions - they are not automatically 
posted:

-- change Sales Invoice/AR number - so every time I generate invoices I 
can set the starting number

-- change default AR account so I can determine which account theese 
invoices go to and

-- select all transaction under recurring transactions and press "process 
transactions"

Afer that I use the second script to delete these "recurring" 
transactions.

Prerequisites are a view based on special 
customers.notes, business.description and invoice.description which shows 
the customers that got invoices during the last three Years
and another one based on that that gives the first year the customer has 
to get an invoice and some functions to fill parts_id, description, 
fxsellprice and sellprice in invoice.

Determined by customer type and last invoice for each specific 
customer
reduction and parts are selected:

-- first the customers are selected into tmp_customer, then invoices into 
tmp_invoice, third Accounts receivable ( ar ) into tmp_ar, then the last 
invoice number + 1 into tmp_firstinvoice.

from these tmp_ tables I fill ar, update the invoice number there, fill 
invoice, fill acc_trans (two times), fill recurring and recurringemail.

done.

all the comments are in german, and the code is neither elegant nor error 
free, but it works for me.
If you are familiar with sql and all the above does not sound too 
complicated to you, it might be an inspiration, and you could possibly use 
it for your purposes.

If that is to complicated for you, you have to generate all invoices you 
need, press schedule and select the proper options.

regards

A.

On Thu, 12 Jun 2008, Walter V. Zamora wrote:

> Hi:
>
> Is there anyway that recurring transactions can be automatically posted
> when they are originally created?
>
> Will appreciate very much any input.
>
> regards
>
> Walter
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>