Electronic reporting of customer payments received for domestic invoices with VAT on payment

Use this procedure to initiate electronic reporting of customer payments received for domestic invoices with VAT on payment.

This reporting is required only in some countries.

See the Country-specific requirements section.

Limitations

Unpaid or rejected checks and drafts that use method 3-'New invoice' in 'Draft/Check. Open Unpaid or Rejected' (ARS340) are not supported by VAT on payment. Therefore, they cannot be used to report received payments.
Electronic reporting of received payments is available for divisions that use 'Tax method' (TATM) set to 1-'VAT/GST' on 'Company. Connect Division' (MNS100/G).

Before you start

Before you start, you must meet these prerequisites:

Select the 'Dom e-rep - pmt' checkbox (DERP) on 'Country. Open' (CRS045/E) for the base country of invoices with reported payments.
FAM functions for invoice payments with cash discount or accepted payment tolerance at partial payment must use 'Split pmt trans' (SPAR) set to alternative 1 or 3. This setting splits the AR transaction into the reported paid amount and the non-reported cash discount or payment tolerance.

Processing of payments received

During the update of received payments in the Accounts Receivable and General Ledger, VAT on the suspense account moves to the regular VAT payable account. At the same time, records are stored automatically in table FARCPR with the paid amount for each invoice. The record status in the table is set to 20 to trigger electronic reporting using the country-specific format.

Reporting of payments received for invoices with payment term for split due date or manual split

Payments for invoices with a split due date or manually split invoices are reported using the original invoice number. The number is retrieved from:

Additional information number 227-'Splitted AR invoice'
Additional information number 228-'Split customer invoice'

Reporting of payments received for drafts

Payments for invoices in a draft are reported when the draft is confirmed in 'Bank Remittance. Reconcile Payments' (ARS350) or 'Bank Remitt. Reconcile Payt per Due Date' (ARS355). Payments are reported using the original invoice numbers in the draft.

If the check box 'Draft accounting method' (DAME) is selected on 'Settings - General Ledger' (CRS750/F), payments are reported when the draft risk is canceled in 'Customer Risk Cancellation. Create' (ARS330).

Resend electronic reporting of payments received

If the electronic message must be resent, select the payment using related option 25-'Re-send electr pmt trigger' on 'Customer Invoice. Display Separate' (ARS215/B). The status of the record in table FARCPR changes to 30 to trigger electronic reporting using the country-specific format.

For payments processed through drafts, select the record created during bank confirmation in (ARS350) or (ARS355).

Note: The related option is available only for payment transactions processed after activating the 'Dom e-rep - pmt' check box in (CRS045).

Country-specific requirements

As part of the 'France Life Cycle' process, an electronic message is required to report the amount paid for customer payments subject to VAT on payment. This message applies to domestic invoices.

See the M3 Localizations Library (Cloud) and open France > France Configuration Guide > Accounts receivable for a description of the electronic message format.