Fixed Asset Transfer in CU7

Has anyone used the new feature in CU7 for transferring multiple fixed assets? Does it create multiple journals and voucher or just one journal with multiple voucher?

Thanks!!!

Heylin

We don’t have CU7 yet, but if you have no other way of checking - and you (or someone else) has SQL Server rights to the AX database - then you can do the following.

You just set the value for @JournalNum and then click Execute.

DECLARE @JournalNum NVARCHAR(20) = ‘000519_010’

SELECT * FROM LEDGERJOURNALTABLE WHERE JOURNALNUM = @JournalNum

SELECT DEFAULTDIMENSION, TAXITEMGROUP, * FROM LEDGERJOURNALTRANS WHERE JOURNALNUM = @JournalNum ORDER BY LINENUM

SELECT * FROM LEDGERJOURNALTRANS_ASSET WHERE REFRECID IN

(SELECT RECID FROM LEDGERJOURNALTRANS WHERE JOURNALNUM = @JournalNum)

ORDER BY LEDGERJOURNALTRANS_ASSET.RECID

SELECT * FROM GENERALJOURNALENTRY WHERE SUBLEDGERVOUCHER IN

(SELECT VOUCHER FROM LEDGERJOURNALTRANS WHERE JOURNALNUM = @JournalNum)

SELECT * FROM GENERALJOURNALACCOUNTENTRY WHERE GENERALJOURNALENTRY IN

(SELECT RECID FROM GENERALJOURNALENTRY WHERE SUBLEDGERVOUCHER IN

(SELECT VOUCHER FROM LEDGERJOURNALTRANS WHERE JOURNALNUM = @JournalNum))

PS: The T-SQL is not very elegant. It is this way (each table with a separate query, and no joins) for a particular reason that I won’t get into. I just copied and pasted what I had.