Dynamic GP Smartlist builder

[Gwennet]

Can some one help me find the table name for Purchase order item detail screen (inventory account number field)?

GP have "inventory account number" field on their prebuild smartlist (Purchase line item smartlist) but i can not find this field anywhere when i try to build a new smartlist to create automatical calculation. Please see picture
thanks xxxx

 

[VictoriaYudin]

Purchase Order line item detail can be in 2 tables:

POP10110 – Purchase Order Line Work
POP30110 – Purchase Order Line History

For more POP tables, check out this page:

http://victoriayudin.com/gp-tables/pop-tables/.

The account number index will be stored in the INVINDX field. If you need the actual account number or you can link to the GL00105 table on INVINDX = GL00105.ACTINDX.

Victoria Yudin
Dynamics GP MVP 2005 - 2010
Use Crystal Reports and SSRS with GP:

http://www.flex-solutions.com/gpreports.html

blog:

http://victoriayudin.com