Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Mass Transfer Inventor...
Microsoft Dynamics GP (Archived)

Mass Transfer Inventory Items

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

User has a spreadsheet with over 1,100 items that need to be transferred from 1 site to another. Is there a way to import/mass transfer the items?

Thanks!

*This post is locked for comments

  • ICH BIN ICH Profile Picture
    ICH BIN ICH 55 on at
    RE: Mass Transfer Inventory Items

    [quote user=""]

    ________________________________________

    # DEXVERSION=11.00.0359.000 2 2

    CheckActiveWin dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry'

    MoveTo field 'Document Date' 
    ActivateWindow dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    TypeTo field 'Document Date' , 'Document Date'
    MoveTo field 'Batch Number' 
    MoveTo field 'Lookup Button 2' 
    ClickHit field 'Lookup Button 2' 
    NewActiveWin dictionary 'default' form 'IV_Batch_Lookup' window 'IV_Batch_Lookup' 
    ActivateWindow dictionary 'default' form 'IV_Batch_Lookup' window 'IV_Batch_Lookup' 
    MoveTo field 'Select Button' 
    ClickHit field 'Select Button' 
    NewActiveWin dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    ActivateWindow dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    TypeTo field '(L) From Default Site' , 'From Location'
    MoveTo field '(L) To Default Site' 
    TypeTo field '(L) To Default Site' , 'To Location'
    TransLinePrepare scrollwin 'IV_Transfer_Scroll' 
    # Key 1: 
    MoveTo line 1 scrollwin 'IV_Transfer_Scroll' field 'Item Number' 
    # Key 1: '0', '', '0.00000'
    TypeTo line 1 scrollwin 'IV_Transfer_Scroll' field 'Item Number' , 'Item Number'
    # Key 1: '0', '', '0.00000'
    MoveTo line 1 scrollwin 'IV_Transfer_Scroll' field 'U Of M' 
    # Key 1: '0', '', '0.00000'
    MoveTo line 1 scrollwin 'IV_Transfer_Scroll' field '(L) TRX QTY' 
    # Key 1: '0', '', '0.00000'
    TypeTo line 1 scrollwin 'IV_Transfer_Scroll' field '(L) TRX QTY' , 'Quantity'
    # Key 1: '0', '', '0.00000'
    MoveTo line 1 scrollwin 'IV_Transfer_Scroll' field 'TRX Location' 
    # Key 1: '0', '', '0.00000'
    MoveTo line 1 scrollwin 'IV_Transfer_Scroll' field 'Transfer To Location' 
    TransLinePrepare scrollwin 'IV_Transfer_Scroll' 
    # Key 1: 
    MoveTo line 2 scrollwin 'IV_Transfer_Scroll' field 'Item Number' 
    MoveTo field 'Save Button' 
    ClickHit field 'Save Button'

    ________________________________________

    2) using the mail merge attach the excel to word

    3) create the bulk macro

    4) start the integration(during the macro integration system remains idle until the process get complete)

    also you can design the macro into two ways

    1) creating unique document number for overall spreadsheet item

    2) creating individual transfer entry for each spreadsheet item

    Regards

    [/quote]

    until the merge everything is working good 

    the problem is that by the merge it copy the top rows as well again and again

    this

    # DEXVERSION=11.00.0359.000 2 2

    CheckActiveWin dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry'

    MoveTo field 'Document Date' 
    ActivateWindow dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    TypeTo field 'Document Date' , 'Document Date'
    MoveTo field 'Batch Number' 
    MoveTo field 'Lookup Button 2' 
    ClickHit field 'Lookup Button 2' 
    NewActiveWin dictionary 'default' form 'IV_Batch_Lookup' window 'IV_Batch_Lookup' 
    ActivateWindow dictionary 'default' form 'IV_Batch_Lookup' window 'IV_Batch_Lookup' 
    MoveTo field 'Select Button' 
    ClickHit field 'Select Button' 
    NewActiveWin dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    ActivateWindow dictionary 'default' form 'IV_Transfer_Entry' window 'IV_Transfer_Entry' 
    TypeTo field '(L) From Default Site' , 'From Location'
    MoveTo field '(L) To Default Site' 
    TypeTo field '(L) To Default Site' , 'To Location'
    TransLinePrepare scrollwin 'IV_Transfer_Scroll' 

    i need it only once 

    and also the line it keep saying line 1 again 

    not line 2 

    any help about it?

  • ICH BIN ICH Profile Picture
    ICH BIN ICH 55 on at
    RE: Mass Transfer Inventory Items

    HI , can you please provide the excel macro for the transfer?

    My email is tosh5314 (AT) gmail (DOT) com

    Thank you

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    Hi everyone,

    Please do not post your email address or ask others to post their email in the forums because the community is public and could be picked up by spambots. Instead, send a friend request or a private message to members that you would like to connect with.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    HI , can you please provide the excel macro for the transfer?

    My email is francosantos_85 (AT) hotmail (DOT) com

    Thank you

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Mass Transfer Inventory Items

    Another thing you can do is to use the cycle count feature to clear out one site and use that same adjustment as the source for the increase adjustment to the other site.

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    Mahmoud, please send me the macro you talked about in this article as I find myself in a situation needing to move items and quantities from site to site.

    My email is jlovin (AT) fhsinc (DOT) com

    Thank you,

    Jason Lovin

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    hi,

    Can you please send me the item transfer macro

    to "shif81 (AT) hotmail (DOT) com"

    thank you

    Shifan Shehabudeen

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    Mr. Davis,

    I was wondering if you ever received the macro for mass transfer's site to site form anyone?

    If so, would you mind emailing it to me?

    tim.wiseman (AT) millerrefrigeration (DOT) com

    Thanks for your time,

    Tim.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Transfer Inventory Items

    Hi Mahmoud

    If you still have a copy of the macro can i please have a copy i need to transfer 3000+ items between sites,

  • manolo Profile Picture
    manolo 97 on at
    RE: Mass Transfer Inventory Items

    Mahmoud, If you be kind enough to send me the excel macro, I would appreciated: email mvivero (AT) himapr (DOT) com

    Thanks!!

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans