Net Receipt Quantity

Yahoo Archive
1
I found a field in the Open Purchase Order report that displays the Net Receipt to date for a Part on a PO but I can't seem to find the calculation driving it. It is field PORel.Calc_OnOrder
I should mention I am trying to build an Open PO Dashboard that displays this field. Thanks!

-Sal

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> PORel.ReceivedQty
>
> Total quantity received to date. In Purchasing unit of measure. This is a summary maintained by the receipt process.
>
> --- In vantage@yahoogroups.com, "dciepicor" <dciepicor@> wrote:
> >
> > Hi,
> >
> > Does anyone know how to calculate the Net Receipt Quantity on a PO. Example: PO: 1000 includes Part: 3000 at Quantity: 2000. Two Receipts were made against this PO for Quantity: 500. How do I display that the Net Receipt Quantity is 1000. If I pull in the RcvDtl Table it will show the two receipts for 500 as two line items with a Net of 1500 each. Hope that makes sense and hope someone can help! Thanks!!
> >
> > -Sal
> >
>
2
Hi,

Does anyone know how to calculate the Net Receipt Quantity on a PO. Example: PO: 1000 includes Part: 3000 at Quantity: 2000. Two Receipts were made against this PO for Quantity: 500. How do I display that the Net Receipt Quantity is 1000. If I pull in the RcvDtl Table it will show the two receipts for 500 as two line items with a Net of 1500 each. Hope that makes sense and hope someone can help! Thanks!!

-Sal
3
PORel.ReceivedQty

Total quantity received to date. In Purchasing unit of measure. This is a summary maintained by the receipt process.

--- In vantage@yahoogroups.com, "dciepicor" <dciepicor@...> wrote:
>
> Hi,
>
> Does anyone know how to calculate the Net Receipt Quantity on a PO. Example: PO: 1000 includes Part: 3000 at Quantity: 2000. Two Receipts were made against this PO for Quantity: 500. How do I display that the Net Receipt Quantity is 1000. If I pull in the RcvDtl Table it will show the two receipts for 500 as two line items with a Net of 1500 each. Hope that makes sense and hope someone can help! Thanks!!
>
> -Sal
>
4
Sal is right. Just remember RecvDtl links down to Release level with PORel, which can create some confusion when summarizing PO lines' and releases' quantities.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705



[Non-text portions of this message have been removed]