Thursday, May 22, 2014

Dynamics GP - Extended Pricing View - list of all prices on all sheets

SELECT     IV10402.PRCSHID, IV10402.EPITMTYP, IV10402.ITEMNMBR, IV00101.ITEMDESC, IV10402.UOFM, IV10402.QTYFROM, IV10402.QTYTO, IV10402.PSITMVAL, IV10402.EQUOMQTY,
                      IV10402.QTYBSUOM, IV10402.SEQNUMBR, IV10402.DEX_ROW_ID, IV00101.ITMCLSCD, IV10401.PRODTCOD
FROM         IV10402 INNER JOIN
                      IV00101 ON IV10402.ITEMNMBR = IV00101.ITEMNMBR INNER JOIN

                      IV10401 ON IV10402.PRCSHID = IV10401.PRCSHID AND IV10402.ITEMNMBR = IV10401.ITEMNMBR

No comments:

Post a Comment