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

Hi Darron, Thank you for your help. That's exactly what I need.  I am very new to Sage 50 and have no experience at all and I will struggle with  the part of creating a join and applying the formula.  Do you know if there is a step by step guide for this task or if someone provides live  support, even paid one?

Thank you!

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.

1. Open your label for editing in Report Designer (assume you already know how to do this a you have already been editing it)
2. Got to the Report Menu and select Joins
3. In the join editor scroll down the toolbox on the left until you see the table called TAX_CODE
4. Select the TAX code table and drag and drop it to the join canvas (the large section in the middle of the dialog)
5. In the newly added TAX_CODE table scroll down until you can see the TAX_CODE field
6. Find the STOCK table (already in the join canvas) and scroll down until you can see the TAX_CODE field
7. 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.
8. 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.

1. From the Toolbox menu select Expression. Your cursor will change to a cross.
2. Click on the canvas to draw a box where you want your value to display on the label.
3. The expression editor dialog will be show. Simply copy and paste the expression from my above reply in to the editor and click OK.
4. 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.

You are a complete star Darron! It can not be clearer than this!

All done!

Thank you very much!