1,357
Hi,
My Procurement department created a PO (as shown in the image)
If you see in the background the smartlist window showing that the VENDORID is 00189040 whereas the PO was created on VENDORID: 00192020
I don't understand why smartlist and actual purchase order window showing this difference in VENDOR ID. For your perusal, I have also attached the vendor properties of both the VENDOR IDs.
Please help.
*This post is locked for comments
Fahad,
It seems to be the Purchasing Line Items Smartlist was modified from you backend. To confirm, go to SQL server and connect the GP instances and get the create query for PurchaseLineItems as per below steps.
1. In SQL server Expand the company Database-->Views.
2. Now find the view PurchaseLineItems. Then right click and get the Create query as per below screen shot and attach the query to us.
Hi soma,
My apologies for late reply to this. Yes, it seems the user is fetching info from not the correct smart list. Please see the screen shot. He is choosing Purchase Line Items smart list instead of fetching info from "Purchase Order" smart list where the info shows correctly.
Could you explain why the Line Item smart list is giving wrong info of Vendor? Is it because somewhere the user had INITIALLY assigned the ITEM of PO to wrong vendor?
This 192020 is the correct vendor ID mapped to your PO number PO-RS-00000247. I think the problem is there in your smartlist. Are get the details for this PO from standard GP smartlist? or New customized smartlist?
Can you show the screen shot for the smartlist(like as smartlist--> purchasing-->etc)?
Hi Soma,
Thanks for the help. Please see the below result came out from POP10100. I don't see any result from POP30100
| PONUMBER | PO-RS-00000247 |
| POSTATUS | 4 |
| STATGRP | 1 |
| POTYPE | 1 |
| USER2ENT | tobehidden |
| CONFIRM1 | |
| DOCDATE | 00:00.0 |
| LSTEDTDT | 00:00.0 |
| LSTPRTDT | 00:00.0 |
| PRMDATE | 00:00.0 |
| PRMSHPDTE | 00:00.0 |
| REQDATE | 00:00.0 |
| REQTNDT | 00:00.0 |
| SHIPMTHD | |
| TXRGNNUM | |
| REMSUBTO | 54600 |
| SUBTOTAL | 54600 |
| TRDISAMT | 0 |
| FRTAMNT | 0 |
| MSCCHAMT | 0 |
| TAXAMNT | 0 |
| VENDORID | 192020 |
| VENDNAME | tobehidden |
| MINORDER | 0 |
| VADCDPAD | PRIMARY |
| CMPANYID | 3 |
| PRBTADCD | KHIOFF |
| PRSTADCD | KHIOFF |
| CMPNYNAM | tobehidden |
| CONTACT | tobehidden |
| ADDRESS1 | tobehidden |
| ADDRESS2 | tobehidden |
| ADDRESS3 | |
| CITY | tobehidden |
| STATE | tobehidden |
| ZIPCODE | tobehidden |
| CCode | tobehidden |
| COUNTRY | Pakistan |
| PHONE1 | tobehidden |
| PHONE2 | |
| PHONE3 | |
| FAX | tobehidden |
| PYMTRMID | Net 30 Days |
| DSCDLRAM | 0 |
| DSCPCTAM | 0 |
| DISAMTAV | 0 |
| DISCDATE | 00:00.0 |
| DUEDATE | 00:00.0 |
| TRDPCTPR | 0 |
| CUSTNMBR | |
| TIMESPRT | 0 |
| CREATDDT | 00:00.0 |
| MODIFDT | 00:00.0 |
| PONOTIDS_1 | 73091 |
| PONOTIDS_2 | 0 |
| PONOTIDS_3 | 73198 |
| PONOTIDS_4 | 0 |
| PONOTIDS_5 | 54 |
| PONOTIDS_6 | 0 |
| PONOTIDS_7 | 46 |
| PONOTIDS_8 | 0 |
| PONOTIDS_9 | 0 |
| PONOTIDS_10 | 0 |
| PONOTIDS_11 | 73092 |
| PONOTIDS_12 | 0 |
| PONOTIDS_13 | 0 |
| PONOTIDS_14 | 0 |
| PONOTIDS_15 | 0 |
| COMMNTID | |
| CANCSUB | 0 |
| CURNCYID | PKR |
| CURRNIDX | 1008 |
| RATETPID | |
| EXGTBLID | |
| XCHGRATE | 0 |
| EXCHDATE | 00:00.0 |
| TIME1 | 00:00.0 |
| RATECALC | 0 |
| DENXRATE | 0 |
| MCTRXSTT | 0 |
| OREMSUBT | 54600 |
| ORSUBTOT | 54600 |
| Originating_Canceled_Sub | 0 |
| ORTDISAM | 0 |
| ORFRTAMT | 0 |
| OMISCAMT | 0 |
| ORTAXAMT | 0 |
| ORDDLRAT | 0 |
| ODISAMTAV | 0 |
| BUYERID | |
| ONORDAMT | 54600 |
| ORORDAMT | 54600 |
| HOLD | 0 |
| ONHOLDDATE | 00:00.0 |
| ONHOLDBY | |
| HOLDREMOVEDATE | 00:00.0 |
| HOLDREMOVEBY | |
| ALLOWSOCMTS | 0 |
| DISGRPER | 0 |
| DUEGRPER | 0 |
| Revision_Number | 0 |
| Change_Order_Flag | 0 |
| PO_Field_Changes | 0x12000000 |
| PO_Status_Orig | 1 |
| TAXSCHID | |
| TXSCHSRC | 3 |
| TXENGCLD | 1 |
| BSIVCTTL | 0 |
| Purchase_Freight_Taxable | 2 |
| Purchase_Misc_Taxable | 2 |
| FRTSCHID | |
| MSCSCHID | |
| FRTTXAMT | 0 |
| ORFRTTAX | 0 |
| MSCTXAMT | 0 |
| ORMSCTAX | 0 |
| BCKTXAMT | 0 |
| OBTAXAMT | 0 |
| BackoutFreightTaxAmt | 0 |
| OrigBackoutFreightTaxAmt | 0 |
| BackoutMiscTaxAmt | 0 |
| OrigBackoutMiscTaxAmt | 0 |
| Flags | 0 |
| BackoutTradeDiscTax | 0 |
| OrigBackoutTradeDiscTax | 0 |
| POPCONTNUM | |
| CONTENDDTE | 00:00.0 |
| CNTRLBLKTBY | 0 |
| PURCHCMPNYNAM | tobehidden |
| PURCHCONTACT | |
| PURCHADDRESS1 | tobehidden |
| PURCHADDRESS2 | tobehidden |
| PURCHADDRESS3 | tobehidden |
| PURCHCITY | tobehidden |
| PURCHSTATE | tobehidden |
| PURCHZIPCODE | |
| PURCHCCode | tobehidden |
| PURCHCOUNTRY | tobehidden |
| PURCHPHONE1 | |
| PURCHPHONE2 | |
| PURCHPHONE3 | |
| PURCHFAX | |
| BLNKTLINEEXTQTYSUM | 0 |
| CBVAT | 0 |
| Workflow_Approval_Status | 9 |
| Workflow_Priority | 2 |
| DEX_ROW_TS | 3/25/2014 |
| DEX_ROW_ID | 5214 |
Run the below query in SQL against your company database and attach the result to us.
select *From POP10100 where PONUMBER='Enter your PO number'
select *From POP30100 where PONUMBER='Enter your PO number'
Your reply is much appreciated.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (