Method Community

Hello! Just hoping for a simple solution here. :)

I have created a report that is pulling in check data. I'm having trouble finding a way to tell the report only to pull the current check. It is pulling all checks and displaying in the report. I want to just display the current check. The end result is to be able to print hardcopy checks from Method. This is the only piece I'm missing so far.

Thanks!!
Phillip

Hi Philip,

You need to edit the generate report action to pull the Record ID of the Check from the current session. Hint - take a look at the Invoice print preview button actions that will guide you in the right direction ;)  Let me know if it works.  

Got it! That worked! Thanks!!
One other item I've hit a wall on. The dollar amount spelled out in text (for example: Fifty Dollars and 00/100 ***************).

Any ideas on that? Is it formatting? A different table field?

Thanks much!!

 
Hi Phillip,

Talk about timing, we have already created this in the “labs” and were waiting for the dropdown update from earlier this week before we started pushing the screens out.  We haven’t pushed them out yet, but if you you're in a  hurry I'll give you a hint on what you can do. ;)
Import the screen CheckWithPreview from the Method Library and you can then use that screen to view your checks or you can do some 'reverse engineering' and finish up the report you are working on.  You can do this by checking out the “Before Print” script of the CheckAmountToWord object on the report.  This script is basically a formula that would take the amount and convert it into words - exactly what you are looking for.

awesome. Thanks! I need to have this ready to bring a client on board before their QB payroll subscription renews on the 7th of this month. Sounds like the timing is perfect. Thanks again for all your help! I'll dig into it this evening.

Have you ever seen someone do a happy dance?

This is EXACTLY what I'm looking for! THANKS!!

Amanda,

I ran into one issue. When the cents are 0-9, then the report prints 0/100 or 1/100 or 2/100.

Since this is printing onto checks, you'll want it to be 00/100 or 01/100 or 02/100.

I found VB formatting information on # and 0s but none of that seemed to apply to this report when I plugged it into the sub routine.

Any thoughts???

Thanks much!!

Hi Phillip,

In that case, you can change the BeforePrint script on the CheckCents object to:

Private Sub OnBeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
                dim intCents as Decimal
                'Get the value after the decimal
                intCents = fldAmount.text - Microsoft.VisualBasic.Fix(fldAmount.Text)
                'multiply by 100 to bring two decimal places in front of decimal
                intCents = intCents * 100
intCents = Microsoft.VisualBasic.Format(Microsoft.VisualBasic.Val(intCents), "#0")
                'remove value after decimal, add leading 0 if less than 10
                              If Microsoft.VisualBasic.Int(intCents) < 10 Then
                               CheckCents.Text = "0" & Microsoft.VisualBasic.Int(intCents)   & " / 100"
                              Else
                               CheckCents.Text = Microsoft.VisualBasic.Int(intCents)   & " / 100"
                              End If
End Sub

That got it! THANKS!!