Small and medium business | Business Central, N...

Cannot change payment method codes.

(4) Share

Report

Posted on by LB-23010004-0

113

UPDATE: When using the config package, I have been able to update all my payment method codes. However, the check printed flag is now unchecked. I am editing the Check Printed column to the value true so that it is checked. This give me the below error. I have this field in the configuration package set to no validation. How can I get this to update?

I have several payment journal lines where checks have already been printed, but I need to update their Payment Method Code from BILL.COM to CHECK. When attempting to make this change in the payment journals module, I receive the following error:

Check Printed must be equal to 'No' in Gen. Journal Line: Journal Template Name=PAYMENT, Journal Batch Name=CASH, Line No.=100000. Current value is 'Yes'.

I understand why this restriction exists, but I need to find a way to update the Payment Method Code while ensuring that the check numbers remain the same.

Additionally, I am unable to void these checks from the Check Ledger Entries because I receive this error:

Entry Status must be equal to 'Posted' in Check Ledger Entry: Entry No.=178. Current value is 'Printed'.

Is there a way to update the Payment Method Code for these payment journal lines, or alternatively, void the check while manually re-entering the same check number? The checks have already been sent, so maintaining the existing check numbers is crucial.

Thank you all for your help.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Suresh Kulla 50,278 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

You can update it using Config Package without doing the Validation, or write a process report to do the same. But all the business logic will be skipped and also the method code will be different on the ledger entries and this?

Since the journal will be deleted and if the check are good why you want to update it ? If this is because of an integration then above is the approach.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,214 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, hope the following helps.

Dynamics 365 Business Central: Can we skip/ignore field validation errors?

https://yzhums.com/44435/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Saif Ali Sabri 2,360 Moderator on at

Like (0)

Report
Copy link

Link copied!
My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.
In Dynamics 365 Business Central, the restriction exists to maintain data integrity, ensuring that once a check is printed, key financial details (like the Payment Method Code) remain unchanged. However, since you need to update the Payment Method Code while keeping the same check numbers, here are your options:

Option 1: Use a Configuration Package (Skipping Validation)

You can bypass the validation by using a Configuration Package to update the Payment Method Code without triggering Business Central’s standard checks.

Steps to use Configuration Package:

Go to "Configuration Packages" in Business Central.

Create a new package and add the table 81 (Gen. Journal Line).

Export the data and modify the Payment Method Code in Excel.

Import the updated file back into Business Central.

Apply the package to update the journal lines.

⚠ Warning: This method skips validation, meaning it will update the data directly without Business Central enforcing its usual rules. If the payment is already posted, this might cause discrepancies in the ledger entries vs. journal entries.

Option 2: Reverse and Re-enter with Same Check Number

If you want to maintain proper audit trails:

Void the check properly (if possible) by resolving the Entry Status = "Printed" issue.

Navigate to Bank Account Ledger Entries and locate the check.

If the check is stuck in Printed status, ensure the related payment journal is deleted.

Then, attempt to void the check.

Re-enter the payment manually using the correct Payment Method Code but keep the same check number.

⚠ Issue: If the check remains in "Printed" status, you may not be able to void it until it's fully posted.

Option 3: Custom Development (Process Report)

If this is a recurring issue or an integration-related problem, consider a Process Report that:

Updates the Payment Method Code directly.

Ensures that the corresponding ledger entries are aligned.

This requires a developer with AL programming skills to write a small extension.

Which Option is Best?

If data consistency is critical, use Option 2 (reverse and re-enter).

If you just need a quick fix without validation, use Option 1 (Configuration Package).

If this is part of an integration issue, consider Option 3 (custom process report).

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,342 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=2808240c-6eb9-4124-a7dd-76185ef5b122

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

In that case you need to write an AL extension to directly put the Payment method code into the Record. As system checks and will not allow you to in front.

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,666 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You will need to void the check, change the payment method code, and then re-print the checks. However, you can also edit this field directly in the vendor ledger entries. This means you can post your checks with the incorrect payment method and then update it later in the vendor ledger entries. Keep in mind, this field is primarily for informational purposes in the payment journal.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No