Method:Classic General Q&A

Re: Report Designer Help - Invoices

Method_Ashur — Wed, 01 May 2013 14:38:27 GMT

Great work! Glad to have helped, you seem to be getting the hang of the Report Designer, kudos! Let us know if you require futher assistance.

- Ashur

Re: Report Designer Help - Invoices

SuzanneB — Wed, 01 May 2013 14:05:25 GMT

Hi Ashur,

I know I've been bombarding you with questions. My last post was lengthy -- but I wanted you to know that i figured it out and have it working well.

thanks so much for all your help -- it made a huge difference.

Suzanne

Re: Report Designer Help - Invoices

SuzanneB — Wed, 01 May 2013 12:28:25 GMT

Hi again,

Yes, it seems that the Invoice-Short Description may have been a custom field, added thru Quick Books. For now, we will not move forward with customizing the functionality to that level. But I would like to use that field in my invoices as is. I dragged it in, but it's not working properly.

Goal: The work order items to flow into an invoice and show the Short Description we are discussing

Problem: The work order date and quantity flows over correctly, but the Description seems to be just the first one listed on the work order. I tried to create an example below:

The Work Order will say:

3/27 1 Outdoor Lighting Maintenance

3/28 4 Lawn Cuts

3/29 3 Hours of pruning

The (incorrect) Invoice will say:

3/27 1 Outdoor Lighting Maintenance

3/28 4 Outdoor Lighting Maintenance

3/29 3 Outdoor Lighting Maintenance

Understand my dilemma? I'm guessing there is some property on that field that I am not addressing. Any help would be appreciated.

As usual, Thanks so much,

Suzanne

Re: Report Designer Help - Invoices

Method_Ashur — Tue, 30 Apr 2013 20:04:24 GMT

What are you referring to when you say Invoice Short Description? Is this a custom field? Something like this would be possible, however, you would need to speak with an in-house Consultant or one of our Method Solution Providers as it goes beyond the scope of the forums.

Let me know if you would like to speak with one of our Consultants and I'll get the ball rolling.

- Ashur

Re: Report Designer Help - Invoices

SuzanneB — Tue, 30 Apr 2013 17:02:07 GMT

Okay I think this might be the last question regarding our invoice template, but this one might be a big one!

My goal: To have the invoice print the Invoice Short Description for our services.

Problem: Not all our services have a short description

Is there a programming functionality that will allow the Short Description to print, if the field is populated - but have the Item Description print if the Short Description field is blank?

Thanks in advance for any help you can provide.

Suzanne

Re: Report Designer Help - Invoices

Method_Ashur — Tue, 30 Apr 2013 13:50:51 GMT

You can do this by selecting the appropriate field on your report and clicking the little white arrow icon that displays on the top right. Locate the Format String field and click the '...' button; from here you'll be able to select how your data will show or even create your own custom format.

My example below displays the dollar sign then the value in the field up to 2 decimal points, e.g. $256.29. *Note: Method calculates this field to 2 decimal points so if your Format String shows 5 points, e.g. {0:$0.00000}, the latter three digits will display as zero's. Hope this helps!

- Ashur

Re: Report Designer Help - Invoices

SuzanneB — Tue, 30 Apr 2013 13:33:12 GMT

Hi Ashur,

That worked great, and yes it was very easy.

Now I have another question. How can I manage how many decimal points it goes out, and add a dollar sign? I'm probably missing the obvious...sorry.

Thanks in advance,

Suzanne

Re: Report Designer Help - Invoices

Method_Ashur — Mon, 29 Apr 2013 20:59:48 GMT

Hi Suzanne,

You can do this by adding the Balance field as a linked field in your Invoice table, then add that field to your report. This will pull the balance from the Customer table. Is this what you're looking for?

- Ashur

Report Designer Help - Invoices

SuzanneB — Mon, 29 Apr 2013 19:06:02 GMT

Hi,

I am trying to find the field that will bring a total account balance into my invoice. For example, right now we use this in QB.
Rather than send out individual statements, our QB invoice bottom shows:

Invoice Total
Payments/Credits
Customer Total Balance

I can't find the Customer Total Balance in the Method field list, in Report Designer.

Make Sense?

Thanks in advance for any help you can provide.

Suzanne