Customer Transaction Partial Settlement

(0) Share

Report

Posted on by Community Member

Hi All,

I have a question on the customer transaction settlement.

I understand that if the customer Invoice and the settlement payment journal have different financial dimension or posting profile, system will generate 2 additional line in CustTrans with type Settlement(TransType 24).

But I also found scenario with exact same FD and Posting profile, If a payment could not fully settle an invoice (partial settlement), system also generate 2 additional line in CustTrans as settlement type.

Does anyone have an explanation on such behaviour in Ax2012 in term of business understanding? Every finance user we encounter actually asked the same question.

Best Regards,

KerZhi

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello kerzhi, Can you provide some additional details / an example on your issue? I actually tested partial payments with identical and different financial dimensions and could only identify one line in the CustTrans table. In the Amount fields you can identify the invoice amount posted and in the SettleAmount fields you can identify the amount settled from the payment made. Would be great if you could possibly insert some screenprints. Many thanks, Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Above is a sample of custTrans with partial settlement.

We created a new customer for a clean simulation, Invoice and Payment both have the same Financial Dimension.

On the first settlement, there is no seperate settlement record on custTrans, but after we reverse the settlement and re-settle, it create the settlement transaction.

Other scenario we faced, involved import customer opening balance with journal, every payment transaction have settlement line until the accumulate balance is zerorized.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi kerzhi,

In examples I have seen where a customer payment generated additional unwanted customer transactions, it was because the invoice transaction was marked with financial dimension values, but the payment transaction was not.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi kerzhi, I have tried replicating your issue but have not managed to do so. Do you know what steps users follow to record the settlement? E.g. are they recording the settlement in GL/AR? Did you setup automatic settlement in the AR parameters? Have you specified a different posting profile for customer settlements? Best regards, Ludwig

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

I have seen this situation happen when the posting profile of the invoice is different than the posting profile of the payment (even they both point to the same ledger account).

Is it possible this is the case?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi KerZhi,

What Zvika writes seems correct. I replicated the issue and always get two additional posting lines when the posting profile that was used for posting the customer invoice differs from the one that is used when posting the customer payment. Please test it once again yourself and I believe you will be able to replicate the issue.

The question is then why your posting profile differs. The only situation I am familiar with are prepayments that are recorded with a specific posting profile and payed with another posting profile. Might this be the case?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

We have confirmed the Financial Dimension of each transaction is identical and we only have 1 posting profile setup. (This was the initial checking, because we are aware the posting profile and financial dimension can impact the settlement in this result. Attached a posting profile and FD print screen in the original sample post)

According our developer's finding, it seems to have a counter of settlement, once the same voucher is being settle more than once, system will create the extra transaction line.

below is a link more detail of the transaction

community.dynamics.com/.../180381

Was this reply helpful? Yes No
Veronika Filonenko 1,261 on at

Like (0)

Report

I am experiencing the same issue and it looks like i am using to different posting accounts.

Can you please point out the exact settings that i need to check?

thanks

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

Find the original invoice and check was "Posting Profile" was selected on it.

Find the original payment and check what "Posting Profile" was selected on it.

If you have posting into different summary posting accounts, it seems to imply these 2 transactions were posted under different posting profiles.

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

Like (0)

Report

I have the same problem with extra settlement transaction.

I have the same one 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