Monday, August 25, 2014

Update SysExportdialog Filename to User Export date and time and user id

// To update SysExportdialog Filename to User Export date and time and user id

AOT -> Form -> SysExportDialog -> Method -> run

Overwrite line  [element.updateBox(fileNameNext(    )] in run method as

element.updateBox(fileNameNext
                (strfmt('%1%2_%3_%4_%5_%6%7',
                        filePath, preFix,treeNode.treeNodeName(),curUserId(),
                                date2str(today(),123,2,DateSeparator::Dot,2,DateSeparator::Dot,2),
                                    time2str(timeNow(),TimeSeparator::Dot,TimeFormat::Hour24), #xpo)));

Search hierarchy for a match (TableALLGroup) X++

  Table1 ppt;  select firstonly ppt  order ItemCode, ItemRelation, AccountCode, AccountRelation where      (ppt.ItemCode == TableGroupAll::T...