Price Per Item Column on Gold Invoices

[jill224]

Hi all,

Before we upgraded to Gold (we are currently using R6), we had been able to modify our print invoices to add an extra column to show a "Price per Item" to the left of the Extended Price. We had been able to easily do this with the help of this thread: viewtopic.php?f=42&t=9417&p=40618&hilit ... ice#p40618

Since we have updated to Gold some time ago, I have been trying to re-implement this on the invoices. We have a lot of customers who order multiples of the same items, so we like to have the single item price noted on the invoice for these cases. The old fix in the previous thread no longer works because of the changes in Gold, and everything I have tried just gives me errors. I have been trying to figure this out for some time now and have not been able to get anywhere.

I am by no means an expert but I know most of you all are and I come here frequently for a lot of help and advice though I have never posted. I was wondering if anyone else here has been able to implement this "Price per Item" column on their invoices in Gold? If so, would you be kind enough to share the code or offer me any suggestions to point me in the right direction? I really appreciate any help with this!

[jmestep]

Try adding this where you want the price
<asp:TemplateField HeaderText="Item Price">
<ItemStyle HorizontalAlign="right" width="80px" />
<ItemTemplate>
<asp:Label ID="Price" runat="server" Text='<%#TaxHelper.GetInvoicePrice(((OrderItem)Container.DataItem).Order, (OrderItem)Container.DataItem).LSCurrencyFormat("lc")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

[nadeem]

Don't forget to add closing tag at the end like this

Code: Select all

</asp:TemplateField>

[jmestep]

Nadeem- smart alec
I've added that to the code above

[nadeem]

Thanks Judy

[jill224]

That certainly did the trick! Exactly what I needed. Thank you both for your help.