Microsoft Dynamics AX (Archived)

Voucher transaction

(0) Share

Report

Posted on by lally

Hi ,

When we click on the voucher transactions two fields are Amount in transaction and amount .

Amount in transaction / Amount will contain the negative amount or positive amount.

Example : Currenty system shows as mentioned below

Amount in transaction Amount

-100 -100

300 300

-800 -800

My client is asking me there should be fields like Debit and credit field ( like how we have the Financial journals) , instead of amount shows with negative symbol in the Amount in transaction / Amount fields.

Client expects :

Debit Credit

100

300

800

In AX 2012 do we have those fields ?

What is the table name ?

What is the base table for the voucher transactions form ?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Consider validating following table which keeps the voucher transaction

Table

GeneralJournalAccountEntry

GeneralJournalAccountEntry_W

GeneralJournalAccountEntryDimension

GeneralJournalAccountEntryHash

GeneralJournalAccountEntryHashLink

GeneralJournalAccountEntryTmp

GeneralJournalAccountEntryZakat_SA

GeneralJournalEntry

GeneralJournalEntry_W

GeneralJournalEntryTmp

GeneralJournalLedgerVoucherView_CN

View

GeneralJournalCube

GeneralJournalSubledgerVoucher

Please verify.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,982 Super User 2025 Season 2 on at

Like (0)

Report

Hi Lally,

There are two main base tables on the Voucher transactions form (nothe that also other tables are used):

- GeneralJournalEntry

- GeneralJournalAccountEntry

The first table contains fields that apply for all account entries.

The AccountEntry table contains three amount fields (Accounting, Reporting and Transaction currency).

These fields contain negative and positive amounts.

It is possible to create display methods to show separate fields for debit and credit. When the customer is asking for it shoud.... it is there wish. If you start creating this, they would want to have it everywhere?

So be careful...

Maybe bettter to explain how this form works and find another solution for reporting? Perhaps there is a business reason to have it on this form I'm not aware of.

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report

Thank you for the reply Andre ,

So You mean to say that there are no standard fields of Debit , credit in the above mentioned tables .

If i want to show the Debit amount , credit amount in the voucher transactions form , how to show ?

Could you guide me ?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,982 Super User 2025 Season 2 on at

Like (0)

Report

Hi Lally,

I noticed there are already display methods for the debit and credit amounts. It is related to localizations in Russia and China.

You can take these as samples or enable the country features related to these funcitonality.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello,

For the criteria for voucher transaction are you able to do an 'Or Statement'?

Also in the criteria for voucher transaction how to do pull actual vs budget information?

Thanks!

Meghan

Was this reply helpful? Yes No