I need to subtract the sales order of today from yesterday
In excel as shown below I can put this formula (+C7-C6) and get the difference between the numbers from yesterday and today.
how can I do this in Acumatica
this is my Grid
Answer
how do i subtract today sales order from yesterday sales order
Best answer by BenjaminCrisman
One thing to keep in mind is that all datetime fields are stored in the database in UTC time. So if an order was created at 8pm EST, then in the DB it will look like tomorrow’s date. So depending on when the orders were made, which time zone the user is in, and when the GI is being reviewed, the results could vary.
+4
+4One thing to keep in mind is that all datetime fields are stored in the database in UTC time. So if an order was created at 8pm EST, then in the DB it will look like tomorrow’s date. So depending on when the orders were made, which time zone the user is in, and when the GI is being reviewed, the results could vary.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.