28 apr

Easy Row Functions (Coresuite)

Versino Financial Suite

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.


AI in everyday work: Person starts with their own task instead of the learning pile

AI in everyday work: Here's how to find the right start

Anyone who wants to use AI in their daily work is familiar with this: You read an article about prompts. A new model appears in it ...
AI-SHOP

AI assistant meets SAP Business One: Two paths out of the Versino AI shop

AI assistants like Claude or Copilot write emails, compile documents, and explain technical terms. But when you ask them about the open-source code...
SPRINT & SWIRL

Sprint and Swirl: How an AI agent divides work and learns from trials

This series deals with artificial intelligence in conjunction with SAP Business One. It takes a close look at fundamental AI principles...
LATS

LATS: Considering several paths simultaneously with AI — and the availability check in SAP B1

This series focuses on artificial intelligence in conjunction with SAP Business One. Not as a collection of product announcements, but as...
ReAct and RLEF

ReAct and RLEF: How Artificial Intelligence Learns from Real Mistakes — and What Automated Bank Reconciliation in SAP Business One Has to Do with It

This is the fourth instalment in a series on this blog dealing with AI fundamentals in conjunction with SAP Business One...
Service Layer AI as a transactional layer

SAP B1 10.0 FP2608: Service Layer AI as a transactional layer

The SAP Business One Service Layer has previously served predominantly as a passive data provider: applications requested data via OData, each ...
Wird geladen …