Altru Ideas

Way to Include Dates with No Sales in Sales Order Query

I have to pull data out of Altru and compile it with other data in excel.

Many of the excels I have include every single date including Christmas, Thanksgiving, New Years, 4th of July, other dates the Museum is closed. When I do a sales order query to pull the data, if there were no sales on that date, I have to manually go through all of the data and add those missing dates in and move all of the data underneath it down one row. Anyway if it included every date I would be able to combine data much more easily with out this manual step.

  • Guest
  • Apr 8 2020
Customer references The Cleveland Museum of Natural History
  • Attach files