Display field that will be showing the sum of the amounts on the product receipt lines

(0) Share

Report

Posted on by wassim.77

Hello evryone i have a task where i need to add a field that will be showing the sum of the amounts on the product receipt lines and the Currency in the product receipt journal.

The distributions view in yallow is where I can locate the lines with their amounts and currencies as demonstrated in the image below

When I checked, the field was getting data by an edit method. I want to know how to sum the multiple lines of the selected record also their value and how to acquire the relationship between the two forms/datasources.

thank you.

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi wassim,

If you want to get the total amount you can directly get it from product receipt line. No need to go for view distribution. I guess view distribution will show all monetary amounts.

On the product receipt form there is a lines tab next to overview tab. I guess that tab will have all the lines.

So you can add a display method to get the total line amount from the tables used in the Lines tab against product receipt.

Thanks,

Girish S.

Was this reply helpful? Yes No
wassim.77 72 on at

Like (0)

Report
Copy link

Link copied!
Hey Girish S.

I want to thank you for your response first.

I used your reasoning, and while it did work, it wasn't how I had intended.

[ExtensionOf(tableStr(VendPackingSlipJour))] public final class VendPackingSlipJour_Extension { public display AmountMST SumProductReceipt() { VendPackingSlipJour vendPackingSlipJour; VendPackingSlipTrans vendPackingSlipTrans; select sum(ValueMST) from vendPackingSlipTrans where vendPackingSlipTrans.OrigPurchid == this.PurchId; return vendPackingSlipTrans.ValueMST; } }

In my situation, I want to obtain the product receipt total and the currency used without converting to US dollars, but the valueMST field returns the amount in monetary standard (national currency).

As demonstrated in the screenshot below, because the currency is CAD I'm getting 171.23 as a total but it should be 175.00 .

Was this reply helpful? Yes No
Verified answer

GirishS 27,843 Moderator on at

Like (1)

Report
Copy link

Link copied!
I got your point. You can make use of "AccountingDistribution" table and "VendPackingSlipJour" table. Relation will be "SourceDocumentHeader".

Try the below code and check whether it works for your scenario.

[ExtensionOf(tableStr(VendPackingSlipJour))] public final class VendPackingSlipJour_Extension { public display AmountMST SumProductReceipt() { VendPackingSlipJour vendPackingSlipJour; VendPackingSlipTrans vendPackingSlipTrans; AccoutingDistribution distribution; select sum(TransactionAmount) from distribution join vendPackingSlipJour where vendPackingSlipJour.SourceDocumentHeader == distribution.SourceDocumentHeader && vendPackingSlipJour.Purchid == this.PurchId && distribution.TransactionCurrency == "CAD"; return distribution.TransactionAmount; } }

Thanks,

Girish S.

Was this reply helpful? Yes No
wassim.77 72 on at

Like (1)

Report
Copy link

Link copied!
thank you Girish S

So i did some modification and it worked here is the code for both the amount and currency for anyone how may need it

[ExtensionOf(tableStr(VendPackingSlipJour))] public final class VendPackingSlipJour_Extension { public display AmountMST SumProductReceipt() { VendPackingSlipJour vendPackingSlipJour; VendPackingSlipTrans vendPackingSlipTrans; AccountingDistribution distribution; select sum(TransactionCurrencyAmount) from distribution join vendPackingSlipJour where vendPackingSlipJour.SourceDocumentHeader == distribution.SourceDocumentHeader && vendPackingSlipJour.Purchid == this.PurchId; return distribution.TransactionCurrencyAmount; } public display CurrencyCode SumProductReceiptCurrency() { VendPackingSlipJour vendPackingSlipJour; VendPackingSlipTrans vendPackingSlipTrans; AccountingDistribution accountingDistribution; select TransactionCurrency from accountingDistribution join vendPackingSlipJour where vendPackingSlipJour.SourceDocumentHeader == accountingDistribution.SourceDocumentHeader && vendPackingSlipJour.PurchId == this.PurchId; return accountingDistribution.TransactionCurrency; } }

Was this reply helpful? Yes No