Dynamics Community Forum Thread Details

Lack of settlement between advance invoice and advance invoice reversal (Advance invoice (Poland))

Hello,

I am using D365 Finance. I started testing advance invoice functionality for Poland for one of our client. At some point everything was working fine. But totally out of blue one day system stopped doing settlement between advance invoice and advance invoice reversal:

It was working some time ago and it is still working in other 2 environments, which have exactly the same setup when it comes to:

-AR parameters

-Customer posting profiles

-Journal names

I tried the same process in all envrionments:

1.Creation of sales order [123PLN]

2.Creation of journal using with one line with ,,Prepayment journal voucher'' marked [61.50 PLN]

3.Settlement of journal with sales order

4.Creation of advance invoice for the same amount as prepayment journal [61.50 PLN]

5.Linking prepayment to advance invoice

6.Generation of invoice for full amount [123 PLN] while marking advance invoice for settlement for its full amount [61.50 PLN]

The result at one particular environment is just as stated above there is lack of settlement between advance invoice and advance invoice reversal after posting of final invoice.

Does anyone experienced similar issue and could provide some hints what might be off?

Best regards, Michal

Categories:

Dynamics 365 Finance

The issue you're facing—where the settlement between the advance invoice and its reversal is not happening in one environment despite identical setups—suggests that something environment-specific is affecting the process. Here are some key troubleshooting steps and solutions to resolve this issue in Dynamics 365 Finance:
1. Check the "Automatic Settlement" Parameter

Go to Accounts Receivable > Setup > Accounts Receivable Parameters.
Navigate to the Settlement tab.
Verify if Automatic Settlement is enabled.
- If disabled, the system may not be automatically settling the advance invoice and its reversal.
- If it’s enabled in the working environments but disabled in the problematic one, enable it and test again.

2. Verify the Settlement Process Manually

Go to Accounts Receivable > Customers > All Customers.
Select the affected customer and navigate to Transactions.
Try manually settling the advance invoice and advance invoice reversal using Customer settlement (AR > Customers > Settle transactions).
If manual settlement works but automatic doesn’t, it’s likely a configuration or process issue.

3. Ensure Correct Posting Profile and Journal Setup

Even though you mentioned that the customer posting profiles and journal names are the same across environments, verify that:
- The Prepayment journal voucher is linked correctly to the posting profile.
- The correct Ledger accounts are used for prepayments.
- The Sales tax setup is identical to working environments.

4. Check Financial Dimensions and Main Accounts

Compare financial dimensions and main accounts used for the advance invoice and its reversal in the working vs. non-working environments.
If financial dimensions are mandatory but missing in one environment, it may prevent automatic settlement.

5. Validate Workflow and Customizations

If you have any customizations in the non-working environment (e.g., extensions modifying settlement behavior), check whether they are affecting the process.
If the issue started suddenly, verify if any recent code deployments or parameter changes were made.

6. Debug by Running the Settlement Process Step-by-Step

Try running the process step-by-step while enabling database logging for settlement-related transactions.
Use Task Recorder to compare the sequence of actions between working and non-working environments.

7. Check for Open Transactions in Customer Settlements

Go to Accounts Receivable > Customers > Settle transactions.
Look for any unsettled transactions related to the advance invoice or its reversal.
If they appear as open, try manually settling them and check if the issue persists for new transactions.

8. Compare System Parameters in All Environments

Use Data Management to export the AR Parameters, Posting Profiles, and Settlement Rules from both a working and non-working environment.
Compare them using Excel or a data comparison tool.

Final Recommendation

Test enabling "Automatic Settlement" if it’s disabled.
Manually settle transactions to confirm if the issue is process-related or system-related.
Compare financial dimensions, ledger postings, and settlement rules across environments.
Check for recent system updates, extensions, or data discrepancies.