web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / APTran PO Number not c...
Microsoft Dynamics SL (Archived)

APTran PO Number not carried from APDoc on PPV

(0) ShareShare
ReportReport
Posted on by Deb Lashua 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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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

  • Deb Lashua Profile Picture
    Deb Lashua 2,165 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans