Sage 100

A client brought to my attention that if they change a bill option description in Bill of Materials Maintenance, then reprint a previously posted invoice, the bill option description will print as the NEW value rather than the value at invoice posting time. I was able to replicate this in my system. I'm planning to overcome this by creating 9 UDF fields in SO_InvoiceDetail that read the bill option descriptions at the time the invoice is created, then pass those UDF fields to the printed invoice forms and to AR Invoice History. My question is: has anyone encountered this before? It sounds like a bug to me...but I haven't been able to find anything on it, which is surprising. I would like to get any feedback anyone has before reporting to Sage.

TIA!


------------------------------
Susan Pawlowic
Consultant
RKL eSolutions, LLC
------------------------------

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing / reprinting and pull from the Options tables and do not get stored in SO_InvoiceDetail at the time of original data entry. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------

Actually that wouldn't be so bad.  The real issue is that when you reprint an invoice (no matter how old the invoice), the new bill optoin descriptions print.  So if you sell a widget today and bill option 1's description is white; then two years later you change bill option 1's description to red; if you reprint that two-year-old invoice, it will print red.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-13-2020 13:43
From: Alnoor Cassim
Subject: Bill Option Descriptions

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing and pull from the Options tables and do not get stored in SO_InvoiceDetail. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA
------------------------------

Would having the forms in Paperless Office be a better solution?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Original Message:
Sent: 10-13-2020 13:51
From: Susan Pawlowic
Subject: Bill Option Descriptions

Actually that wouldn't be so bad.  The real issue is that when you reprint an invoice (no matter how old the invoice), the new bill optoin descriptions print.  So if you sell a widget today and bill option 1's description is white; then two years later you change bill option 1's description to red; if you reprint that two-year-old invoice, it will print red.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 10-13-2020 13:43
From: Alnoor Cassim
Subject: Bill Option Descriptions

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing and pull from the Options tables and do not get stored in SO_InvoiceDetail. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA

I wouldn't have believed it had I not seen it with my own eyes, but the PDFs, when accessed from Customer Inquiry, are appearing with the new bill option descriptions as well.  I had to back away from the computer (slowly) at that point.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------

Original Message:
Sent: 10-13-2020 14:13
From: Michelle Taylor
Subject: Bill Option Descriptions

Would having the forms in Paperless Office be a better solution?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------


Original Message:
Sent: 10-13-2020 13:51
From: Susan Pawlowic
Subject: Bill Option Descriptions

Actually that wouldn't be so bad.  The real issue is that when you reprint an invoice (no matter how old the invoice), the new bill optoin descriptions print.  So if you sell a widget today and bill option 1's description is white; then two years later you change bill option 1's description to red; if you reprint that two-year-old invoice, it will print red.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-13-2020 13:43
From: Alnoor Cassim
Subject: Bill Option Descriptions

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing and pull from the Options tables and do not get stored in SO_InvoiceDetail. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA

Super creepy...just in time, or right in line, for Halloween 2020

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772
------------------------------

Original Message:
Sent: 10-13-2020 14:18
From: Susan Pawlowic
Subject: Bill Option Descriptions

I wouldn't have believed it had I not seen it with my own eyes, but the PDFs, when accessed from Customer Inquiry, are appearing with the new bill option descriptions as well.  I had to back away from the computer (slowly) at that point.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 10-13-2020 14:13
From: Michelle Taylor
Subject: Bill Option Descriptions

Would having the forms in Paperless Office be a better solution?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-13-2020 13:51
From: Susan Pawlowic
Subject: Bill Option Descriptions

Actually that wouldn't be so bad.  The real issue is that when you reprint an invoice (no matter how old the invoice), the new bill optoin descriptions print.  So if you sell a widget today and bill option 1's description is white; then two years later you change bill option 1's description to red; if you reprint that two-year-old invoice, it will print red.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-13-2020 13:43
From: Alnoor Cassim
Subject: Bill Option Descriptions

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing and pull from the Options tables and do not get stored in SO_InvoiceDetail. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA

Are they reprinting the invoices?  There's a setup option in Paperless / Form Maintenance to Keep Only the Last Copy.  Make sure that's not turned on if they're reprinting invoices.

------------------------------
Mary Jo Krueger
Senior Software Consultant
CLA (CliftonLarsonAllen LLP)
Appleton WI
920-996-1176
------------------------------

Original Message:
Sent: 10-13-2020 14:18
From: Susan Pawlowic
Subject: Bill Option Descriptions

I wouldn't have believed it had I not seen it with my own eyes, but the PDFs, when accessed from Customer Inquiry, are appearing with the new bill option descriptions as well.  I had to back away from the computer (slowly) at that point.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC
------------------------------


Original Message:
Sent: 10-13-2020 14:13
From: Michelle Taylor
Subject: Bill Option Descriptions

Would having the forms in Paperless Office be a better solution?

------------------------------
Michelle Taylor
ERP Consulting Manager, CS3 Technology
918-388-9772


Original Message:
Sent: 10-13-2020 13:51
From: Susan Pawlowic
Subject: Bill Option Descriptions

Actually that wouldn't be so bad.  The real issue is that when you reprint an invoice (no matter how old the invoice), the new bill optoin descriptions print.  So if you sell a widget today and bill option 1's description is white; then two years later you change bill option 1's description to red; if you reprint that two-year-old invoice, it will print red.

------------------------------
Susan Pawlowic
consultant
RKL eSolutions, LLC


Original Message:
Sent: 10-13-2020 13:43
From: Alnoor Cassim
Subject: Bill Option Descriptions

I haven't run into it myself but you're correct that the Option descriptions are generated at the time of invoice printing and pull from the Options tables and do not get stored in SO_InvoiceDetail. So one place you can check to see if people have run into this is the ideas site: https://www5.v1ideas.com/TheSageGroupplc/Sage100ERP

------------------------------
Alnoor Cassim

Email: alnoor@asifocus.com
Ph: 949-689-9887
Orange County, CA