Method Community

Hi! Thank you both. I actually figured it out - there cannot be any pixels in between the fields and then it looks perfect in Excel. All I had to do is get the info about each field and make sure one field starts where the other one ends. Thanks!  

When I design a new report that needs to be printed into XLS, it always creates an extra column after each existing column. So it looks something like this: https://goo.gl/JDkqcU It is annoying and I would like to ask for help how to prevent it. All my fields are alligned and are not overlaping. Thank you! 

Hi, we actually upload out time entries through MethodAPI and we enter info into the TimeTracking table: TimeStart, TimeEnd and BreakInMinutes. We then calculate the difference between end and start and subtract the break time to find out the duration. It all works fine until we sync with Quickbooks. When trying to fix the issue, we Update the ...

When we approve Non-Posted Time Tracking (changing Wait For Sync Approval to No), all entries that include break time suddently ignore it. So if person worked 8am - 5 pmwith 60 min break, before updating the Waiting for the Sync Approval they worked 8 hours but after they work 9 hours. Even updating the Duration in the table afterwards changes ...

Thank you!

Hi, so if I understand it correctly, it will still add the bills to Method, it will just not sync them with QuickBooks? - And yes, we do have a password set for the closing date in QB - No, we are able to add returned items or input invoices dirrectly in Method to the closed period. - yes, even invoices entered in Method synced with ...

Hi. We have had some issues when we were adding bills to a time for which we have already balanced our books and we wish to be able to close Method to all changes after the end of the month.  QuickBooks offers a feature of setting a date to which we can close books to, but despite that we are able to upload our bills through the ...

Seems to be working! Thank you!

Hi. I am trying to get a field from the Entity table so I can insert the same info into another table, but the only info I can use to search the Entity table at that point is the BillAddressAddr1, not the RecordID. If I use MethodAPISelect_DataSetV2 and the RecordID, I get the info I need, but not when I use sSelectWhere = ...

Thank you - I appreciate your help. If I understand it correctly, I cannot get the Summary in the Report Designer to ignore 0, but I can script my own Summary Function. I can do that - it's just that I wanted the Summary to be printed before the details of that section, not after, and I think that you cannot do that with values calculated ...