Changing inventory valuation method

Yahoo Archive
21
The BPM might have an issue if you have the inventory stored in Multiple
locations at the same time.

You might want to revisit backflushing that (or those) specific parts.

* Is there a reason for backflushing the part?

* Who is pulling the materials, the Operator?

* Who knows where the materials are if a default bin is used?

* If the backflushed materials went negative, where did the real
materials come from?



Maybe a dashboard which shows the bins in a low condition would allow
you to see when the default bin needs to be filled.





Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com









From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 12:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Default Bin Dilema





Having re-read my posting, I could have worded this one more
effectively.

The problem is that a specific part's default bin is where it will be
backflushed (or added to inventory in the case of mfg'ed). But the place
where we store parts is always changing.

To have the part backflush from the correct location, I'd have to change
the
default bin every time we store the part in a new location.

I'm thinking that I'll need to create a BPM that will change the default
bin
whenever a receipt or an inventory movement occurs.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Tuesday, October 13, 2009 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

So the question is why segregate like parts into different bins? You
must have a REALLY good reason to not want to combine parts....because
you can....unfortunately 8.x doesn't have rev control for inventory.
Not sure if version 9 does.

One solution is to either have a report for where parts are located for
your shipping dept, or do a BAQ for your shippers to use so they can see
where the parts are located.

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 11:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Hello and thank you for the input. We have set the default bin for the
parts
in the part master. I'll give an example to better explain my dilema.

1. We receive part ABC which is set to bin1 as it's default bin.

2. The receiver stores the part ABC but bin1 is taken so he store it
in bin5 and moves the qty in Vantage accordingly.

3. Part ABC is used and the inventory is relieved from bin1 because
that is the default set in the part master. bin1 goes into a negative
inventory qty when bin5 has parts available.

I don't want to have to reset my default bin every time we store parts
in a
new location, which is very common.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Friday, October 09, 2009 4:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

You set your default bin per part in the part maintenance screen. When
you receive parts to stock from a job it should automatically go to its
default location. When you receive parts from purchase, click the 'to
location' button and that will bring up the default bin location for
that part as defined in the part master. With some exceptions (mostly
human driven) it works pretty well for us.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site) <http://www.dsmfg.com/
<http://www.dsmfg.com/> >

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Friday, October 09, 2009 2:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Default Bin Dilema

Hello group and TGIF!

We're currently using one bin location (DEFAULT) for all parts. To
improve parts locating on the shop floor, I want to start using specific
bin locations. The problem I'm having is that Vantage backflushes from
the default bin instead of the bin that actually has qty on hand.

I entered some production in pilot and saw the manufactured components
being backflushed from empty default bins and while other bins of the
same part, with qty-on-hand, were not utilized.

Aside from changing the default bin everytime we receive, manufacture or
move inventory is there a way to work around this?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
22
Hello Charlie. There are a number of reasons why backflushing works well in
our environment. We will not be storing inventory in multiple locations.



The AMM module would be my slickest option but I will try to get the BPM
going before I go shopping. I've been pecking away at the BPM but it's not
working, no errors just not working.



Here's my 4GL on the InvTransfer.CommitTransfer. Any suggestions?

for each ttInvTrans where (ttInvTrans.RowMod = "U" or ttinvtrans.RowMod =
"A") no-lock.

If ttInvTrans.ToWarehouseCode = "MAIN" then do:
Find Partbin where partbin.partnum = ttinvtrans.PartNum no-lock no-error.
Run lib\UpdateTableBuffer.p(input BUFFER PartBin:HANDLE, 'BinNum',
'ttinvtrans.ToBinNum').
end.

end.



Gerry















From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
CharlieSmith
Sent: Wednesday, October 14, 2009 4:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Default Bin Dilema





The BPM might have an issue if you have the inventory stored in Multiple
locations at the same time.

You might want to revisit backflushing that (or those) specific parts.

* Is there a reason for backflushing the part?

* Who is pulling the materials, the Operator?

* Who knows where the materials are if a default bin is used?

* If the backflushed materials went negative, where did the real
materials come from?

Maybe a dashboard which shows the bins in a low condition would allow
you to see when the default bin needs to be filled.

Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 12:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Having re-read my posting, I could have worded this one more
effectively.

The problem is that a specific part's default bin is where it will be
backflushed (or added to inventory in the case of mfg'ed). But the place
where we store parts is always changing.

To have the part backflush from the correct location, I'd have to change
the
default bin every time we store the part in a new location.

I'm thinking that I'll need to create a BPM that will change the default
bin
whenever a receipt or an inventory movement occurs.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Tuesday, October 13, 2009 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

So the question is why segregate like parts into different bins? You
must have a REALLY good reason to not want to combine parts....because
you can....unfortunately 8.x doesn't have rev control for inventory.
Not sure if version 9 does.

One solution is to either have a report for where parts are located for
your shipping dept, or do a BAQ for your shippers to use so they can see
where the parts are located.

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 11:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Hello and thank you for the input. We have set the default bin for the
parts
in the part master. I'll give an example to better explain my dilema.

1. We receive part ABC which is set to bin1 as it's default bin.

2. The receiver stores the part ABC but bin1 is taken so he store it
in bin5 and moves the qty in Vantage accordingly.

3. Part ABC is used and the inventory is relieved from bin1 because
that is the default set in the part master. bin1 goes into a negative
inventory qty when bin5 has parts available.

I don't want to have to reset my default bin every time we store parts
in a
new location, which is very common.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Friday, October 09, 2009 4:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

You set your default bin per part in the part maintenance screen. When
you receive parts to stock from a job it should automatically go to its
default location. When you receive parts from purchase, click the 'to
location' button and that will bring up the default bin location for
that part as defined in the part master. With some exceptions (mostly
human driven) it works pretty well for us.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site) <http://www.dsmfg.com/
<http://www.dsmfg.com/> >

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Friday, October 09, 2009 2:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Default Bin Dilema

Hello group and TGIF!

We're currently using one bin location (DEFAULT) for all parts. To
improve parts locating on the shop floor, I want to start using specific
bin locations. The problem I'm having is that Vantage backflushes from
the default bin instead of the bin that actually has qty on hand.

I entered some production in pilot and saw the manufactured components
being backflushed from empty default bins and while other bins of the
same part, with qty-on-hand, were not utilized.

Aside from changing the default bin everytime we receive, manufacture or
move inventory is there a way to work around this?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
23
A couple of things to try:



* Try changing the "Find PartBin" to "Find First PartBin".

If that does not work then

* Sometimes I have had trouble getting lib\UpdateTableBuffer.p
to run in Pre-Process BPM.

Try moving it to a Post-Process BPM. The code will need to be
re-worked for Post Process.



Hope This helps.



Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner



RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@...
<BLOCKED::blocked::mailto:dale.schuerman@...> (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerry Loranger
Sent: Wednesday, October 14, 2009 3:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Default Bin Dilema







Hello Charlie. There are a number of reasons why backflushing works well
in
our environment. We will not be storing inventory in multiple locations.

The AMM module would be my slickest option but I will try to get the BPM
going before I go shopping. I've been pecking away at the BPM but it's
not
working, no errors just not working.

Here's my 4GL on the InvTransfer.CommitTransfer. Any suggestions?

for each ttInvTrans where (ttInvTrans.RowMod = "U" or ttinvtrans.RowMod
=
"A") no-lock.

If ttInvTrans.ToWarehouseCode = "MAIN" then do:
Find Partbin where partbin.partnum = ttinvtrans.PartNum no-lock
no-error.
Run lib\UpdateTableBuffer.p(input BUFFER PartBin:HANDLE, 'BinNum',
'ttinvtrans.ToBinNum').
end.

end.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
CharlieSmith
Sent: Wednesday, October 14, 2009 4:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

The BPM might have an issue if you have the inventory stored in Multiple
locations at the same time.

You might want to revisit backflushing that (or those) specific parts.

* Is there a reason for backflushing the part?

* Who is pulling the materials, the Operator?

* Who knows where the materials are if a default bin is used?

* If the backflushed materials went negative, where did the real
materials come from?

Maybe a dashboard which shows the bins in a low condition would allow
you to see when the default bin needs to be filled.

Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 12:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Having re-read my posting, I could have worded this one more
effectively.

The problem is that a specific part's default bin is where it will be
backflushed (or added to inventory in the case of mfg'ed). But the place
where we store parts is always changing.

To have the part backflush from the correct location, I'd have to change
the
default bin every time we store the part in a new location.

I'm thinking that I'll need to create a BPM that will change the default
bin
whenever a receipt or an inventory movement occurs.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Tuesday, October 13, 2009 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

So the question is why segregate like parts into different bins? You
must have a REALLY good reason to not want to combine parts....because
you can....unfortunately 8.x doesn't have rev control for inventory.
Not sure if version 9 does.

One solution is to either have a report for where parts are located for
your shipping dept, or do a BAQ for your shippers to use so they can see
where the parts are located.

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 11:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Hello and thank you for the input. We have set the default bin for the
parts
in the part master. I'll give an example to better explain my dilema.

1. We receive part ABC which is set to bin1 as it's default bin.

2. The receiver stores the part ABC but bin1 is taken so he store it
in bin5 and moves the qty in Vantage accordingly.

3. Part ABC is used and the inventory is relieved from bin1 because
that is the default set in the part master. bin1 goes into a negative
inventory qty when bin5 has parts available.

I don't want to have to reset my default bin every time we store parts
in a
new location, which is very common.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Friday, October 09, 2009 4:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

You set your default bin per part in the part maintenance screen. When
you receive parts to stock from a job it should automatically go to its
default location. When you receive parts from purchase, click the 'to
location' button and that will bring up the default bin location for
that part as defined in the part master. With some exceptions (mostly
human driven) it works pretty well for us.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site) <http://www.dsmfg.com/
<http://www.dsmfg.com/> >

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Friday, October 09, 2009 2:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Default Bin Dilema

Hello group and TGIF!

We're currently using one bin location (DEFAULT) for all parts. To
improve parts locating on the shop floor, I want to start using specific
bin locations. The problem I'm having is that Vantage backflushes from
the default bin instead of the bin that actually has qty on hand.

I entered some production in pilot and saw the manufactured components
being backflushed from empty default bins and while other bins of the
same part, with qty-on-hand, were not utilized.

Aside from changing the default bin everytime we receive, manufacture or
move inventory is there a way to work around this?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
24
Good suggestion, but still no pulse.



Gerry





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dale Schuerman
Sent: Thursday, October 15, 2009 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Default Bin Dilema





A couple of things to try:

* Try changing the "Find PartBin" to "Find First PartBin".

If that does not work then

* Sometimes I have had trouble getting lib\UpdateTableBuffer.p
to run in Pre-Process BPM.

Try moving it to a Post-Process BPM. The code will need to be
re-worked for Post Process.

Hope This helps.

Dale E. Schuerman

Senior Consultant

Epicor Certified Consulting Partner

RAM Software Systems, Inc.

972-669-0763 x233 (voice)

972-669-9603 (fax)

mailto:dale.schuerman@... <mailto:dale.schuerman%40ramsys.com>
<BLOCKED::blocked::mailto:dale.schuerman@...
<mailto:dale.schuerman%40ramsys.com> > (email)

http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
(website)

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Wednesday, October 14, 2009 3:41 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Hello Charlie. There are a number of reasons why backflushing works well
in
our environment. We will not be storing inventory in multiple locations.

The AMM module would be my slickest option but I will try to get the BPM
going before I go shopping. I've been pecking away at the BPM but it's
not
working, no errors just not working.

Here's my 4GL on the InvTransfer.CommitTransfer. Any suggestions?

for each ttInvTrans where (ttInvTrans.RowMod = "U" or ttinvtrans.RowMod
=
"A") no-lock.

If ttInvTrans.ToWarehouseCode = "MAIN" then do:
Find Partbin where partbin.partnum = ttinvtrans.PartNum no-lock
no-error.
Run lib\UpdateTableBuffer.p(input BUFFER PartBin:HANDLE, 'BinNum',
'ttinvtrans.ToBinNum').
end.

end.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
CharlieSmith
Sent: Wednesday, October 14, 2009 4:15 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

The BPM might have an issue if you have the inventory stored in Multiple
locations at the same time.

You might want to revisit backflushing that (or those) specific parts.

* Is there a reason for backflushing the part?

* Who is pulling the materials, the Operator?

* Who knows where the materials are if a default bin is used?

* If the backflushed materials went negative, where did the real
materials come from?

Maybe a dashboard which shows the bins in a low condition would allow
you to see when the default bin needs to be filled.

Charlie Smith

Smith Business Services / 2W Technologies LLC

www.vistaconsultant.com <http://www.vistaconsultant.com/> /
www.2WTech.com

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 12:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Having re-read my posting, I could have worded this one more
effectively.

The problem is that a specific part's default bin is where it will be
backflushed (or added to inventory in the case of mfg'ed). But the place
where we store parts is always changing.

To have the part backflush from the correct location, I'd have to change
the
default bin every time we store the part in a new location.

I'm thinking that I'll need to create a BPM that will change the default
bin
whenever a receipt or an inventory movement occurs.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Tuesday, October 13, 2009 12:43 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

So the question is why segregate like parts into different bins? You
must have a REALLY good reason to not want to combine parts....because
you can....unfortunately 8.x doesn't have rev control for inventory.
Not sure if version 9 does.

One solution is to either have a report for where parts are located for
your shipping dept, or do a BAQ for your shippers to use so they can see
where the parts are located.

M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerry Loranger
Sent: Tuesday, October 13, 2009 11:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

Hello and thank you for the input. We have set the default bin for the
parts
in the part master. I'll give an example to better explain my dilema.

1. We receive part ABC which is set to bin1 as it's default bin.

2. The receiver stores the part ABC but bin1 is taken so he store it
in bin5 and moves the qty in Vantage accordingly.

3. Part ABC is used and the inventory is relieved from bin1 because
that is the default set in the part master. bin1 goes into a negative
inventory qty when bin5 has parts available.

I don't want to have to reset my default bin every time we store parts
in a
new location, which is very common.

Gerry

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Rob Bucek
Sent: Friday, October 09, 2009 4:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Default Bin Dilema

You set your default bin per part in the part maintenance screen. When
you receive parts to stock from a job it should automatically go to its
default location. When you receive parts from purchase, click the 'to
location' button and that will bring up the default bin location for
that part as defined in the part master. With some exceptions (mostly
human driven) it works pretty well for us.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/ <http://www.dsmfg.com/> >

(Click the logo to view our site) <http://www.dsmfg.com/
<http://www.dsmfg.com/> >

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of schmangy20000
Sent: Friday, October 09, 2009 2:50 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Default Bin Dilema

Hello group and TGIF!

We're currently using one bin location (DEFAULT) for all parts. To
improve parts locating on the shop floor, I want to start using specific
bin locations. The problem I'm having is that Vantage backflushes from
the default bin instead of the bin that actually has qty on hand.

I entered some production in pilot and saw the manufactured components
being backflushed from empty default bins and while other bins of the
same part, with qty-on-hand, were not utilized.

Aside from changing the default bin everytime we receive, manufacture or
move inventory is there a way to work around this?

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
25
I was referencing the wrong field. The following code is now changing my primary bin when a main warehouse inventory movement occurs. Thanks for the help all!

Gerry


for each ttInvTrans where ttInvTrans.RowMod = 'U' or ttinvtrans.RowMod = 'A'.

find PlantWhse where PlantWhse.Company = CUR-COMP and PlantWhse.PartNum = ttinvtrans.PartNum and PlantWhse.WarehouseCode = "MAIN".

if avail PlantWhse then do:

Run lib\UpdateTableBuffer.p(input BUFFER PlantWhse:HANDLE, 'PrimBin', ttinvtrans.ToBinNum).

end.
end.



--- In vantage@yahoogroups.com, "Dale Schuerman" <dale.schuerman@...> wrote:
>
> A couple of things to try:
>
>
>
> * Try changing the "Find PartBin" to "Find First PartBin".
>
> If that does not work then
>
> * Sometimes I have had trouble getting lib\UpdateTableBuffer.p
> to run in Pre-Process BPM.
>
> Try moving it to a Post-Process BPM. The code will need to be
> re-worked for Post Process.
>
>
>
> Hope This helps.
>
>
>
> Dale E. Schuerman
>
> Senior Consultant
>
> Epicor Certified Consulting Partner
>
>
>
> RAM Software Systems, Inc.
>
> 972-669-0763 x233 (voice)
>
> 972-669-9603 (fax)
>
> mailto:dale.schuerman@...
> <BLOCKED::blocked::mailto:dale.schuerman@...> (email)
>
> http://www.ramsys.com <BLOCKED::blocked::http://www.ramsys.com/>
> (website)
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Gerry Loranger
> Sent: Wednesday, October 14, 2009 3:41 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Default Bin Dilema
>
>
>
>
>
>
>
> Hello Charlie. There are a number of reasons why backflushing works well
> in
> our environment. We will not be storing inventory in multiple locations.
>
> The AMM module would be my slickest option but I will try to get the BPM
> going before I go shopping. I've been pecking away at the BPM but it's
> not
> working, no errors just not working.
>
> Here's my 4GL on the InvTransfer.CommitTransfer. Any suggestions?
>
> for each ttInvTrans where (ttInvTrans.RowMod = "U" or ttinvtrans.RowMod
> =
> "A") no-lock.
>
> If ttInvTrans.ToWarehouseCode = "MAIN" then do:
> Find Partbin where partbin.partnum = ttinvtrans.PartNum no-lock
> no-error.
> Run lib\UpdateTableBuffer.p(input BUFFER PartBin:HANDLE, 'BinNum',
> 'ttinvtrans.ToBinNum').
> end.
>
> end.
>
> Gerry
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> CharlieSmith
> Sent: Wednesday, October 14, 2009 4:15 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Default Bin Dilema
>
> The BPM might have an issue if you have the inventory stored in Multiple
> locations at the same time.
>
> You might want to revisit backflushing that (or those) specific parts.
>
> * Is there a reason for backflushing the part?
>
> * Who is pulling the materials, the Operator?
>
> * Who knows where the materials are if a default bin is used?
>
> * If the backflushed materials went negative, where did the real
> materials come from?
>
> Maybe a dashboard which shows the bins in a low condition would allow
> you to see when the default bin needs to be filled.
>
> Charlie Smith
>
> Smith Business Services / 2W Technologies LLC
>
> www.vistaconsultant.com <http://www.vistaconsultant.com/> /
> www.2WTech.com
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Gerry Loranger
> Sent: Tuesday, October 13, 2009 12:54 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Default Bin Dilema
>
> Having re-read my posting, I could have worded this one more
> effectively.
>
> The problem is that a specific part's default bin is where it will be
> backflushed (or added to inventory in the case of mfg'ed). But the place
> where we store parts is always changing.
>
> To have the part backflush from the correct location, I'd have to change
> the
> default bin every time we store the part in a new location.
>
> I'm thinking that I'll need to create a BPM that will change the default
> bin
> whenever a receipt or an inventory movement occurs.
>
> Gerry
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Manasa Reddy
> Sent: Tuesday, October 13, 2009 12:43 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Default Bin Dilema
>
> So the question is why segregate like parts into different bins? You
> must have a REALLY good reason to not want to combine parts....because
> you can....unfortunately 8.x doesn't have rev control for inventory.
> Not sure if version 9 does.
>
> One solution is to either have a report for where parts are located for
> your shipping dept, or do a BAQ for your shippers to use so they can see
> where the parts are located.
>
> M. Manasa Reddy
> manasa@... <mailto:manasa%40weldcoa.com>
> <mailto:manasa%40weldcoa.com>
> <mailto:manasa%40weldcoa.com>
> <mailto:manasa%40weldcoa.com>
> P: 630-806-2000
> F: 630-806-2001
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of Gerry Loranger
> Sent: Tuesday, October 13, 2009 11:38 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Default Bin Dilema
>
> Hello and thank you for the input. We have set the default bin for the
> parts
> in the part master. I'll give an example to better explain my dilema.
>
> 1. We receive part ABC which is set to bin1 as it's default bin.
>
> 2. The receiver stores the part ABC but bin1 is taken so he store it
> in bin5 and moves the qty in Vantage accordingly.
>
> 3. Part ABC is used and the inventory is relieved from bin1 because
> that is the default set in the part master. bin1 goes into a negative
> inventory qty when bin5 has parts available.
>
> I don't want to have to reset my default bin every time we store parts
> in a
> new location, which is very common.
>
> Gerry
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Rob Bucek
> Sent: Friday, October 09, 2009 4:06 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Default Bin Dilema
>
> You set your default bin per part in the part maintenance screen. When
> you receive parts to stock from a job it should automatically go to its
> default location. When you receive parts from purchase, click the 'to
> location' button and that will bring up the default bin location for
> that part as defined in the part master. With some exceptions (mostly
> human driven) it works pretty well for us.
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/ <http://www.dsmfg.com/> >
>
> (Click the logo to view our site) <http://www.dsmfg.com/
> <http://www.dsmfg.com/> >
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of schmangy20000
> Sent: Friday, October 09, 2009 2:50 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Default Bin Dilema
>
> Hello group and TGIF!
>
> We're currently using one bin location (DEFAULT) for all parts. To
> improve parts locating on the shop floor, I want to start using specific
> bin locations. The problem I'm having is that Vantage backflushes from
> the default bin instead of the bin that actually has qty on hand.
>
> I entered some production in pilot and saw the manufactured components
> being backflushed from empty default bins and while other bins of the
> same part, with qty-on-hand, were not utilized.
>
> Aside from changing the default bin everytime we receive, manufacture or
> move inventory is there a way to work around this?
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
> [Non-text portions of this message have been removed]
>
>
>
>
> ########################################################################
> Attention:
> This email message is privileged and confidential. If you are not the
> intended recipient please delete the message and notify the sender.
> Any views or opinions presented are solely those of the author.
>
> This email message has been scanned for Viruses and Content and cleared
> by MailMarshal SMTP
>
> For more information go to http://www.ramsys.com
> ########################################################################
>
>
> [Non-text portions of this message have been removed]
>