to get the sum of the reciept quantity and amount

(2) Share

Report

Posted on by Dineshkarlekar

1,836

i was trying ti get the sum of reciept quantity and amount from purchse order reciepts but getting wrong data , like if there is return it is also get added in sum ,

i am nt aware hot to use purch totals for this ,can you people help me out on this .

 //while select
                     //          sum(vendPackingSlipTrans.ValueMST),
                     //          sum(vendPackingSlipTrans.REMAIN),
                     //          sum(vendPackingSlipTrans.Qty) from  vendPackingSlipTrans
                     //       join vendPackingSlipJour
                     //             where vendPackingSlipJour.RecId == vendPackingSlipTrans.VendPackingSlipJour 
                     //              && vendPackingSlipJour.PurchId == purchTable.PurchId
                     //{

                     //       receivedQty += vendPackingSlipTrans.Qty;
                     //       receivedAmount += vendPackingSlipTrans.ValueMST;
                     //       pendingQty += vendPackingSlipTrans.REMAIN;
                     //}

                     //   tempRec.QtyReceived    = qtyReceived;
                     //   tempRec.ReceivedAmount = receivedAmount;
                     //   tempRec.QtyPending     = qtyPending;
                     //   tempRec.PendingAmount  = qtyPending * tempRec.PurchPrice;

Categories:

Dynamics 365 Project Operations

I have the same question (0)

All responses (7)

Answers (0)

Vigneshvaran 354 on at

Like (1)

Report

Please try to refer the below blog, where I have calculated the Purchase requisition totals, same way you can try to find against purchase order.

https://axvigneshvaran.wordpress.com/2023/04/17/get-the-purchase-requisition-total-page-fields-using-x-in-microsoft-dynamics-365-for-finance-and-operations/

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

thanks for reply @Vigneshvaran

but which method get the purch reciept amount , and quantity it is sitll not clear from this method .

can you explain

thanks regards

dinesh

Was this reply helpful? Yes No
Vigneshvaran 354 on at

Like (0)

Report

Could you please share me the front end screenshot which field you want to calculate.

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report
hi @Vigneshvaran

i am getting the data in ssrs report , so i need to calculate

these to poplulate my temp tableI. in ssrs dp clas i put code like this

PurchtotalsForm purchTotalsForm; purchTotalsForm = PurchtotalsForm::newPurchTotalsForm(purchTable); purchTotalsForm.doUnPack(); if (purchTotalsForm.allowEditCurrencyCode()) { CurrencyCode accountingCurrency = Ledger::accountingCurrency(CompanyInfo::current()); purchTotalsForm.setCurrencyCode(accountingCurrency); } purchTotalsForm.calctotals(); purchTotalsForm.doPack(); ReceivedAmount = purchTotalsForm.sumLinesValue() + purchTotalsForm.invoiceRoundOffValue(); ReceivedAmount1 = purchTotalsForm.sumTaxValue(); ReceivedAmount2 = purchTotalsForm.invoiceAmountValue(); tempRec.QtyReceived = purchTotalsForm.qtyValue();

// receivedQty += vendPackingSlipTrans.Qty; // receivedAmount += vendPackingSlipTrans.ValueMST; // pendingQty += vendPackingSlipTrans.REMAIN; //} // tempRec.QtyReceived = qtyReceived; // tempRec.ReceivedAmount = receivedAmount; // tempRec.QtyPending = qtyPending; // tempRec.PendingAmount = qtyPending * tempRec.PurchPrice;

Was this reply helpful? Yes No
Vigneshvaran 354 on at

Like (1)

Report

Hi Dinesh,

I dont need the code, I just need to understand your requirement through front end to suggest the code.

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

Hi Vigneshvaran

I can share you path ,

in All purchase orders >Product receipt journal >lines

Recieved & Amount & Remaining is already there .hope you understand .

thanks

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

hi @Vigneshvaran

this is the image , i hope it helps

Was this reply helpful? Yes No

Join the conversation

Community site session details

to get the sum of the reciept quantity and amount

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

to get the sum of the reciept quantity and amount

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates