Hello, I am using Partkeepr for inventory and Gnucash on the same Mysql server instance.
I plan for customers to sign off on an initial invoice from Gnucash. A Partkeepr Materials List ID will be identical to the Gnucash Invoice number. I would like to create a database trigger on Partkeeper that inserts Materials entries (quantity, price, etc) into the Entries table in Gnucash using the invoice number (pre-created in Gnucash). I see the entries in the Gnucash Entries table have guid,date and date_entered fields as not null. Followed by invoice related fields i_acct ... i_discount_denom ... , followed by billing related fields and finally order_guid. Could this mechanism work from Gnucash point of view? If so, I would like to know how to obtain a new instance of guid for the records that I insert. Also Which of the Entries table fields are foreign keys? Such a mechanism would be of general benefit to anyone using an external inventory system. Best wishes _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
