We don't calculate our pricelists on LN.
We just want to import an excel file in order to avoid to do all by hand. We have a big quantity of prices to mantain.
I tried with Exchange. But with our actual price parameters it's simply impossibe.
So i would like to know what are the methods you are using for this.
I think this question faced many of us.
Thanks.

Hi,

may be you could write a code to upload data from CSV or other Delimited into Price list tables.

or

You can write an AFS to update the same .

Regards,
Sushil Kumar Mudaliar

We have 9 sales price lists for standard items. Different customers are linked to different price lists. e.g. distributors are linked to pricelist 1 if we invoice them in GBP.
We also use the configurator and customised items but that's a different matter!
I upload them from csv files (created with the relevant formulas & discount % in excel) using Exchange. The csv file may contain items that do no exist on Baan and these lines are just ignored.
Our exchange script expires the previous price when I upload a new price.

Ed

Thank you sushil for your help.
Unfortunately i'm not a technical.
but if we use a code, do we risk to corrupt data ?
What is AFS. can i get somewhere informations about it ?

Thank you EdHubbard too, you way is very interesting. have you got problems when configuring import in exchange ?

Hello,
You could download AFS Docs in Infor Support Site and also check in AFS/DDC/OLE section.

http://www.baanboard.com/baanboard/showthread.php?p=159240

This is the sales price expiry date script:

table ttdsls032

domain tccplt store.cpls
domain tcitem store.item
domain tccuni store.cntr
domain tddile store.dile
domain tcqsl1 store.qanp
domain tcdate store.stdt
domain tcdate store.tdat
domain tcpric store.pric
domain tcdisc store.disc
domain tcdiam store.damt
domain tccdsc store.cdis
domain tcgnpr store.gnpr

store.cpls = tdsls032.cpls
store.item = tdsls032.item
store.cntr = tdsls032.cntr
store.dile = tdsls032.dile
store.qanp = tdsls032.qanp
store.stdt = tdsls032.stdt
store.tdat = tdsls032.tdat
store.pric = tdsls032.pric
store.disc = tdsls032.disc
store.damt = tdsls032.damt
store.cdis = tdsls032.cdis
store.gnpr = tdsls032.gnpr


tdsls032.stdt = 0

db.columns.to.record(ttdsls032)
db.ge(ttdsls032)
db.record.to.columns(ttdsls032)
while tdsls032.cpls = store.cpls and
tdsls032.item = store.item and
tdsls032.cntr = store.cntr and
tdsls032.dile = store.dile and
tdsls032.qanp = store.qanp and
not e
if (tdsls032.stdt <= store.tdat or store.tdat = 0) and
(tdsls032.tdat >= store.stdt or tdsls032.tdat = 0) then
db.eq(ttdsls032,db.delayed.lock)
if e then
db.gt(ttdsls032)
db.record.to.columns(ttdsls032)
continue
endif

if tdsls032.stdt >= store.stdt then
tdsls032.stdt = store.stdt - 2
endif

tdsls032.tdat = store.stdt - 1
db.update(ttdsls032, db.delayed.lock)
commit.transaction()
endif

db.next(ttdsls032)
db.record.to.columns(ttdsls032)
endwhile




tdsls032.cpls = store.cpls
tdsls032.item = store.item
tdsls032.cntr = store.cntr
tdsls032.dile = store.dile
tdsls032.qanp = store.qanp
tdsls032.stdt = store.stdt
tdsls032.tdat = store.tdat
tdsls032.pric = store.pric
tdsls032.disc = store.disc
tdsls032.damt = store.damt
tdsls032.cdis = store.cdis
tdsls032.gnpr = store.gnpr

return(true)

Thank EdHubbard. You are great.