Quantity Counts in Cues

mariya

All Cues I have in my activities section show 0 counts. Those I created myself and those that were there .
I can click on stacks and actually get a list of entries. How do I get the counts to work?
MK

Savatage

Cues? Stacks?

mariya

I mean stacks as pictures on the Activities part. Cue tables are the ones that feed them.

beran

Take a look at table 9053 Sales Cue (used for page 9060 SO processor Activities standard for page 9006 Order Processor Role Center). On field 5 Sales orders - the properties says

FieldClass = FlowField
CalcFormula = Count("Sales Header" WHERE (Document Type=FILTER(Order),Status=FILTER(Open)))

The filter is digged out from CalcFormula.

mariya

I had simply disregarded my activities page and started over. The mystery is that counts were showing up if I ran Finance cue table and are working in the new page. Whish I knew what caused the error.

JDVyska

Probably too late to help, but was it a new Cue table you were working with? It's very easy to overlook that the Cue Table must have a record initialized and inserted. Typically, you'd have OnOpenPage() have at least this bit of code:

RESET;
IF NOT GET THEN BEGIN
  INIT;
  INSERT;
END;

I wonder if that's all you ran into?

mariya

The problem was in how I added lines to the page. I used cut/paste/copy for lines and that messed something up. I have strated from scratch using a mouse and things worked nice and neat.

Capone

The reason to why it show 0 counts for me was that I my source field or source variable was not Integer.
Apprently Decimal doesn't work.