Original Question:
Posted by Dan on Friday, October 23, 2009
OK I’ve been trying to figure out how to create a recurring transaction from a new invoice, not an already created invoice.
I click on Sales Invoice, enter product and amount and date on the invoice. I also enter a new description and change the invoice date to 11-01-2009. Next, I clicked on Schedule and entered another description here, set start date to 11-01-2009, checked off Email Invoice, and then clicked Save. The recurring transaction brings me back to the invoice and does not save anything in the recurring transaction list.
What am I missing?
Thanks,
Dan
Response from Marcus (localguru), Germany, on Saturday, October 24, 2009
Hi Dan,
If I understand the recurring concept of SQL-Ledger correctly, the first invoice is never a recurring invoice or transaction. In your example, you need to save the invoice itself first to create a recurring transaction.
However, if you set the date of the invoice and the first recurring transaction to the same date (e.g., 11-01-2009), you will create an invoice with a future date (11-01-2009) and not a recurring transaction starting on that date.
Important Notes
- Initial Invoice Date: The date of the initial invoice should reflect when the first transaction occurred, not necessarily the start date of the recurring series.
- Future Dated Invoices: Creating an invoice with a future date may not generate the recurring transaction as expected and can cause accounting inconsistencies.
- Recurring Transaction Creation: Recurring transactions are typically based on existing, saved transactions. Saving the initial invoice provides a template for the recurring entries.
Summary
To successfully create a recurring transaction in SQL-Ledger:
- First, create and save the initial invoice with the correct date and details.
- Then, set up the recurring schedule from the saved invoice, specifying the start date and frequency.
- Finally, verify that the recurring transaction has been saved and is listed correctly.
By following these steps, you should be able to generate recurring invoices that will automatically be created and, if configured, emailed to your customers at the specified intervals.
Ledger123.com 