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 ...