Customer settlement creates unwanted ledger transactions in Ax 2012

(0) Share

Report

Posted on by Claus Jensen

155

We have a situation where the settlement of an invoice results in the posting of ledger transactions.

We are unable to reproduce in our testenvironment, and are unable to find any differences in the parameters for customer or ledger.

All transactions are in the same currency.

In the example we have an invoice of 5.000 DKK, posted on the 18. of august. When we receive payment on the 18. of september for this we settle it in the payment journal. When doing this the following customer transactions are created (including original invoice):

Voucher - Transaction type - Date - Invoice - Amount

431505 - Customer - 18/08/2013 - 431505 - (5.000)

DEBB008041 - Settlement - 18/09/2013 431505 - (-5000)

DEBB008041 - Settlement - 18/09/2013 431505 - (5000)

DFIK002815 - <blank> - 18/09/2013 431505 - (-5000)

The two transactions in the middle are the strange ones. The vouchers in question are the Payment Voucher number sequence.

There is a difference in Dimension on the the middle vouchers.

The ledger transactions created by the two middle transactions are as follows:

Voucher - Date - Ledger account - Amount

DEBB008041 - 18/09/2013 - (12210-71065-1300-1860) - (-5.000)

DEBB008041 - 18/09/2013 - (12210----) - (5.000)

The are posted on the same account, but the dimension is another.

I am not sure if this has anything to say.

Hope someone can guide me in the right direction.

Kind regards

Martin Hellerup Madsen

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Sort by

Suggested answer

André Arnaud de Cal... 305,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

I think the cause is indeed the dimensions. Can you check if dimensions are used on the invoice voucher for the customer balance?

When the dimensions at the payment transaciton is different, it will create these additional lines.

You can change the account structures where the customer balance account will have no dimensions.

You can also set fixed dimensions on the main account of this customer balance. (Enable fixed and leave the dimension empty).

The last option is only possible as from AX2012 R2 and a certain Cumulative update for AX 2012 RTM. Forgot if it was CU4 or CU5.

Was this reply helpful? Yes No
Emma Husberg 100 on at

Like (0)

Report
Copy link

Link copied!

Hi André!

I have another related problem.... We use different accounting dimensions on har customer balance ledger account and of course want the customer settlement in the same way. This works fin on free-text invoices but not on sales order invoices. Why is there a difference here??? Grateful for any suggestions... BR, Emma

Was this reply helpful? Yes No
Suggested answer

Kumar Gaurav @ MS on at

Like (0)

Report
Copy link

Link copied!

Your free text invoice header get's initiated with customer dimensions, where as for the payment and settlement that's not the case. You can specify it on your payment journal line manually to match it with customer (Lines-> Financial Dimension -> Account ) and the additional transactions will be taken care of.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Emma,

Can you ceeate a new thread and explain more in detail on your problem? I don't understand your question. E.g. What is the difference you have noticed?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Audre,

I have the same problem as described above by Martin. When I settle a customer invoice with a payment, AX2012 creates additional vouchers.

I set the customer balance account (Trade Receivables) as "fixed" and "blank" as you suggested but the issue remains. AX2012 still creates additional vouchers with a blank cost centre for those additional vouchers.

Do you have any other suggestion to resolve this problem?

Thanks.

Sarita

Was this reply helpful? Yes No
André Arnaud de Cal... 305,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI Sarita,

You are not telling all details. Are there currently unsettled customer transactions where the customer transaction has one or more dimensions? If you try to settle them after you changed the "fixed" setting on the main account, this will not help.

It creates two lines during the settlement. What is the dimension used on the first and the second line?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Thank you for your swift response.

I am testing this in AX2012 R2 CU7 for one of our clients who have reported this issue.

The customer invoice I tried to settle was posted after I changed the dimension setup to "fixed" as per your suggestion.

This is the replication steps:

1. I set the cost centre dimension as "fixed" while leaving the dimension value blank for the Trade Receivable (Customer Balance) account

2. I posted a Free Text Invoice to cost centre AAA (for example). I checked the voucher for this transaction and this how the posting occurred:

+$100 to Trade Receivable (Customer balance) account --> Cost centre is blank

-$100 to Offset Main account --> Cost centre = AAA

3. Using the receipt journal, I selected the invoice from point 2 above for settlement. I entered a cost centre for the Account as well as Offset Account in the receipt journal. This creates additional vouchers for the Trade Receivable account as follows:

+$100 to Trade receivable --> Cost centre is blank

-$100 to Trade receivable --> Cost centre is blank

So the additional vouchers are posted when the user enters a dimension in the receipt journal for the account, even if the dimension is set as "fixed & blank" for the customer balance account.

Have I wrongly followed your suggested solution?

Sarita

Was this reply helpful? Yes No
André Arnaud de Cal... 305,561 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Sarita,

Are there any other differences between the +100 and -100 lines? Is the dimension CostCenter on the CustTrans table filled with the value 'AAA'?

Was this reply helpful? Yes No
Anna Jaszczur 25 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I have the same problem with extra settlement transaction in AX 2012 R3 CU 11.

I have the same posting profile on both transaction.

I have enabled Cost centre dimension in the account structures for all accounts.

I have set the cost centre dimension as "fixed" while leaving the dimension value blank for the Customer Balance account. That is very important in this proces.

I set up Cost centre „590”on Customer account.

I do free text invoice to my Customer and in header i have Cost centre „590”. When i look to Subledger journal the Cost Center is blank for Customer balance. Is good and i post the invoice. When I look the transaction posted on Customer i see the Cost center dimension „590”. When i look the Voucher i see the dimension is blank.

Next i register the payment in General journal. When i will choose my Customer default dimension for Cost center will be „590”for him. When i post the journal the Cost center will be blank on Customer balans account. In Customer transaction i see the Cost Center „590” but in Voucher is blank.

When I settlement the both transaction i will have extra settlement transaction. I ask why?

I know the system checks the dimensions from Customer transactions with Subledger journal dimencion if it occurs. Why that is happening? Why dont checked dimensions from Voucher?

I think it’s a bug or I’m wrong? Maybe there is a parameter for this?

Was this reply helpful? Yes No
CapsLock 1,419 on at

Like (0)

Report
Copy link

Link copied!

Did this get responded at any point?? I have the same scenario. I get two lines of settlement that both post against the customer ledger account. They are unnecessary for me, I would like to know if that is a parameter or what. It's happening in a French company, maybe it's part of the localization for that country?

Was this reply helpful? Yes No