Simple DIY Document Email

1
Simple DIY Document E-mail
And Other Useful DIY Utilities.By David
JudgeImplematic Pty Ltd
2
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

3
Simple Document E-mail

• EFT Remittance, Sale Invoice, and AR Statement
• No Modification
• Develop New Document Print UBEs
• SMTP Mail
• JDE.INI
• Peoplesoft Business Function (B0500190)
• Fax via Web

4
E-mail Document Creation

• Target E-mail from Whos Who
• Contact Name from Whos Who.
• Return E-mail as Processing Option on Control
  Job.
  
• Resend Options

5
Target E-mail
6
E-mail Document Despatch

• E-mail Text from UDC Attachment.

7
E-mail Text
8
E-mail Dpcument Example
9
Reprint (E-mail) Advice
10
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

11
Print PDF to PS Translation
12
(No Transcript)
13
Logo on PDF

• Unix Script
• Postscript Printers
• Free Software from Web
• Create a copy of Postscript_Printer filter

14
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

15
Smaller Print Files for WAN

• Postscript Level1 Generic, but very verbose.
• Free Software from Web
• Converts Postscript Level 1 to Postscript Level
  2
  
• 200k files ? 50k
• Create a copy of Postscript_Printer filter

16
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

17
Auto Signatures on Cheques

• Scanned Signature Associated with User Profile
• Payee Control
• Modified Work with Payment Groups
• Capture First and Second Approvals
• Password in Order Hold Information
• Payment Analysis Report Approver Signature
• Logic in Print Filter to Assign Signature
  Location on Cheque
  

18
Auto Signatures on Cheques
19
Auto Cheque Signature
20
Auto Cheque Signature
21
Auto Cheque Signature
22
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

23
Unix System Call

• New Business Function
• New Report to call Business Function with
  Parameters
  
• Can be scheduled with other JDE Jobs
• Run Unix Shell Scripts via this Utility
• Unix Script, SQL script, E-mail, FTP

ReturnInt system(lpDS-szExecutionString)
IntToMathNumeric(ReturnInt, lpDS-mnReturnCode)
24
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

25
Forecast Generation via SQL

• JDE Weekly Forecast Generation 3 Days Plus to
  Process!
  
• R3465 / R34650 (Very Inefficient)
• Replaced with a Simple SQL Extract from F42199
  into F3460
  
• SQL Weekly Forecast Generation 7 MINUTES to
  Process!
  
• Managed Via JDE System Call UBE

26
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

27
Set Processing Options

• Peoplesoft B9090001 retrieve and set Processing
  Options
  
• Set to Client and Server
• Develop New Custom Reports to set Values
• Applications
• Debtors Aging Reports As Of Date
• Allocation Journals GL Date
• Maintenance Work Order Release Thru Date

28
DIY Utilities

• Simple Document E-mail
• Logos on UBE output
• Smaller Postscript UBE output (WAN Environment)
• Signatures on Cheques
• Unix System Call from a UBE
• Forecast Generation via SQL
• Processing Option Update via UBE
• Over Night Processing Queue Management

29
Overnight Queue Mgt
30
Overnight Queue Mgt
31
Overnight Queue Mgt

• New Business Function to Wait / Sleep
• New Table to communicate between Versions
• New Version per Queue
• Maintenance Form for Manual Override

MathNumericToInt(lpDS-mnReceiverWaitSeconds,
iSeconds)
sleep(iSeconds)
32
Overnight Queue Mgt
33
Simple DIY Document E-mail
And other useful utilities.By David
JudgeImplematic Pty Ltd