Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
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

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 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 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 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 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 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 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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans