System Enhancement -Ignoring Custom Object while taking backup which starts by name Custom_Customer

System Enhancement -Ignoring Custom Object while taking backup which starts by name Custom_Customer

Product version:          

iVend 6.6 7989 above

Problem statement:

System Enhancement -Ignoring Custom Object while taking backup which starts by name Custom_Customer

Symptoms:

Customer creates SQL Custom database Objects (Stored Procedures, User Defined Functions, Views)  which creates issues in Store backup file creation from iVend Enterprise MC 

Proposed Solution/Workaround:

It is suggested to customers that they should create their SQL Custom database Objects with below nomenclature Custom_Customer_SQL object name.

For Example :
Tables Name :Custom_Customer _<Table Name>
Function Name:Custom_Customer_<Function Name>
SP Name:Custom_Customer_<Stored Procedure Name>
System will ignore those objects while creating backup and backup restoration should work smoothly as those object will not be part of backup file.
e.g.
Custom_Customer_vMonthlySalesByStore_GL
Custom_Customer_vSalesMargin_GL
Custom_Customer_vSalesonAccount_GL
Custom_Customer_vMonthlySalesByTender_GL
Custom_Customer_vTransactionsCount_GL
Custom_Customer_vSalesByTender_GL


    • Related Articles

    • Remove Customer Master which has transaction and also remove those customer which has no transaction

      Environment:   Ivend 6.6 Problem statement: Need to Remove Customer Master which has transaction and also need to remove those customers which has no transaction details. Resolution/Work Around: 1. Remove customer master which has no transaction ...

    • Change cash Customer Name in a transaction

      Environment: iVend 6.6 Problem Statement: Change Cash Customer Name at POS during transaction Symptoms: The POS user Changes the default Cash customer name to a temporary one using the F4(Sale Edit) button but upon completing the sale, the temporary ...

    • Getting Pop-up while taking a fresh backup for a store from the enterprise Management Console

      Version 6.6 Query Getting below Pop-up while taking a fresh backup for a store from the enterprise Management Console, Pop-up message says: Taking backup will mark all non-replicated data for this store / POS as replicated. iVend recommends to take ...

    • iVend POS Custom Tender

      What is a Custom Tender in iVend Retail POS? Special tender types can be used by the Retailer as per their business practices, such as Check (Cheque) on Delivery, Cash on Delivery, named Credit Cards, etc. The Custom Tenders type in iVend POS ...

    • iVend Retail - Object Relationship Hierarchy

      Who should be reading this document? This document is intended for partners who have signed-up with CitiXsys under the ‘Open Source License Program’. Partners willing to undertake source code modifications under license from CitiXsys to pursue ...