Sorry about the delay here. On Thu, Apr 12, 2012 at 6:59 AM, Andres Basile <[email protected]> wrote: > Hello Havard, > > I would like to finish this, at least a basic invoice but I'm having issues > understanding how to record the invoioce on the database, so far: > > 1. New Acc Transaction > -Id, table_name > > 2. New AR > -Date, invoice true, total with taxes, total without taxes, total paid > > 3. New Invoice > -Foreach part { trans_id, sell price, qty } > > 4. Inventory > -Foreach part {Parts_id, qty, shipping_date, trans_id} > > 5. Taxes > How should I record them? I'm summing total amount for each tax account and > then a transaction
These get recorded in acc_trans. > > 6. Cost Account > From where I have to get the part cost? Maybe an old transaction when I > bought it? The current approach is to look at the invoice table and check qty against allocated and build up COGS that way. I would like to move this into a stored procedure, as that would make it easier to make the logic consistent. If you can give me a few days, I can try to do this. Best Wishes, Chris Travers ------------------------------------------------------------------------------ For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
