RECIEVED BUT NOT INVOICED REPORT IN CRYSTAL 1

[mathews1]

I am trying to make crystal report for recieved but not invoiced report. I am using POP10500 AND POP10600 as main tables. What are other tables that I can use. I am not able to understand qty invoiced and qty matched fields in POP10500

Thanks

-G

 

[Luvsql]

I have one that uses POP10100, POP10110, POP10500 and the POP30300 (in order to remove voids).

Here's my sql script from the report, which may help:

SELECT POP10110.ITEMNMBR, POP10110.ITEMDESC, POP10110.QTYORDER, POP10110.POLNESTA, POP10100.PONUMBER, POP10100.VENDORID, POP10100.VENDNAME, POP10100.DOCDATE, POP10500.QTYSHPPD, POP10110.ORD, POP10500.POPRCTNM, POP10500.QTYINVCD, POP10500.QTYRESERVED, POP30300.GLPOSTDT, POP10500.ORCPTCOST, POP10500.POPTYPE, POP10500.CURNCYID, POP10500.XCHGRATE, POP30300.POPTYPE, POP30300.VOIDSTTS
FROM ((POP10100 INNER JOIN POP10110 ON POP10100.PONUMBER=POP10110.PONUMBER) INNER JOIN POP10500 ON (POP10110.PONUMBER=POP10500.PONUMBER) AND (POP10110.ORD=POP10500.POLNENUM)) INNER JOIN POP30300 ON POP10500.POPRCTNM=POP30300.POPRCTNM
WHERE POP10110.QTYORDER<>0 AND POP10110.POLNESTA<5 AND POP30300.VOIDSTTS=0
ORDER BY POP10100.PONUMBER, POP10110.ORD, POP10110.ITEMNMBR

 

[mathews1]

Thanks very much.

 

[mathews1]

Hi,

In above script, POP10500.QTYINVCD picksup the QTY if pop type is 2 (invoice) or 3 (invoice/shipment). if POPTYPE is 1(Shipment) and we match shipment then qty matched does not shows up. Do you think, for matched shipments, I should be using pop10600 and for matched landed costs,I should be using POP30700 AND POP10600.

Thanks
-g

 

[mathews1]

Hi,

I want to place unmatched landed cost in my report and I am not able to identify unmatched landed cost.is there any way I can pull only unmatched landed cost

-g