Delete related data from book keeping report

By /

Delete related data from book keeping report

Delete related data such as products, staff and customers from the book keeping report within a given date range. Set the schedule to run daily automatically or run manually when needed.
reportsproductscustomersstaff Available
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 products, staff or 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.

Address Line1

Filter

Address Line1

Filter

Address Line1

Filter

Address Line2

Filter

Address Line2

Filter

Address Line2

Filter

Age Restriction

Filter

Amount

Filter

Article Code

Filter

Article Code

Filter

Article Code

Filter

Barcode

Filter

Barcode

Filter

Barcode

Filter

Bottle Deposit Item I D

Filter

Brand I D

Filter

Brand I D

Filter

Brand Name

Filter

Business Name

Filter

Button Colour I D

Filter

Button Colour I D

Filter

Button Colour I D

Filter

Button Colour I D

Filter

Button Colour I D

Filter

Button Colour I D

Filter

Button Colour Name

Filter

Can Access Back Office

Filter

Can Access Back Office

Filter

Can Access Misc Products

Filter

Can Access Misc Products

Filter

Can Access Table Plan

Filter

Can Access Table Plan

Filter

Can Access Till

Filter

Can Access Till

Filter

Can Access Till Admin Options

Filter

Can Access Till Admin Options

Filter

Can Accesss Customers

Filter

Can Accesss Customers

Filter

Can Adjust Float

Filter

Can Adjust Float

Filter

Can Apply Basket Discounts

Filter

Can Apply Basket Discounts

Filter

Can Apply Item Discounts

Filter

Can Apply Item Discounts

Filter

Can Change Tab Spend Amount

Filter

Can Change Tab Spend Amount

Filter

Can Clear Transaction

Filter

Can Clear Transaction

Filter

Can Delete Unordered Items

Filter

Can Delete Unordered Items

Filter

Can Disable Service Charge

Filter

Can Disable Service Charge

Filter

Can Edit Customer Points

Filter

Can Edit Customer Points

Filter

Can Hold Transaction

Filter

Can Hold Transaction

Filter

Can Manually Select Customer

Filter

Can Manually Select Customer

Filter

Can Order Allocation Server

Filter

Can Order Allocation Server

Filter

Can Order Allocation Table Manager

Filter

Can Order Allocation Table Manager

Filter

Can Order Allocation Team Server

Filter

Can Order Allocation Team Server

Filter

Can Receive Stock

Filter

Can Receive Stock

Filter

Can Refund Items

Filter

Can Refund Items

Filter

Can Remove From Table

Filter

Can Remove From Table

Filter

Can Run End Of Day

Filter

Can Run End Of Day

Filter

Can See End Of Day Report

Filter

Can See End Of Day Report

Filter

Can Send Stock

Filter

Can Send Stock

Filter

Can Server Baking

Filter

Can Server Baking

Filter

Can Stock Take

Filter

Can Stock Take

Filter

Can Tip Out Others

Filter

Can Tip Out Others

Filter

Can Tip Out Self

Filter

Can Tip Out Self

Filter

Can Unlock Device Via Pin

Filter

Can Unlock Device Via Pin

Filter

Can Unrestricted Stock Take

Filter

Can Unrestricted Stock Take

Filter

Can Use Number Sale

Filter

Can Use Number Sale

Filter

Can Use Payouts

Filter

Can Use Payouts

Filter

Can Use Petty Cash

Filter

Can Use Petty Cash

Filter

Can Void Items

Filter

Can Void Items

Filter

Card Number

Filter

Category

Filter

Category I D

Filter

Category I D

Filter

Category I D

Filter

Category I D

Filter

Category I D

Filter

Category I D

Filter

Category Name

Filter

Code

Filter

Colour I D

Filter

Colour I D

Filter

Colour Name

Filter

Contact Number

Filter

Contact Number

Filter

Contact Number

Filter

Contact Number2

Filter

Contact Number2

Filter

Contact Number2

Filter

Container Fee I D

Filter

Container Fee I D

Filter

Container Fee Name

Filter

Container Fee Value

Filter

Cost Price

Filter

Cost Price

Filter

Cost Price Ex Tax

Filter

Cost Price Excluding Tax

Filter

Cost Price Factor

Filter

Cost Price Including Tax

Filter

Cost Price Measurement Scheme Item I D

Filter

Cost Price Measurement Scheme Item I D

Filter

Cost Price Measurement Unit Volume

Filter

Cost Price Measurement Unit Volume

Filter

Cost Price Tax Group I D

Filter

Cost Price Tax Group I D

Filter

Cost Price Tax Group Name

Filter

Cost Price Unit

Filter

County

Filter

County

Filter

County

Filter

Current Balance

Filter

Current Points

Filter

Cust I D

Filter

Customer Address I D

Filter

Customer I D

Filter

Customer Type I D

Filter

Customer Type Name

Filter

Date Of Birth

Filter

Date Time

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Description

Filter

Detailed Description

Filter

Device

Filter

Discount Reason

Filter

Discount Value

Filter

Display Once Per Transaction

Filter

Eat In Take Out

Filter

Eat Out

Filter

Eat Out Price

Filter

Eat Out Price

Filter

Eat Out Price

Filter

Eat Out Price Ex Tax

Filter

Eat Out Price Including Tax

Filter

Eat Out Price Tax Group I D

Filter

Eat Out Price Tax Group I D

Filter

Eat Out Price Tax Group Name

Filter

Email

Filter

Email Address

Filter

Email Address

Filter

Email Address

Filter

Exclude From Loyalty Points Gain

Filter

Exclude From Loyalty Points Gain

Filter

Expiry Date

Filter

Forename

Filter

Forename

Filter

From Date

Filter

Full Name

Filter

Has Swipe Card

Filter

Hourly Rate

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

I D

Filter

Image U R L

Filter

Is Admin On Till

Filter

Is Admin On Till

Filter

Is Archived

Filter

Is Cost Price Including Tax

Filter

Is Cost Price Including Tax

Filter

Is Eat Out Price Including Tax

Filter

Is Eat Out Price Including Tax

Filter

Is Main Address

Filter

Is Multiple Choice Product Optional

Filter

Is Sale Price Including Tax

Filter

Is Sale Price Including Tax

Filter

Is Tax Exemptable

Filter

Is Variable Price

Filter

Is Variable Price

Filter

Location

Filter

Location Area I D

Filter

Mail

Filter

Main Image

Filter

Main Location I D

Filter

Margin

Filter

Margin

Filter

Max Basket Discount Amount

Filter

Max Basket Discount Amount

Filter

Max Basket Discount Percentage

Filter

Max Basket Discount Percentage

Filter

Max Credit

Filter

Max Customer Credit Limit

Filter

Max Customer Credit Limit

Filter

Max Item Discount Amount

Filter

Max Item Discount Amount

Filter

Max Item Discount Percentage

Filter

Max Item Discount Percentage

Filter

Max Refund Amount

Filter

Max Refund Amount

Filter

Measurement Scheme Item I D

Filter

Measurement Unit Volume

Filter

Multi Choice Note Name

Filter

Multiple Choice Note I D

Filter

Multiple Choice Note I D

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Name

Filter

Net Sales

Filter

Nominal Code

Filter

Nominal Code

Filter

Nominal Code

Filter

Nominal Code

Filter

Nominal Code

Filter

Note

Filter

Notes

Filter

Notes

Filter

Order Code

Filter

Order Code

Filter

Order Quantity Limit

Filter

Parent I D

Filter

Parent I D

Filter

Parent I D

Filter

Parent I D

Filter

Phone

Filter

Popup Note I D

Filter

Popup Note I D

Filter

Popup Note Short Description

Filter

Post Code

Filter

Post Code

Filter

Post Code

Filter

Price I D

Filter

Product

Filter

Product I D

Filter

Product I D

Filter

Product I D

Filter

Product Type

Filter

Product Type

Filter

Quantity

Filter

Quantity Unit

Filter

R R Price

Filter

Reference Code

Filter

Reference Code

Filter

Reference Code

Filter

Reporting Category I D

Filter

Reporting Category I D

Filter

Reporting Category I D

Filter

Reporting Category I D

Filter

Role I D

Filter

Rr Price

Filter

S K U

Filter

S K U

Filter

Sale Price

Filter

Sale Price

Filter

Sale Price

Filter

Sale Price Ex Tax

Filter

Sale Price Factor

Filter

Sale Price Including Tax

Filter

Sale Price Measurement Scheme Item I D

Filter

Sale Price Measurement Unit Volume

Filter

Sale Price Tax Group I D

Filter

Sale Price Tax Group I D

Filter

Sale Price Tax Group Name

Filter

Sale Price Unit

Filter

Scannable Only

Filter

Select Brands

Filter

Select Customer Addresses

Filter

Select Customers

Filter

Select Parent Categories

Filter

Select Product Categories

Filter

Select Products

Filter

Select Products Catalogue

Filter

Select Reporting Categories

Filter

Select Role

Filter

Select Role

Filter

Select Root Categories

Filter

Select Staff

Filter

Select Suppliers

Filter

Select Suppliers

Filter

Sell On Till

Filter

Sell On Till

Filter

Sell On Web

Filter

Sell On Web

Filter

Show At All Locations

Filter

Show On Till

Filter

Show On Till

Filter

Show On Till

Filter

Show On Till

Filter

Sign Up Date

Filter

Sign Up Location I D

Filter

Size

Filter

Sort Position

Filter

Sort Position

Filter

Sort Position

Filter

Sort Position

Filter

Sort Position

Filter

Staff

Filter

Staff I D

Filter

Supplier I D

Filter

Supplier I D

Filter

Supplier Name

Filter

Surname

Filter

Surname

Filter

Tag Type I D

Filter

Tare Weight

Filter

Tare Weight

Filter

Tax

Filter

Tax Code

Filter

Tax Exempt Eligible

Filter

Tax Rate I D

Filter

Tender

Filter

Text

Filter

Till Order

Filter

Title

Filter

Title

Filter

To Date

Filter

Total Sales

Filter

Town

Filter

Town

Filter

Town

Filter

Type

Filter

Type

Filter

Type

Filter

Unit Of Sale

Filter

Unit Of Sale

Filter

Value

Filter

Value

Filter

Value

Filter

Value

Filter

Variant Description

Filter

Variant Group I D

Filter

Variant I D

Filter

Variant Item I D

Filter

Volume Of Sale

Filter

Volume Of Sale

Filter

Wet

Filter

Wet

Filter

Wet

Filter

Wet

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.

Product I D

Action
Scroll to Top