Bartender SQL Statement which includes Shelf Location

Bartender SQL Statement which includes Shelf Location

Paste this text below into the custom SQL statement field, update your template and you should have a new field appear for shelf location providing they are using the shelf locations within TCP.

SELECT "dbo"."LabelQueueDetail"."LabelQueueDetailOrder", "dbo"."LabelQueueDetail"."LabelQueueDetailQty", "dbo"."LabelTemplate".*, DisplayTypes.DisplayTypeDescription
FROM DisplayTypes INNER JOIN
PLUs ON DisplayTypes.DisplayTypeIndex = PLUs.DisplayTypeIndex RIGHT OUTER JOIN
LabelTemplate ON PLUs.PLUIndex = LabelTemplate.PLUIndex RIGHT OUTER JOIN
LabelQueue LEFT OUTER JOIN
LabelQueueDetail ON LabelQueue.LabelQueueCode = LabelQueueDetail.LabelQueueCode ON LabelTemplate.PLUIndex = LabelQueueDetail.LabelQueueDetailPLUIndex
WHERE "dbo"."LabelQueue"."LabelQueueCode" = ?TC2Queue ORDER BY "dbo"."LabelQueueDetail"."LabelQueueDetailOrder" ASC
    • Related Articles

    • Bartender BT exception error

      If you are unable to print labels from Total Control Premier which is throwing up a BT exception error message. What you need to do, if you click on your Windows Start to open up the Programs sub-menu and locate Bartender application. If you open up ...
    • Idispatch Error 3127 when printing Labels

      Check the Custom SQL Query as it may have become corrupt. The query should be as below: SELECT "dbo"."LabelQueueDetail"."LabelQueueDetailOrder", "dbo"."LabelQueueDetail"."LabelQueueDetailQty", "dbo"."LabelTemplate".* FROM ("dbo"."LabelQueue" LEFT ...
    • Inserting a picture into Bartender Label File

      Total Control Premier when it is installed comes with some default label files for use with Bartender labelling software. The default location for these files is C:\program files (x86)\Fidelity Systems\Total Control Premier\Labels. This location may ...
    • Instant CRM Client Setup

      This article applies to Instant CRM version 2.5 and higher - screenshots are taken from Instant CRM version 2.6. Before You Get Started Installation Requirements An Administrator account, or a user account with permissions to install software and ...
    • Label Queues (How to use)

      How to Add PLUs into your Label Queue If you go into ‘Daily Tasks’ and select ‘Label Manager’ from the menu. This will open in a new tab as below; To add to the queue, if you highlight your queue as follows; If you double click on the queue name ...