BIN to BIN Transfer - Where the Data Goes?

[Viol-8-r]

I just realized that when we Transfer the inventory from BIN 2 BIN; there is only one Working Table I.e. IV10004 where you can't save the TRXs in Batches, nor there is any Doc. reference and then on top of that there is no History table keeping the records of all the TRANSFERS.

 

We have even installed GP Auditing where TO BIN Column is always empty and then there is no record of Movement, all. WE also bought the Idera Compliance Manger and auditing Before and After Data and amazingly it is not able to capture the TO BIN.

 

There is no report available in GP to find out the TRANSFERS and then there is no option of of print any TRACK.

 

Every week we loose some of tracking and then becomes a mission impossible, who transferred the items when why and how. Is there is a logical reason for keeping the BIN to BIN Transfer this way which I am missing ?

[Charles Allen]

I don't know about logical. But it's been this way for many years.

The only thought I have is to create two transactions.
1. Decrease adjustment to remove the item from bin 1.
2. Increase adjustment to put the item in bin 2.
--
Charles Allen, MVP

[Viol-8-r]

Thanks Charles,
But it should not have been this way. The reality on ground is, that when
we receive all the material it first goes to QA for Inspection and then if
it is acceptable; our Stock Clerk moves it to Warehouse to a BIN and since
we have multi-bin situation, therefore once in a while the material gets
disappeared ( it is not a joke, we have recently lost material worth around
$60K and could not find out who moved and where) and then it becomes very
hard to find out; by who, when, how and where it was moved and there is no
record to look anywhere.

We are spending days and weeks just to find out missing stuff which is
terrible.

Is there any workaround or any 3rd party solution available in market? I
know when we were looking for a bar coding solution; the vendor ( Maximum
Data) did demonstrate and offered the full tracking solution for BIN to BIN
transfers.
Regards,

"Charles Allen" <cal...@nospam-bkd.com> wrote in message
news:A27DBFC8-5325-4C0B...@microsoft.com...

[Charles Allen]

Unfortunately, arguing about what is and what should be is rather pointless.
You can enter a suggestion for people to vote on.

I would say that if you found a solution with an ISV, then that is your
solution. That's where ISV solutions come in -- adding functionality not
available in the off-the-shelf solution.

[Frank Hamelly, MCP-GP, MCT, MVP]

I'm sure you don't want to hear this but it sounds like you have a
process problem. Having a system to record every movement of
inventory will do you no good if people don't input the data. You
could barcode everything in your inventory and supply your employees
with the best scanning system in the world. If someone doesn't pull
the trigger on the scanner, guess what - no tracking.

What is your inventory transaction volume? What kinds of products are
you stocking? I'm wondering how could you possibly lose $60k in
inventory and no one in the stock room has a clue what happened to
it. The same thing could happen regardless of the tracking system you
have in place if employees are careless about following a sound
process.

Hope this helps,

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com

[Mariano Gomez]

I would also add that if you find yourself transferring products constantly
between bins, then your warehouse is most likely not following best
practices. I have implemented GP in $500M+ food distribution companies and
constantly transferring products between bins or even sections of the
warehouse is not an option for the majority of the products, and considered
an extremely inefficient exercise for selectors and put away personnel.

Certain warehouses use tolerance margins for product loss, because,
unfortunately this is unavoidable, but depending on the size of your
environment, $60K may just be way too much.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[Viol-8-r]

I did not like your answer and this should not be an answer from a MVP.
period. Only Arguments can make some one responsible for his idiotic work
and performance.

I have the right to express my feelings and that is why Microsoft has
created this Users' Group and they and their MVP must have the courage to
listen Customer's grievances as well.

Also, why I should find an ISV to put the bandaid on one party's poor
analysis and design not knowing the realities on ground.

Let me also tell you I also have more have 20 years of experience and I have
also supported SAP, Oracle and many other with 65,000 Users and I am 1st one
who successfully implemented a job shop solution using Solomon back in
1988-89 which Microsoft now takes the pride with OCC; but I am not convinced
with this GP. It looks like a team frogs is acting like whales.

Next time, don't make any comment on my query and I am also going to submit
this with Microsoft. You can't imagine how much heat I face every day from
my users and how I convince them on behalf of MS this is not my job. If the
economy was the issue my company would have dumped this piece of ..........
long time ago. Every day we just drag this.

"Charles Allen" <cal...@nospam-bkd.com> wrote in message

news:942488ED-37CB-4F41...@microsoft.com...

[Frank Hamelly, MCP-GP, MCT, MVP]

Whoa, man, just trying to help here. I'm sorry to have offended you
but we who answer questions in these forums, voluntarily I might add,
have no idea what function you perform in your company or how much
experience you have. If you're an IT, IS, accounting person, etc., I
was merely trying to point out that maybe the problem isn't with the
system, but with the process, and help give you some ammunition to go
back to your users with.

I have over 30 years in this business and do know a thing or two about
inventory and stockroom processes. And in addition to GP, I too have
implemented and supported SAP, Baan, 4th Shift, etc, all the way from
the little guys to large multi-nationals.

So, that said, how else can we be of assistance?

[Viol-8-r]

I really appreciate from the bottom of my heart and I am also thankful for
all of you guys, helping out of your personal time while I also appreciated
all the knowledgeable replies from Richard, Mariano and Frank.

My point is and was that I have a situation and I am trying to share it with
the Group, while I have also worked in both roles as Vendor and as Customer
and 3rd parties role is also a key but someone must understand that when
User complains about something and then Solution Provider also gives you a
dried response, then where to look for help?

I am going to investigate the situation again based on Diagnostics tips
provided by Richard and Mariano but we are fighting with this situation for
a long time and so far nothing has clicked; about where we are making
mistakes and we did have and had two seasoned industry professionals as our
partner and their response also leads no where.

Anyhow thank you all
Regards,

"Frank Hamelly, MCP-GP, MCT, MVP" <fham...@eastcoast-dynamics.com> wrote in
message
news:38c8a070-0647-42ed...@37g2000yqm.googlegroups.com...

[Frank Hamelly, MCP-GP, MCT, MVP]

Maximum Data (now Accellos) does provide the de facto standard ISV
solution for GP for automating inventory and production data
collection. Unfortunately, GP out of the box does not capture the
data you need for an end-to-end audit of your inventory movements.
Perhaps a customization to capture and report on that data would work
in your environment if a 3rd party solution isn't the answer.

[Mariano Gomez]

Look, we are big fans of GP, but we are also the biggest critics of the
product as MVPs.

Understanding that GP does not provide true warehouse management, one of the
biggest issues I find with GP is that it attempts to do a lot of things that
other specialized products, like warehouse management systems, do extremely
well, and bin management certainly falls within that realm of things.
However, when I look at it from another perspective, the software does
extremely well in providing functionality not found in average competing
products. This is a delicate balancing act.

With that said, if your warehousing requirements are far more complex than
you are getting from GP, then maybe is time to look into a specialized system
that you could integrate with GP, and use GP for what it does well: produce
orders and invoicing the customer.

The one thing that's hard to convince users and business managers about is
investing in solutions, especially in this economy.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com

[Viol-8-r]

You are absolutely correct and that is also one the problem I have too.
Company made the investment when the vision was not clear about what was the
intention to accomplish or the wish list and what GP could for them.

Now that everything is clear along with the expectations there is no budget
to spend; to make it the way it is required.

"Mariano Gomez" <Marian...@discussions.microsoft.com> wrote in message
news:BB6B7E3E-8C16-4207...@microsoft.com...

[Patrick [MSFT]]

Viol-8-r,

 

As you noted, for some reason there isn't any kind of tracking for bin to bin transfers.

 

One of our developers created a small customization that does track this movement and stores it in a custom table.  There isn't currently a UI or report that prints from this table but you could use SRS or crystal reports to get at the data or we could add reporting if you wanted.

 

For details, you can contact mbs profesional services (mbsprosv at microsoft.com) and they would refer you to the GP Developer Support team.

 

patrick

developer support

 

--
This posting is provided "AS IS" with no warranties, and confers no rights.

 

 

"Viol-8-r" <viol...@hotmail.com> wrote in message news:ORTuU3zK...@TK2MSFTNGP02.phx.gbl...

[Viol-8-r]

HI Patrick,

Thank you very much for this useful update and actually this is what I was looking for.  Let me contact them.

 

Regards,

 

"Patrick [MSFT]" <pr...@online.microsft.com> wrote in message news:uvmlpoQL...@TK2MSFTNGP02.phx.gbl...

[Viol-8-r]

As expected, it is becoming an MI to explain and get the Utility from MBS

"Patrick [MSFT]" <pr...@online.microsft.com> wrote in message news:uvmlpoQL...@TK2MSFTNGP02.phx.gbl...

[Patrick [MSFT]]

Yes, I spoke with Professional Services about this today.

 

I perhaps should have explained this a bit more clearly.  While there are a few free utilities (the Add Item chunk that I wrote years ago is one), this customization isn't one of the free tools however helpful it would be for your situation.  I should have implied there would be a fee in my response (although I never implied it would be free either).

Sorry about the misunderstanding.

 

patrick

dev support

--
This posting is provided "AS IS" with no warranties, and confers no rights.

 

 

"Viol-8-r" <viol...@hotmail.com> wrote in message news:%23jWFcmi...@TK2MSFTNGP04.phx.gbl...

[S.Purks]

Viol-8-r,

I am in the same boat. We need bin transfer history reported somewhere and
(as we know) it is not. Please share your findings if you come up with a
solution as, I am looking for the same thing.

In my humble opinion, this should be an "out of the box" feature. Having the
ability to move your inventory without tracking it seems like a disadvantage.

Regards,
Scott Purks

[Matt Brewing@discussions.microsoft.com FX Matt Brewing]

I too would love to have some bin-to-bin tracking abillity. Has anyone found
any solutions?