Sage 100

Has anyone had any success importing new work tickets in Production Management?  Scanco said go to Sage Support.  Sage Support can't figure it out yet.

Essentially, the issue is ...
 
Import into JT_WorkTicketHeader complains that the Step doesn't exist
Import into JT_WorkTicketStep complains that the header doesn't exist.
So, it's a circular issue

This is v2019 PU2 with all the hot fixes installed that I can find.

We did this type of import in work order; but the equivalent header work order import didn't check that the step existed yet so we could move forward

Any input is most appreciated!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.
I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that! 

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Millions for marketing but not one penny for testing....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

PM is not Work Order, it's JobOps. So the simple answer is no.

------------------------------
John Hoyt, Co-Founder
Next Level Manufacturing Consulting Group
johnh@nextlevelMCG.com
------------------------------

Original Message:
Sent: 05-07-2020 08:25
From: Phil McIntosh
Subject: Importing work tickets (Production Management)

Millions for marketing but not one penny for testing....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------


Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

------Original Message------

Millions for marketing but not one penny for testing....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

OK, are we talking work order or Job Ops here???  WO = PM (made to stock).  Job Ops = Operations Management (fka PM Made to order).  If resellers can't keep it straight, how does Sage expect end users to know the difference.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 05-07-2020 10:43
From: Robert Osborn
Subject: Importing work tickets (Production Management)

Does anyone know if the data dictionary for PM is available to the rest of Sage yet?  One of the first things I ever tried to do in PM was to create UDF in the Lot number file for PM and then send it to the standard Sage lot file.   Could not do it.  Showed it to Sage and they agreed.  That was right after the release of PM and as far as I know, it has not been fixed.    Back in the day, they would fix issues like that inside a week...

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message------

Millions for marketing but not one penny for testing....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

PM is Job Ops Lite, which is probably what John meant.

------------------------------
Kevin Moyes
Technical Systems Analyst
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-07-2020 11:44
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

OK, are we talking work order or Job Ops here???  WO = PM (made to stock).  Job Ops = Operations Management (fka PM Made to order).  If resellers can't keep it straight, how does Sage expect end users to know the difference.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-07-2020 10:43
From: Robert Osborn
Subject: Importing work tickets (Production Management)

Does anyone know if the data dictionary for PM is available to the rest of Sage yet?  One of the first things I ever tried to do in PM was to create UDF in the Lot number file for PM and then send it to the standard Sage lot file.   Could not do it.  Showed it to Sage and they agreed.  That was right after the release of PM and as far as I know, it has not been fixed.    Back in the day, they would fix issues like that inside a week...

 

Thank you,

 

Bob Osborn

ACI Consulting

p 714.282.0378 ext. 402    f 714.282.0235

 

Bob@ACIconsulting.com

 

                   

This communication, including attachments, is confidential and may contain proprietary information intended only for the proposed recipient. Please notify the sender and delete this message if you believe that you have received this message in error or if you are not the proposed recipient. Unauthorized disclosure, copying, or distribution of the information is strictly prohibited.

 

 

 

 

Original Message------

Millions for marketing but not one penny for testing....

------------------------------
Phil McIntosh
President
Friendly Systems, Inc.
Asheville NC
678.273.4010 ext 5
------------------------------

@Jeff Schwenk, you beat me to it by a bit. I just posted my first address as president and the Mod Squad is part of it. https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=7&MessageKey=c34cc093-624e-417b-880c-2d06b3783997&CommunityKey=918f100c-0e88-408a-b4fc-a23920d0afe6&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts ​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

I sent the details to a contact in Scanco. Hopefully they can shed some light on how we should address an issue like this.

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-07-2020 11:51
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Jeff Schwenk, you beat me to it by a bit. I just posted my first address as president and the Mod Squad is part of it. https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=7&MessageKey=c34cc093-624e-417b-880c-2d06b3783997&CommunityKey=918f100c-0e88-408a-b4fc-a23920d0afe6&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts ​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------


Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

Thanks @Robert Wood​​, you are a quick writer.  I spent way too much time crafting my post and you whipped yours up i minutes!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------

Original Message:
Sent: 05-07-2020 12:06
From: Robert Wood
Subject: Importing work tickets (Production Management)

I sent the details to a contact in Scanco. Hopefully they can shed some light on how we should address an issue like this.

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------


Original Message:
Sent: 05-07-2020 11:51
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Jeff Schwenk, you beat me to it by a bit. I just posted my first address as president and the Mod Squad is part of it. https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=7&MessageKey=c34cc093-624e-417b-880c-2d06b3783997&CommunityKey=918f100c-0e88-408a-b4fc-a23920d0afe6&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts ​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

His address has been in process for more than a week. The timing was coincidental.

------------------------------
Jerry Norman
VP, 90 Minds
Smartbridge Partners
512.419.1444 x112
------------------------------

Original Message:
Sent: 05-07-2020 12:38
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Thanks @Robert Wood​​, you are a quick writer.  I spent way too much time crafting my post and you whipped yours up i minutes!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-07-2020 12:06
From: Robert Wood
Subject: Importing work tickets (Production Management)

I sent the details to a contact in Scanco. Hopefully they can shed some light on how we should address an issue like this.

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 11:51
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Jeff Schwenk, you beat me to it by a bit. I just posted my first address as president and the Mod Squad is part of it. https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=7&MessageKey=c34cc093-624e-417b-880c-2d06b3783997&CommunityKey=918f100c-0e88-408a-b4fc-a23920d0afe6&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts ​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

@Jeff Schwenk ​, I've been working on that for a while. I just finished whipping it into shape this morning. What Wayne can do in 15 minutes takes me 2 hours.

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-07-2020 12:38
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Thanks @Robert Wood​​, you are a quick writer.  I spent way too much time crafting my post and you whipped yours up i minutes!

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444
------------------------------


Original Message:
Sent: 05-07-2020 12:06
From: Robert Wood
Subject: Importing work tickets (Production Management)

I sent the details to a contact in Scanco. Hopefully they can shed some light on how we should address an issue like this.

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 11:51
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Jeff Schwenk, you beat me to it by a bit. I just posted my first address as president and the Mod Squad is part of it. https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=7&MessageKey=c34cc093-624e-417b-880c-2d06b3783997&CommunityKey=918f100c-0e88-408a-b4fc-a23920d0afe6&tab=digestviewer&ReturnUrl=%2fbrowse%2fallrecentposts ​

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 08:22
From: Jeff Schwenk
Subject: Importing work tickets (Production Management)

Well, as Harry Truman used to say "If you can't convince them, confuse them".  The buck stops at Sage's desk!  Their name is on the product.  But good luck with getting anything changed this year!  Perhaps post the request in Sage City?  I have heard that "key" personnel read that paper everyday.  The question is, is it the front page or the comics?  Dilbert does come to mind.  Do you call out Cody @ Scanco?  He posted an open letter the other day for people to contact him with issues.  But he is in charge of all things sales.  How is this fix going to increase his top line?  Good luck with that!

And then there's Maude, er the Mod Squad.  No, not those hipster cats from the late sixties/early seventies seen these days on TVLand, but 90M's very own.  Rumor has it (unless your attended MOTM earlier this year and sat in on the session) that there is a "secret" (ok, not well publicized) gang of wiz bang tech guru members who have a direct line red phone to the Commissioner (or is it a telephone booth to Sage CONTROL).  Again, this is all rumor (as I did not attend MOTM).  Who is on this team of black ops specialist?  What is their mission?  Is their role to be designer's in Q's lab, dreaming up cool tools for James to use in his fight against the bad Vlads of the world or are they break/fix specialists whose mission is to become more like the Maytag repairman?  For now, only the Shadow knows.......

Stay tuned for scenes from next week's episode!

Help us Obi-Wan Kenobi.

------------------------------
Jeff Schwenk
FORMER 90M Board Member
Bottomline Software, Inc.
Waynesboro VA
540-221-4444


Original Message:
Sent: 05-07-2020 00:32
From: David Speck II
Subject: Importing work tickets (Production Management)

Looks like someone dropped the ball and i have no idea who to point the finger at.
Looking at the object handles available in Work Ticket Entry, the header object has 3 object handle properties that stand out, while on the "Steps" tab, "Lines" and "Steps" have the same handle whereas while on the "Materials" tab, "Lines" and "Parts" have the same handle.
This was taken while on the Steps tab.

This was taken while on the Materials tab.

I would expect the VI import to function similar to a framework level Bill of Materials import, where importing into BM_BillHeader allows you to also import into BM_BillDetail, BM_BillOptionCategory, BM_BillOptionHeader, and BM_BillOptionDetail where each table has a different record type prefix.
In theory, it is probably possible to hack together some perform logic to handle the Steps through the coBusiness'Steps handle using either the IMP$[x] variables or temp fields to read the values.
Either Scanco or Sage need to step up and specify whether or not we can expect to be able to import work tickets through stock VI.

------------------------------
David Speck II
Tennessee Software Solutions

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898
------------------------------

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well. 

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898
------------------------------

Thanks for the update, guess I must have an old build installed too. Good to know that is resolved at least.
When I get a chance, I'm going to see if there are any methods available to coBusiness that can copy the materials from the bills. If something exists, might be able to accomplish this with a simple perform logic.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 05-07-2020 19:58
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well.

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898

Regarding "The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!"

I got this back from Scanco:

"Currently it is not coded to do that.  We drastically change the UI from WO to work differently.  Operations management we have modified to do that but it was not in the original spec for PM.   I have added it to the list to see if we can add it in 2020.  Will keep you posted."

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------

Original Message:
Sent: 05-07-2020 19:58
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well.

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898

Thank you @RobertWood​

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-08-2020 10:19
From: Robert Wood
Subject: Importing work tickets (Production Management)

Regarding "The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!"

I got this back from Scanco:

"Currently it is not coded to do that.  We drastically change the UI from WO to work differently.  Operations management we have modified to do that but it was not in the original spec for PM.   I have added it to the list to see if we can add it in 2020.  Will keep you posted."

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898
------------------------------


Original Message:
Sent: 05-07-2020 19:58
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well.

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898

I haven't upgraded to the latest build yet so i haven't been able to test this is VI but i did find a method that is part of the Parts detail bus called CopyBillDetail. Was a PITA figuring out how many arguments it expected and what it expects in said arguments but without any documentation on it, a whole lot of trial and error, and reviewing forced crash dumps, i found that it accepts 5 arguments.

1. BillNo
2. RevisionNo
3. OptionList: i believe this is the same "option list" used elsewhere, like in sales order entry or BoM production entry. Refer to image added that shows the bill option joined together as a comma delimited list, two spaces represent an option that is left blank.
4. ExplodeSubAssemblies: i believe this expects a Y or a N.
5. DestinationStepKey: if you don't know the step key but know the step number, i found another method that is part of the Steps detail bus called GetStepLineKey$. It returns the line key, as a string, for the step number passed as the first and only argument. It expects the step number passed to it to be a 6 character long string.

The CopyBillDetail method will return a 1 if successful and a 0 if unsuccessful.

Here is an example of the bill options string.


I was able to successfully copy a bill to the parts tab from the command window using the method. Here is an example of it being used from the command window.

So i don't know how you plan to structure your source file for your work ticket import but you should be able to use a post read perform logic to execute the method and use the IMP$[x] (replace the "x" with the column number) variables that represent columns in your source file passed as arguments to the method.
You could even add a numeric temp field to the import after the last header field and set it to calculated and use the method as the calculation. Doing it this way will write the result of the method to the temp field so you can review whether or not it succeeded when viewing the vi job log.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

Original Message:
Sent: 05-08-2020 11:02
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you @RobertWood​

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------


Original Message:
Sent: 05-08-2020 10:19
From: Robert Wood
Subject: Importing work tickets (Production Management)

Regarding "The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!"

I got this back from Scanco:

"Currently it is not coded to do that.  We drastically change the UI from WO to work differently.  Operations management we have modified to do that but it was not in the original spec for PM.   I have added it to the list to see if we can add it in 2020.  Will keep you posted."

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 19:58
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well.

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898

Thank you @DavidSpeckII  I was impressed by the work, but alas, this is outside of my skillset.  I haven't worked much with perform logic, so am unsure of some of the syntax and placements
​

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON
------------------------------

Original Message:
Sent: 05-09-2020 01:33
From: David Speck II
Subject: Importing work tickets (Production Management)

I haven't upgraded to the latest build yet so i haven't been able to test this is VI but i did find a method that is part of the Parts detail bus called CopyBillDetail. Was a PITA figuring out how many arguments it expected and what it expects in said arguments but without any documentation on it, a whole lot of trial and error, and reviewing forced crash dumps, i found that it accepts 5 arguments.

1. BillNo
2. RevisionNo
3. OptionList: i believe this is the same "option list" used elsewhere, like in sales order entry or BoM production entry. Refer to image added that shows the bill option joined together as a comma delimited list, two spaces represent an option that is left blank.
4. ExplodeSubAssemblies: i believe this expects a Y or a N.
5. DestinationStepKey: if you don't know the step key but know the step number, i found another method that is part of the Steps detail bus called GetStepLineKey$. It returns the line key, as a string, for the step number passed as the first and only argument. It expects the step number passed to it to be a 6 character long string.

The CopyBillDetail method will return a 1 if successful and a 0 if unsuccessful.

Here is an example of the bill options string.

I was able to successfully copy a bill to the parts tab from the command window using the method. Here is an example of it being used from the command window.

So i don't know how you plan to structure your source file for your work ticket import but you should be able to use a post read perform logic to execute the method and use the IMP$[x] (replace the "x" with the column number) variables that represent columns in your source file passed as arguments to the method.
You could even add a numeric temp field to the import after the last header field and set it to calculated and use the method as the calculation. Doing it this way will write the result of the method to the temp field so you can review whether or not it succeeded when viewing the vi job log.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------


Original Message:
Sent: 05-08-2020 11:02
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you @RobertWood​

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-08-2020 10:19
From: Robert Wood
Subject: Importing work tickets (Production Management)

Regarding "The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!"

I got this back from Scanco:

"Currently it is not coded to do that.  We drastically change the UI from WO to work differently.  Operations management we have modified to do that but it was not in the original spec for PM.   I have added it to the list to see if we can add it in 2020.  Will keep you posted."

------------------------------
Robert Wood
DDF Consulting Group, Inc.
Ocala FL
352-615-5898


Original Message:
Sent: 05-07-2020 19:58
From: Robert White
Subject: Importing work tickets (Production Management)

Thank you all for your input.  With a bit of egg on my face, I confess I was using a build from Oct 2019 and should have been using the build from Apr 2020.   Once that got figured out, I was able to import new work tickets.  Scanco provided screen shots of the 'data' tab for the VI job to Sage support and they 'read' them off to me on the phone and what was being read was not on my screen​, so I reinstalled with latest downloads and all was well.

The one thing that still can't be figured out is how to import a new work ticket and have materials auto loaded from the bill of materials.  The UI does it (by clicking Import From | Bill of Materials) but I can't see to get it as part of the import.  If anyone has guidance on that one, I would be all ears!

Thanks, Robert

------------------------------
Robert White
Munjal White Consulting Co.
Toronto ON


Original Message:
Sent: 05-07-2020 14:17
From: Robert Wood
Subject: Importing work tickets (Production Management)

@Robert White, I've moved your post to the Sage 100 community since it went way off the rails and it sounds like you got your answers. Let me know if you would like me to put it back. ​

------------------------------
Robert Wood
Consultant
90 Minds, Inc.
Ocala FL
352-615-5898