Finance | Project Operations, Human Resources, ...

How to obtain the total revenue of a project purchaseorder

(0) Share

Report

Posted on by Danzel Zuo

131

Hello All

I can get the total number of individual purchase orders, but I don't know how to get the total number of all purchase orders under the project number

while select purchLine
        where purchLine.PurchId         == 'PO001798'//ST-0016-0001
           && !purchLine.IsDeleted && purchLine.PurchStatus !=4
    {
        amountCur  = purchLine.calcLineAmountExclTax(purchLine.PurchQty);

    }

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Danzel Zuo 131 on at

Like (0)

Report
Copy link

Link copied!

I solved the problem

while select m_purchTable

where m_purchTable.projid =='ST-0016-0001'

join m_purchLine

where m_purchLine.purchid == m_purchTable.purchid

&& !m_purchLine.IsDeleted && m_purchLine.PurchStatus !=4

{

amountCur += m_purchLine.calcLineAmountExclTax(m_purchLine.PurchQty);

}

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Danzel Zuo,

Can you elaborate?

A purchase order typically has no association with revenue because it is used for purchasing things.

Revenues are linked to your sales orders.

Best regards,

Ludwig

Was this reply helpful? Yes No