Mass Transfer Inventory Items

(0) Share

Report

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

I have the same question (0)

All responses (19)

Answers (1)

Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Mass Transfer Inventory Items

For me, the macro has always delivered successfully such tasks. I have a predefined set of Excel-based Macros

Send me an email and I will forward the macro generator for you.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Mass Transfer Inventory Items

If you want to actually transfer the items with their quantities then the macro idea Mahmoud suggests is the way to go. If all you need to do is assign this new site to these items then Cards->Inventory->Site and then Assign will do that.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Mass Transfer Inventory Items

You can also transfer the bulk of items from one site to another with creating a custom application via eConnect/Web service.

Hope this helps!!!

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (2)

Report

RE: Mass Transfer Inventory Items

Would I develop an eConnect or web service integration just to transfer around 1000 items ... Absolutely not.

We shall not only be effective in achieving a target. Rather, efficiency matters a lot.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: Mass Transfer Inventory Items

Hi Nola,

If you have sound in developing eConnect\Webservice then you can create a custom application to integrate the Item transfer entry.

else follow the experts way. macro - the way to go

1) create\Record a simple macro from Item Transfer Entry as shown below.

________________________________________

# 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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Mass Transfer Inventory Items

Mahmoud - I would love to get the Excel based macro generator file you mentioned if it is still available.

My email is jdavis (AT) usacompression (DOT) com.

Thanks!

Jeff Davis

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Mass Transfer Inventory Items

Hi,

Anybody has Coding for Transfer With Mail Merge Method Please send me ; I have LotNUmber & Expiry Option in my GP; If anybody has coding please let me know...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Mass Transfer Inventory Items

do you have the coding for Expiry or Lot Number Please let me know i am successfully done for 0 Quantity but for Lot Number I need another Macro or how can i create for Lot Number if you have something let me know...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Mass Transfer Inventory Items

Hi Mahmoud, can you please provide the the excel macro for uploading mass inventory items ??

My email: sajjad1.khan (AT) hotmail (DOT) com

Thanks,

Was this reply helpful? Yes No
manolo 97 on at

Like (0)

Report

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

Was this reply helpful? Yes No