HI Mr_Mayor can you please help me with some more information so I can try re-creating the issue?

• Did you add the Optional Field against Orders or Order Details?
• Is the error occuring when you try to print an OE Order displaying the Optional Field where it prints on the Classic Desktop but not on the Web Screens?
  OR
  Does the error occuring when you try to open the OE Order screen in the web?
• What version and Product Update are you running?

Please re-create the error then open the relevant log file located (for exaple): \\Sage300Server\Sage300Share\Sage300Apps\Online\Web\Logs

Good luck!

hi 

i created an optional field under Common Services of type txt validate and allow blank

went in to the IC items and put the code with auto insert yes allowed no

went to OE setup and put the optional field in Shipment details and Invoice details with auto insert and required yes

the oeinv01.rpt linked the OEINVDO linking INVUNIQ and LINENUM

the invoice begins at Shipment entry 

to answer your question, OE invoice printing on classic prints ok, but when i try to do the same on web it throws that error. 

NB. there are no serial numbers, BOMs or Lots. just pure Inv

the web error logs throws this 

----------------------------------------
Timestamp: 3/21/2025 11:11:25 AM

Message: Information-[Tenant:] [Company:] [Module:REPORT] [User:] - >>>>>>>>>>>>>>>>21008 started >>>>>>>>>>>>>>>>

Machine Name: SERV61

----------------------------------------
----------------------------------------
Timestamp: 3/21/2025 11:11:25 AM

Message: Information-[Tenant:] [Company:] [Module:REPORT] [User:] - [21008] COMMAND LINE:["2" "QzpcV2luZG93c1xTeXN0ZW1UZW1wXHRtcDlEQTIudG1w" "R0ZTWklH" "QURNSU4=" "U2dWa1lwM3M2djl5JEImRSlIQE1jUWZUaldtWnE0dDc=" "WXh3dkp5dHIyUHRwQXAyQkNWT1VsL0F6MFpKWWtaUUdxZElmNFZJZ29hbWJsRldRZUM4cGNRQmhzTGMyWDR6Wjc3RGNTYXF3azd2a0c5Q0xMdHBjL2Rab29lbkVubXR6RHB4ZXdOeUEvTHpOUHFCeU11Qlo2cDlQL3NmTTc4RkdjZmEvelJRRmFscG5jckxha3FDR0dUUlhmZ2VHWkx5cDgxb3k5KzdIdmJicjVoSHBvTmZMaGtzK1g3SURpNlpj" "NzFB" "T0VJTlYwMVtPRUlOVjAxLlJQVF0=" "NQ==" "RmFsc2U=" "MA==" "MA==" "T0UxNDAw" "PE1FTlUgSUQ+" "MjA=" "ZW4=" "U09SVEZST00=&SU4wMDAwMDEyOTkz&U09SVFRP&SU4wMDAwMDEyOTkz&UFJJTlRFRA==&MQ==&REVMTUVUSE9E&MQ==&RUNFTkFCTEVE&MA==&RElSRUNURUM=&MA==&UVRZREVD&NA==&Qk9JVEVN&MQ==&U1dERUxNRVRIT0Q=&Mw==&U0VSSUFMTE9UTlVNQkVSUw==&MA==&UFJJTlRLSVQ=&MA==&UFJJTlRCT00=&MA==&UkVUQUlOQUdF&MA==&SURTRUxFQ1Q=&KCh7T0VJTlZILklOVk5VTUJFUn0gPj0gIklOMDAwMDAxMjk5MyIpIEFORCAoe09FSU5WSC5JTlZOVU1CRVJ9IDw9ICJJTjAwMDAwMTI5OTMiKSk="]

Machine Name: SERV61

----------------------------------------
----------------------------------------
Timestamp: 3/21/2025 11:11:25 AM

Message: Information-[Tenant:] [Company:] [Module:REPORT] [User:] - [21008] PARAMETERS:[Report Name:[OEINV01[OEINV01.RPT]] Export Filename:[C:\Windows\SystemTemp\tmp9DA2.tmp] Company:[GFSZIG] ReportFormat:[PortableDocFormat] UsePageRange:[False] FirstPage:[0] LastPage:[0] TimeOutInMinutes:[20] Regular Report Parameters:[ SORTFROM:IN0000012993 SORTTO:IN0000012993 PRINTED:1 DELMETHOD:1 ECENABLED:0 DIRECTEC:0 QTYDEC:4 BOITEM:1 SWDELMETHOD:3 SERIALLOTNUMBERS:0 PRINTKIT:0 PRINTBOM:0 RETAINAGE:0 IDSELECT:(({OEINVH.INVNUMBER} >= "IN0000012993") AND ({OEINVH.INVNUMBER} <= "IN0000012993"))]

Machine Name: SERV61

----------------------------------------
----------------------------------------
Timestamp: 3/21/2025 11:11:30 AM

Message: Information-[Tenant:] [Company:] [Module:REPORT] [User:] - <<<<<<<<<<<<<<<<21008 ended <<<<<<<<<<<<<<<<

Machine Name: SERV61

----------------------------------------

Hi Mr_Mayor thanks for the reply.  I went through and re-created the problem (added all the optional fields + a new order, shipment and OE invoice with the Optional Field auto inserted) which is that OEINV01.RPT is a datapipe report.  Initially when creating the link/joins "OEINVDO linking INVUNIQ and LINENUM" I received the following problems:

Crystal

Printing the OE Invoice in Web

Printing in the Classic Screens:

Changing the RDO Database Connection in Crystal to use Trusted (Windows Auth) connection, then add the Windows Account to SQL, which fixes it in the Desktop:

But the problem is the Web Screens do not support Windows Auth. So your options to try and solve it are:

1. Try adding CSCOM table into your report i.e. OEINV01.RPT -> Database Links: OEINPR3 -> CSCOM -> <something in between> -> OEINVDO so that the Web Screens can authenticate with the report.
   1. Or probably better...
2. Modify OEINV03.RPT, OEINV04.RPT, OEINV05.RPT into looking how you need.  These are normal database table reports containing CSCOM and will work with the web screens after adding additional tables in.  

Note, no matter what you do, either modifying OEINV01.RPT or using OEINV03-05.RPT, the report will run slower because of adding things in.  Also, you may want to add the Optional Field into a database view or similar view to prevent all OE Invoice Details Optional Fields displaying on your report instead of just the one you want.

In conclusion, I recommend re-working OEINV03.RPT, OEINV04.RPT or OEINV05.RPT to solve the problem.  Good luck!

Hi Tim - Accsys Consulting 

thank your for the write ups. That’s exactly what I faced step by step. I even tried commenting out the datapipes to use report I think it’s OEINV02. The issue was with sub reports. It kept throwing the parameters screen when trying to print on classic

when I commented out I could tell the BOMs and Lot/Serial numbers sub reports were the ones throwing parameter pop ups on classic.

 I'm not sure if there is a separate oerpt.ini equivalent for sub reports. 

NB. When replying using the phone browser I noted there isn’t a reply option direct to the thread or to your answer.  

Hi Mr_Mayor the subreports aren't datapipes so I don't think they will have an INI file (I could be wrong).  Good thinking though, you might be able to solve it by placing the optional field in a subreport and carefully working it into where you need it to display (I know this can be very painful to get cosmetically right but likely a better option than placing it in the main report).  Otherwise if you really want the Optional Field in the main report, making CSCOM an active part of the joins might work however I suspect you will need to use OE Invoice 03 to 05.  Good luck and keep us updated.

hi

i went the datapipe route, commented out the datapipes, used oeinv04

same problem, on classic it prints okay, on web it doesn't print at all.

returns same error

Hi Mr_Mayor unfortunately with the limited authentication options for Web Crystal reports, I'm not sure how you're going to get around this with a datapiped report.  Are the Sage 300 Web Screens installed on the same server as SQL?  If so I just had the idea you could try granting the local machine IIS User (or LocalSystem if that's what the AppPool identity is) Local Security status in SQL Server then try mapping db_datareader permissions or higher to the Sage 300 database  That could be a wild security vulnerability though so you need to think through the security ramifications if it actually works - which it may not.  This could be a waste of time, and it might be watching the SQL Activity Monitor to see all accounts trying to access the database while runnining the report...but I guess if you want to solve this you might need to go way outside the box.  Good luck!