Share
ReportHi
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'm glad we were able to resolve your issue. You can close the topic by verify the answer.
All responses (
Answers (
Ergun ahin,
Thank you very much, your answer is exactly what I needed, it worked.
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));
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156