Finance | Project Operations, Human Resources, ...

Production Journal BOM should have only items which are available in Production BOM

(0) Share

Report

Posted on by ankitrsharma

Hi I need help. I am trying to provide the validation in the ProdJournalTransBOM form where the filed ItemID need to show only those Items which are available in its Production BOM. Rest it should not allow or show any item in the grid. Kindly let me know what could be the probable code for the same. Thanks and Regards.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi Ankit,

Under ProdJournalTransBOM\DataSources\ProdJournalBOM\Fields\ItemId, method validate has already been added. You can add your logic to validate if the ItemId is present in the production BOM.

From what I understand, you wouldn't want other items to show up on the lookup as well. For this requirement, you can override the lookup method under the same control to restrict the number items showing up in the lookup.

Was this reply helpful? Yes No
ankitrsharma 15 on at

Like (0)

Report
Copy link

Link copied!

Hi Gunjan, Thanks for your kind reply. I agree with you but there are two methods suppose validate as well as modify. Now I need to add a new one lookup there can you kindly suggest what code will be there in validate as well as lookup. Thanks and regards.

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!
Hi Ankit,

Here is the logic you can put in validate method -

select firstOnly prodBOMLoc where prodBOMLoc.ItemId == prodJournalBom.ItemId && prodBOMLoc.ProdId == prodJournalBOM.ProdId; if (!prodBOMLoc) { ret = checkFailed(strFmt("Item %1 is not a part of Production BOM", prodJournalBom.ItemId)); }

For lookup, this should work -

public void lookup(FormControl _formControl, str _filterStr) { SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable), _formControl); Query query = new Query(); QueryBuildDataSource qbds1, qbds2; QueryBuildRange queryBuildRangeItemType; qbds1 = query.addDataSource(tableNum(InventTable)); qbds2 = qbds1.addDataSource(tableNum(ProdBOM)); qbds2.joinMode(JoinMode::InnerJoin); qbds2.addLink(fieldNum(InventTable, ItemId), fieldNum(ProdBOM, ItemId)); qbds2.addRange(fieldNum(ProdBOM, ProdId)).value(queryValue(prodJournalBom.ProdId)); sysTableLookup.addLookupfield(fieldNum(InventTable,ItemId)); sysTableLookup.addLookupMethod(tableMethodStr(InventTable,itemGroupId)); sysTableLookup.addLookupMethod(tableMethodStr(InventTable,defaultProductName)); sysTableLookup.addLookupfield(fieldNum(InventTable,ItemType)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); }

Was this reply helpful? Yes No