Sage 100

Tara,

I can help a little bit. I have a client that we are in the process of converting also – luckily they do not print materials on the traveler, but I could duplicate what you are seeing and I think I see why.  The work tickets that converted from work order module do not seem to have a record in the JT_WorkTicketHistoryDetail Table. That must be a bug.  I'm looking at Sage 100 premium 6.20.2 I checked the KB briefly and didn't see this noted, but it might be out there somewhere.

Once I realized the records were missing, I brought up one of those converted work tickets in work ticket Entry > went to the materials tab. Then I put a dot in the comment field for each line on the work ticket. That forced the detail record to be written to the JT_WorkTicketHistoryDetail table and then when I printed the traveler the materials all showed up.

I'm not sure if that helps much, not knowing how many work tickets you have, or lines per work ticket. If the numbers are small, that might be a workaround.  Fortunately my client does not need to print materials so I'm off the hook - they have thousands of open work tickets with hundreds of lines on each WT.

Tara,

I can help a little bit. I have a client that we are in the process of converting also – luckily they do not print materials on the traveler, but I could duplicate what you are seeing and I think I see why.  The work tickets that converted from work order module do not seem to have a record in the JT_WorkTicketHistoryDetail Table. That must be a bug.  I'm looking at Sage 100 premium 6.20.2 I checked the KB briefly and didn't see this noted, but it might be out there somewhere.

Once I realized the records were missing, I brought up one of those converted work tickets in work ticket Entry > went to the materials tab. Then I put a dot in the comment field for each line on the work ticket. That forced the detail record to be written to the JT_WorkTicketHistoryDetail table and then when I printed the traveler the materials all showed up.

I'm not sure if that helps much, not knowing how many work tickets you have, or lines per work ticket. If the numbers are small, that might be a workaround.  Fortunately my client does not need to print materials so I'm off the hook - they have thousands of open work tickets with hundreds of lines on each WT.

So – when I did a deep dive into the history table, it looks like when the data converted from work order, it didn't populate the history tables at all. Any thoughts as to why that would happen?

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

Tara,

I can help a little bit. I have a client that we are in the process of converting also – luckily they do not print materials on the traveler, but I could duplicate what you are seeing and I think I see why.  The work tickets that converted from work order module do not seem to have a record in the JT_WorkTicketHistoryDetail Table. That must be a bug.  I'm looking at Sage 100 premium 6.20.2 I checked the KB briefly and didn't see this noted, but it might be out there somewhere.

Once I realized the records were missing, I brought up one of those converted work tickets in work ticket Entry > went to the materials tab. Then I put a dot in the comment field for each line on the work ticket. That forced the detail record to be written to the JT_WorkTicketHistoryDetail table and then when I printed the traveler the materials all showed up.

I'm not sure if that helps much, not knowing how many work tickets you have, or lines per work ticket. If the numbers are small, that might be a workaround.  Fortunately my client does not need to print materials so I'm off the hook - they have thousands of open work tickets with hundreds of lines on each WT.

So – when I did a deep dive into the history table, it looks like when the data converted from work order, it didn't populate the history tables at all. Any thoughts as to why that would happen?

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

Alan,

That is correct that work order history is not converted, but in Production Management, whenever a work ticket is created, then work ticket history is immediately populated including JT_WorkTicketHistoryHeader, JT_WorkTicketHistoryDetail, and JT_WorkTicketHistoryStep. (much like Sales order and Sales Order History acts).  So they history tables should have all the open work tickets that were converted.

Tara,

In work order module setup. Is the flag on the main tab for Retain Work Order Transaction Detail turned off?  I don't know if that would cause it or not, but just wondering.  

Ok – here is where I really need some help/answers. The Work Orders I converted are live/released work orders. In the JT_WorkTicketHistoryDetail, none of the information in the work order came over (this looks to be all inventory that goes in here from what I can see). I did a prior conversion about 2 months back and it looks like that worked back then.

Note – all of the inventory for these work orders have been issued and each work order is set to auto-issue materials. The challenge I'm having is that none of the materials from these work orders prints on the Work Order traveler or the picking sheet.

I honestly just want to know if I let this go, how big of an issue is it. The customer went live today in everything else so I cannot hold off having them wait much longer on using this and since it's 64 work orders, I'm trying to figure out if it's worth the work of going through this again.

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

Alan,

That is correct that work order history is not converted, but in Production Management, whenever a work ticket is created, then work ticket history is immediately populated including JT_WorkTicketHistoryHeader, JT_WorkTicketHistoryDetail, and JT_WorkTicketHistoryStep. (much like Sales order and Sales Order History acts).  So they history tables should have all the open work tickets that were converted.

Tara,

In work order module setup. Is the flag on the main tab for Retain Work Order Transaction Detail turned off?  I don't know if that would cause it or not, but just wondering.  

So – when I did a deep dive into the history table, it looks like when the data converted from work order, it didn't populate the history tables at all. Any thoughts as to why that would happen?

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

Tara,

I can help a little bit. I have a client that we are in the process of converting also – luckily they do not print materials on the traveler, but I could duplicate what you are seeing and I think I see why.  The work tickets that converted from work order module do not seem to have a record in the JT_WorkTicketHistoryDetail Table. That must be a bug.  I'm looking at Sage 100 premium 6.20.2 I checked the KB briefly and didn't see this noted, but it might be out there somewhere.

Once I realized the records were missing, I brought up one of those converted work tickets in work ticket Entry > went to the materials tab. Then I put a dot in the comment field for each line on the work ticket. That forced the detail record to be written to the JT_WorkTicketHistoryDetail table and then when I printed the traveler the materials all showed up.

I'm not sure if that helps much, not knowing how many work tickets you have, or lines per work ticket. If the numbers are small, that might be a workaround.  Fortunately my client does not need to print materials so I'm off the hook - they have thousands of open work tickets with hundreds of lines on each WT.

Ok – here is where I really need some help/answers. The Work Orders I converted are live/released work orders. In the JT_WorkTicketHistoryDetail, none of the information in the work order came over (this looks to be all inventory that goes in here from what I can see). I did a prior conversion about 2 months back and it looks like that worked back then.

Note – all of the inventory for these work orders have been issued and each work order is set to auto-issue materials. The challenge I'm having is that none of the materials from these work orders prints on the Work Order traveler or the picking sheet.

I honestly just want to know if I let this go, how big of an issue is it. The customer went live today in everything else so I cannot hold off having them wait much longer on using this and since it's 64 work orders, I'm trying to figure out if it's worth the work of going through this again.

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

Alan,

That is correct that work order history is not converted, but in Production Management, whenever a work ticket is created, then work ticket history is immediately populated including JT_WorkTicketHistoryHeader, JT_WorkTicketHistoryDetail, and JT_WorkTicketHistoryStep. (much like Sales order and Sales Order History acts).  So they history tables should have all the open work tickets that were converted.

Tara,

In work order module setup. Is the flag on the main tab for Retain Work Order Transaction Detail turned off?  I don't know if that would cause it or not, but just wondering.  

So – when I did a deep dive into the history table, it looks like when the data converted from work order, it didn't populate the history tables at all. Any thoughts as to why that would happen?

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104

So – when I did a deep dive into the history table, it looks like when the data converted from work order, it didn't populate the history tables at all. Any thoughts as to why that would happen?

Tara Morgan Schinkel, CPA
Stewart Technologies, Inc.

Sage 100 Certified Consultant

Act!/Sage CRM Certified Consultant

785 Elkridge Landing Road, Suite 150

Linthicum, MD 21090

410 – 309 – 9550 x1104