Company Copy v1.5

Administrator

Company Copy v1.5
Copy data between companies in your database comfortably with this cutie made for Navision 3.70 (and higher).

http://www.mibuso.com/dlinfo.asp?FileID=275

Discuss this download here.

Anonymous

When a record variable from another table is used in the onvalidate trigger, the record will be one from the company which is open. Tricky or the meaning ??

Anonymous

Yes, when you validate a field and in this validate records are used as variable, then these records are from the company that is active.

This is a Navision thingy.

You can use company copy from every company in your database. I recommend running CompanyCopy in the company you are coping to.

Thx for your feedback!

zoechiang

Hi,

Whenever I copy the data by choosing some specific fields, other fields of data I didn't choose will be lost.

Can I keep the original value if I didn't select the field to copy
:-k

imurphy

I think I've found a small bug.

While copying several tables one after another Nav displayed an error saying that RECORDREF had to be closed before it could be used again. After spending a little time stepping through the code I added the three closes shown in the code below to the copydata function to the Copy Company Managemente CU. After this there were no problems.

  END ELSE BEGIN
    NumOfRecsSkipped := NumOfRecsSkipped + GetNumOfRecs(Template."From Company",Table."Table No.");
    Window.UPDATE(6,NumOfRecsSkipped);
  END;
  FromTable.CLOSE;
  ToTable.CLOSE;
  ToTable2.CLOSE;
UNTIL Table.NEXT = 0;

MESSAGE(Text005,Template."From Company",Template."To Company",NumOfRecsCreated,NumOfRecsModified,NumOfRecsSkipped);

kmaiers012

Is there a way that I am not seeing to put parameters as to what data I would like to grab? I only see a way to pull everything.

Thanks for you help,
Kim

kriki

If you are on SQL, you can also check this: http://www.mibuso.com/dlinfo.asp?FileID=1171.
It generates a SQL script in which you can always put some where-statements.