Monday, September 25, 2017

Update Comment/Text from Maintain Session in LN 10.X

Infor 10.x session has new option to add Text on session and Text Area instead of old version of Text Editor. Following is code used to insert/update text field in maintain session:


DAL Code:

function extern long before.save.object(long i.mode)
{
long no.of.text.lines.copied

txinh219.lusr = logname$
txinh219.ludt = utc.num()

on case i.mode
case DAL_NEW:
if txinh219.cmnt <> 0 then
no.of.text.lines.copied = text.copy(
"txinh219.cmnt",
"txinh219.cmnt",
"", |* Keyword 1
"", |* Keyword 2
"", |* Keyword 3
"", |* Keyword 4
"", |* Text Group
"") |* Edit Options
endif
break
case DAL_UPDATE:
with.old.object.values.do(fill.old.values)

select tccom121.clan
from tccom121
where tccom121._index1 = {:txinh219.sfbp}
as set with 1 rows
selectdo
endselect

RETIFNOK(tccom.dll4000.rewrite.keywords.of.text(
"txinh219.cmnt",
txinh219.cmnt,
tccom121.clan,
"", |* KW1
"", |* KW1
"", |* KW2
"", |* KW2
"", |* KW3
"", |* KW3
"", |* KW4
"")) |* KW4

break
endcase

return(0)
}


Tuesday, September 5, 2017

Migration of Direct Delivery Sales Order and Link to PO in ERP LN 10.5

Following Steps are to migrate Direct Delivery Sales Order and Link with Purchase Order:

1. Migrate Open Sales Orders
2. Migrate Open Purchase Orders
3. Migrate Tables tdsls402 and tdpur402 for Open Orders
4. Approve Sales Order
5. Select approved sales order line and identify  activities pending till release sales order and find it in tdsls413 table
6. Update fields tdsls413.xcst as executed and tdsls413.nxct as No for selected session.
7. Update Field tdsls413.nxct as yes for actual activity need to execute.

Above steps will take make sales order in release state which were in previous environment and link is already maintained with purchase order.