Delete related data from sales summary report

By /

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.

Trigger
Manual Run

Run your flow manually using our dashboard. This is useful for testing your flow or running it on demand.

Trigger

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

Filter

epn_sales_summary_report_customer_rating_AverageRating

Filter

epn_sales_summary_report_customer_rating_RatingsCount

Filter

epn_sales_summary_report_customer_rating_CustomerCount

Filter

epn_sales_summary_report_DiscountValue

Filter

epn_sales_summary_report_FromDate

Filter

epn_sales_summary_report_GratuityValue

Filter

epn_sales_summary_report_ItemQty

Filter

epn_sales_summary_report_locationId

Filter

epn_sales_summary_report_margin_Percent

Filter

epn_sales_summary_report_margin_Amount

Filter

epn_sales_summary_report_margin_Avg

Filter

epn_sales_summary_report_net_sales_ExcTax

Filter

epn_sales_summary_report_net_sales_IncTax

Filter

epn_sales_summary_report_net_sales_AvgIncTax

Filter

epn_sales_summary_report_NoSaleQty

Filter

epn_sales_summary_report_RefundQty

Filter

epn_sales_summary_report_RefundValue

Filter

epn_sales_summary_report_SalesValueIncTax

Filter

epn_sales_summary_report_ToDate

Filter

epn_sales_summary_report_TransactionCount

Filter

epn_sales_summary_report_VoidLineQty

Filter

epn_sales_summary_report_VoidLineValue

Filter

epn_locations_address1

Filter

epn_locations_address2

Filter

epn_locations_barTabSpendLimit

Filter

epn_locations_countryName

Filter

epn_locations_county

Filter

epn_locations_currencyId

Filter

epn_locations_dateFormat

Filter

epn_locations_decimalSeparator

Filter

epn_locations_description

Filter

epn_locations_emailAddress

Filter

epn_locations_groupSeparator

Filter

epn_locations_id

Filter

epn_locations_id_name

Filter

epn_locations_isWarehouse

Filter

epn_locations_languageId

Filter

epn_locations_locationAreaId

Filter

epn_locations_longTimeFormat

Filter

epn_locations_name

Filter

epn_locations_noOfTopSellers

Filter

epn_locations_numberOfBarTabs

Filter

epn_locations_phoneNumber

Filter

epn_locations_postCode

Filter

epn_locations_predefinedLocaleSettingsId

Filter

epn_locations_shortTimeFormat

Filter

epn_locations_showBarTabs

Filter

epn_locations_timeZoneId

Filter

epn_locations_town

Filter

epn_location_areas_description

Filter

epn_location_areas_emailAddress

Filter

epn_location_areas_locationAreaId

Filter

epn_location_areas_locationAreaId_name

Filter

epn_location_areas_name

Filter

epn_location_areas_parentId

Filter

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

Action
Scroll to Top