Fixed Assets - Derived Books (OPERATIONS Layer)

(0) Share

Report

Posted on by SU-22040800-0

2,459

I have two fixed asset books. One posting to CURRENT layer (mainbook), and the other to the OPERATIONS layer (globalbook). I want the globalbook to derive from the mainbook, so that when i acquire an asset in mainbook, it acquires in globalbook (in the OPERATIONS layer).

Is this possible?

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

SU-22040800-0 2,459 on at

Like (0)

Report

Just some more information on this:

When I process the product receipt, it creates the (un-acquired) asset master, and posts to two accounts on the CURRENT layer.

When I then process the invoice, i get this error: "Account number for transaction type Fixed assets, credit does not exist."

I'm assuming that the 'credit' it is referring to, is for the OPERATIONS layer.. but I'm not sure why it is not posting anything (even on the product receipt leg of the transaction)

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello James Solomon,

If you make use of the derived book functionality then your requirement can be achieved.

Attached is an example of a book "150_SLLR" that has a couple of other derived books attached.

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Hi Ludwig

Sorry for the late response on this. See below my setups, and my error I'm facing:

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Can you share a screenprint of your fixed asset posting profile?

I am especially interested in the acquisition posting, the value models that have been setup for this transaction type and the ledger accounts that are Setup.

I suppose the offset account for the derived book is missing.

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Hi Ludwig

Is this ok:

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello James,

What you typically have in this form is the following:

1. One line with the leading book CURSTRGT. You can enter a default offset account or enter it manually in the journal.

2. A second line with the derived book OHADASTRGT. For this line you need a main account and an offset account setup.

Can you test such a setup?

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Thanks Ludwig

Tested and working!

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Hi Ludwig

Thanks for the answers.

Do you know if it's possible to process it to the same accounts as the CURSTRGT book? (i.e. credit the Creditors Control account)

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello James,

For the derived books I usually see companies using separate accounts.

This makes the identification and reconciliation easier.

However, as you use posting layers, you can of course also use the same accounts that you use for the current layer.

Before implementing this in your live system do some test postings and run some financial reports for your accountants to familiarize them with the way how and to which accounts AX posts.

Otherwise, they might have difficulties doing their month end closing and reconciliation jobs.

Hope this helps.

Best regards,

Ludwig

Was this reply helpful? Yes No
SU-22040800-0 2,459 on at

Like (0)

Report

Thanks. Will do so.

Was this reply helpful? Yes No