Skip to main content
Try for free

How to Use A/R Payment Rounding Adjustments in Cetec ERP

Aug 24 2026

Overview

The A/R Payment Rounding Adjustment feature helps you complete payments when an invoice has a value smaller than the currency precision shown on screen. It identifies the small difference between the exact amount applied to invoices and the payment amount you entered, then lets you add the required write-off. When the optional automatic setting is enabled, the page can create and maintain that write-off for the current editing session.

The feature is available on both A/R payment edit pages:

  • Standard edit page: `/arpayment/{id}/edit`
  • New edit page: `/arpayment/{id}/edit_new`

It is designed for small precision differences only. It does not replace normal partial-payment, unapplied-cash, credit-memo, or write-off workflows.

Before You Start

  • You need access to A/R Payments and permission to update the payment.
  • The payment must be active.
  • Use the invoice's displayed balance for normal payment entry.
  • Use the rounding adjustment only when Payment Value matches the invoice's displayed full balance, but Raw Applied Total differs slightly because the invoice stores more decimal places.

What Changed

The payment edit pages now include two values next to Payment Value.

Raw Applied Total: Shows the exact, unrounded total applied to the included invoices and other payment components.

Rounding Adjustment: Shows the small write-off needed to reconcile Raw Applied Total with Payment Value.

An Apply button is available when there is a rounding adjustment on an active payment. Payment Complete is disabled until the payment balances. With automatic rounding write-offs enabled, the page normally balances the adjustment as soon as the automatic write-off is saved.

The values recalculate after you commit a change to Payment Value, an Apply amount, an invoice inclusion, a discount, unapplied cash, a credit memo, or a write-off.

Automatic Rounding Write-Offs

Enable the setting

An accounting administrator can enable auto_apply_rounding_adjustment in Config Settings. The setting is disabled by default.

When disabled, the payment pages retain the manual behavior described in How Apply Works. Existing write-offs are never automatically changed.

When enabled, the page automatically manages one rounding write-off while you keep the current payment edit page open. The automatic behavior applies to both payment edit pages.

What the page does

After the page calculates a qualifying, non-zero Rounding Adjustment, it:

  1. Creates one write-off using the page's current default write-off GL account and selected cost center.
  2. Marks that row as Auto Rounding Adjustment and provides a helper tip explaining its behavior.
  3. Includes the row in Raw Applied Total. Once the row balances the payment, the displayed Rounding Adjustment becomes `$0.00`.
  4. Updates the same marked row, instead of adding another row, when a later calculation produces a different adjustment.
  5. Removes only that marked row if the underlying adjustment becomes `$0.00`.

The system waits for each automatic create, update, or delete to finish before processing the next one. Rapid changes to Apply amounts or Payment Value therefore settle on one row and the final calculated adjustment, rather than creating duplicate rounding write-offs.

What remains editable

The marked write-off is still a normal editable row. You may change its:

  • Amount
  • GL account
  • Cost center
  • Skip Cost Center setting

The next rounding calculation replaces a manual change to the row's amount with the newly calculated rounding adjustment. It preserves your GL account, cost center, and Skip Cost Center choices.

For example, you may choose a different permitted rounding GL account before changing an invoice Apply amount. The page updates the marked row's amount for the new residual, but retains the GL account you selected.

Delete or restore the automatic row

If you delete the row marked Auto Rounding Adjustment, the page does not recreate it during the rest of that browser-page session. This gives you a way to take over the balancing decision manually.

After deleting the row:

  • The Rounding Adjustment becomes visible again if a residual remains.
  • Payment Complete remains unavailable until the payment balances.
  • Further recalculations do not recreate the automatic row.

Click Apply next to Rounding Adjustment to clear that session-only dismissal. If a qualifying non-zero adjustment remains, the page creates or resumes maintaining one marked automatic row.

Session scope and refresh behavior

The automatic marker and its management state exist only while the page remains open. No database field is added to identify an automatic row.

If you reload the page, navigate away, or open the payment in a new tab, a write-off created by the prior session remains saved but is treated as an ordinary write-off. It is not marked automatic and will not be modified by later automatic recalculations. If a new qualifying residual is calculated, the current page session can create one new marked automatic row.

Automatic-operation errors

If the page cannot create, update, or remove the marked write-off, it shows an error in the existing Write Off/Charges message area. The page continues to show the remaining imbalance and does not treat the payment as balanced. Resolve the accounting setup or write-off error, then reload the page or use Apply as appropriate.

Why the Feature Exists

Invoices can contain more decimal places than are displayed in the payment screen. For example, an invoice may display as `$441.98` while its exact unpaid balance is `441.9783`.

If you enter the displayed amount of `$441.98`, the payment and invoice are visibly aligned but differ by `-$0.0017` at full precision. Without a write-off, that residual can prevent the payment from being completed cleanly or leave a small balance behind.

The rounding adjustment makes that difference visible and gives you a controlled way to offset it.

Key Concepts

Displayed amounts and raw amounts

Displayed amounts use your currency precision, usually two decimal places. Raw amounts preserve the exact stored calculation.

For a full invoice payoff, the system recognizes that the entered Apply amount matches the displayed rounded invoice balance. It then uses the invoice's raw balance in Raw Applied Total.

Example:

Invoice Value: $441.98

Raw invoice balance: 441.9783

Entered Apply amount: $441.98

Raw Applied Total: $441.9783

This is expected. It means the system is treating the invoice as a full payoff, not a partial application.

Full payoffs and partial applications

For a full payoff, Raw Applied Total uses the invoice's exact remaining balance.

For a partial application, Raw Applied Total uses the amount you entered. For example, if an invoice's raw balance is `441.9783` and you enter `$100.00` in Apply, Raw Applied Total is `$100.00`. No rounding adjustment is created merely because the invoice itself has extra decimal places.

Signed rounding adjustments

The adjustment is calculated as:

Raw Applied Total − Payment Value

For the example above:

441.9783 − 441.98 = -0.0017

A negative adjustment means the entered payment is slightly greater than the exact applied total. A positive adjustment means it is slightly less. The system preserves the sign when it adds the write-off.

Complete a Payment with a Rounding Adjustment

Example: invoice raw balance of 441.9783

1. Open the active A/R payment.

2. Include the invoice.

3. In the invoice's Apply field, enter the displayed balance: $441.98.

4. Click or tab away from the Apply field to commit the value.

5. Enter $441.98 in Payment Value.

6. Click or tab away from Payment Value to commit the change.

7. Confirm the following values:

Raw Applied Total: $441.9783

Rounding Adjustment: -$0.0017

  1. Confirm that Payment Complete is disabled and the rounding adjustment Apply button is enabled.
  2. If automatic rounding write-offs are disabled, click Apply next to Rounding Adjustment. If they are enabled, the marked row should normally already have been created and the displayed Rounding Adjustment should be `$0.00`.
  3. Review the write-off/charge added by the system. It uses the signed raw adjustment and may contain more decimal places than the currency's normal display precision.
  4. Confirm that the payment totals balance and Payment Complete is enabled.
  5. Click Update to save the payment, then click Payment Complete.

How Apply Works

Selecting Apply resolves the small precision difference without changing Payment Value. With automatic rounding write-offs enabled, Apply is also the way to resume automatic management after you deleted the marked row in the current page session.

  1. If needed, it changes the invoice application behind the scenes to the invoice's exact raw balance. This prevents an overpayment caused by applying the displayed rounded amount.
  2. It adds a write-off/charge equal to the rounding adjustment so the payment balances exactly.

For example, if Payment Value is `$441.98` and the invoice's exact balance is `441.9783`, Apply retains the `$441.98` payment, applies `441.9783` to the invoice, and adds a `-$0.0017` write-off/charge.

Review the added write-off before completing the payment. Your organization may require a specific GL account, cost center, or location for write-offs.

Completion Safeguards

  • Payment Complete remains unavailable when payment totals do not balance.
  • Payment Complete is also disabled while a non-zero rounding adjustment remains unbalanced. An enabled automatic setting normally clears that condition after its write-off operation succeeds.

These safeguards prevent a small rounding difference from being silently ignored. They do not prevent normal partial payments; a partial payment must still follow the standard A/R payment workflow and balance normally.

Common Tasks

Check whether a difference is a rounding adjustment

Use the rounding workflow when all of the following are true:

1. Payment Value matches the displayed rounded total.

2. Raw Applied Total differs only by a small fraction of a currency unit.

3. The invoice is being paid in full.

If Payment Value differs materially from Raw Applied Total, review the included invoices, Apply amounts, discounts, unapplied cash, credit memos, and write-offs. That is a balancing issue, not a rounding adjustment.

Use a partial payment

1. Include the invoice.

2. Enter the partial amount in Apply.

3. Click or tab away from the field.

4. Set Payment Value to the same partial amount, accounting for any normal charges, discounts, credit memos, or unapplied cash.

5. Complete the payment through the standard workflow.

Raw Applied Total should use the partial amount entered. A rounding adjustment should remain $0.00 unless there is a genuine full-payoff precision difference.

Review an existing or closed payment

Raw Applied Total and Rounding Adjustment remain visible for review on active and closed payments. The Apply button is available only while the payment is active.

Troubleshooting

Payment Complete is disabled

Symptoms: Payment Complete is unavailable, and the page shows a non-zero Rounding Adjustment.

Resolution: Click Apply next to Rounding Adjustment, review the added write-off, save the payment, and confirm the totals balance.

If automatic rounding write-offs are enabled, first confirm that the marked row was created successfully. If it was deleted, click Apply to restore automatic management for the current page session. If the Write Off/Charges area contains an error, correct the listed GL account, cost center, location, or permission issue before continuing.

If the adjustment is much larger than a small fraction of a cent, do not apply it. Review the payment applications instead.

Raw Applied Total shows the invoice raw value after entering the displayed full balance

Symptoms: You enter $441.98, but Raw Applied Total shows $441.9783.

Resolution: This is expected for a full payoff. The system uses the exact invoice balance so it can calculate the required rounding adjustment.

Raw Applied Total does not update while typing

Symptoms: The value remains unchanged while the cursor is still in Payment Value or Apply.

Resolution: Click or tab away from the field. The payment screen recalculates after the field change is committed.

No rounding adjustment appears

Symptoms: Rounding Adjustment is $0.00 or Apply is disabled.

Resolution: Confirm that the payment is a full payoff and that Payment Value equals the displayed rounded Raw Applied Total. A partial payment or a larger mismatch does not qualify as a rounding adjustment.

The write-off cannot be saved

Symptoms: Applying the adjustment adds a write-off, but Update or Payment Complete shows an error.

Resolution: Complete any required GL account, cost center, or location fields for the write-off, then save again. Contact your accounting administrator if you do not know which accounting values to use.

Frequently Asked Questions

Does this change the amount received from the customer?

No. Payment Value remains the payment amount you entered. The adjustment records the small accounting difference needed to reconcile the exact invoice balance.

What is the Auto Rounding Adjustment label?

It identifies the one write-off that the currently open page created to balance a calculated rounding residual. The label is not saved. After a reload, that saved write-off is treated as a normal write-off.

Can I edit the automatic write-off?

Yes. You can edit its amount, GL account, cost center, and Skip Cost Center setting. The next rounding calculation replaces a manual amount edit, but retains the other accounting selections.

Why did the automatic write-off disappear?

The page removes its marked row when the underlying rounding adjustment becomes zero. It removes only the current session's marked row; it does not remove ordinary write-offs.

Why did the automatic write-off not come back after I deleted it?

Deleting the marked row disables automatic management for the rest of the current page session. Click Apply to restore it, or reload the page to start a new session.

Will enabling the setting modify existing write-offs?

No. Existing saved write-offs remain unchanged. The setting only manages the one row created by the current open edit page.

Should I use this for a $5.00 difference?

No. Investigate a difference of that size as a normal payment-balancing issue. Rounding Adjustment is intended for small precision residuals.

Why is the adjustment negative?

A negative value means the entered Payment Value is slightly greater than Raw Applied Total. A positive value means it is slightly less.

Can I complete the payment without applying the adjustment?

No. A non-zero rounding adjustment disables Payment Complete until it is applied or the underlying payment entries are corrected.

Does the feature work with credit memos, unapplied cash, and write-offs?

Yes. Raw Applied Total accounts for those components when calculating the payment's net raw total.

Related Information

  • Contact your accounting administrator for your organization's write-off GL account, cost-center, and location requirements.