18,267
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
*This post is locked for comments
It's my bad I check my FA macros it goes with mmddyyyy format i.e. 03292010.
Thanks
Sandip
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
I mean 3292010.
Thanks
Macro take dates in 3/29/2010; it should be okay.
THanks
Sandip
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
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.
Theresa,
Thanks much for your reply.
Appreciate.
Tks
Sandip
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.
Any luck experts?
Thanks
Sandip
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
