Delete related data from sales summary report
reportslocations Available
Delete related data such as locations from the sales summary report within a given date range. Set the schedule to run daily automatically or run manually when needed.
This flow template gives you a good starting point and you can customise it as needed.
We’d love to hear about what you want to automate and can advise on how to use flow to meet your requirements.
Send us an enquiry or
book in a call, whatever suits you best.
When this happens…
Run automatically or manually
You can run this flow automatically on a schedule, for example every weekday at midnight, or choose to run it manually via our dashboard when you need it.
Trigger
Get the data …
Fetch the report
The flow will fetch the report from your Epos Now account ready for filtering
Fetch
Apply filters…
Target the data that matches your filters
Filter so that this is only applied to products, customers or staff which match your filters
Filter
Then do this…
Delete the data
Delete the locations that match the filters
Action
Customisation
This template can be easily customised by changing the triggers, filters and actions
Learn more
Triggers are the events that start the flow.
For example, run at 6pm on Mondays, Wednesdays and Fridays.
Scheduler
Set your flow to run automatically at a specific time or interval. Choose from monthly, weekly, daily or hourly.
Manual Run
Run your flow manually using our dashboard. This is useful for testing your flow or running it on demand.
Filters allow you to apply the actions only to the objects that pass the filter criteria you specify.
For example, filter by the customer type or where the customer name contains certain characters.
epn_sales_summary_report_customer_rating_AverageSum
epn_sales_summary_report_customer_rating_AverageRating
epn_sales_summary_report_customer_rating_RatingsCount
epn_sales_summary_report_customer_rating_CustomerCount
epn_sales_summary_report_DiscountValue
epn_sales_summary_report_FromDate
epn_sales_summary_report_GratuityValue
epn_sales_summary_report_ItemQty
epn_sales_summary_report_locationId
epn_sales_summary_report_margin_Percent
epn_sales_summary_report_margin_Amount
epn_sales_summary_report_margin_Avg
epn_sales_summary_report_net_sales_ExcTax
epn_sales_summary_report_net_sales_IncTax
epn_sales_summary_report_net_sales_AvgIncTax
epn_sales_summary_report_NoSaleQty
epn_sales_summary_report_RefundQty
epn_sales_summary_report_RefundValue
epn_sales_summary_report_SalesValueIncTax
epn_sales_summary_report_ToDate
epn_sales_summary_report_TransactionCount
epn_sales_summary_report_VoidLineQty
epn_sales_summary_report_VoidLineValue
epn_locations_barTabSpendLimit
epn_locations_countryName
epn_locations_decimalSeparator
epn_locations_description
epn_locations_emailAddress
epn_locations_groupSeparator
epn_locations_isWarehouse
epn_locations_locationAreaId
epn_locations_longTimeFormat
epn_locations_noOfTopSellers
epn_locations_numberOfBarTabs
epn_locations_phoneNumber
epn_locations_predefinedLocaleSettingsId
epn_locations_shortTimeFormat
epn_locations_showBarTabs
epn_location_areas_description
epn_location_areas_emailAddress
epn_location_areas_locationAreaId
epn_location_areas_locationAreaId_name
epn_location_areas_parentId
Actions allow you to make changes to the objects that pass the filter checks.
For example, set the customer balance to 10 or add 20% to the existing balance.
epn_sales_summary_report_locationId