Method:Classic General Q&A

Re: How to get the total number of items on invoice--possible???

jad — Wed, 13 Mar 2013 21:05:03 GMT

Jason, that's exactly what I was looking for--thank you for your help!

Re: How to get the total number of items on invoice--possible???

Method_Jason — Tue, 12 Mar 2013 20:33:47 GMT

Hi jan,

After taking another look at this post, I have some additional comments that may help. I mentioned that you should try to retrieve the Maximum with the Retrieve value from table action but it would make more sense to retrieve the Count. Same result, but retrieving the count is easier to understand.

If you want your customers to also see the count, you might need to customize the Invoice (Product) report in Method's Report Designer. This is the report that you generate when you click Print Preview. Add the field Invoice.InvoiceLine.Invoice.Item to the report and edit the properties of this field. Click the three dots button beside the Summary properties. Here you will be able to add a Count under Summary function. See the attached image.

If you're still stuck please expand a little further on what exactly you are trying to do.

- Jason

Re: How to get the total number of items on invoice--possible???

Method_Jason — Mon, 11 Mar 2013 22:22:25 GMT

Hi jad,

Some customization can be done to achieve this goal. I don't think you can add the count right on the grid but you can add it elsewhere on the invoice. Add a textbox or a label object somewhere on the invoice. This will be used to display the count. Next add the following actions into your Save button. Alternatively, you can make a button that updates the count.

First use the action Retrieve value from table. You'll have to retrieve the LineOrder field from the InvoiceLine table where the InvoiceRecordID field is equal to the active recordID. Retrieve the maximum. The logic behind this is that the LineOrder field tracks the order on the invoice and the maximum number (the last item on the invoice) will be equal to the count. Make sure to then enter this action result into your desired object using the Enter Value into Field On Screen action.

When you're entering new items into an invoice you will have to Update the grid before you proceed to see the updated count.

If you need consulting help I can put you in touch with one. Just remember this is a paid service. Hope this helps!

Jason

How to get the total number of items on invoice--possible???

jad — Mon, 11 Mar 2013 19:28:54 GMT

I have a lot of customers that need an item total on their invoices. If there are 107 different items on the invoice, I need the invoice to automatically give me the 107 total at the bottom of the invoice, so I don't need to do that manually. Is there a way to alter the invoice to do this?