Finance | Project Operations, Human Resources, ...

Whats the x++ code to get the value of the method "Reservation" in batch reservation form

(4) Share

Report

Posted on by ISDev

275

Hello

i have a custom report im developing, i need to retrieve the value of field Reservation in batch reservation form, to go through this form, first go All sales order and check sales line, make sure u are selecting a line order(itemid). then click on inventory and click after on batch reservation.

i need the x++ code to be able to retrieve the value knowing that its a method and not a field on the form. the method name is reserveNowQty() in form data source of table TmpPdsBatchSelect in form WHSBatchAttribReserve.

if anyone can provide me the code that i need to implement in my DP class please. it should be based on Itemid because each salesline has a a different ItemID.

Thank you

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Aymen CHELBI 574 on at

Like (0)

Report

Hello,

Here’s a possible implementation of the X++ code to retrieve the value of reserveNowQty() from the WHSBatchAttribReserve form for a given ItemId in your DP (Data Provider) class :

class MyReportDP extends SrsReportDataProviderBase
{
TmpMyReportTable tmpMyReportTable; // Temporary table for report data

public void processReport()
{
SalesLine salesLine;
TmpPdsBatchSelect tmpPdsBatchSelect;
InventDim inventDim;
WHSBatchAttribReserve whsBatchAttribReserve;
Qty reservedQty;

// Iterate through all sales lines with an ItemId
while select salesLine
where salesLine.SalesStatus == SalesStatus::Backorder
{
// Get inventory dimension
inventDim = InventDim::find(salesLine.InventDimId);

// Open the Batch Reservation form programmatically
whsBatchAttribReserve = new WHSBatchAttribReserve();
whsBatchAttribReserve.initParm(salesLine.ItemId, inventDim.InventBatchId);
whsBatchAttribReserve.run();

// Retrieve the reservation quantity from the method
select firstonly tmpPdsBatchSelect
where tmpPdsBatchSelect.ItemId == salesLine.ItemId;

if (tmpPdsBatchSelect)
{
reservedQty = tmpPdsBatchSelect.reserveNowQty(); // Call the method
}

// Insert into temporary table for the report
tmpMyReportTable.ItemId = salesLine.ItemId;
tmpMyReportTable.ReservedQty = reservedQty;
tmpMyReportTable.insert();
}
}

public TmpMyReportTable getTmpMyReportTable()
{
return tmpMyReportTable;
}
}

Best regards,

Was this reply helpful? Yes No
ISDev 275 on at

Like (0)

Report

Hello Aymen,

i tried ur code but its not working

Was this reply helpful? Yes No
Martin Dráb 237,967 Most Valuable Professional on at

Like (0)

Report

This is a duplicate of x++ code to get the value of the method "Reservation" in batch reservation form. Please select a thread - continue the discussion in one and abandon the other.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Whats the x++ code to get the value of the method "Reservation" in batch reservation form

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

Whats the x++ code to get the value of the method "Reservation" in batch reservation form

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