Move invoices from one vendor to another under different Companies

(0) Share

Report

Posted on by Community Member

Hi Experts,

I have a vendor VEND01 in my company DAT. I have certain transactions associated to that vendor.

Now i realized that i have created the vendor under the wrong company and it had to be under CONTOSO (custom company in AX). I have invoices against this Vendor and i dont want to re enter them because of the sheer volume.

Is there any way to transfer these invoices as well as the user from DAT to CONTOSO?

I am willing to create another vendor in CONTOSO company and transfer the invoices to him, if that is possible.

This might be a very silly question and not possible at all but because i have never done this before so thought would get expert advice.

Any advice is much appreciated.

Thanks! :)

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

even, if we think to change party association, the issue is; invoices are created under DataAreaId=Dat

Since financially, invoices reside in DAT, changing party association can not worth much here.

Are those invoices posted or just created ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Those invoices were posted earlier but i have reversed them.

That is the main issue as i understand it because the invoices were created under DAT, AX might not allow it to be moved to CONTOSO.

Was this reply helpful? Yes No
advent77 250 on at

Like (0)

Report

I recently completed a migration of "Open" Purchase and Sales Ledger Invoices using the Import/Export Framework DIEF. The import was for all outstanding invoices. However it was in summary (no line info). This might be a possible solution if you have a huge volume. But you will only get a single invoice (no lines) for each invoice. This also means a single main account and related dimensions for each invoice.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

my mind is also suggesting something as following

1) take data/invoices from DAT and import those in other companies

2) run SysDataBaseTransDelet on DAT

3) block users to access DAT

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Advent,

It was not a huge volume - 10 invoices with an average of 5 lines each.

I just didnt want to go through the whole process of entering them again. Also, i need the line summary as well.

Thank you so much for your suggestion :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I just decided to re enter them.

Maybe i will try this in my test environment with one of the invoices to see what happens. :)

Was this reply helpful? Yes No
advent77 250 on at

Like (0)

Report

Glad you got it sorted. Just let me know if you need any assistance with the DIEF template. :)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Nidhi,

You can use 'Copy entity data between companies' option under DIEF to coy data from DAT to Contoso.

Later you can delete the transactions in DAT using sysdatabasetransdelete

Was this reply helpful? Yes No