Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Transaction Import for...
Microsoft Dynamics SL (Archived)

Transaction Import for Inventory

(0) ShareShare
ReportReport
Posted on by Chris McCoy 782

Okie Doke...I thought I was losing my mind a while back and figured I had made an error with my macro when I was testing this earlier...okay this makes no sense, I will start again.

A few months back, my engineering dept asked if there was a way to set aside a large block of sequential inventory items for a project. I thought about it and decided that a Transaction Import Job that would create the inventory items with a description of "reserved for project 123456" would work. Then as they actually "consumed" the inventory items for the project, they could override the description  and anything else they needed to change.

So I created my intelligent control macro, "commenting out" anything that would be filled in by default values and hard coding any values that I could. I created a test csv file and tried it. the inventory screen promptly crashed with a message from windows that "Inventory Items has stopped working". I went back and reviewed the macro and the csv file and could not figure out what I did wrong.

Fast forward to today...I need to update the default site and pick and put away bins for roughly 500 inventory items. So I turned to TI again. Intelligent Macro, with everything commented out except the part number, the site and the bin locations. Created my data file (multi level) with the "Change" comment added after the level alias, and fed it to TI...pressed start, and it did the same thing. "Inventory Items has stopped working".

Using SL 2011 FP1 with all hotfixes applied (actually did this last night). SQL 2008R2 as the backend...and yes, the inventory screen is customized...but using the intelligent macro, and not actually addressing any of the custom fields (they are commented out).

Any help would be appreciated.

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Transaction Import for Inventory

    Hi Chris,

    One other thing that sometimes makes a difference is the Run Minimized option.  Have you tried unchecking the Run Minimized option and run the import?

    It's hard for me at this point to recommend whether or not you redo your customizations. I'm thinking that if the customizations work fine when using the screen manually, it's your control macro causing it to crash.  Why not leave the customizations alone.  Generate a new control macro while the screen is customized.  Leave it as it is and adjust your data file as I suggested a few responses back to just leave place holders for areas that you are accepting the data as it is.  See if it works.  Then if you want, comment out a few fields at a time to see how it goes.  

  • Chris McCoy Profile Picture
    Chris McCoy 782 on at
    RE: Transaction Import for Inventory

    No Worries Carolyn :-),

    For both the Mass Import of Inventory ID's and the Mass Update of the Inventory Records, both Macros had many fields commented out and all of the custom fields were commented out. So they did not come into play when I chose the "standard" customization level.

    What confuses me, is why the screen crashes when opened by TI, but not when it is opened normally.

    Do you think I should delete all of the customizations on the Inventory Screen and re-customize it?

    Chris

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Transaction Import for Inventory

    Hi Chris,

    I assume you generated the control macro with the customizations in tact.  The system will modify the control macro accordingly.  Then you would need to generate a new control macro if you remove the customizations.  Sorry if I'm suggesting something that you already know.  

  • Chris McCoy Profile Picture
    Chris McCoy 782 on at
    RE: Transaction Import for Inventory

    Carolyn,

    For the mass inventory import for the project, my data file only had one line, and the inventory screen crashed.

    I did some reading on the error windows was throwing for the inventory screen crash, and came to the conclusion that it had something to do with the screen customization. So I decided to try the mass component import macro (only one record on the import) after changing my customization level to standard. It went in without a problem. So I tried the mass update macro and data file the same way, and got the same results, it went in without a problem.

    So...apparently TI and my custom inventory screen do not get along for some reason. The customization on the Inventory Screen are from SL 6.5. Exported prior to the upgrade.

    What I did, after upgrading the db's:

    1. Deleted the customizations using SMS

    2. Imported the customizations using SL

    3. Adjusted them as required to make them fit the screen properly.

    None of the customizations are anything that spectacular. Essentially adding user fields and labels.

    I am wondering if I need to delete the customizations on the Inventory Screen, and start scratch....

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    RE: Transaction Import for Inventory

    Hi Chris,

    I would suggest that you try and update one inventory item instead of having a data file with 500 items in it.  See if your data file and control macro work with just one item.  Also, I have had better luck with leaving the intelligent control macro as it is and having place holders in my data file for those fields I wish to leave with the default value.

    If you get errors on the one item, it is easier to correct your data file and then make that correction to the rest of the items you wish to change.  Also, if it works for that one item, try  then to update 10 or 25 and see if that succeeds.

    Let me know how it goes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans