Armanino Blog
Article

eConnect - POP Receivings Integration Issue

August 10, 2009

We were integrating PO Receipts with Shipment/Invoice type, non-inventoried items (without PO) and manual distributions into GP using eConnect. Things integrate flawlessly into the TEST company. However, once we integrate transactions into a LIVE company we saw some issues. At first impression, the imported transactions looked just fine. Transactions, line items and distributions all look accurate. Things got interesting the moment we run batch edit list. Payables accounts associated with each transactions are reverted back either to a blank account (which leads to "account not found" error) or to the default AP posting account.

We spent time reviewing/comparing setups and transaction data, rebuilding account index table, check links, reconcile, and remove historical transactions - essentially almost everything short of re-installing the company or eConnect. Spent a couple of hours on the phone with Support; they were as puzzled as we were.

After working with Support and debugging through GP Dexterity code, we found the issue. The issue is LIVE Company is registered with multicurrency, and we do not have any items under the item card. Even though we are integrating non-inventoried items, it causes the currencyID on the transaction to be set to blank. Apparently GP will check table IV00105 for the currencyID regardless of the type of line items integrated. And running the batch edit list (or opening the transaction and saving it without making any changes) triggers GP to recalculate the distributions since the currencyID is blank.

The workaround is to create a dummy item number in the inventory module even if we are not using it and then associate it to the functional currency. We didn't see these issues in the TEST Company since some item numbers were created in the beginning for testing which masked this issue. This is a corner case but you may still come across this too.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Resources
Related News & Insights
Tracking SaaS Success
Webinar
Discover the ways SaaS metrics can be used to your advantage.

June 21, 2022 | 10:00 AM - 11:00 AM PT
SOX Internal Control Crypto
Webinar
Knowing when to implement or improve a process can help your organization save countless resources.

June 9, 2022 | 11:00 AM - 12:00 PM PT
Regulatory and Industry News Alerts from Armanino
Article
Here’s how to avoid noncompliance, plus tips for reporting the ERC on financial statements.

May 25, 2022