Microsoft Dynamics AX (Archived)

how to track automatic journal posting in ledger

(0) Share

Report

Posted on by Community Member

Hi all

I have ax 2012

I want to know how to track some transaction (automatic journal by system) in any ledger

for example I have open account transaction and found "Inventory, inventory loss" that system posted automatically

I want to know this journal came from what ?

how can I know ?

I have Journal number & voucher number but I don't know this number for what ?

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you open the voucher then you can drill down to the source document that will open the journal where the transaction was created.

Best regards

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig

I didn't get the exactly information but it's help for now

another question

In quality order there's a Destructive Test check if we check the quantity will deleted from warehouse

but in financial this quantity have value and it's posting to account that we selected in posting "Inventory, inventory loss"

also if i make inventory closing the different will be in the same account right ?

so can i make "Destructive Test" posting to another account ?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

That's right that the destructive tests and the adjustments that are posted during inventory close use the same inventory loss account. Do you have the chance to specify a separate financial dimension while doing the destructive test? That's the only chance you have to separate those posting from a financial perspective. If that's not possible you would have to make use of BI tools for your analysis.

Best regards

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Dr.

it's not possible to make it as financial dimension so How can i use BI tools ?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Abdalrahman Mohammed,

Yeah, I would say that you need BI tools for this analysis.

Not sure if the standard cubes provide this level of detail.

So, please check them and if required enhance them.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hello Dr

BI tools is not helpful

however about inventory lose only destructive test accounting on it or there's another process use inventory lose account ?

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

Like (0)

Report
Copy link

Link copied!

Hi Abdalrahman Mohammed,

the inventory loss account is used for a number of transactions, such as for posting inventory adjustment and inventory counting journals. Also the inventory closing process makes use of it. So, there is a mix of different transactions recorded on those accounts.

I think you best option to separate those costs is the use of a financial dimension that can be specified in the respective tab of the quality order. Other than that you only have the BI option or the option to track those costs/transactions outside of the system.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig

Can you please provide me more details about BI ? what is it ? how can it work on it ?

how to change posting on it ?

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

Like (0)

Report
Copy link

Link copied!

Hi Abdalrahman Mohammed,

You can either use Power BI or the AX2012 Standard cubes.

Information on Power BI can be found here: powerbi.microsoft.com/en-us

Some info on the AX2012 Standard cubes can be found on TechNet. For details, please see: technet.microsoft.com/.../dd309683.aspx

Best regards,

Ludwig

Was this reply helpful? Yes No
lally 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Can you give some light on what is this destructive test and why it would post to inventory loss account ? How inventory closing process effect on this inventory loss account ?

Thanks !

Was this reply helpful? Yes No