[Kathy Kim]

I am trying to setup a SmartConnect integration for MDA in the SOP series.  One required field is the ACTINDX.  I need to first get the account number tied to the inventory item code so that I can then lookup the ACTINDX for the G/L account tied to the inventory item.

For example:
We have an inventory item named RENAL.
The default sales G/L account number associated with this item code is 0-100-4000-000.
The ACTINDX for this account number is 273

What table contains RENAL and either 0-100-4000-000 or RENAL and 273.  I’ve tried Victoria Yudin’s site, but I’m not finding it (and I am just venturing into SQL tables and SmartConnect integrations).

Thanks for any help that you can provide.

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Phoenix AZ
——————————

[Jim Harris]

GL00105 has ACTINDX and ACTNUMST, as well as each individual account segment.

——————————
Jim Harris
Director of Information Systems
ExamWorks, Inc.
Atlanta GA
——————————
——————————————-

[Daniel Tomlin]

The inventory master table (IV00101) contains the accounts associated with an item.

Look at the field IVSLSIDX to get the sales account index for that item.  You can then link that index to the GL00100 or GL00105 to get the full account number or account description.

——————————
Daniel Tomlin
CV Starr & Co, Inc.
New York NY
——————————
——————————————-

[Kathy Kim]

Thank you – that looks like just what I needed!

——————————
Kathy Kim
Director of Finance
Donor Network of Arizona
Phoenix AZ
——————————
——————————————-