How to get Main account type of Main Account in x++

(0) Share

Report

Posted on by Rana Anees

1,813

Hii,

I am developing RDP report from LedgerJournalTrans table. The requirement is to select transactions of Main account type Profit and Loss and other report for Balance Sheet accounts from LedgerJournalTrans table with some other criteria.

How to know from (General journal -> Lines) LedgerJournalTrans.LedgerDimension the Main Account is of type Profit and Loss or Balance Sheet in processReport method.

Please some code examples.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Rana Anees 1,813 on at

Like (0)

Report

In the following while loop where i need to select Main account type

while select ledgerJournalTrans where ledgerJournalTrans.Voucher==voucherNum

{

}

any solution please...

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

help please..

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

Like (0)

Report

Hi Rana Anees,

Why you want to develop a report for this purpose?

Aren't the standard reports and Management Reporter already sufficient?

Best regards,

Ludwig

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Hii Ludwig Reinhard,

You are right, actually we have two new customized fields in LedgerJournalTrans table for vehicle expenses and for reporting purpose only. When we create general journal or payment journal, we select and save those fields based on some scenarios.

I have a report that selects and shows required information and its perfect for our finance dept. But sometimes, our data entry operator mistakenly, selects and saves these new fields with balance sheet accounts while its only for profit and loss accounts.

That's why I need some way to select only Profit and Loss accounts from my RDP class.

Best Regards,

Anees

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Rana Anees,

Please refer to this thread community.dynamics.com/.../152606 discussing how to get main account from ledger dimensions. Having main account you can filter records by type easily.

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

Like (0)

Report

Hi Rana Anees,

Is it still an option for you to use reason codes instead of those added field? They are actually made for this purpose and can be analyzed in Management Reporter out of the box.

If it is already too late, please have a look at the answer of ievgen.

All the best,

Ludwig

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Hii Ludwig Reinhard,

I have one more request from finance to add two more customized fields on general journals and payment journal forms. I will be very happy to understand and use reason codes.

Could you please explain more about reason codes, how and where to use on forms and MR.

Best Regards,

Anees

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

Like (0)

Report

Hi Anees,

You can find some Information about reason codes on the following site:

https://technet.microsoft.com/en-us/library/gg242861.aspx

Once you specify them in a transaction (e.g. Journal) you can filter and report - that is print - them in Management Reporter by making use of row modifiers.

Example:

Reason codes are tracked similar to ledger accounts but users have a higher degree of freedom how, when and where to use them.

Hope this helps.

Best regards,

Ludwig

Was this reply helpful? Yes No
Rana Anees 1,813 on at

Like (0)

Report

Hii Ludwig Reinhard,

About the reason codes, my requirement is we have a report at

AP -> Payment Journal -> a journal -> Lines -> Print -> Bank Local Transfer Report .

This is bank draft request form from a bank where we print info from our ERP.

Our new requirement is to add two new fields (Check Boxes) Transfer and Bank Draft on Payment Journal lines form. The data entry operator will select Transfer and Bank Draft check boxes for a required transaction.

If Transfer or Bank Draft or both are selected, then should be printed on Bank Local Transfer Report.

This report is based on Report Data Provider (RDP).

I think we can select only one reason code for one line, but we need two.

Sir, do you think Reason Codes is the solution for this requirement.

Regards,

Anees

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

Like (0)

Report

Hi Anees,

This requirement cannot be fulfilled with reason codes especially that you can chose only one.

Also the bank local transfer report is not a standard report, so I believe that you might be better off with the solution that you have chosen for the additional new checkboxes.

Best regards,

Ludwig

Was this reply helpful? Yes No