Adding a Retail price to a product barcode label

Question

Hi, 
 I need to add a retail price to our Product barcode template so we can print . Product & Services> Labels> Product Bar Code ... I've managed to adjust and add some details to the label but I can not find a way to create a Retail price appearing. 
 That is what I've achieved by now. 
 
 I will appreciate if anyone can help with the above 
 
 Thank you! 
 Dimitar

Darron Cockram · Accepted Answer

Going off your screen shot you've got on really well already by the looks of things. 
 I'm not aware a of a specific step by step guide around adding joins (you can search in our knowledge base here https://ask.sage.co.uk/Scripts/ask.cfg/php.exe/enduser/std_alp.php ) but it's a fairly straightforward thing to do so I'll try to capture the steps here. 
 
 Open your label for editing in Report Designer (assume you already know how to do this a you have already been editing it) 
 Got to the Report Menu and select Joins 
 In the join editor scroll down the toolbox on the left until you see the table called TAX_CODE 
 Select the TAX code table and drag and drop it to the join canvas (the large section in the middle of the dialog) 
 In the newly added TAX_CODE table scroll down until you can see the TAX_CODE field 
 Find the STOCK table (already in the join canvas) and scroll down until you can see the TAX_CODE field 
 Select the TAX_CODE field in the STOCK and drag and drop it to the TAX_CODE field on the TAX_CODE If you've done it correctly you will see a line added between the tables. NOTE: There are advanced options for joins but the defaults should be OK in this case. 
 Click OK to confirm you joins. 
 
 Now that you have the join available you can use fields from the TAX_CODE table to do the above calculation I suggested. 
 
 From the Toolbox menu select Expression. Your cursor will change to a cross. 
 Click on the canvas to draw a box where you want your value to display on the label. 
 The expression editor dialog will be show. Simply copy and paste the expression from my above reply in to the editor and click OK. 
 Apply any particular formatting you want to the newly added expression and preview your label to test it is working as desired. 
 
 Hopefully that all makes sense. Let me know if you need any more detail.

Darron Cockram · Answer

By retail price do you mean you want the price inclusive of VAT i.e. the value currently showing as zero in your above screen shot? 
 If so then you would need to calculate this from the tax rate of the tax code associated with the stock item. First thing you would ned to do is edit the joins via Report -> Joins and add the TAX_CODE table and add a join between STOCK.TAX_CODE and TAX_CODE.TAX_CODE. With this join in place your price inclusive of VAT can be calculated by adding an expression like this: 
 STOCK.SALES_PRICE + (STOCK.SALES_PRICE * (TAX_CODE.TAX_RATE / 100)) 
 Hope that helps

Sage 50 Accounts

Adding a Retail price to a product barcode label

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING