Summary:
When printing the Sales Analysis report by Cell, the cell descriptions print as “2 cells”, “3 cells” and “4 cells” instead of the actual cell descriptions.
Cause:
When selling two cells of the same gridded item on one line of a ticket, the CELL_DESC column in PS_TKT_HIST_LIN contains the value 2 cells to indicate that two cells for this item were on the ticket.
The actual description of the cells are not in PS_TKT_HIST_LIN, but in PS_TKT_HIST_CELL.
Because the Sales Analysis by Group report pulls from PS_TKT_HIST_LIN, and not from PS_TKT_HIST_CELL, it never gets the actual cell details. The report pulls the CELL_DESC, which in this case contains 2 cells.
Solution:
This is working as designed.
Article ID: 548
Created: September 8, 2014
Last Updated: September 9, 2014
Online URL: https://counterpoint.knowledgebase.co/article.php?id=548