Import Fixed Assets Books information

This question is not answered

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/
All Replies
  • Any luck experts?

    Thanks

    Sandip

    Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
  • 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.

  • Theresa,

    Thanks much for your reply.

    Appreciate.

    Tks

    Sandip

    Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
  • 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.

  • 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

  • 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/
  • I mean 3292010.

    Thanks

    Thanks Sandip Jadhav Cell : +1.210.440.9855 Dynamics GP Blog : http://sandipdjadhav.blogspot.com/
  • 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

  • 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/