Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Inventory Items data entry excel template?

Posted on by Microsoft Employee

Is there a set template for excel for Inventory Items? I would like to be able to enter the data in excel over time, then copy and paste it into inventory items. Is this possible? 

  • Apps Mexico Profile Picture
    Apps Mexico 1,090 on at
    RE: Inventory Items data entry excel template?

    Hi, if you whis we can develop an excel file that do all that you need without TI, just executing a store procedure.

    Basically is the excel file that you already have, and we just add the execution to the store procedure.

    If you're interested let me know.

  • CFROTON Profile Picture
    CFROTON 4,710 on at
    RE: Inventory Items data entry excel template?

    Good day -

    Thank you for posting your question on the forum.

    Typically when sites copy from a spreadsheet into a SL screen, it is to populate a grid, not the data fields as seen in the Inventory Item screen. To bring data into a screen like this we suggest using Transaction Import (TI).

    www.bing.com/.../search;view=detail&mid=34540E14DBC5AC819F5334540E14DBC5AC819F53&FORM=VIRE

    TI is a tool available in all versions of SL and without special registration/unlocking keys. TI can be found under the Administration menu group. Below is a link to a video on this tool. you can also find information on TI in the System Manager User Guide.  User Guides are typically installed on your SL application server in a folder similar to the following:

    ...\Microsoft Dynamics\SL\Applications\User Guides\SystemManager.pdf

    By using TI, you can update a comma delimited file (Excel) that can be manually updated, then import as needed into SL.

    I hope this is what you were looking for.

    Thank you

    Carolyn

    MSDSL Support Engineer

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans