Easy Row Functions (Coresuite)

E-invoicing in Germany: How to implement the obligation with SAP Business One

Easy Row Functions is the row-oriented part of the Coresuite Designer formula library. While the general Easy Functions work on the document header, Easy Row Functions focus on the detail section of a Crystal layout – meaning the repeated document lines of a quote, order, invoice, or goods receipt. They provide pre-built logic to format, hide, aggregate, or enrich lines with additional information on a contextual basis.

Context

Typical Easy Row functions help, for example, to separate text lines from article lines (ItemType = 290 for texts), to form position sums by product group, to insert subheadings at group changes, to provide free lines with a note, or to automatically set the delivery/billing address appropriately on the line for partial deliveries. The call syntax and return types remain simple and readable in Crystal syntax; complex SQL joins to the B1 tables (INV1, DLN1, RDR1) are hidden within the function itself. This allows documents to be brought up to corporate design level with just a few lines of formula code, without having to resort to subreports or extra commands.

Demarcation

Easy Row Functions only work in the details area and within the Coresuite Designer runtime. For values at document header level, regular Easy Functions responsible; for external data sources and more complex analyses, subreports or commands are still used. The line functions of the SAP B1 UI API (e.g. DataSource.GetValue): These apply at client runtime, not during print rendering.