Armanino Blog
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.

Related News & Insights
Streamlining Business: ERP and CRM Integration Benefits
Propel Your Business With ERP and CRM Integration

July 19, 2023 | 01:00 PM - 01:30 PM PT
Future Horizons in Finance
The Next Chapter in Finance for Professional Services

June 22, 2023 | 11:00 AM - 12:00 PM PT
Ensuring Your SaaS Company Is Built to Scale
Scaling your high-growth SaaS company just got easier.

June 22, 2023 | 10:00 AM - 11:00 AM PT