Re: [Ledger-smb-devel] Creating POs/Salesorders directly...

2007-01-03 Thread Chris Travers
Also note that I am in favor of a stable db schema once we get to a certain point because db-level access makes sense for certain sorts of integration challenges (i.e. where triggers make sense). However, we are certainly not there yet, so you should be very careful about entering data directly in

Re: [Ledger-smb-devel] Creating POs/Salesorders directly...

2007-01-03 Thread Charley Tiggs
Jason Rodrigues wrote: > On Wednesday 03 January 2007 10:36, Charley Tiggs wrote: >> Hello, >> 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. > > Genrally, you shou

Re: [Ledger-smb-devel] Creating POs/Salesorders directly...

2007-01-03 Thread Jason Rodrigues
On Wednesday 03 January 2007 10:36, Charley Tiggs wrote: > Hello, > 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. Genrally, you should avoid directly inserting/updat

[Ledger-smb-devel] Creating POs/Salesorders directly...

2007-01-03 Thread Charley Tiggs
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 gener