On Fri, 2002-08-30 at 13:08, Dieter Simader wrote: > Not at all. You must write an import routine which either generates sql or > a commandline argument to be passed to the appropriate script.
Can you import directly to the database? What I mean is we would write a script in php to export from our web database which would post to a table the last order number exported, last customer number,etc. store the values in an array, then connect to the LAN postgres database and post to the appropriate tables. We are most interested in a efficient means to process orders and track inventory than in accounting with the G/L. We have a firm which does our tax accounting. We don't necessarily need to maintain strict accounting rules in this application. There is an autoincrementing id field in table oe. I assume in creating a query to update that table, we would use a "" for the id field and the database would assign it the next available number. The order numbers are assigned by the web database. > > > > > Secondly, we have backordered items. How are the current users handling > > backorders? I understand they will be supported in a future version. > > You keep the sales order and revise it. > Well yes, of course. But it would be helpful if we had a trigger to release backorders when stock arrives. We ship 150+ orders per day and have 2 full time staffers who enter orders into a networked Quickbooks. We max out the transaciton limit in quickbooks about every quarter. It's also exceedingly slow and cumbersome. As far as the backorders go, we could probably use the notes field until we can find a solution. Thanks for your input. Susan ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
