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.
Any luck experts?
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.
Thanks much for your reply.
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.
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?
Macro take dates in 3/29/2010; it should be okay.
I mean 3292010.
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.
It's my bad I check my FA macros it goes with mmddyyyy format i.e. 03292010.