2,165
Is there an issue with the po number not populating on PPV (purchase price variance) transactions? I am attempting to pull information from APTran and capture the PO Number for the transaction. I have several PPV transactions that do not have a PO Number in APTran even though the document (APDoc) has a PO Number. Is there a reason why this is not populated? Do I have a system issue?
*This post is locked for comments
Thank you. I am actually working on adding the PO number to the Detail GL report and may need to incorporate a similar statement into the report to capture the information for the PPV transactions.
Hi Deb,
Most things like this are because someone made a decision a long time ago as to how to do something. Some times I think it is because of the additional programming time it would take. My guess is sometimes it is because someone just didn't think of it, etc.
Would a query like this help?
select t.batnbr as'APbatch',p.batnbr as 'PO batch',t.RefNbr as 'VOnbr',t.trantype, t.PONbr, t.RcptNbr,t.invtid,
t.Qty,t.POQty as 'po qty',t.PPV as 'PPV' , t.POunitprice as 'PO Unit price',
t.poextprice as 'PO Ext price', t.tranamt as 'aptran tranamt',p.Acct as 'Receipt acct',p.Sub as 'Receipt sub',
d.RefNbr as 'VO Refnbr', d.DocType from APTran t
inner join APDoc d on t.RefNbr=d.RefNbr and t.BatNbr=d.BatNbr
inner join POTran p on p.PONbr=t.PONbr and p.RcptNbr=t.RcptNbr
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (