Hi,

Please suggest the replacement tables fields for cisli205.csai, cisli205.gdai ,cisli205.rmai in FP10. To use in invoice report.

Thanks in advance

Regards,
Jnandesh

use table cisli305 and cisli310.

Hi Kishore,

Thanks for reply, i didn't find exact replacement fields in Cisli305 and cisli310 table. Can you please suggest me the exact replacement fields in FP10.

Regards,
Jnandesh

Do you have sources? This fields seem to be used when printing Service invoices. We're not using service.
But we do have a F6 System and an FP8 system. FP8 already uses cisli305/3010 and FP6 still uses the older tables (i.e cisli205). Printing is done in DLL cislidll1200.

In FP6 the mentioned fields are accessed like this:


cisli205.gdai :goods.amount,
cisli205.svai :service.amount, |#800-166993.n
cisli205.csai :cost.amount,
cisli205.rmai :remaining.amount,


Those variables aren't present in FP8s cislidll1200 but we do have lookalikes.


domain tcamnt goods.amount.hc(3)
domain tcamnt service.amount.hc(3)
domain tcamnt cost.amount.hc(3)

Those are internal variables. I think they are all filled with cisli310.slai (source.line.amount) depended on some type fields in cisli310. (I didn't dug deeper into the sourcecode.)


on case i.charge.type
case cisli.chtp.goods: |* Goods
io.goods.amount = io.goods.amount + source.line.amount
(..)
break
case cisli.chtp.service: |* Service
io.service.amount = io.service.amount + source.line.amount
(..)
break
case cisli.chtp.costs: |* Costs
io.cost.amount = io.cost.amount + source.line.amount
(..)
break


Not speaking of an educated guess, but I'm would like to suggest the use some external variables instead (filled with the internal variables). I think it worth trying.


extern domain tcamnt r.ih.am.goods
extern domain tcamnt r.ih.am.service
extern domain tcamnt r.ih.am.cost

(..)

function long set.report.data.aggregated.values(
domain tcamnt i.blocked.amount,
domain tcamnt i.goods.amount,
domain tcamnt i.service.amount,
domain tcamnt i.cost.amount,
domain tcamnt i.remaining.amount,
domain tcamnt i.discount.amount,
domain tcamnt i.settlement.amount,
domain tcamnt i.interest.amount,
domain tcamnt i.installment.amount,
domain tcamnt i.advance.amount,
domain tcamnt i.hold.back.amount,
domain tcamnt i.shifted.tax.amount,
domain tcamnt i.wage.part.amount)
{
r.ih.am.bloc = i.blocked.amount
r.ih.am.goods = i.goods.amount
r.ih.am.service = i.service.amount
r.ih.am.cost = i.cost.amount
(..)


You may also want to compare the standard invoice reports, too. Maybe there some lookalike layouts in the FP6 and LN 10.4 reports, where you can compare the used variables. (I did not check these.)