Which fields are updated during invoice printing?

[kevvlol]

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?

 

[dgillz]

Macola ES or Progression? Version? You should never post a question without providing this info.

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:

http://www.gainfocus.biz/exceladdin.html

 

[kevvlol]

@dgillz, we're running Macola ES v9.6.400. Completely forgot about invoice numbers! We are only simulating invoice printing, the posting will be done manually or, more likely, via deferred printing.

Thanks for the info!