Delete related data from book keeping report

By /

Delete related data from book keeping report

reportsproductscustomersstaff Available
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.

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 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.

epn_bookkeeping_report_ArticleCode

Filter

epn_bookkeeping_report_Barcode

Filter

epn_bookkeeping_report_Category

Filter

epn_bookkeeping_report_CostPrice

Filter

epn_bookkeeping_report_CustID

Filter

epn_bookkeeping_report_DateTime

Filter

epn_bookkeeping_report_Device

Filter

epn_bookkeeping_report_DiscountReason

Filter

epn_bookkeeping_report_DiscountValue

Filter

epn_bookkeeping_report_EatInTakeOut

Filter

epn_bookkeeping_report_EatOut

Filter

epn_bookkeeping_report_Forename

Filter

epn_bookkeeping_report_FromDate

Filter

epn_bookkeeping_report_FullName

Filter

epn_bookkeeping_report_Location

Filter

epn_bookkeeping_report_Margin

Filter

epn_bookkeeping_report_NetSales

Filter

epn_bookkeeping_report_NominalCode

Filter

epn_bookkeeping_report_Notes

Filter

epn_bookkeeping_report_Product

Filter

epn_bookkeeping_report_ProductId

Filter

epn_bookkeeping_report_Quantity

Filter

epn_bookkeeping_report_QuantityUnit

Filter

epn_bookkeeping_report_Staff

Filter

epn_bookkeeping_report_StaffID

Filter

epn_bookkeeping_report_Surname

Filter

epn_bookkeeping_report_Tax

Filter

epn_bookkeeping_report_TaxCode

Filter

epn_bookkeeping_report_TaxRateID

Filter

epn_bookkeeping_report_Tender

Filter

epn_bookkeeping_report_Title

Filter

epn_bookkeeping_report_ToDate

Filter

epn_bookkeeping_report_TotalSales

Filter

epn_customers_businessName

Filter

epn_customers_cardNumber

Filter

epn_customers_contactNumber

Filter

epn_customers_contactNumber2

Filter

epn_customers_currentBalance

Filter

epn_customers_currentPoints

Filter

epn_customers_customerAddressId

Filter

epn_customers_dateOfBirth

Filter

epn_customers_emailAddress

Filter

epn_customers_expiryDate

Filter

epn_customers_forename

Filter

epn_customers_id

Filter

epn_customers_id_name

Filter

epn_customers_maxCredit

Filter

epn_customers_notes

Filter

epn_customers_referenceCode

Filter

epn_customers_signUpDate

Filter

epn_customers_signUpLocationId

Filter

epn_customers_surname

Filter

epn_customers_title

Filter

epn_customers_type

Filter

epn_products_articleCode

Filter

epn_products_barcode

Filter

epn_products_brandId

Filter

epn_products_buttonColourId

Filter

epn_products_categoryId

Filter

epn_products_colourId

Filter

epn_products_containerFeeId

Filter

epn_products_costPrice

Filter

epn_products_costPriceTaxGroupId

Filter

epn_products_description

Filter

epn_products_eatOutPrice

Filter

epn_products_eatOutPriceTaxGroupId

Filter

epn_products_excludeFromLoyaltyPointsGain

Filter

epn_products_id

Filter

epn_products_id_name

Filter

epn_products_isArchived

Filter

epn_products_isCostPriceIncTax

Filter

epn_products_isEatOutPriceIncTax

Filter

epn_products_isMultipleChoiceProductOptional

Filter

epn_products_isSalePriceIncTax

Filter

epn_products_isTaxExemptable

Filter

epn_products_isVariablePrice

Filter

epn_products_multipleChoiceNoteId

Filter

epn_products_name

Filter

epn_products_orderCode

Filter

epn_products_popupNoteId

Filter

epn_products_productType

Filter

epn_products_referenceCode

Filter

epn_products_rrPrice

Filter

epn_products_salePrice

Filter

epn_products_salePriceTaxGroupId

Filter

epn_products_sellOnTill

Filter

epn_products_sellOnWeb

Filter

epn_products_size

Filter

epn_products_sku

Filter

epn_products_sortPosition

Filter

epn_products_supplierId

Filter

epn_products_tareWeight

Filter

epn_products_unitOfSale

Filter

epn_products_variantGroupId

Filter

epn_products_volumeOfSale

Filter

epn_staff_hourlyRate

Filter

epn_staff_id

Filter

epn_staff_id_name

Filter

epn_staff_mainLocationId

Filter

epn_staff_name

Filter

epn_staff_referenceCode

Filter

epn_staff_roleId

Filter

epn_staff_showAtAllLocations

Filter

epn_brands_description

Filter

epn_brands_id

Filter

epn_brands_id_name

Filter

epn_brands_name

Filter

epn_container_fees_amount

Filter

epn_container_fees_bottle_deposit_item_id

Filter

epn_container_fees_name

Filter

epn_measurement_scheme_name

Filter

epn_measurement_scheme_value

Filter

epn_multiplechoicenotes_id

Filter

epn_multiplechoicenotes_name

Filter

epn_popupnotes_displayOncePerTransaction

Filter

epn_popupnotes_id

Filter

epn_popupnotes_name

Filter

epn_popupnotes_note

Filter

epn_product_categories_description

Filter

epn_product_categories_id

Filter

epn_product_categories_id_name

Filter

epn_product_categories_isWet

Filter

epn_product_categories_name

Filter

epn_product_categories_nominalCode

Filter

epn_product_categories_parentId

Filter

epn_product_categories_reportingCategoryId

Filter

epn_product_categories_showOnTill

Filter

epn_product_categories_sortPosition

Filter

epn_product_types_name

Filter

epn_product_types_value

Filter

epn_role_CanAccessBackOffice

Filter

epn_role_CanAccessMiscProducts

Filter

epn_role_CanAccesssCustomers

Filter

epn_role_CanAccessTablePlan

Filter

epn_role_CanAccessTill

Filter

epn_role_CanAccessTillAdminOptions

Filter

epn_role_CanAdjustFloat

Filter

epn_role_CanApplyBasketDiscounts

Filter

epn_role_CanApplyItemDiscounts

Filter

epn_role_CanChangeTabSpendAmount

Filter

epn_role_CanClearTransaction

Filter

epn_role_CanDeleteUnorderedItems

Filter

epn_role_CanDisableServiceCharge

Filter

epn_role_CanEditCustomerPoints

Filter

epn_role_CanHoldTransaction

Filter

epn_role_CanManuallySelectCustomer

Filter

epn_role_CanOrderAllocationServer

Filter

epn_role_CanOrderAllocationTableManager

Filter

epn_role_CanOrderAllocationTeamServer

Filter

epn_role_CanReceiveStock

Filter

epn_role_CanRefundItems

Filter

epn_role_CanRemoveFromTable

Filter

epn_role_CanRunEndOfDay

Filter

epn_role_CanSeeEndOfDayReport

Filter

epn_role_CanSendStock

Filter

epn_role_CanServerBaking

Filter

epn_role_CanStockTake

Filter

epn_role_CanTipOutOthers

Filter

epn_role_CanTipOutSelf

Filter

epn_role_CanUnlockDeviceViaPin

Filter

epn_role_CanUnrestrictedStockTake

Filter

epn_role_CanUseNoSale

Filter

epn_role_CanUsePayouts

Filter

epn_role_CanUsePettyCash

Filter

epn_role_CanVoidItems

Filter

epn_role_Description

Filter

epn_role_id

Filter

epn_role_id_name

Filter

epn_role_IsAdminOnTill

Filter

epn_role_MaxBasketDiscountAmount

Filter

epn_role_MaxBasketDiscountPercentage

Filter

epn_role_MaxCustomerCreditLimit

Filter

epn_role_MaxItemDiscountAmount

Filter

epn_role_MaxItemDiscountPercentage

Filter

epn_role_MaxRefundAmount

Filter

epn_role_name

Filter

epn_suppliers_addressLine1

Filter

epn_suppliers_addressLine2

Filter

epn_suppliers_contactNumber

Filter

epn_suppliers_contactNumber2

Filter

epn_suppliers_county

Filter

epn_suppliers_description

Filter

epn_suppliers_emailAddress

Filter

epn_suppliers_id

Filter

epn_suppliers_id_name

Filter

epn_suppliers_name

Filter

epn_suppliers_postCode

Filter

epn_suppliers_town

Filter

epn_suppliers_type

Filter

epn_unit_of_sale_name

Filter

epn_unit_of_sale_value

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_bookkeeping_report_ProductId

Action
Scroll to Top