Icon

Stop Using XLOOKUP

Simple Lookups


using the Value Lookup node

Advanced Lookups


using the Joiner node (e. g. with multiple join criteria)

import GL transactions table
CSV Reader
importchart of accounts
CSV Reader
lookup GL accountdetails based onAccount No
Value Lookup
Export toFinal_Report.xlsxSheet 1: GL TransactionsSheet 2: Export Invoices in RC
Excel Writer
Import the Export Invoice Table(downloaded from ERP)
CSV Reader
Currency Exchangerates per period
CSV Reader
Join FX Ratebased on PeriodAND Currency
Joiner
Calculate Amount in Reporting Currency
Expression

Nodes

Extensions

Links