CitiXsys Forums CitiXsys Forums

iVend POS

RE: Query Promotions

Toggle
Query Promotions
promotion
Answer
4/14/18 3:37 AM

Dear Team,

I would like to create a report which lists all the current products which are either present in any active promotion or listed in any particular special price list.  Any clues onto which tables I need to be looking at?

kind regards,

Mark


RE: Query Promotions
Answer
4/15/18 8:49 PM as a reply to Mark Seguna.

Hi Mark,

 

You can download the database help file from CKP document store. The help file contains all database objects and a brief explanation of all fields available. This file has become my "bible" when it comes to creating reports. There is a version of teh help file available for both 6.4 and 6.5 versions of iVend


RE: Query Promotions
Answer
4/16/18 6:56 PM as a reply to Eddie Willcox.

Thanks Eddie,

however I feel that the help file for 6.5.5 does need some good beefing up.  Unfortunately, sometimes with field descriptions with a mere repetition of the field title, the help file isn't much of help.

Thanks anyways though.

regards,

Mark