Skip to main content

Outbound Periodic

A periodic outbound message type produces a recurring bulk export — a daily on-hand file, a customer list, an EDI invoice batch — delivered through a connector such as SFTP or Azure File Share. The export class extends DEVIntegExportBulkBase (a RunBaseBatch subclass), and the Outbound message type defines the connection, file name template, and schedule-ready operation.

Three implementation levels​

  1. No-code, SQL: DEVIntegExportBulkSQL exports the result of a SQL statement configured directly in the message type setup:

    SELECT ITEMID, sum(availPhysical) as Qty, InventLocationId FROM INVENTSUM
    WHERE CLOSEDQTY = 0 AND DATAAREAID = 'USMF'
    GROUP BY ITEMID, InventLocationId
    HAVING sum(availPhysical) > 0

    The same approach works against data entity views (CUSTCUSTOMERV3ENTITY etc.) for entity-shaped exports without code.

  2. Simple X++: a small class that builds the dataset in X++ and writes it through the base class helpers (DEVIntegTutorialExportBulkInventOnhand, DEVIntegTutorialExportBulkOnhandPricesQuery).

  3. Incremental: tracking what was already sent — DEVIntegTutorialExportBulkCustInvEDIInc exports customer invoices in an EDI file structure.

Every run is recorded in the Export log with line counts, duration, and warning/skipped counters.

Tutorial​