Method:Classic General Q&A

Re: Method to Quickbooks Sync Issue

voltaire — Thu, 05 Jan 2012 20:03:08 GMT

Paul and Michael, thank you. Works like a charm.

Re: Method to Quickbooks Sync Issue

Method_Michael — Thu, 05 Jan 2012 15:26:24 GMT

voltaire-

What I would do is add an action to assign JournalEntryRecordID from Row to an action result, and then use that in the Send To Desktop action. JournalEntryRecordID refers to the RecordID of the Journal Entry that the Journal Entry Line is associated with.

The Sent to Desktop would look something like this:

Table Name: JournalEntry
Locate Record ID: Action Result
resultJournalEntryRecordID

-Michael

Re: Method to Quickbooks Sync Issue

voltaire — Thu, 05 Jan 2012 10:45:16 GMT

Thanks Paul, this makes sense. I've looked around quite a bit but I can't find any decent examples of how to properly use the "Send to Desktop" action via a loop when working with both transaction and detail tables. Here's what I have right now, but I'm a little unclear as to the placement and configuration of the Send to Desktop action.

Order	Action	Notes	Move
	Start Loop Through Grid	Start loop through checked rows of JournalEntryLin...	Move
	Retrieve Value From Table	Copy Account Name and store as AccountName_AR	Move
	Character Function	Join text to AccountName_AR	Move
	Update Field In Table	Copy AccountName_AR to Class field	Move
	Send to Desktop		Move
	End Loop Through Grid	End Loop	Move
	Refresh Grid	Refresh Grid	Move

Re: Method to Quickbooks Sync Issue

Method_Paul — Wed, 04 Jan 2012 21:36:15 GMT

Modifying the JournalEntryLine would NOT send the tranaction to QuickBooks.

Modifying the JournalEntry WOULD send the transaction to QuickBooks.

After you are finished editing all your JournalEntryLine records, call the SendToDesktop action for the JournalEntry and that will tell Method "hey I'm doing making all the modifications to the line items, go ahead and post it".

Re: Method to Quickbooks Sync Issue

voltaire — Wed, 04 Jan 2012 21:23:47 GMT

Paul, I'm trying to modify journal entry lines via a loop. It loops just fine and updates the record in Method, and they show that they have been modified in the Method audit history, but nothing gets pushed to QuickBooks and i'm not getting any conflicts or other error messages in Method or on the Desktop.

Just to test it out, I created a journal entry from scratch in Method and that pushed to Quickbooks just fine.

I'm wondering if because the journal entries that transferred with the initial sync had the wrong field name in the JournalEntryLine table, as you noted above, if that would corrupt the syncing for those transactions.

Sean

Re: Method to Quickbooks Sync Issue

Method_Paul — Wed, 04 Jan 2012 20:21:45 GMT

Sounds completely unrelated to your original question.

What kind of existing transactions are you modifying?

Are there any messages coming up in the actual sync engine activity log on your desktop?

Paul

Re: Method to Quickbooks Sync Issue

voltaire — Wed, 04 Jan 2012 20:03:54 GMT

Paul, I'm still having issues with this. The error message isn't showing up anymore, but when I make changes to the existing transactions, updates are still not being made in QuickBooks.

I tried doing a full sync in addition to a changes only sync, and nothing is happening. I'm wondering if I'll continue to have issues unless I wipe the slate clean by syncing the QB file with a new Method account.

Is there a way to do this so I can sync from scratch?

Thanks.

Re: Method to Quickbooks Sync Issue

Method_Paul — Wed, 04 Jan 2012 15:09:37 GMT

Sean -

You should be good to go now. We have hotfixed the site.

It was a typo in the server code for JournalEntry syncing with multi-currency turned on. It should have been "IsAmountsEnteredInHomeCurrency" in our code, rather than "IsAmountsEnteredInHomeCurrencyAdjustment".

Paul

Method to Quickbooks Sync Issue

voltaire — Wed, 04 Jan 2012 10:57:02 GMT

When we make certain changes to existing transactions in Method (in particular changes to existing journal entries), the changes save in Method, but they won't sync with Quickbooks, and I'm not getting a conflict/error message in the "Resolve Conflicts" screen. However, I do get the following error message, but I'm not sure if the two issues are related:

Error: Column 'IsAmountsEnteredInHomeCurrencyAdjustment' does not belong to table Table

This client uses the multiple currency feature in QB Enterprise 2012.

Can anyone help me out here?

Thanks, Sean