Hello, I'd like some confirmation of what I've found by turning on statement logging within postgres and watching the logs. Basically, creating purchase orders/sales orders involves inserting a record into the oe table (populating vendor_id or customer_id as appropriate), getting the id generated, and inserting the necessary records into the orderitems table with orderitems.trans_id set to oe.id. For both, a shipto record is created from the vendors/customers shipto information and associated with oe.id.
For purchase orders, if I don't enter my own PO number, I update the value of the default record to value + 1. Same goes for the order number for sales orders. Have I left anything out? I don't have multiple warehouses so the inventory table doesn't seem to come into play. Shipping/receiving is not involved at this point, either. Charley ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
