jojovalenton
2nd August 2023, 14:52
hi,
i am trying to create a script to save acr open items, in afs tfacr200.amnt used to save as screen.amnt but how it is in dal.set.field? I tried same as screen.amnt but system doesn't recognized. pls need your help. thanks.

jojo

OmeLuuk
7th August 2023, 11:15
Show us what you tried in code

jojovalenton
15th August 2023, 02:25
dal.new.object("tfacr200")
db.set.to.default(ttfacr200)
dal.set.field("tfacr200.ttyp",i.ttyp)
dal.set.field("tfacr200.ninv",i.seri)
dal.set.field("tfacr200.line",0)
dal.set.field("tfacr200.tdoc","")
dal.set.field("tfacr200.docn",0)
dal.set.field("tfacr200.lino",0)
dal.set.field("tfacr200.itbp",i.bp)
dal.set.field("tfacr200.docd",i.tedt)
dal.set.field("tfacr200.dued",i.tedt)
dal.set.field("tfacr200.trec",i.trec)
dal.set.field("tfacr200.ccur",i.ccur)
dal.set.field("tfacr200.adrs",i.cadr)
dal.set.field("tfacr200.pfbp",i.bp)

dal.set.field("tfacr200.rade",i.rade)
dal.set.field("tfacr200.rate",1,1)
dal.set.field("tfacr200.rate",3.75,2)
dal.set.field("tfacr200.rate",0.000001,3)
dal.set.field("tfacr200.ratf",1,1)
dal.set.field("tfacr200.ratf",1,2)
dal.set.field("tfacr200.ratf",1,3)
dal.set.field("tfacr200.ratd",i.date)
dal.set.field("tfacr200.amnt",i.amnt)
dal.set.field("tfacr200.amti",i.amnt)
dal.set.field("tfacr200.amth",i.amnt,1)
dal.set.field("tfacr200.amth",(i.amnt/3.75),2)
dal.set.field("tfacr200.amth",0.00,3)

dal.set.field("tfacr200.refr",i.refr)
dal.set.field("tfacr200.prod",i.fprd)
dal.set.field("tfacr200.year",i.year)
dal.set.field("tfacr200.styp","SPSLS")
dal.set.field("tfacr200.rtyp","SLS")
dal.set.field("tfacr200.cfrs","CUSUNA")
dal.set.field("tfacr200.lvat",i.vatc)hi,

OmeLuuk
15th August 2023, 11:28
dal.new.object("tfacr200")
db.set.to.default(ttfacr200)
...
dal.set.field("tfacr200.amth",i.amnt,1)
dal.set.field("tfacr200.amth",(i.amnt/3.75),2)
dal.set.field("tfacr200.amth",0.00,3)[/COLOR]
...Did you try dal.set.array.field()?