Is it possible to set the business date in an automation schedule? Invoices are prepared using the process at month end because consolidation of sales orders is necessary. The volumes are high and when users run the process it may fail when it gets over 1 hour, resulting in no consolidation. So running the prepare in an automation should take care care of this. However invoicing does not start until day1 of the new period. Users set their business date back to ensure correct invoice date/period, hence the request.
Setting Business Date in automation schedules
I’m pretty sure the “Relative” CheckBox is intended for this sort of situation, but I wasn’t able to quickly figure out how to set it, since the invoice date seems to be locked to the shipment date.
Maybe this is the situation you ran into and why you asked the question?
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/9a8a4ead-5904-45c7-9fe8-bd10e39313a7.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/ac8736ca-0712-4ea6-84d2-e4cc3ac22dbb.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/43a2a6e5-ca5e-4c67-8f22-6f4800451369.png)
Yes, no way to control the invoice date except with the business date as far as I can find. Coming from IN sales order type so skips shipments.
Since it’s locked down by the system, I would suggest creating a support case to see if there is a recommended method to accomplish this. I don’t think it’s a bug, but I don’t know why they would lock it down. It seems like your requirement would be a common business case….
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.