Notifications
Announcements
No record found.
What sql table stores the gl distribution accounts for an item. Cards>Inventory>Item>Item Accounts ... The window name is "Item Account Maintenance"
Thanks
*This post is locked for comments
The Item master or IV00101. That stores the account index which is from the GL00105 table. The account number is stored in the GL00100.
Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com
this should help
select [Item Number] = ITEMNMBR, [Inventory On Hand] = (select ACTNUMST from GL00105 where IVIVINDX = ACTINDX), [Inventory On Hand] = (select ACTDESCR from GL00100 where IVIVINDX = ACTINDX), [Inventory Offset] = (select ACTNUMST from GL00105 where IVIVOFIX = ACTINDX), [Inventory Offset] = (select ACTDESCR from GL00100 where IVIVOFIX = ACTINDX), [Cost of Goods Sold] = (select ACTNUMST from GL00105 where IVCOGSIX = ACTINDX), [Cost of Goods Sold] = (select ACTDESCR from GL00100 where IVCOGSIX = ACTINDX), [Sales] = (select ACTNUMST from GL00105 where IVSLSIDX = ACTINDX), [Sales] = (select ACTDESCR from GL00100 where IVSLSIDX = ACTINDX), [Markdowns] = (select ACTNUMST from GL00105 where IVSLDSIX = ACTINDX), [Markdowns] = (select ACTDESCR from GL00100 where IVSLDSIX = ACTINDX), [Sales Returns] = (select ACTNUMST from GL00105 where IVSLRNIX = ACTINDX), [Sales Returns] = (select ACTDESCR from GL00100 where IVSLRNIX = ACTINDX), [In Use] = (select ACTNUMST from GL00105 where IVINUSIX = ACTINDX), [In Use] = (select ACTDESCR from GL00100 where IVINUSIX = ACTINDX), [In Service] = (select ACTNUMST from GL00105 where IVINSVIX = ACTINDX), [In Service] = (select ACTDESCR from GL00100 where IVINSVIX = ACTINDX), [Damaged] = (select ACTNUMST from GL00105 where IVDMGIDX = ACTINDX), [Damaged] = (select ACTDESCR from GL00100 where IVDMGIDX = ACTINDX), [Variance] = (select ACTNUMST from GL00105 where IVVARIDX = ACTINDX), [Variance] = (select ACTDESCR from GL00100 where IVVARIDX = ACTINDX), [Drop Ship Items] = (select ACTNUMST from GL00105 where DPSHPIDX = ACTINDX), [Drop Ship Items] = (select ACTDESCR from GL00100 where DPSHPIDX = ACTINDX), [Purchase Price Variance] = (select ACTNUMST from GL00105 where PURPVIDX = ACTINDX), [Purchase Price Variance] = (select ACTDESCR from GL00100 where PURPVIDX = ACTINDX), [Unrealized Purchase Price Var] = (select ACTNUMST from GL00105 where UPPVIDX = ACTINDX), [Unrealized Purchase Price Var] = (select ACTDESCR from GL00100 where UPPVIDX = ACTINDX), [Inventory Returns] = (select ACTNUMST from GL00105 where IVRETIDX = ACTINDX), [Inventory Returns] = (select ACTDESCR from GL00100 where IVRETIDX = ACTINDX), [Assembly Variance] = (select ACTNUMST from GL00105 where ASMVRIDX = ACTINDX), [Assembly Variance] = (select ACTDESCR from GL00100 where ASMVRIDX = ACTINDX) from IV00101 --select * from GL00105 --select * from GL00100
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
mtabor 1
