Which fields are updated during invoice printing?
Which fields are updated during invoice printing?
(OP)
Attempting to set up event manager invoicing, are there any fields which need to be updated for the order to be post-able besides changing status to 9? Does there need to be an invoice date (inv_dt) for the order to post?
RE: Which fields are updated during invoice printing?
Just be clear, can I assume the orders are already status 8 - selected for billing correct? All we need to do is simulate invoice printing right? If not this is a much deeper discussion.
If so, in the oeordhdr_sql table the status changes to '9' (note this is a string not a number), the inv_dt and inv_no fields are populated, the selection_cd is changed to an 'X'. Also the arctlfil_sql table the str_inv_no field is incremented by 1 (this is unsurprisingly, where you get the value for the inv_no field to be populated). There are no changes made to the oeordlin_sql table.
This answer is for Progression, not Macola ES, although it *should* be the same or very close to it. Progression populates dates as an 8 digit integer in the YYYYMMDD format, while ES uses a real date-time field.
I would test this event out by printing the invoice edit list and reprinting the invoices in Macola and make sure you like the physical output before posting.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html
RE: Which fields are updated during invoice printing?
Thanks for the info!