Time Zone shift and Invoice Gl_Date
Hello everyone,
I try to explicitly update the shipment start time via a custom agent via a direct sql update. At the first step i get (assign) the event_date correspondaing to the start time from the ie_shipmentstatus table, and next i update the shipment start time using a direct sql update.
After that, in the invoice we define the GL_Date as the value that we have stored (via the previous custom agent) in the Shipment Start_date. To do so, we assign the shipment start time and after , via a direct sql update, we update the gl_date of the invoice.