I have couple of warehouses (Site ID's) what are transferring ALL their inventory to one location. Instead of entering a separate transaction for each line item (each warehouse has 75-150 items) is there a way to tell GP to transfer ALL Inventory located at one site ID to another at one time?
*This post is locked for comments
Hi,
In order to process a count, each line has to be 'verified'. If you're moving 1500 items, you certainly do not want to check every line's 'verified' box for items that have zero quantities. Thinking a little bit more about this and the quantity of items you're dealing with, I think a macro may be a better answer for you. The stock count entry displays 9 rows, so your macro would need to count down rows 1 through 9 and then every line would be line 9 after that. You really only need to record a couple of items just so you can see how it repeats. Then you would use the Mail-Merge technique to read the database items and check all of the boxes. I created one for TWO and it looked like this for the first 12 items:
# DEXVERSION=14.00.0085.000 2 2
CheckActiveWin dictionary 'default' form ivStockCountEntry window ivStockCountEntry
# Key 1:
MoveTo line 1 scrollwin LineScroll field '(L) Count Verified' # 'FALSE'
# Key 1: 'WAREHOUSE', '', '1-A3261A'
ClickHit line 1 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '1-A3261A'
MoveTo line 2 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '1-A3483A'
ClickHit line 2 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '1-A3483A'
MoveTo line 3 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '128 SDRAM'
ClickHit line 3 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '128 SDRAM'
MoveTo line 4 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '1GPROC'
ClickHit line 4 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '1GPROC'
MoveTo line 5 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '2-A3284A'
ClickHit line 5 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '2-A3284A'
MoveTo line 6 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '24X IDE'
ClickHit line 6 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '24X IDE'
MoveTo line 7 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '256 SDRAM'
ClickHit line 7 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '256 SDRAM'
MoveTo line 8 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '2GPROC'
ClickHit line 8 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '2GPROC'
MoveTo line 9 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '3-A2440A'
ClickHit line 9 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
ScrollByLine down scrollwin LineScroll
# Key 1: 'WAREHOUSE', '', '3-A2440A'
MoveTo line 9 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
# Key 1: 'WAREHOUSE', '', '3-A2969A'
ClickHit line 9 scrollwin LineScroll field '(L) Count Verified' # 'TRUE'
ScrollByLine down scrollwin LineScroll
Notice how when you hit line 9, another line is added to the macro which is:
ScrollByLine down scrollwin LineScroll
Put the ShowAdvancedMacroMenu=TRUE in your Dex.ini file and then check the box 'No User Interface Flash' in the Status window to double the speed of the macro.
Kind regards,
Leslie
Hi Leslie, would you be kind enough to explain in more detail the step " I use SQL to check the box to enter a count of zero". Or perhaps the easiest way to move 1500 items from one warehouse to another that is going to become the central warehouse. Thanks!!
Hi
What I have done when faced with this kind of thing is to create an inventory count schedule that includes all of the items. I use SQL to check the box to enter a count of zero. The resulting variance gives me the count. Complete the count and post the transaction. Create another count at the new site, import the quantities captured and post the increase adjustment.
It works a lot faster than it sounds :) Anyway, another option for you.
Kind regards,
Leslie
There are several cases in which a business would need to post certain type of transactions on a regular base. I assume that the case you present above is one of them.
I would recommend creating a "recurring" batch on the "Item Transfer Entry" which you can post on a regular base (weekly, monthly, quarterly ... etc) depending on your business need.
Each time, you need only to fill out the available quantities to be transferred from the original site and post the batch. After posting, the batch is still saved for later uses.
Sorry, there is no functionality in the application to do this easily.
I have done this in the past with a SQL script that generates a Macro. It works with Lot/Serial and Multi-bin.
Tim
Share
Report
All responses (
Answers (
65,271
