E1-OTM Integration (Full)

 

 

Step

Action

1. 

Sign in to EnterpriseOne as jde/jde

 

Enter the desired information into the User ID: field. Enter a valid value e.g. "jde".

2. 

Enter the desired information into the Password: field. Enter a valid value e.g. "jde".

3. 

Click the Sign In button.

4. 

Fast Path: E1OTM

 

Enter the desired information into the Fast Path field. Enter a valid value e.g. "e1otm".

5. 

Click the Fast Path button.

6. 

Click the Daily Processing button.

7. 

Click the Sales Order Processing button.

8. 

Click the Sales Order Entry link.

9. 

Click the Add button.

10. 

Create a new sales order as:

Customer = 59303

B/P = 28004

 

Enter the desired information into the Sold To field. Enter a valid value e.g. "59303".

11. 

Enter the desired information into the Ship To field. Enter a valid value e.g. "59303".

12. 

Enter the desired information into the Branch/Plant field. Enter a valid value e.g. "28004".

13. 

Order 15000 of item 726698M for 5 June

 

Click in the Quantity Ordered field.

14. 

Enter the desired information into the Quantity Ordered field. Enter a valid value e.g. "15000".

15. 

Enter the desired information into the Item Number field. Enter a valid value e.g. "726698M".

16. 

Enter the desired information into the Requested Date field. Enter a valid value e.g. "6/5/12".

17. 

Note the Sales Order Number (18020).  This will be needed in subsequent transactions

18. 

Shop for a carrier & rate

 

Click the Go To list.

19. 

Click the Rate Shopping list item.

20. 

Click the Go button.

21. 

Select a rate & carrier from the values displayed

 

Click the option.

22. 

Click the Save and Continue button.

23. 

Click the Submit and Close button.

24. 

Click the Close button.

25. 

Create a Freight Request to be sent to OTM

 

Click the Freight Request link.

26. 

Click the Data Selection option.

27. 

Click the Submit button.

28. 

Click the Where list.

29. 

Click the Literal list item.

30. 

Enter the sales order number from earlier.

 

Enter the desired information into the Literal Value field. Enter "18020".

31. 

Click the OK button.

32. 

Click the OK button.

33. 

Click the OK button.

34. 

Communication from E1 to OTM is pushed via a Remote Desktop Server.

 

Click the Remote Desktop button.

35. 

Use the OTMPostSubmit function to transfer the file to OTM.

 

The Freight Request uses transaction type FR

 

Close the box when it has completed.

 

Then minimise the Remote Desktop window.

36. 

Click the Minimize button.

37. 

Next the Sales Order is planned in OTM.

 

Switch to the OTM window.

 

Click the OTM: Oracle Transportation Management button.

38. 

Now log in to OTM as JDEMASTER.PLANNER / WELCOME

 

Enter the desired information into the field. Enter a valid value e.g. "JDEMASTER.PLANNER".

39. 

Enter the desired information into the field. Enter a valid value e.g. "WELCOME".

40. 

Click in the Login field.

41. 

Navigate to the Sales Order from E1 ...

 

Click the Order Management link.

42. 

Click the Order Release link.

43. 

Click the Order Release link.

44. 

Enter the E1 Order number.

 

Ensure that the search type is "begins with".

 

Enter the desired information into the field. Enter a valid value e.g. "18020".

45. 

Click the Search link.

46. 

Click the JDEMASTER.18020_S8_00001-1 link.

47. 

Notice that the Dates & Locations have come across from E1.

48. 

Click the Line Item link.

49. 

Note the shipment line information.

50. 

First create a Sell Shipment in OTM - this creates the Freight line in E1.

 

Click the Actions link.

51. 

Click the OK button.

52. 

Click the graphic.

53. 

Click the Direct list item.

54. 

Click the Ok link.

55. 

Click the Close Window graphic.

56. 

Next create a Buy Shipment - this creates the shipment to pass back to E1.

 

Click the Actions link.

57. 

Click the OK button.

58. 

Click the graphic.

59. 

Click the Direct list item.

60. 

Click the Ok link.

61. 

This is the Shipment Summary.

 

Note the Shipment ID (04927), Cost, Carrier & Transport Mode.

 

62. 

Now that there is a Shipment the 'Resources' have to be secured from the load carrier.

 

Click the 04927 link.

63. 

First Secure the Resources - this notifies the carrier that there is a load for them.

 

Click the Actions link.

64. 

Click the graphic.

65. 

Click the Secure Resources list item.

66. 

Click the Close Window graphic.

67. 

Then Accept the Tender.  This triggers sending information back to E1.

 

Click the Actions link.

68. 

Click the graphic.

69. 

Click the Accept Tender list item.

70. 

Click the Close Window graphic.

71. 

Click the Close button.

72. 

Click the Close Window button.

73. 

Click the Close Window button.

74. 

The next steps are in E1

 

Click the EnterpriseOne button.

75. 

Now that the transportation has been arranged in OTM it is interfaced back into E1.

 

Click the Inbound Processor-Transportation link.

76. 

Click the OK button.

77. 

Review the Sales Order to see the Transportation Planned State.

 

Click the Transportation Planning - Sales Order link.

78. 

Enter the Sales Order Number.

 

Enter the desired information into the Line Number field. Enter a valid value e.g. "18020".

79. 

Enter the desired information into the Company No field. Enter a valid value e.g. "1".

80. 

Click the Find button.

81. 

Note that the Transportation Plan State is now TA and the Shipment ID from OTM is now shown (04927)

82. 

Click the Close button.

83. 

Next the Pick Slip is printed.

 

Click the Sales Order Entry link.

84. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "18020".

85. 

Enter the desired information into the Branch/Plant field. Enter a valid value e.g. "*".

86. 

Click the Find button.

87. 

Select the row(s) ...

 

Click the Row option.

88. 

Click the Print Pick Slip button.

89. 

Click the OK button.

90. 

Click the Close button.

91. 

Confirm the shipment

 

Click the Confirm Shipments link.

92. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "18020".

93. 

Enter the desired information into the Branch/Plant field. Enter a valid value e.g. "*".

94. 

Click the Find button.

95. 

Click the Form button.

96. 

Click the Confirm Shown Rows menu.

97. 

Click the OK button.

98. 

Click the Close button.

99. 

Now confirm to OTM that the sales order has shipped.

 

Click the Sales Order Confirmation link.

100. 

Click the Data Selection option.

101. 

Click the Submit button.

102. 

Click the Where list.

103. 

Click the Literal list item.

104. 

Enter the Sales Order number

 

Enter the desired information into the Literal Value: field. Enter a valid value e.g. "18020".

105. 

Click the OK button.

106. 

Click the OK button.

107. 

Click the OK button.

108. 

Transmission to OTM is, again, via the Windows Desktop Server.

 

Click the Windows Desktop Server button.

109. 

Code 'SC' is used to create the Sales Confirmation

 

Press [PrintScreen].

110. 

Click the Minimize button.

111. 

On receipt of the Sales Confirmation record OTM automatically sends the Sell Shipment information (created earlier) back to E1.

 

Confirm that it has been received.

 

Click the External Inbound Transmissions link.

112. 

Click the Show All Transmissions option.

113. 

Click the Find button.

114. 

Here it is.

 

115. 

Click the Cancel button.

116. 

Now the file transmitted from OTM has to be imported.

 

This process imports the billable freight charges from OTM and adds new lines for freight to the Sales Order, so that they can be billed to the Customer.

 

Promised Delivery Date & Time may also be updated by this process.

 

Click the Inbound Processor-Transportation Confirmed link.

117. 

Click the OK button.

118. 

A Sales Invoice is printed for the customer.

 

Click the Sales Invoice link.

119. 

Click the Data Selection option.

120. 

Click the Submit button.

121. 

Click the Document Number list.

122. 

Click the Literal list item.

123. 

Enter the Sales Order number.

 

Enter the desired information into the Literal Value: field. Enter a valid value e.g. "18020".

124. 

Click the OK button.

125. 

Click the OK button.

126. 

Click the OK button.

127. 

The next part of this demonstration concentrates on paying the carrier.

 

A Purchase Order is created in E1 and transmitted to OTM.  This is then matched up to the shipment.  Details are sent back to E1 and 'received' there.  A Purchase Invoice is generated in OTM and is transmitted to E1 where it is imported into the Supplier Ledger.

 

128. 

Close the Sales Order menu & open the Purchase Order menu.

 

Click the Sales Order Processing button.

129. 

Click the Purchase Order Processing button.

130. 

Click the Enter Purchase Orders link.

131. 

Click the Add button.

132. 

Create a Purchase Order for the items transported:

Supplier = 126308

Branch/Plant = 28004

 

Enter the desired information into the Supplier field. Enter a valid value e.g. "126308".

133. 

Enter the desired information into the Branch/Plant field. Enter a valid value e.g. "28004".

134. 

Click the OK button.

135. 

Note the PO Number (11144), it will be used later.

 

Now enter details that match the Sales Order line:

Item = 726698M

Qty = 15000

Date = 5 June

136. 

Enter the desired information into the Item Number field. Enter a valid value e.g. "726698M".

137. 

Enter the desired information into the Quantity Ordered field. Enter a valid value e.g. "15000".

138. 

Enter the desired information into the Matrix Line Number field. Enter a valid value e.g. "6/5/12".

139. 

Click the OK button.

140. 

Click the Close button.

141. 

Prepare the details to send over to OTM.

 

Click the Freight Request link.

142. 

Click the Data Selection option.

143. 

Click the Submit button.

144. 

Click the Where list.

145. 

Click the Literal list item.

146. 

Enter the Purchase Order number

 

Enter the desired information into the Literal Value: field. Enter a valid value e.g. "11144".

147. 

Click the OK button.

148. 

Click the OK button.

149. 

Click the OK button.

150. 

Again, the details are transmitted to OTM via the Desktop Server

 

Click the Windows Desktop Server button.

151. 

The code entered for the Purchase details is 'PR'

 

Press [PrintScreen].

152. 

Click the Minimize button.

153. 

The next steps are in OTM:

 

Click the Oracle Transportation Management button.

154. 

Click the Purchase Order link.

155. 

Click the Order Base Line link.

156. 

Enter the PO number from E1.  (Ensure that the LOV shows 'Begins With')

 

Enter the desired information into the field. Enter a valid value e.g. "11144".

157. 

Click the Search link.

158. 

Click the JDEMASTER.11144-O8-00001-000-1000 link.

159. 

Note:

- Packaged Item ID

- Weight

- Volume

- Source & Destination Locations

 

160. 

Release the PO line

 

Click the New Release Instruction link.

161. 

Enter the ordered quantity from the PO

 

Enter the desired information into the field. Enter a valid value e.g. "15000".

162. 

Click the Save link.

163. 

Click the Finished link.

164. 

Click the Checkbox option.

165. 

Release the full quantity

 

Click the Actions link.

166. 

Click the Release Total Order Amount link.

167. 

Click the 11144-O8-00001-000-001 link.

168. 

Now create the Buy Shipment

 

Click the Actions link.

169. 

Click the graphic.

170. 

Click the Direct list item.

171. 

Click the OK graphic.

172. 

Click the Close Window graphic.

173. 

Click the Close Window graphic.

174. 

The next steps are in E1:

 

Click the JD Edwards EnterpriseOne button.

175. 

Review the Transportation Planned state of the PO

 

Click the Transportation Planning-Purchase Order link.

176. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "11144".

177. 

Click the Find button.

178. 

Note:

- State = FR

- Trans Code = UI

 

179. 

Click the Cancel button.

180. 

Receive the PO

 

Click the Receive Purchase Order link.

181. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "11144".

182. 

Enter the desired information into the Branch/Plant field. Enter a valid value e.g. "*".

183. 

Click the Find button.

184. 

Click the Select button.

185. 

Select the Row(s) to receive

 

Click the Row option.

186. 

Click the OK button.

187. 

Click the Close button.

188. 

Review the changed values on the PO

 

Click the Transportation Planning-Purchase Order link.

189. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "11144".

190. 

Click the Find button.

191. 

Note now:

- State = FR

- Trans Code = CL

 

192. 

Click the Cancel button.

193. 

Now match the receipt lines and create a Voucher

 

Click the Voucher Match link.

194. 

Point to the Add button.

195. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "11144".

196. 

Enter the desired information into the Order Number field. Enter a valid value e.g. "o8".

197. 

Enter the desired information into the Branch/ Plant field. Enter a valid value e.g. "28004".

198. 

Enter the desired information into the Invoice Num. field. Enter a valid value e.g. "12345".

199. 

Click the Form button.

200. 

Click the Receipts To Match menu.

201. 

Select the order line to match

 

Click the Row option.

202. 

Click the OK button.

203. 

Click the OK button.

204. 

Click the Close button.

205. 

Create an invoice & a Voucher in OTM.  These are sent back to E1 as a Payables Invoice

 

Click the Oracle Transportation Management button.

206. 

Click the Transportation Planning and Execution link.

207. 

Click the Shipment Management link.

208. 

Click the Buy Shipments link.

209. 

Enter the shipment number noted previously

 

Enter the desired information into the field. Enter a valid value e.g. "04928".

210. 

Click the Search link.

211. 

Click the option.

212. 

Click the Actions link.

213. 

Create an Invoice

 

Click the graphic.

214. 

Click the Create Invoice link.

215. 

Click the 20120522-0002 link.

216. 

Note:

- Invoice Number

- Amount Due

- Service Provider

 

217. 

Approve the Invoice

 

Click the Actions link.

218. 

Click the Approve Invoice link.

219. 

Expand the entry

 

Click the Expand graphic.

220. 

Note the Shipment cost & Freight charge

 

221. 

Clicking Finish creates the Voucher.  This is then sent to E1 to be imported as a Payables Invoice

 

Click the Finish link.

222. 

Click the Close Window graphic.

223. 

Click the Close Window graphic.

224. 

Back to E1:

 

Click the JD Edwards EnterpriseOne button.

225. 

Click the Purchase Order Processing button.

226. 

Click the Financial/Voucher Process button.

227. 

Verify that the transmission from OTM has arrived

 

Click the External Inbound Transmissions link.

228. 

Click the Show All Transmissions option.

229. 

Click the Find button.

230. 

Here it is

 

231. 

Click the Cancel button.

232. 

Import it

 

Click the Transportation Inbound Voucher link.

233. 

Click the OK button.

234. 

Review the imported transaction

 

Click the Voucher Invoice EDI Cross Reference link.

235. 

Note the EDI Doc Number (113152) for later use

236. 

This is the Supplier's Invoice number

 

237. 

Click the Cancel button.

238. 

Now process it into the Supplier Ledger

 

Click the Batch Voucher Processing link.

239. 

Click the Data Selection option.

240. 

Click the Submit button.

241. 

Click the Where list.

242. 

Click the Literal list item.

243. 

Enter the EDI Batch Number noted earlier

 

Enter the desired information into the Literal Value: field. Enter a valid value e.g. "113152".

244. 

Click the OK button.

245. 

Click the OK button.

246. 

Click the OK button.

247. 

View it in the Supplier's Ledger

 

Click the Supplier Ledger Inquiry link.

248. 

Enter the desired information into the Supplier Number field. Enter a valid value e.g. "131810".

249. 

Click the Find button.

250. 

Select the Voucher just created ...

 

Click the Document Number link.

251. 

... and note that it is for the Invoice number that was just imported

252. 

 

End of Procedure.