EOD/W/M Reporting Area/Setup

Reporting Area

Automated Reporting Area: https://drive.google.com/drive/u/1/folders/1jjemo61F7WOJmil0tCQSdryAC2r4YQvb

Setting we use to point at the folder bobglobalconfiguration.gdriverootfolderid =1jjemo61F7WOJmil0tCQSdryAC2r4YQvb

To build up monthly KPI figures when it is not the end of the month we need to ensure bobglobalconfiguration.kpitableupdatetaskbypassdatecheck is set to TRUE so it can be ran.

Full Stock List – Uses spLast12Months stored procedure

Update bob_ProductKPIQuantityHistory every month with new sales data.

Requires Task: UpdateMonthlyProductFigures to be ran which updates Bob_ProductMonthlyKPI table.

End of Day

(BoB 2 Task – Report Build And Save Task EOD)

Run Time: Every day at 01:00AM.

Consists of the following reports…

• Daily Takings
  • StartDate = ReportDate (Yesterdays date) with time = 00:00AM
  • End Date = ReportDate with time = 23:59PM
• VAT Report
  • StartDate = ReportDate with time = 00:00AM
  • End Date = ReportDate with time = 23:59PM

End of Week

(BoB 2 Task – Report Build And Save Task EOW)

Run Time: Every 7 Days with start date being 1st of the month at 01:15AM.

Consists of the following reports…

• Average Invoice Values
  • StartDate =
  • End Date =
• Stock Adjustments
  • StartDate =
  • End Date =

End of Month

(BoB 2 Task – Report Build And Save Task EOM)

Run Time: Task to run daily at 01:30AM, though an IF to check on run that looks at whether it is the first of the month. If it is then run the task, else fail and try again the next day.

NOTE: First task that runs should be UpdateMonthlyProductFigures, this builds the new data needed to build bob_ProductKPIQuantityHistory, which is a summary at stock level of the sales for a month and the On Hand Qty & Cost at EOM.

Consists of the following reports…

• Daily Takings
  • StartDate = First day of the previous month with time = 00:00AM
  • End Date = Last day of the previous month with time = 23:59PM
• VAT Report
  • StartDate = First day of the previous month with time = 00:00AM
  • End Date = Last day of the previous month with time = 23:59PM
• All GRN
  • StartDate = First day of the previous month with time = 00:00AM
  • End Date = Last day of the previous month with time = 23:59PM
• Stock Awaiting Pick or Pack
• Stock Dispatched
  • StartDate = First day of the previous month with time = 00:00AM
  • End Date = Last day of the previous month with time = 23:59PM
• Orders Awaiting Pick or Pack
  • StartDate = First day of the previous month with time = 00:00AM
  • End Date = Last day of the previous month with time = 23:59PM

Update: The below reports have been added to EOM as of the 21st July 2025.

 

Has a setting called bobglobalconfiguration.EOMrepordatecheck which when TRUE will perform a date check when trying to run the scheduled task and will only generate when its the first day of the month. Changing this to FALSE and running the task will pass the first and last day of the current month to generate and save the reports to the Google Drive