Page 1 of 1

Price Per Item Column on Gold Invoices

Posted: Sat Jun 14, 2014 2:57 pm
by 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!

Re: Price Per Item Column on Gold Invoices

Posted: Mon Jun 16, 2014 4:31 am
by 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>

Re: Price Per Item Column on Gold Invoices

Posted: Mon Jun 16, 2014 6:38 am
by nadeem
Don't forget to add closing tag at the end like this 8)

Code: Select all

</asp:TemplateField>

Re: Price Per Item Column on Gold Invoices

Posted: Mon Jun 16, 2014 10:04 am
by jmestep
Nadeem- smart alec :D
I've added that to the code above

Re: Price Per Item Column on Gold Invoices

Posted: Mon Jun 16, 2014 10:59 pm
by nadeem
Thanks Judy :)

Re: Price Per Item Column on Gold Invoices

Posted: Tue Jun 17, 2014 6:04 pm
by jill224
That certainly did the trick! Exactly what I needed. Thank you both for your help. :D