Search results by user ID 5818

Re: Sync error

DavidGlantz — Thu, 03 Sep 2015 04:00:20 GMT

Client of ours too is experiencing this same issue. Still a problem this evening.

Re: Is there a way to trim spaces from a field?

DavidGlantz — Thu, 15 Jan 2015 22:54:15 GMT

That is relatively easy. I must be doing something wrong because i don't see any change. The after looks exactly the same as the before :-(

-David

Re: Is there a way to trim spaces from a field?

DavidGlantz — Thu, 15 Jan 2015 01:57:58 GMT

Actually, they are text fields on a screen. They are pasting a large block of data in fixed length format and I am parsing the data but need to trim spaces at the end of the block of text.

Could post to a table if that could help.

Thanks.

--David

Is there a way to trim spaces from a field?

DavidGlantz — Wed, 14 Jan 2015 15:04:42 GMT

We are parsing fixed length data and want to trim the trailing spaces. The character action doesn't appear to have an option to do as such. Maybe there is a tricky way somewhere to do so.

Thanks.

Re: Method QB sync causes invoice lines to disappear after sync

DavidGlantz — Mon, 28 Jan 2013 16:43:45 GMT

Hi Val.

The issue is indeed isolated to a particular custom screen. This one is a pop-up which prompts the user to add one or more invoice lines to the invoice. It uses the action Save All Sections to save each line. It just so happens that all the line items added via this pop-up use the same Item name but with a different description, rate, etc. Other custom screens that add invoice line items work fine - custom version of the invoice and another poop-up screen.

Hmmm. The pop-up is linked to the InvoiceLineItem Record ID and this screen has the ability to update that line item and add additional line items . Could it be that since this pop-up is linked by the InvoiceLinteItem RecordID that Method is automatically making this a group? Maybe the pop-up should not be linked? That would make sense.

Interstingly, after removing the value in the InvoiceLineGroupRecordID field, the sync works fine and the invoice is no longer altered after the sync.

Method QB sync causes invoice lines to disappear after sync

DavidGlantz — Fri, 25 Jan 2013 19:44:09 GMT

After the Method QB sync, particular Method generated invoices are inserted into QB with just one line out of a multi-line invoice and the invoice is updated and replaced in Method. Some work perfectly but in this case the issue has been isolated to certain items and then to a particular custom pop-up screen that creates the entries.

There is nothing unorthodox about how the invoice line items are created in this custom screen but after digging into the InvoiceLine table we have discovered that the field InvoiceLineGroupRecordID is populated on the ones that are disappearing. The first line item (which is what QB ends up saving) has a blank value in that field; the 2nd line item has the InvoiceLine RecordID of the 1st line; the 3rd line has a RecordID value of the 2nd line, etc. Not sure why Method is populating this field as the item is a service item and there are actually no group items in their item table whatsoever. Coincidentally, this pop-up screen creates multiple line items with the same item name - each item has a different rate, description, Method specific fields, etc. Appears to be a bug.

Seems that QB treats them as Group items and consolidates them to a single line. It doesn't add up the total but uses just the value from the first line item and changes the invoice amount. Interesting but not what we want or expect. It takes a loooong time for the sync to happen and then nothing appears in the Conflict screen in Method and the invoice just looks like a one line item invoice in Method. Hmmm.

Not sure if this is kosher but went ahead and added a little loop through the InvoiceLine table after the entry of these particular invoice lines and removed the value in the InvoiceLineGroupRecordID field. That seemed to do the trick - invoices sync with QB as one would expect - all line items are created and in a timely fashion.

My concern is that until that is fixed in Method, not sure if there are any downstream impact when removing the value in this field on service items. It shouldn't be populated anyway and no issues have popped up as of yet but it has only been a couple of hours but I am not comfortable removing field values that Method controls.

Anyone experienced this before or have any thoughts on the ramifications of clearing that field?

Sync issues

DavidGlantz — Tue, 08 Jan 2013 14:59:22 GMT

When adding certain customers in Method, it produces an error stating that “The Customer/Employee/Vendor/OtherName could not be sent to QuickBooks. This Name is already in use. Please edit the Name so that it is unique and save again.”; however, it does not exist in QuickBooks. The sync with QB produces errors and ultimately no customers are sent to QB.

The story behind the story is that we are trying to reset the data in QB and Method yet keep all the settings and screens. Felt like it would be too much work to create a new Method account. The QB file is basically the same but with no customers. We wanted to re-import the customers into Method and then with QB. Here is what transpired:

1. Created a new QB file by restoring a current backup. This QB file is the same but with not customers. There are no real customers in the newly restored QB file.

2. Wrote a routine in Method to delete the Customer records. That appeared to work fine as all the customers were deleted and there were no Customer-Entity records (though I should have done this before the prior step)

3. Imported a few thousand Customers and Customer:jobs into Method. Most of them converted; however, a bunch did not as it said they already existed in QuickBooks. They don’t but Method thinks they do

4. There are no customers in QB as a result of the import.

5. Receive the error noted above when trying to manually enter a customer. The Resolve Conflicts screen shows a bunch of errors. Here is an example:

QuickBooks returned an error when adding/modifying a accEntity record. The error was: Object "80000001-1325081693" specified in the request cannot be found. QuickBooks error message: Invalid argument. The specified record does not exist in the list.. The Request was: <?xml version="1.0" encoding="windows-1252" ?> <?qbxml version="8.0" ?> <QBXML><QBXMLMsgsRq onError="stopOnError"><CustomerAddRq requestID="qx_1"><CustomerAdd><Name>3C</Name><IsActive>0</IsActive><CompanyName>3C</CompanyName><Salutation />...</QBXMLMsgsRq></QBXML>

I obviously messed something up when trying to reset the data. Thoughts on how to resolve?

--David

Search results by user ID 5818

Re: Sync error

Re: Is there a way to trim spaces from a field?

Re: Is there a way to trim spaces from a field?

﻿Is there a way to trim spaces from a field? ﻿

Re: Method QB sync causes invoice lines to disappear after sync

Method QB sync causes invoice lines to disappear after sync

Sync issues

Is there a way to trim spaces from a field?