Microsoft Dynamics AX (Archived)

vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

(0) Share

Report

Posted on by Lakshmi Karambakkam

1,307

Hi,

I am trying to post a cash discount journal.

For that I have a account structure of Main 520200(Vendor cash discount account) - Dept (all+blank allowed) - Vendor (all + blank allowed)

I posted an AP invoice journal with cash discount amount.

Then I went to payment journal and selected the invoice to be settled (Functions --> Settlements) and posted the payment journal and it got posted.

When I view Payment Journal (lines) --> Inquiries --> Voucher -->Related Voucher --> Voucher (button),

the ledger account field is showing only 520200-- instead of 520200-dept-vendor (00000004)

Payment Journal (lines) --> Buttons --> financial dimensions --> Account is entirely blank.

This is an end user issue and needs to be solved fast.

Any ideas why the system is not throwing an error and simply posting to the main account (520200) alone.

Thanks,

Lakshmi

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (2)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Lakshmi,

Can you double check how you entered your original invoice that you paid? Have you recorded the additional financial dimensions that you require together with the invoice?

I wonder what might be different in your system as it works fine in my demo enviornment. Can you probably provide some additional information on how you setup your discounts and the accounts linked to your discount codes?

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

This is the account structure setup and Cash Discount form

AP Invoice Journal posted

payment posting.:

payment journal --> Functions --> Settlements and selected the invoice and did the posting

After posting when you go to Inquiries --> Voucher --> Related Vouchers (button) --> Voucher (button)

Since cash discount account is set, dept is provided and vendor exist, the cash discount must be posted to 520200-10-0000003 but not 520200--.

if the DAX code is assigning leger account with a value 520200 --, then the system should throw an error. Instead it posting everything.

Do I need to check or set any other parameters ?

Let me know if you need any more info.

Thanks,

Lakshmi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Lakshmi,

You setup looks good to me.

The only thing that I noticed is that you recorded the offset account 110110 for the invocie recording.

What financial dimension have you posted together with this account?

Those financial dimensions will be used when posting your discount.

Can you double check and test again?

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

The offset account type is bank account -Operating.

Are you saying that I have to manually set the offset account to the financial dimensions for which the cash discount has to be posted (i.e. 520200 - 10 -)

Also could you please explain me in a more detailed way about this offset account to understand in a much better way.

Thanks,

Lakshmi

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

I confused and the problem has got side-tracked. Here is the issue.

Main account - dept (no blanks allowed) - vendor (no blanks allowed) is the structure for posting AP Cash discounts.

End user forgot to provide dept and vendor in financial dimensions. So basically the system must throw an error while posting the journal because dept and vendor dimensions are not provided. Instead system posted the journal.

That was the reason for starting this thread. I did realize I provided wrong offset account value to the invoice journal. But even though I provide the correct Cash Discount Main account; as dept and vendor dimensions are not provided system must throw the error rather than posting to 520200 - -. We are able to replicate the error also.

Hope we both understand the problem in the same way. So some where system is not doing the offset account validation properly.

That needs to be rectified.

Thanks,

Lakshmi

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

Just a quick question,

End user from a department (main account -141500) is posting an invoice journal. Since he settled transactions on time, he got a cash discount.

So first end user posted an invoice journal for offset account (141500). Now end user is trying to do settlement using payment journal. Now in this process, system automatically posts cash discount. but where should end user provide the additional financial dimensions of the cash discounts?

Thanks,

lakshmi

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hello Lakshmi,

Unfortuantely, you cannot enter an additional financial dimension directly. The financial dimension used for posting the cash discount depends on the financial dimension recorded with the invoice. If you do not like to have the financial dimension from the invoice or if you forgot to post one with the invoice recording you can fix the financial dimension in your COA at the cash discount account level.

Hope it helps,

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

How to fix the financial dimensions in COA at the cash discount account level? How to setup? What is process? Do you have any related doc for how to post all these different type of journals? Will be very useful if you can provide one.

Thanks,

Lakshmi

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Lakshmi,

Here a short summary:

a) Open your COA and select the main account that you will use for recording your cash discounts

b) Select the company for which you want to fix the financial dimension for (highlighted in yellow in the screen-print below)

c) Select your financial Dimension and select "fixed value" (highlighted in red below).

Hope it helps,

Ludwig

Was this reply helpful? Yes No
Lakshmi Karambakkam 1,307 on at

Like (0)

Report

RE: vendor Cash discount journal is not getting posted to the appropriate financial dimensions but NO errors

Hi Ludwig,

As you know my additional financial dimensions are dept and vendor. I cannot specify vendor here. It has to be taken from the payment journal form (Account field where the vendor account is selected. How can I pre-assign it or how to do a setup in the system so that the system automatically takes it from the vendor specified in the payment journal form?

Thanks,

Lakshmi

Was this reply helpful? Yes No