Search values ??in other months if the current one does not have

(0) Share

Report

Posted on by Community Member

Hi
I'm developing an activity that I need to develop the following rule:
Check the last highest unit purchase value of the item entered in the current month. 
(VendInvoiceTrans).PurchPrice of the Item (VendInvoicetrans).ItemId , if there is no purchase record in the current month, 
check the previous month and so on.
How could I do this on Ax 2012?

I have the same question (0)

All responses (4)

Answers (1)

André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Euler,

Do you need the last or highest purchase price? The current month is per calendar month or a 30 day running period?

Curiosity: What is the purpose for this requirement?

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
The question sounded very familiar. It's like I answered once .
In the other question, account was involved, so I included the header in the answer.
If it's just the item, the process is easier. You can find the last record of this item with a simple select, instead of looking for the last record month by month. After you find the last record, what you need to do is to apply a one-month range with the date(month) information of that record and find the maximum price.

ItemId _itemId = ""; VendInvoiceTrans vendInvoiceTrans; FromDate fromDate; ToDate toDate; ; select firstOnly vendInvoiceTrans order by InvoiceDate Desc where vendInvoiceTrans.ItemId == _itemId; fromDate = mkDate(1,mthofyr(vendInvoiceTrans.InvoiceDate),year(vendInvoiceTrans.InvoiceDate)); toDate = endMth(vendInvoiceTrans.InvoiceDate); select maxof(PurchPrice) from vendInvoiceTrans where vendInvoiceTrans.InvoiceDate >= fromDate && vendInvoiceTrans.InvoiceDate <= toDate && vendInvoiceTrans.ItemId == _itemId; info(strFmt("%1",vendInvoiceTrans.PurchPrice));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Ergun ahin, Thank you very much, your answer is exactly what I needed, it worked.

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

I'm glad we were able to resolve your issue. You can close the topic by verify the answer.

Was this reply helpful? Yes No