We want to generate invoices in
LedgerSMB programmatically, not manually, since there are hundreds
or even thousands weekly.
So far I've taken the approach of creating a row in the AR table, along with rows in the INVOICE table (and possibly creating a customer, too).
To post the invoices and have data in LedgerSMB referentially correct, it looks like I need to add two rows to the ACC_TRANS table.
Can you confirm that?
Is there a better approach (eg, executing a store procedure)? Any other tables to affect?
Thanks.
Brian
On 06/18/2013 04:26 PM, Erik Huelsmann wrote:
So far I've taken the approach of creating a row in the AR table, along with rows in the INVOICE table (and possibly creating a customer, too).
To post the invoices and have data in LedgerSMB referentially correct, it looks like I need to add two rows to the ACC_TRANS table.
Can you confirm that?
Is there a better approach (eg, executing a store procedure)? Any other tables to affect?
Thanks.
Brian
Brian Wolf
Phone: 410.367.2958
Email: ..hidden..
Try out Activus
Secure Payments™, our recurring payments
application.
Demo at http://demo.activustech.com
Hi Brian,
On Tue, Jun 18, 2013 at 10:12 PM, Brian Wolf <..hidden..> wrote:
I want to generate invoices programmatically (based on data from another system), along with a payment.
The result can be either posted invoices (with full accounting effects) or unposted with subsequent human intervention in batch.
We're talking about hundreds of invoices weekly.
With this description, I conclude you're sending the actual invoices from another system or source? In that case, I would advise using AR Transactions, optionally with an invoice from the source attached. AR Transactions can be saved to be posted. Unfortunately, the change was too invasive in old code to do the same for invoices. Basically, we want to get 1.4 out as soon as possible in order to rewrite the rfq/order and (remaining) AR/AP stuff for 1.5 and up. However, stabilizing it is taking longer due to the fact that Chris and I have been spending more time on 1.3 than expected.
--
Bye,
Erik.
http://efficito.com -- Hosted accounting and ERP.Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Ledger-smb-users mailing list ..hidden.. https://lists.sourceforge.net/lists/listinfo/ledger-smb-users