Pyament Export SEPA

(0) Share

Report

Posted on by Community Member

Hi,

I have this problem:

When I try to export payment on a file I get this error" Only transactions in euro (EUR) are allowed, because the 01 bank account is set up to use the SEPACT export format."

The transaction is in Euro, the currency of the account is euro.

I don't know how to solve this problem

Could you hel me? Many thanks

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (0)

Report

RE: Pyament Export SEPA

check the settings of the bank accounts.

Was this reply helpful? Yes No
Verified answer

Jens Glathe 6,092 on at

Like (0)

Report
RE: Pyament Export SEPA

Hi,

sounds like a setup issue. Is your LCY 'EUR'? And did you also enter 'EUR' as currency, and set it in the bank account? In this case the checking logic would simply fail (and this would be correct from the system POV).

Here's a list of possible setup errors:

GLSetup LCY Code = EUR, Bank = EUR - should be empty.

Currency Code for Euro is not EUR - must be, since the check is sort of hard coded in Codeunit 1223.

If you already have posted entries in EUR and your LCY code is the same, then these entries will be treated as in a foreign currency. Although this is one of the more common errors, limiting the effect of this will require some changes from your NAV partner (or your inhouse NAV team).

How to get out of this:

In Codeunit 1223, function CheckGenJnlLine() should be changed:

LOCAL CheckGenJnlLine(VAR GenJnlLine : Record "Gen. Journal Line") GLSetup.GET; WITH GenJnlLine DO BEGIN IF "Bal. Account Type" <> "Bal. Account Type"::"Bank Account" THEN InsertPaymentFileError(MustBeBankAccErr); IF "Bal. Account No." = '' THEN AddFieldEmptyError(GenJnlLine,TABLECAPTION,FIELDCAPTION("Bal. Account No."),''); IF "Recipient Bank Account" = '' THEN AddFieldEmptyError(GenJnlLine,TABLECAPTION,FIELDCAPTION("Recipient Bank Account"),''); IF NOT ("Account Type" IN ["Account Type"::Vendor,"Account Type"::Customer]) THEN InsertPaymentFileError(MustBeVendorOrCustomerErr); IF (("Account Type" = "Account Type"::Vendor) AND ("Document Type" <> "Document Type"::Payment)) OR (("Account Type" = "Account Type"::Customer) AND ("Document Type" <> "Document Type"::Refund)) THEN InsertPaymentFileError(STRSUBSTNO(MustBeVendPmtOrCustRefundErr)); IF Amount <= 0 THEN InsertPaymentFileError(MustBePositiveErr); IF "Currency Code" <> GLSetup.GetCurrencyCode('EUR') THEN BEGIN //PX001s px.jgl if "Currency Code" <> 'EUR' then begin BankAccount.GET("Bal. Account No."); InsertPaymentFileError(STRSUBSTNO(EuroCurrErr,"Bal. Account No.",BankAccount."Payment Export Format")); end; //PX001e px.jgl END; IF "Posting Date" < TODAY THEN InsertPaymentFileError(TransferDateErr); END;

This change tests again after the normal check if the currency code is indeed EUR, handled as a foreign currency. This should ensure that the export can jump over this obstacle.

The correct way to correct this would be to clean the EUR currency code from the whole company, which can be quite a task. Better to change the checking and ensure that the currency exchange rate for EUR is 1.

with best regards

Jens

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Pyament Export SEPA

Hi,

I missed the GLSetup LCY Code = EUR

Thank you very much

Was this reply helpful? Yes No