Dynamics Community Forum Thread Details

[ExtensionOf(formDataSourceStr(InventJournalName, InventJournalName))]
internal final class DTT_InventJournalName_F_Extension
{
public int active()
{
int ret = next active();

InventJournalName InventJournalNameloc = this.cursor();

if(InventJournalNameloc.JournalType == InventJournalType::Count || InventJournalNameloc.JournalType == InventJournalType::Movement)
{
this.object(fieldNum(InventJournalName,DTT_SiteMandatory)).allowEdit(true);
}
else
{
this.object(fieldNum(InventJournalName,DTT_SiteMandatory)).allowEdit(false);
}
return ret;
}
}

static final class DTT_InventJournalNameEventHandler_F_Extension
{
[FormDataSourceEventHandler(formDataSourceStr(InventJournalName, InventJournalName), FormDataSourceEventType::Activated)]

public static void Table_OnActivated(FormDataSource sender, FormDataSourceEventArgs e)
{

InventJournalName _table = sender.cursor();
FormDataSource table_ds=sender.formRun().dataSource(/InventJournalName/);
FormRun element = sender.formRun();
FormControl ControlName =element.design(0).controlName(/DTT_SiteNotMandatory_DTT_SiteMandatory/);

/* if(_table.JournalType == InventJournalType::Count || _table.JournalType == InventJournalType::Movement)
ControlName.allowEdit(true);
else
ControlName.allowEdit(false);*/
}

}

[ExtensionOf(classStr(InventCountCreate))]
public final class DTT_InventCountCreate_C_Extension
{
public DialogField dialogSplit;
public DTT_SplitJournalPerWarehouse splitPerWarehouse;
public JournalId journalIdToCreate;

#DEFINE.CurrentVersion(10)
#LOCALMACRO.CurrentList
splitPerWarehouse
#ENDMACRO

public Object dialog()
{
InventJournalName inventJournalName;
InventJournalTable inventJournalTableForDialog = InventJournalTable::find(this.parmJournalId());
DialogRunbase thisDialog = next dialog();

inventJournalName = inventJournalTableForDialog.inventJournalName();
dialogSplit = thisDialog.addField(extendedTypeStr(DTT_SplitJournalPerWarehouse));

if(inventJournalName.DTT_SiteMandatory == NoYes::Yes)
{
if (!inventJournalTableForDialog.InventLocationId)
{
dialogSplit.value(true);
dialogSplit.allowEdit(true);
}
}
else
{
dialogSplit.value(false);
dialogSplit.allowEdit(false);
}

return thisDialog;
}

public boolean getFromDialog()
{
boolean ret = next getFromDialog();

splitPerWarehouse = dialogSplit.value();

return ret;
}

public container pack()
{
container packedClassLocal = next pack();
return SysPackExtensions::appendExtension(packedClassLocal, classStr(DTT_InventCountCreate_C_Extension), this.myPack());
}

public boolean unpack(container _packedClass)
{
boolean result = next unpack(_packedClass);

if (result)
{
container myState = SysPackExtensions::findExtension(_packedClass, classStr(DTT_InventCountCreate_C_Extension));

//Also unpack the extension
if (!this.myUnpack(myState))
{
result = false;
}
}

return result;
}

private container myPack()
{
return [#CurrentVersion, #CurrentList];
}

private boolean myUnpack(container _packedClass)
{
Integer version = RunBase::getVersion(_packedClass);
switch (version)
{
case #CurrentVersion:
[version, #CurrentList] = _packedClass;
break;
default:
return false;
}
return true;
}

public void run()
{
next run();

if (splitPerWarehouse)
{
this.splitJournalPerWarehouse();
}
}

public void splitJournalPerWarehouse()
{
InventJournalTable fromInventJournalTable = InventJournalTable::find(this.parmJournalId());
InventJournalTrans inventJournalTrans;
InventDim inventDim;

// To loop on how many unique warehouses from the journal
while select inventDim
group by InventLocationId
exists join inventJournalTrans
where inventJournalTrans.JournalId == this.parmJournalId()
&& inventJournalTrans.InventDimId == inventDim.inventDimId
{
this.createNewHeader(fromInventJournalTable);
this.createNewLines(inventDim.InventLocationId);
this.postProcessing(inventDim.InventLocationId);
}

this.deleteLinesFromHeaderAndUpdateHeaderNumOfLines();
}

public void createNewHeader(InventJournalTable _fromInventJournalTable)
{
if (_fromInventJournalTable)
{
InventJournalTable toInventJournalTable;

toInventJournalTable.data(_fromInventJournalTable);
toInventJournalTable.JournalId = NumberSeq::newGetNum(InventParameters::numRefInventJournalId(),false).num();
toInventJournalTable.SessionId = 0;
toInventJournalTable.SessionLoginDateTime = utcDateTimeNull();
toInventJournalTable.RecId = 0;
toInventJournalTable.NumOfLines = 0;
toInventJournalTable.SystemBlocked = NoYes::No;

if (toInventJournalTable.validateWrite())
{
toInventJournalTable.insert();
journalIdToCreate = toInventJournalTable.JournalId;
}
}
}

public void createNewLines(InventLocationId _inventLocationId)
{
InventJournalTrans inventJournalTransLines;
InventDim inventDimLines;
int lineCounter;

// To loop the lines in the original journal and add it to a separate journal base on the grouping of warehouse
while select inventJournalTransLines
join inventDimLines
where inventJournalTransLines.JournalId == this.parmJournalId()
&& inventJournalTransLines.InventDimId == inventDimLines.inventDimId
&& inventDimLines.InventLocationId == _inventLocationId
{
lineCounter++;
InventJournalTrans inventJournalTransToCreate;

inventJournalTransToCreate.data(inventJournalTransLines);
inventJournalTransToCreate.JournalId = journalIdToCreate;
inventJournalTransToCreate.LineNum = lineCounter;
inventJournalTransToCreate.RecId = 0;

if (inventJournalTransToCreate.validateWrite())
{
inventJournalTransToCreate.insert();
}
}
}

public void postProcessing(InventLocationId _inventLocationId)
{
this.updateHeaderNumOfLines(_inventLocationId);
}

public void updateHeaderNumOfLines(InventLocationId _inventLocationId)
{
InventJournalTable inventJournalTableLocal;
InventJournalTrans inventJournalTransLocal;

select count(RecId) from inventJournalTransLocal
where inventJournalTransLocal.JournalId == journalIdToCreate;

if (inventJournalTransLocal.RecId)
{
inventJournalTableLocal = InventJournalTable::find(journalIdToCreate);

// This should have a value, but just to make sure
if (inventJournalTableLocal)
{
ttsbegin;
inventJournalTableLocal.selectForUpdate(true);
inventJournalTableLocal.NumOfLines = inventJournalTransLocal.RecId; // To assign the number of lines to the header
inventJournalTableLocal.update();
ttscommit;

Info(strFmt(/@Deloitte:DTT_CountingJournalForWarehouseInfo/, journalIdToCreate, _inventLocationId));
}
}
}

public void deleteLinesFromHeaderAndUpdateHeaderNumOfLines()
{
InventJournalTrans inventJournalTransToDelete;
InventJournalTable inventJournalTableToUpdate;

delete_from inventJournalTransToDelete
where inventJournalTransToDelete.JournalId == this.parmJournalId();

inventJournalTableToUpdate = InventJournalTable::find(this.parmJournalId());

if (inventJournalTableToUpdate)
{
ttsbegin;
inventJournalTableToUpdate.selectForUpdate(true);
inventJournalTableToUpdate.NumOfLines = 0;
inventJournalTableToUpdate.update();
ttscommit;
}

}

Extension on standard form

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Leaderboard

Featured topics

Product updates