Question Status

Unanswered
Sandip Jadhav asked a question on 14 Jul 2011 8:36 AM

Hi,

Is there any way to import FA Books information with Decreciation Sensitve field? I tried almost all source.

Please help me to import FA Books informaiton.

 

Thanks
Sandip

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply
Sandip Jadhav responded on 14 Jul 2011 5:44 PM

Any luck experts?

Thanks

Sandip

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply
Theresa Gulbranson responded on 15 Jul 2011 11:27 AM

Have you reviewed the Fixed Asset Management printable manual (Help button) from within GP? Chapter 7 covers Asset imports and gives you a listing of the fields available for import. (Page 68 in GP2010).

I hope this helps.

Reply
Sandip Jadhav responded on 17 Jul 2011 5:14 PM

Theresa,

Thanks much for your reply.

Appreciate.

Tks

Sandip

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply
Heather Roggeveen responded on 19 Jul 2011 8:21 PM

And if this doesn't do it, you can record macro's on this screen and mail merge the info (that is what the standard import does).  If the data already exists and you are updating a manually recorded macro would be a better option.

Reply
Tony Fernandez responded on 20 Mar 2012 11:30 AM

Heather,  

Hi there I'm tyring to do just that a macro to the general information window but having an issue with the dates, in excel even though it is display as 03/29/2010 when it is converted to the macro vial mail merge it comes as 3292010 and GP does not them gets the date right. ? any sugestions as to what to do?

Tony

Reply
Sandip Jadhav responded on 20 Mar 2012 11:33 AM

Macro take dates in 3/29/2010; it should be okay.

THanks

Sandip

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply
Sandip Jadhav responded on 20 Mar 2012 11:37 AM

I mean 3292010.

Thanks

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply
Heather Roggeveen responded on 20 Mar 2012 12:31 PM

Hi

Sandip - if it drops the leading zero, then it tries to put the date as 32/92/010 which obviously won't work.

Tony - I have had this sort of thing before.  Sometimes when it runs the merge it drops leading zeros.  Trying setting the Excel column up as a text format and have the date displaying as 03292010.  You don't need to have the / in the date.

If you look in the Fixed Assets manual under the Fixed Assets Import Utility, it lists all the fields (this is designed to work with the GP Import Utility) with the format they should be set up in to work.  

Hope this helps.

Cheers

Heather

Reply
Sandip Jadhav responded on 20 Mar 2012 1:36 PM

It's my bad I check my FA macros it goes with mmddyyyy format i.e. 03292010.

Thanks

Sandip

Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
Reply