Vantage 406 - Service Connect importing inventory

Yahoo Archive
1
Mine works just dandy I think I'll just stick with that one thanks for the
info though.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Friday, March 06, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing inventory



You buy them from Epicor. J

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com> photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Friday, March 06, 2009 10:43 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

Where are these packaged workflows that you speak of I wrote my own to
do
the inventory adjustments.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Brian W. Spolarich
Sent: Friday, March 06, 2009 10:38 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

Alternatively you can turn off the G/L Inventory interface flag in
the Company setup when you're doing big inventory imports, and avoid the
big suspense account transaction. We did this for our two "cutover"
activities.

I would recommend creating real inventory adjustment transactions.
The Epicor-provided SC workflows work perfectly for this for us.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Mark Wonsil
Sent: Thursday, March 05, 2009 7:52 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

> Import of inventory is done in the PartTran table with 3 records for
each
> part:
> 1 - PartQty
> 2 - Set cost to zero
> 3 - write extended cost
> I've never had a problem during testing, but everybody freaks when you
> mention imports.
>
> Manual entry:
> 1 - Make sure part cost is correct.
> 2 - Manual quantity adjust x 4000 part numbers
>
> I'd like to hear what others did.

Like Dale, we used the Business Objects to load inventory. (It was a
fairly
small and easy program) but unlike Dale, we used the Adjust Quantity
transaction with a reason code that used the suspense account. After we
ran
the WIP/COS capture for those transactions, we reversed the entry in the
G/L. Finally, we ran a stock status to make sure the accounts balanced,
and
made necessary adjustments.

Mark W.

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date:
02/27/09
13:27:00

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

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00




[Non-text portions of this message have been removed]
2
We are going live soon, and our workflow for importing inventory is not working. (Costing? no problem. Inventory? Won't even try.) Does anyone have a Service COnnect workflow for importing inventory that they could share?
Thanks in advance!
- leAnn
3
Not knowing what tables your Inventory import workflow is trying to
load. The following may or may not help.



I have loaded inventory in the past with a progress program calling the
Epicor business objects (Before SC).

Because of the complexity of inventory, I created a Physical Inventory
Count Group. Created enough blank tags for the number of imported
combinations(no extra).

My program then loaded only the CountTag table. When completed, I
posted the Count group and let the Epicor post program deal with all of
the other tables.

This worked quit well several times.



This program quit working with version 404(So did the Paste Update into
the Count Tag Entry grid). Do not know if it has been fixed.



If your workflow was trying to load all the other inventory tables it
will be easier to create a Workflow to load the CountTag table only.

If your workflow is trying to load the Counttag table, try doing a Paste
Update into the Count Tag Entry program. If that fails then the BO is
still broke.



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 leann_37
Sent: Thursday, March 05, 2009 11:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 406 - Service Connect importing inventory



We are going live soon, and our workflow for importing inventory is not
working. (Costing? no problem. Inventory? Won't even try.) Does anyone
have a Service COnnect workflow for importing inventory that they could
share?
Thanks in advance!
- leAnn




########################################################################
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]
4
This is a very good idea! I hadn't considered using the count tags. If the GL is turned off for the upload, the result is the same as if we had run SC, without the SC woes...
Thank you very much!
- leAnn


--- In vantage@yahoogroups.com, "Dale Schuerman" <dale.schuerman@...> wrote:
>
> Not knowing what tables your Inventory import workflow is trying to
> load. The following may or may not help.
>
>
>
> I have loaded inventory in the past with a progress program calling the
> Epicor business objects (Before SC).
>
> Because of the complexity of inventory, I created a Physical Inventory
> Count Group. Created enough blank tags for the number of imported
> combinations(no extra).
>
> My program then loaded only the CountTag table. When completed, I
> posted the Count group and let the Epicor post program deal with all of
> the other tables.
>
> This worked quit well several times.
>
>
>
> This program quit working with version 404(So did the Paste Update into
> the Count Tag Entry grid). Do not know if it has been fixed.
>
>
>
> If your workflow was trying to load all the other inventory tables it
> will be easier to create a Workflow to load the CountTag table only.
>
> If your workflow is trying to load the Counttag table, try doing a Paste
> Update into the Count Tag Entry program. If that fails then the BO is
> still broke.
>
>
>
> 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 leann_37
> Sent: Thursday, March 05, 2009 11:42 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage 406 - Service Connect importing inventory
>
>
>
> We are going live soon, and our workflow for importing inventory is not
> working. (Costing? no problem. Inventory? Won't even try.) Does anyone
> have a Service COnnect workflow for importing inventory that they could
> share?
> Thanks in advance!
> - leAnn
>
>
>
>
> ########################################################################
> 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]
>
5
> Import of inventory is done in the PartTran table with 3 records for each
> part:
> 1 - PartQty
> 2 - Set cost to zero
> 3 - write extended cost
> I've never had a problem during testing, but everybody freaks when you
> mention imports.
>
> Manual entry:
> 1 - Make sure part cost is correct.
> 2 - Manual quantity adjust x 4000 part numbers
>
> I'd like to hear what others did.

Like Dale, we used the Business Objects to load inventory. (It was a fairly
small and easy program) but unlike Dale, we used the Adjust Quantity
transaction with a reason code that used the suspense account. After we ran
the WIP/COS capture for those transactions, we reversed the entry in the
G/L. Finally, we ran a stock status to make sure the accounts balanced, and
made necessary adjustments.

Mark W.
6
I have two SC flows that adjust inventory. One of which will add to
inventory. It reads a part number and qty from an excel file and adds that
qty to that part number. If your interested let me know.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bruce Ordway
Sent: Thursday, March 05, 2009 7:43 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 406 - Service Connect importing inventory



--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"leann_37" <lmarruffo@...> wrote:
>
> We are going live soon, and our workflow for importing inventory is not
working. (Costing? no problem. Inventory? Won't even try.) Does anyone have
a Service COnnect workflow for importing inventory that they could share?
> Thanks in advance!
> - leAnn
>

We are going live soon also.
I have tested importing and manual entry.
I am still not sure which way to go.

Import of inventory is done in the PartTran table with 3 records for each
part:
1 - PartQty
2 - Set cost to zero
3 - write extended cost
I've never had a problem during testing, but everybody freaks when you
mention imports.

Manual entry:
1 - Make sure part cost is correct.
2 - Manual quantity adjust x 4000 part numbers

I'd like to hear what others did.



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00




[Non-text portions of this message have been removed]
7
Alternatively you can turn off the G/L Inventory interface flag in
the Company setup when you're doing big inventory imports, and avoid the
big suspense account transaction. We did this for our two "cutover"
activities.



I would recommend creating real inventory adjustment transactions.
The Epicor-provided SC workflows work perfectly for this for us.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Wonsil
Sent: Thursday, March 05, 2009 7:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory



> Import of inventory is done in the PartTran table with 3 records for
each
> part:
> 1 - PartQty
> 2 - Set cost to zero
> 3 - write extended cost
> I've never had a problem during testing, but everybody freaks when you
> mention imports.
>
> Manual entry:
> 1 - Make sure part cost is correct.
> 2 - Manual quantity adjust x 4000 part numbers
>
> I'd like to hear what others did.

Like Dale, we used the Business Objects to load inventory. (It was a
fairly
small and easy program) but unlike Dale, we used the Adjust Quantity
transaction with a reason code that used the suspense account. After we
ran
the WIP/COS capture for those transactions, we reversed the entry in the
G/L. Finally, we ran a stock status to make sure the accounts balanced,
and
made necessary adjustments.

Mark W.





[Non-text portions of this message have been removed]
8
Where are these packaged workflows that you speak of I wrote my own to do
the inventory adjustments.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Friday, March 06, 2009 10:38 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing inventory



Alternatively you can turn off the G/L Inventory interface flag in
the Company setup when you're doing big inventory imports, and avoid the
big suspense account transaction. We did this for our two "cutover"
activities.

I would recommend creating real inventory adjustment transactions.
The Epicor-provided SC workflows work perfectly for this for us.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com> photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Mark Wonsil
Sent: Thursday, March 05, 2009 7:52 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

> Import of inventory is done in the PartTran table with 3 records for
each
> part:
> 1 - PartQty
> 2 - Set cost to zero
> 3 - write extended cost
> I've never had a problem during testing, but everybody freaks when you
> mention imports.
>
> Manual entry:
> 1 - Make sure part cost is correct.
> 2 - Manual quantity adjust x 4000 part numbers
>
> I'd like to hear what others did.

Like Dale, we used the Business Objects to load inventory. (It was a
fairly
small and easy program) but unlike Dale, we used the Adjust Quantity
transaction with a reason code that used the suspense account. After we
ran
the WIP/COS capture for those transactions, we reversed the entry in the
G/L. Finally, we ran a stock status to make sure the accounts balanced,
and
made necessary adjustments.

Mark W.

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



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date: 02/27/09
13:27:00




[Non-text portions of this message have been removed]
9
You buy them from Epicor. J



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Friday, March 06, 2009 10:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory



Where are these packaged workflows that you speak of I wrote my own to
do
the inventory adjustments.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Brian W. Spolarich
Sent: Friday, March 06, 2009 10:38 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

Alternatively you can turn off the G/L Inventory interface flag in
the Company setup when you're doing big inventory imports, and avoid the
big suspense account transaction. We did this for our two "cutover"
activities.

I would recommend creating real inventory adjustment transactions.
The Epicor-provided SC workflows work perfectly for this for us.

-bws

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com
~ 734-864-5618 ~
www.advancedphotonix.com

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Mark Wonsil
Sent: Thursday, March 05, 2009 7:52 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Re: Vantage 406 - Service Connect importing
inventory

> Import of inventory is done in the PartTran table with 3 records for
each
> part:
> 1 - PartQty
> 2 - Set cost to zero
> 3 - write extended cost
> I've never had a problem during testing, but everybody freaks when you
> mention imports.
>
> Manual entry:
> 1 - Make sure part cost is correct.
> 2 - Manual quantity adjust x 4000 part numbers
>
> I'd like to hear what others did.

Like Dale, we used the Business Objects to load inventory. (It was a
fairly
small and easy program) but unlike Dale, we used the Adjust Quantity
transaction with a reason code that used the suspense account. After we
ran
the WIP/COS capture for those transactions, we reversed the entry in the
G/L. Finally, we ran a stock status to make sure the accounts balanced,
and
made necessary adjustments.

Mark W.

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

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.4/1976 - Release Date:
02/27/09
13:27:00

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





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