-- For UPC missing in NLS on PO
Run this query with changing the PO number
select s1.alu,s1.local_upc from Attunity_RPro_Web.dbo.po p
inner join Attunity_RPro_Web.dbo.PO_ITEM pi1 on p.po_sid=pi1.po_sid
inner join Attunity_RPro_Web.dbo.invn_sbs s1 on pi1.ITEM_SID=s1.item_sid
where po_no='P1541889'
check the missing UPC if they are on the list in the results
then check the Item master file and PO file and see what we have sent
\\gt-sql01\GolfTown_Stage\OUTBOUNDfromRTP\PO\Archive
\\10.34.85.71\integrations\NLS_PRD\ITEM_MASTER
If the data is not match anywhere, that system needs to be corrected.
e.g
Fix the SKU
Fix the PO
Integrations run every night and POs and Item master is sent to NLS every day