Method Community

I built a screen for inputting credit card purchases from scratch that was modeled from the "Check" screen (I started from scratch so I could use the correct table).  Everything is displaying properly, the dropdowns work fine, looks like the correct information is pulling in.  However, when I go to save, I'm getting this ...

DanSchmidt, What happens if you click Update on any of the editable grids you have on the screen? -Michael

Yes, I just checked and all of our invoices are in Method (dating back to 2/22/10). If the code works, then could there be an action on the screen that is altering the data in the YTD sales field? Thanks for your help, Birch

I followed these steps to set up a Credit Card transaction entry screen.  However, when I click Save/New, I'm setting an error message that reads "The 'Save' action could not be completed.Validation on: RecordID.Validation rule: must a numeric value" I looked at the RecordID field, but there isn't a validation rule ...

James, Maybe its better to think of it as controls or objects In the report designer if you look to the left you will see a bar(Tool Box) with controls/objects that you can drag onto the screen, you should see Label and Rich Text in the Tool Box. You can drag a Label control or a Rich Text control onto your report and data bind a field from the ...

 This confuses me.  What is a rich text field? EDIT: searching this forum for "rich text field" yields two results, this thread is one of them. EDIT 2: I see now.  Insert the Rich Text field, then bind it to the field in the table.

Birch, Just to confirm if you take a look at your Invoice list, you do see invoices older then 31 days? I did a copy and paste of this code into one of my screens and it seems to work fine.  -Michael

Hi Michael - Transaction history is set to 31 days and invoices are set to 'all days'. These settings haven't been changed since we started exporting our customer data from this grid over a year ago, which is why it's so difficult to figure out why this field isn't calculating as it should. Thanks, Birch

Hi Birch, Under QuickBooks > Synchronize what is the Transaction History set to? If you click on Show options per transaction type what's set for invoices? -Michael

In 2010, I had a custom screen built out that exports our customer data. One of the fields is ‘YTD Sales’ that has the following SQL override code to pull each customer’s YTD sales: SELECT Cast(ROUND(Sum(Amount),2) as decimal(9,2)) FROM viewaccInvoice WHERE viewaccInvoice.Customer = viewaccEntity.FullName AND ...