x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 4 replies
  • Subscribers 102 subscribers
  • Views 1406 views
  • Users 0 members are here
Browse Forums
Announcements
271
topics
260
replies
Databases and Operating Systems
771
topics
2k
replies
Financials Suite
1k
topics
3k
replies
General Discussion
2k
topics
10k
replies
Operational Suite
855
topics
2k
replies
Reporting and Analytics
1k
topics
3k
replies
Reports, Macros, and Customizations
879
topics
3k
replies
Sage CRM for Sage 300
184
topics
415
replies
MoreLikeRage300

Good Template for Importing Files into "Asset Management - Asset Acquisition"

Posted By

Merry Christmas Everybody,

Before I left my office for Christmas Eve Thursday night, I was struggling with the very clumsy and unwieldy asset acquisition data entry process of the norming asset management module of our Sage 300 system. I had noticed and thought about changing the whole process to Excel file importing. Does anyone have any good template for that and would like to share or give some guidance? I have no problem building one myself, but I am just curious if there are already some really handy ones out there.

Thanks in advance.

Kindest regards,

Alex

Parents
  • 0

    Hi Alex,

    Merry Chrisetmas.  You can create an acquisition entry firstly, then export it, and then maintain ASSETNO field with ***NEW***, then you can use it to import into Acquisition, new asset ID will be generated.

    Please tell me what's your acquisition code with, for GL, AP, IC, PJC? Then I can create a sample template to you.

  • 0 in reply to lika

    Hi Lika,

    Sorry I noticed it this late. Our acquisition code is GLJE. Hope you can still enlighten me on this.

    I had some initial success already but I still find the data entry quite cumbersome and I am trying to use formulas and an additional data entry tab to make things much easier and faster.

    Regards,

    Alex

Reply
  • 0 in reply to lika

    Hi Lika,

    Sorry I noticed it this late. Our acquisition code is GLJE. Hope you can still enlighten me on this.

    I had some initial success already but I still find the data entry quite cumbersome and I am trying to use formulas and an additional data entry tab to make things much easier and faster.

    Regards,

    Alex

Children

*Community Hub is the new name for Sage City