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
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
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
