AX 2012 - Payment Journal Entry with Fee charges

(0) Share

Report

Posted on by Junaid Idrees

Dears,

Customer Invoice :1000

Payment: 1000 but 20 is charges deducted by Bank. I wan't customer to bear this charges. Currently system is making following entry:

Bank DR 1000

A/R 1000

Bank Charges DR 50

BANK CR 50

i want the following:

Bank DR 950

Bank Charges DR 50

A/R CR 1000

Even though i put payment fee setup charges on "CUSTOMER LEVEL" but i guess it is not working... Any suggestion please.

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (0)

Praveen 1,201 on at

Like (0)

Report

Junaid, by your explanation, total's for the GL accounts in AX is already correct.

Bank DR 1000-50 = 950

A/R CR 1000

Bank Charges DR 50

Was this reply helpful? Yes No
Caryn Axelrad 220 on at

Like (0)

Report

Agree with Praveen, it is already doing what you said you wanted.

I'm wondering, are you really asking for the customer to bear the charge and so therefore you don't want AR to decrease by the 1000, but only by 950 so you still show AR of the $50 charge? You are perhaps looking for this to happen:

Bank DR = 950

A/R CR = 950

- this would leave the 50 charge still outstanding in A/R.

OR somthing like:

Bank DR = 1000

A/R CR = 1000

(for the payment)

plus:

A/R DR = 50

Bank Fees charged to customers CR = 50

Bank Charges DR = 50

Bank CR = 50

(to record the charge, and then turn around and charge your customer for it)

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Dear Praveen,

Thx you for the response. AX is not making the following entry & I want system to make it:

Bank DR 1000-50 = 950

A/R CR 1000

Bank Charges DR 50

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Dear Caryn Axelrad:

Yes i want customer to bear the charges & same entry which you mentioned above :)

DR: Bank with 950

DR: Bank Charges 50

CR: Customer 1000

OR

Compound Entry:

DR: Bank 950

CR: Customer 950

DR: Bank Charges 50

CR: Customer 50

Can you kindly elaborate the same how can i achieve this (Steps).

Thank you Both. Thank yo so much.

Regards

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Guys,

Any suggestion regarding the subject?? Please Help

Appreciated.

Was this reply helpful? Yes No
640579632b5c4e6780a... 4,730 on at

Like (0)

Report

Go to Payment Fee tab and click on view details for Fee Id.

On the Payment Fee setup the payment fee setup

Doing this will make the customer fee work

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

Dear Huzaifa,

I want system to generate the above entry "Please refer last POST on the same"

Secondly, system is not allowing to select customer ID from Payment fee tab. Even though Account type is customer but Account ID is empty ??? I want to make sure, Is it application bug or Am i missing any setup.

Thank you.

Was this reply helpful? Yes No
Suggested answer

640579632b5c4e6780a... 4,730 on at

Like (0)

Report

S5164.6.JPG"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/33/7536.1.JPG" border="0" />

Step 2:

Step 3:

Step 4: results after posting

Was this reply helpful? Yes No
Junaid Idrees on at

Like (0)

Report

D3617.4.png"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/33/1538.1.png" border="0" />

Screen 02:

Screen 03:

Screen 04:

Was this reply helpful? Yes No
Suggested answer

640579632b5c4e6780a... 4,730 on at

Like (0)

Report

When I save Journal line it defaults fee line.

As work around you can type the customer number that will work too.

Was this reply helpful? Yes No