How to check costing item based on Receipt

(0) Share

Report

Posted on by Dedi Hermawan

295

Using this sp view to make Smartlist by using Smartlist Designer or Smartlist Builder to check item cost based on Receipt

On Dynamics GP we can see Purchase Receipt Inquiry Window

Create view ABC_Costing_OUT_Base_ON_Receipt
as

select a.ITEMNMBR as [Item Number],
b.ITEMDESC as [Item Description],
a.TRXLOCTN as [Site ID],
a.DOCDate as [Document Date],
a.ORIGINDOCID as [Doc Number OUT],
c.RCPTNMBR as [Receipt Number],
a.LNSEQNBR as [LineITemSeq],
a.QTYSOLD as [Qty],
a.UNITCOST as [Unit Cost],
a.QTYSOLD*a.UNITCOST as [Extended Cost]

from IV10201 a
left join IV00101 b on a.ITEMNMBR = b.ITEMNMBR
left join IV10200 c on a.ITEMNMBR = c.ITEMNMBR and a.SRCRCTSEQNM = c.RCTSEQNM

go
GRANT SELECT ON ABC_Costing_OUT_Base_ON_Receipt TO DYNGRP

*This post is locked for comments