One moment please...
 

The attached zip file contains the files required for (re)compiling your IFALL link for Exact Financials version 3.50.

Change register

See document 13.636.194 for older changes.

version entity change recompile required
3.42 hour categories / surcharge codes / project machinery / project units / asset books / index tables / commitment classifications / commitment / contracts new -
3.42 project master cards parent project added yes *
3.42 commitments immediate processing added yes *
3.42 journals bank statement data added yes *
3.42 cost centers cost center manager added yes *
3.41 asset locations / asset departments / asset groups / asset sets new -
3.41 collection arrangements upgraded from IFALL3 to IFALL4 yes
3.40 - dynamic interface using temp-table table handles added reducing necessity of recompile when extra fields are added to temp-table yes
3.40 project locations new -
3.40 postal codes new -
3.40 ISO countries / ISO currencies / ISO languages new -
3.40 g/l accounts temp-table field names standardized yes - also need to adjust interface
3.40 - shared variables as defined in system/inc/shared.i (for example s-adm-nr for company number) are no longer used, use system/inc/session.i instead yes

* Only when not using the dynamic interface - see document 12.354.256 for details.

Note

We recommend using the newer IFALL modules since newer IFALL versions support more functionality. Also, older IFALL modules are generally linked through to newer IFALL modules resulting in unncessary overhead. For example ifdebtor.p simply passes its data to ifdebtor4.p. The results are then passed back from ifdebtor4.p to ifdebtor.p.

We also recommend using the dynamic interface since this reduces the necessity to recompile when upgrading Exact Financials.

Examples

Example programs are available in the examples directory in the zip file:

Journal entries

  • JournalEntryBank.p
  • JournalEntryCash.p
  • JournalEntryGeneral.p / JournalEntryGeneral-dynamic.p
  • JournalEntryGiro.p
  • JournalEntryPurchase.p / JournalEntryPurchase-dynamic.p
  • JournalEntrySales.p / JournalEntrySales-dynamic.p

Master data

  • CostCenters-dynamic.p
  • CostUnits-dynamic.p
  • CreditorsSearch.p (find)
  • Creditors.p (create) / Creditors-dynamic.p
  • Debtors.p / Debtors-dynamic.p
  • DeleteDebtor.p / DeleteDebtor-dynamic.p
  • GLaccounts.p
  • MainClassifcation.p
  • ProjectMasterCards.p
  • SubClassification.p
  • VATcodes.p

Various

  • CorsaAppServer.p (demonstrates dynamic IFALL interface with an AppServer connection)
  • ExchangeRates.p
  • HourEntries.p
  • IncomingInvoices.p
  • MachineryEntries.p
  • OutstandingItemTotal.p (demonstrates IFALL search to get total outstanding amount)

Overview IFALLs

Finance

Master data
table description IFALL file name temp-table file name IFALL version
admdat / admnac company data / company addresses finance/interf/ifadmdat.p finance/interf/inc/ifadmdat.i 4
bnktpe bank account types finance/interf/ifbnktpe.p finance/interf/inc/ifbnktpe.i 4
boenom nature of movement finance/interf/ifboenom.p finance/interf/inc/ifboenom.i 4
ccent cost centers finance/interf/ifccent.p finance/interf/inc/ifccent.i 4
ccnacc link cost center / g/l account finance/interf/ifccnacc.p finance/interf/inc/ifccnacc.i 4
colarr collection arrangements finance/interf/ifcolarr.p finance/interf/inc/ifcolarr.i 4
comcls commitment classifications finance/interf/ifcomcls.p finance/interf/inc/ifcomcls.i 4
comctr commitment contracts finance/interf/ifcomctr.p finance/interf/inc/ifcomctr.i 4
comp sub-classifications finance/interf/ifcomp.p finance/interf/inc/ifcomp.i 4
countr countries finance/interf/ifcountr.p finance/interf/inc/ifcountr.i 4
crdbnk creditor bank accounts finance/interf/ifcrdbnk.p finance/interf/inc/ifcrdbnk.i 3 (replaced by ifcredit4)
crdcat creditor categories finance/interf/ifcrdcat.p finance/interf/inc/ifcrdcat.i 4
credit creditors finance/interf/ifcredit.p finance/interf/inc/ifcredit.i 3 (replaced by ifcredit4)
credit / bnklnk / bnkacc / crdnac creditors finance/interf/ifcredit4.p finance/interf/inc/ifcredit4.i 4
cunacc link cost unit / g/l account finance/interf/ifcunacc.p finance/interf/inc/ifcunacc.i 4
cunit cost units finance/interf/ifcunit.p finance/interf/inc/ifcunit.i 4
curren currencies finance/interf/ifcurren.p finance/interf/inc/ifcurren.i 4
debbnk debtor bank accounts finance/interf/ifdebbnk.p finance/interf/inc/ifdebbnk.i 3 (replaced by ifdebtor4)
debcat debtor categories finance/interf/ifdebcat.p finance/interf/inc/ifdebcat.i 4
debtor debtors finance/interf/ifdebtor.p finance/interf/inc/ifdebtor.i 3 (replaced by ifdebtor4)
debtor / bnklnk / bnkacc / delnac / prdeb debtors finance/interf/ifdebtor4.p finance/interf/inc/ifdebtor4.i 4
fipcolh / fipcoll collection installments finance/interf/iffipcolh.p finance/interf/inc/iffipcolh.i 4
iiown invoice owners finance/interf/ifiiown.p finance/interf/inc/ifiiown.i 4
journl journals finance/interf/ifjournl.p finance/interf/inc/ifjournl.i 4
lang languages finance/interf/iflang.p finance/interf/inc/iflang.i 4
ledger general ledger acounts finance/interf/ifledger.p finance/interf/inc/ifledger.i 4
mcomp main classifications finance/interf/ifmcomp.p finance/interf/inc/ifmcomp.i 4
mdim1 multi-dimension 1 finance/interf/ifmdim1.p finance/interf/inc/ifmdim1.i 4
mdim2 multi-dimension 2 finance/interf/ifmdim2.p finance/interf/inc/ifmdim2.i 4
mdim3 multi-dimension 3 finance/interf/ifmdim3.p finance/interf/inc/ifmdim3.i 4
mdim4 multi-dimension 4 finance/interf/ifmdim4.p finance/interf/inc/ifmdim4.i 4
mdim5 multi-dimension 5 finance/interf/ifmdim5.p finance/interf/inc/ifmdim5.i 4
paycon payment conditions finance/interf/ifpaycon.p finance/interf/inc/ifpaycon.i 4
props / prpmc cost center properties finance/interf/ifprops-ccent.p finance/interf/inc/ifprops-ccent.i 4
props / prpmc creditor properties finance/interf/ifprops-credit.p finance/interf/inc/ifprops-credit.i 4
props / prpmc cost unit properties finance/interf/ifprops-cunit.p finance/interf/inc/ifprops-cunit.i 4
props / prpmc debtor properties finance/interf/ifprops-debtor.p finance/interf/inc/ifprops-debtor.i 4
props / prpmc asset properties finance/interf/ifprops-fas_ast.p finance/interf/inc/ifprops-fas_ast.i 4
props / prpmc g/l account properties finance/interf/ifprops-ledger.p finance/interf/inc/ifprops-ledger.i 4
sett g/l links finance/interf/ifgllink.p finance/interf/inc/ifgllink.i 4
titles titles finance/interf/iftitles.p finance/interf/inc/iftitles.i 4
vatrep VAT fiscal representatives finance/interf/ifvatrep.p finance/interf/inc/ifvatrep.i 4
vattrs VAT codes finance/interf/ifvattrs.p finance/interf/inc/ifvattrs.i 4

Entries
table description IFALL file name temp-table file name IFALL version
atrsh / atrss journal entries finance/interf/ifatrs.p finance/interf/ifatrs.i 2.5 (replaced by ifatrs-*)
atrsh / atrss journal entries finance/interf/iffife.p finance/interf/inc/iffife.i 3 (replaced by ifatrs-*)
atrsh / atrss accrual journal entries finance/interf/ifatrs-accrual.p finance/interf/inc/ifatrs-accrual.i 4
atrsh / atrss bank journal entries finance/interf/ifatrs-bank.p finance/interf/inc/ifatrs-bank.i 4
atrsh / atrss cash journal entries finance/interf/ifatrs-cash.p finance/interf/inc/ifatrs-cash.i 4
atrsh / atrss general journal entries finance/interf/ifatrs-general.p finance/interf/inc/ifatrs-general.i 4
atrsh / atrss giro journal entries finance/interf/ifatrs-giro.p finance/interf/inc/ifatrs-giro.i 4
atrsh / atrss purchase journal entries finance/interf/ifatrs-purchase.p finance/interf/inc/ifatrs-purchase.i 4
atrsh / atrss sales journal entries finance/interf/ifatrs-sales.p finance/interf/inc/ifatrs-sales.i 4
atrsh / atrss VAT journal entries finance/interf/ifatrs-vat.p finance/interf/inc/ifatrs-vat.i 4
comhl / comsl / comel commitments finance/interf/ifcom.p finance/interf/inc/ifcom.i 4
crdout creditor outstanding items finance/interf/ifcrdout.p finance/interf/inc/ifcrdout.i 4
debout debtor outstanding items finance/interf/ifdebout.p finance/interf/inc/ifdebout.i 4
fireh / firel recurring entries finance/interf/iffire.p finance/interf/inc/iffire.i 3
iireg incoming invoice registration finance/interf/ifiireg.p finance/interf/inc/ifiireg.i 4
xrates exchange rates finance/interf/ifxrates.p finance/interf/inc/ifxrates.i 4

Logistic

Master data
table description IFALL file name temp-table file name IFALL version
llcoc cost codes logistic/interf/ifllcoc.p logistic/interf/inc/ifllcoc.i 4
lldesc extra description codes logistic/interf/iflldesc.p logistic/interf/inc/iflldesc.i 4
lldome delivery / order methods logistic/interf/iflldome.p logistic/interf/inc/iflldome.i 4
lligrp item groups logistic/interf/iflligrp.p logistic/interf/inc/iflligrp.i 4
llinvc invoice codes logistic/interf/ifllinvc.p logistic/interf/inc/ifllinvc.i 4
llitem items logistic/interf/ifllitem.p logistic/interf/inc/ifllitem.i 4
llplig price lists per item group logistic/interf/ifllplig.p logistic/interf/inc/ifllplig.i 4
llplit price lists per item logistic/interf/ifllplit.p logistic/interf/inc/ifllplit.i 4
llplst price lists logistic/interf/ifllplst.p logistic/interf/inc/ifllplst.i 4
lllrr link recurring invoice to relation logistic/interf/iflllrr.p logistic/interf/inc/iflllrr.i 4
lltext general text codes logistic/interf/iflltext.p logistic/interf/inc/iflltext.i 4
lsrep representatives logistic/interf/iflsrep.p logistic/interf/inc/iflsrep.i 4
props / prpmc item properties finance/interf/ifprops-llitem.p finance/interf/inc/ifprops-llitem.i 4
units units logistic/interf/ifunits.p logistic/interf/inc/ifunits.i 4

Entries
table description IFALL file name temp-table file name IFALL version
llrech / llrecl recurring sales invoices logistic/interf/ifllrec.p logistic/interf/inc/ifllrec.i 4
lsihl / lsisl sales invoices logistic/interf/iflsei.p logistic/interf/inc/iflsei.i 4
lsohl / lsosl sales orders logistic/interf/iflseo.p logistic/interf/inc/iflseo.i 4
lpeih / lpeil purchase invoices logistic/interf/iflpei.p logistic/interf/inc/iflpei.i 4
lpeoh / lpeol purchase orders logistic/interf/iflpeo.p logistic/interf/inc/iflpeo.i 4
lperh / lperl receipts logistic/interf/iflper.p logistic/interf/inc/iflper.i 4

Project

Master data
table description IFALL file name temp-table file name IFALL version
prccat cost categories project/interf/ifprccat.p project/interf/inc/ifprccat.i 4
prdep departments project/interf/ifprdep.p project/interf/inc/ifprdep.i 4
premp employees project/interf/ifpremp.p project/interf/inc/ifpremp.i 4
prgrp project groups project/interf/ifprgrp.p project/interf/inc/ifprgrp.i 4
prhcat hour categories project/interf/ifprhcat.p project/interf/inc/ifprhcat.i 4
pringh project invoice groups project/interf/ifpringh.p project/interf/inc/ifpringh.i 4
prloc project locations project/interf/ifprloc.p project/interf/inc/ifprloc.i 4
prmach machinery project/interf/ifprmach.p project/interf/inc/ifprmach.i 4
prmst / prmstdeb project master cards project/interf/ifprmst.p project/interf/inc/ifprmst.i 4
props / prpmc employee properties finance/interf/ifprops-premp.p finance/interf/inc/ifprops-premp.i 4
props / prpmc machinery properties finance/interf/ifprops-prmach.p finance/interf/inc/ifprops-prmach.i 4
props / prpmc project master card properties finance/interf/ifprops-prmst.p finance/interf/inc/ifprops-prmst.i 4
prpos project position project/interf/ifprpos.p project/interf/inc/ifprpos.i 4
prstat project state project/interf/ifprstat.p project/interf/inc/ifprstat.i 4
prsurc surcharge codes project/interf/ifprsurc.p project/interf/inc/ifprsurc.i 4
prtype project type project/interf/ifprtype.p project/interf/inc/ifprtype.i 4
prunit project units project/interf/ifprunit.p project/interf/inc/ifprunit.i 4

Entries
table description IFALL file name temp-table file name IFALL version
prdeh / prdes project direct entries project/interf/ifprde.p project/interf/inc/ifprde.i 4
prheh / prhes project hour entries project/interf/ifprhe.p project/interf/inc/ifprhe.i 4
prieh / pries project item entries project/interf/ifprie.p project/interf/inc/ifprie.i 4
prinsh / prinss project installments project/interf/ifprins.p project/interf/inc/ifprins.i 4
prmeh / prmes project machinery entries project/interf/ifprme.p project/interf/inc/ifprme.i 4
prrcca project budget per cost category project/interf/ifprrcca.p project/interf/inc/ifprrcca.i 4
prrcyp project budget per cost category per period project/interf/ifprrcyp.p project/interf/inc/ifprrcyp.i 4
prrhca project budget per hour category project/interf/ifprrhca.p project/interf/inc/ifprrhca.i 4
prrhyp project budget per hour category per period project/interf/ifprrhyp.p project/interf/inc/ifprrhyp.i 4
prritm project budget per item project/interf/ifprritm.p project/interf/inc/ifprritm.i 4
prriyp project budget per item per period project/interf/ifprriyp.p project/interf/inc/ifprriyp.i 4
prrmch project budget per machinery project/interf/ifprrmch.p project/interf/inc/ifprrmch.i 4
prrmyp project budget per machinery per period project/interf/ifprrmyp.p project/interf/inc/ifprrmyp.i 4

Fixed Assets

Master data
table description IFALL file name temp-table file name IFALL version
dpr_idxm / dpr_idxd index tables assets/interf/ifdpr_idxm.p assets/interf/ifdpr_idxm.i 4
fas_ast / fas_depr / fas_prmst fixed assets assets/interf/iffas_ast.p assets/interf/inc/iffas_ast.i 4
fas_book asset books assets/interf/iffas_book.p assets/interf/inc/iffas_book.i 4
fas_dept departments assets/interf/iffas_dept.p assets/interf/iffas_dept.i 4
fas_grp asset groups assets/interf/iffas_grp.p assets/interf/iffas_grp.i 4
fas_loc locations assets/interf/iffas_loc.p assets/interf/iffas_loc.i 4
fas_mast asset sets assets/interf/iffas_mast.p assets/interf/iffas_mast.i 4

System

Master data
table description IFALL file name temp-table file name IFALL version
isocnt ISO countries finance/interf/ifisocnt.p finance/interf/inc/ifisocnt.i 4
isocur ISO currencies finance/interf/ifisocur.p finance/interf/inc/ifisocur.i 4
isolng ISO languages finance/interf/ifisolng.p finance/interf/inc/ifisolng.i 4
stexca external categories system/interf/ifstexca.p
system/interf/ifstexca0.p
system/interf/inc/ifstexca.i
system/interf/inc/ifstexca0.i
4
stnactype address types system/interf/ifstnactype.p system/interf/inc/ifstnactype.i 4

Entries
table description IFALL file name temp-table file name IFALL version
prpval properties system/interf/ifprpval.p system/interf/inc/ifprpval.i 4
stexob external objects system/interf/ifstexob.p system/interf/inc/ifstexob.i 4


Attachments
ifall350.zip 598.3 KB Download