Guides

Automatic Certification Storage

Guide for using automatic storage in the fne_certifications table

FNE Client can automatically store certifications in a database table to facilitate management of certified invoices and future refund creation.

Overview

When an invoice is successfully certified, FNE Client can automatically store important information in the fne_certifications table. This feature is particularly useful for:

Creating refunds: FNE UUIDs are required to create refunds
History: Keep a history of certifications
Search: Easily search certified invoices
Reports: Generate reports on certifications

Activation

Via Configuration

Or in .env:

Via Laravel Pennant

Force Storage Explicitly

Table Migration

Laravel

The migration is available in database/migrations/2024_01_01_000000_create_fne_certifications_table.php.

Symfony

Use the provided SQL file:

Usage

With CertifiableInvoice Trait

Storage is automatic if the feature is enabled:

Verify Storage

Use UUID to Create Refund

Multi-Framework Compatibility

Automatic storage works with:

Laravel: Uses Eloquent Model (FNECertification)
Symfony: Uses Doctrine EntityManager or DBAL Connection
Native PHP: Uses PDO directly

The system automatically detects the framework and uses the appropriate method.

Error Handling

If storage fails (table doesn't exist, SQL error, etc.), certification continues normally. The error is logged but does not affect the certification process.

Disable Storage

If you don't want to use this feature:

Or explicitly disable during certification: