Hello!

No, there's no programmatic API.. don't know where you saw that.. the DB structure is something you can find if you look on your DB, all the Invoice Manager tables are named #__invoices_XXXXXX (there's a table for invoices, for contacts, for items inside invoices...)

Thanks for your quick answer

I caugth the term "Invoice creation API" in the referenced topic, but i didn't know if it was a wish or a reality... I had a look to the database schema, that seems to be sufficiently clear so that i can automate my invoices creation.

However, i have several questions about the database fields :
1 - the field called "auth_code" in "invoices" table : How is it used by your code ? what value have I to use if I programmatically create my invoices ?
2 - the field called "external_type" in "items" table : It seems to be empty on all items I added. Could it be used for another purpose (i would like to link my products to joomla articles, without any modification in database if possible - this field could be useful for me...)
3 - why is there two "num" fields in invoices : invoice_num and real_invoice_num ?
4 - I saw that some fields in invoice table are computed before being stored (computed_status and computed_total). Could they be computed after i fill the database with my datas ? If yes, how can i do that ? or should i compute by myself (easy for total, no idea for status...) and store it in the database ?

And more globally, even if I understand that there is no developement documentation left, have you got some pieces of information about enumeration used in the tables (ie invoice "type" or payment "payment_status" enumeration for example)

Thanks by advance,

1. it's a random string to grant guest access to the invoice. we have a method to create such random codes, it's InvoicesHelper::getRandomCode()

2. it's only for internal reference. in invoice manager is left empty. you can use it otherwise if you want.

3. the real_invoice_num is an INTEGER, it's the real value for the invoice number.the other is the FORMATTED value.

4. we have a helper function to populate this after the invoice has been created. check out InvoicesHelper::updateComputedStatus($invoice_id, true, false);

these functions are in file components/com_invoices/helpers/helpers.php if you want to take a look.

although it's not really an API, it's similiar, it will help you get what you need.

Perfect, many thanks for your answer.