Job Aid

Topic of the course

This job aid is for helping the user to create transaction within Oracle Receivables module such as AR
Invoice and Letter of Credit.

Introduction
TPM will replace their current sales system with Oracle Order Management, due to this replacement
several current practices might also changes. Along with this replacement process, a new module called
eBusiness Tax also will be implemented to support GST Implementation which will take in place on 1
April 2015.

Since TPM user has using Oracle Receivables since 2006, this manual will only focus on the following
area:
 Generate auto-invoice from Oracle Order Management
 Validating invoice generated from auto-invoice related to GST Implementation
 Letter of credit creation
 Deposit creation

Date Created: December 8, 2014 Page 1

Job Aid

Generate Auto-Invoice from Oracle Order Management

Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Interface Line function.

Note: in daily operation this process will be scheduled in a range of time thus user doesn’t need to run it
manually. Manual request might be needed in certain condition such as:
 Error when running the autoinvoice master program and certain correction need to be done in AR
Invoice Lines.
 A tax invoice need to produce immediately without waiting the schedule

Navigation: TPM_ABS_AR_SU or TPM_IPC_AR_SU > Control > AutoInvoices > Interface Lines

Step Action
1. Once the Interface Lines screen is opened, user will receive a prompt message ‘Find all
records in this folder?’.

In this case, click on to retrieve all available transaction coming from Oracle Order
Management module.

Page 2 Date Created: December 11, 2014

Job Aid

2. User will see some transactions coming from Oracle Order Management in the Interface
Line screen.

Note: only sales order which has ship confirmed status will appear on this screen.

3. Navigate to TPM_ABS_AR_SU or TPM_IPC_AR_SU > Interfaces > Autoinvoice to run

Autoinvoice Master Program request.
4. Select Single Request and click on button to proceed with Submit
Request screen.
5. Select AutoInvoice Master Program for the concurrent request name.

Date Created: December 8, 2014 Page 3

Job Aid

6. Enter the following parameter:

Number of Instances = [automatically defaulted to 1]

Organization = [automatically defaulted to All]
Invoice Source = [select SOM ABS for ABS transaction or SOM
IPC for IPC transaction]
Default Date = [enter default date as today’s date]
Transaction Type = [leave this field blank]
(Low) Bill To Customer Number = [leave this field blank]
(High) Bill To Customer Number = [leave this field blank]
(Low) Bill To Customer Name = [leave this field blank]
(High) Bill To Customer Name = [leave this field blank]
(Low) GL Date = [leave this field blank]
(High) GL Date = [leave this field blank]
(Low) Ship Date = [leave this field blank]
(High) Ship Date = [leave this field blank]
(Low) Transaction Number = [leave this field blank]
(High) Transaction Number = [leave this field blank]
(Low) Sales Order Number = [enter with sales order number if you need to
generate AR Invoice individually]
(High) Sales Order Number = [enter with sales order number if you need to
generate AR Invoice individually]
(Low) Invoice Date = [leave this field blank]
(High) Invoice Date = [leave this field blank]
(Low) Ship To Customer Number = [leave this field blank]
(High) Ship To Customer Number = [leave this field blank]
(Low) Ship To Customer Name = [leave this field blank]
(High) Ship To Customer Name = [leave this field blank]
Base Due Date on Trx Date = [automatically defaulted to Yes]
Due Date Adjustment Days = [leave this field blank]

Page 4 Date Created: December 11, 2014

Job Aid

7. Click on button to return to Submit Request screen.

8. Click on button to execute the request.

9. User may check the request result on the Request screen. Make sure the request status is
Completed – Normal.

Date Created: December 8, 2014 Page 5

Job Aid

Page 6 Date Created: December 11, 2014

Job Aid

Validate AR Invoice from Auto-Invoice Related to GST

Implementation
Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Receivables Transaction function.

Navigation: TPM_ABS_AP_INVOICE_USER or TPM_IPC_AP_INVOICE_USER > Transactions >

Transactions

Step Action
1. From the Transaction screen, click on icon to enter to Find Transactions screen.
Enter the following information into the parameter:

Transaction Date From = [enter with start date for any transactions you would like to
query]
Transaction Date To = [enter with end date for any transactions you would like to
query]
Sources From = [select SOM ABS for ABS transaction or SOM IPC for IPC
transaction]
Sources To = [select SOM ABS for ABS transaction or SOM IPC for IPC
transaction]

2. Click on button to run the query.

Date Created: December 8, 2014 Page 7

Job Aid

3. Transaction Summary screen will appear with all transactions which met the parameter
you entered.
4. Select a transaction then click on button to review the invoice details.

Page 8 Date Created: December 11, 2014

Job Aid

5. Review the following information in the invoice header to make sure it align with TPM
policies and GST Regulation which issued by Royal Malaysian Customs.

Source = [select SOM ABS for ABS transaction or SOM IPC for IPC
transaction]
Number = [automatically populated by system. There will be 4 sets of
sequence number which are ABS Trade, IPC Trade, Non-Trade
and manual invoice]
Class = [automatically populated as Invoice]
Type = [automatically populated based on order type enter in sales
order form. Please refer to the table below for a complete list of
transaction type and order type mapping]
Reference = [automatically populated with delivery order number]
Date = [automatically populated base on invoice date entered in Sales
Order custom form]
GL Date = [automatically populated base on invoice date entered in Sales
Order custom form]
Currency = [automatically populated base on sales order currency]
Bill To = [automatically populated base on sales order accountee]
Commitment = [automatically populated base on guarantee entered at sales
order line]
Payment Terms = [automatically populated base on sales order payment term]
Due Date = [automatically calculated based on payment terms and
transaction date]

6. Click on button to save your works and return to Invoice screen.

No Transaction Type
1 ABS TRADE HOLDING
2 ABS TRADE GRP EXPORT
3 ABS TRADE GRP LOCAL
4 ABS TRADE EXT EXPORT
5 ABS TRADE EXT LOCAL
6 ABS 2ND GRADE
7 ABS SAMPLE
8 ABS SALES RETURN
9 IPC TRADE HOLDING
10 IPC TRADE GRP EXPORT
11 IPC TRADE GRP LOCAL
12 IPC TRADE EXT EXPORT
13 IPC TRADE EXT LOCAL
14 IPC BUYBACK
15 IPC SAMPLE
16 IPC SALES RETURN

Date Created: December 8, 2014 Page 9

Job Aid

7. For transaction in foreign currency, please check the exchange rate information by
accessing menu Tools > Exchange Rate

Note:
 exchange rate date was taken from transaction (invoice) date
 exchange rate type was automatically populated base on exchange rate entered on
sales order

Page 10 Date Created: December 11, 2014

Job Aid

8. Click on button to review tax information generated by system. Make sure

the tax status, rate name and tax rate are populated correctly.

Tax Regime Code = [automatically populated base on tax rule]

Tax = [automatically populated base on tax rule]
Jurisdiction = [automatically populated base on tax rule]
Tax Status = [automatically populated base on tax rule]
Rate Name = [automatically populated base on tax rule]
Rate = [automatically populated base on tax rule]
Tax Amount = [automatically calculated]
Place of Supply = [automatically populated base on tax rule]

9. Click on button to return to Transaction screen.

No Ship To Item Category Tax Status Rate Name

1 Malaysia Standard Rate Item Standard S-SR
2 Malaysia Zero Rate Item Zero Rate S-ZRL
3 Malaysia Deemed Item Standard S-DS
4 Malaysia Out of Scope Items Out of Scope S-OS
5 Overseas - any - Zero Rate S-ZRE

Date Created: December 8, 2014 Page 11

Job Aid

Create Letter of Credit

Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Receivables Transaction function.

Navigation: TPM_ABS_AP_INVOICE_USER or TPM_IPC_AP_INVOICE_USER > Transactions > Letter

of Credit (Enter)

Step Action
1. Review the following information in the invoice header to make sure it align with TPM
policies and GST Regulation which issued by Royal Malaysian Customs.

Source = [select LC ABS for ABS transaction or LC IPC for IPC

transaction]
Number = [enter with LC Number received from customer]
Class = Guarantee
Type = Letter of Credit
Reference = [leave it blank or enter reference number if any]
Entry Date = [enter with entry date]
GL Date = [enter with expected GL Date]
Currency = [enter with letter of credit currency, for local transaction choose
Rate Type = Daily while for overseas choose Rate Type =
Corporate]

Bill To = [select accountee as per letter of credit]

Page 12 Date Created: December 11, 2014

Job Aid

Step Action
Payment Terms = [select payment terms as per letter of credit]
Due Date = [automatically calculated based on payment terms and entry
date]
2. Select to enter additional letter of credit information.

3. In the Transaction Information screen, select TPM Letter of Credit Information as

context value.

Date Created: December 8, 2014 Page 13

Job Aid

4. In the Transaction Information screen, enter additional information related to letter of

credit:

Issuing Bank = [enter issuing bank name as per letter of credit]

Issuing Bank Address = [enter issuing bank address as per letter of credit]
Drawee = [enter drawee bank name as per letter of credit]
Drawee Address = [enter drawee bank address as per letter of credit]
5. Click on button to save your work and return to Transaction screen.

6. Select Distibutions tab to enter remaining letter of credit information

Issuing Date = [enter with letter of credit issuing date]

Expiry Date = [enter with letter of credit expiry date]
Amount = [enter with letter of credit amount]
Item = [leave this field blank]
Memo Line = [leave this field blank]
Description = Generic Commitment

Transaction
Context Value = TPM LC - Document Requirement
Invoice = [enter number of document requires for claim]
Packing List = [enter number of document requires for claim]
Certificate of Inspection = [enter number of document requires for claim]
B/L = [enter number of document requires for claim]
Weight List = [enter number of document requires for claim]
Certificate of BEN = [enter number of document requires for claim]
N.N.B.L = [enter number of document requires for claim]

Page 14 Date Created: December 11, 2014

Job Aid

Certificate of Quality = [enter number of document requires for claim]

Beneficiary Fax = [enter number of document requires for claim]
Certificate of Insurance = [enter number of document requires for claim]
Certificate of Origin = [enter number of document requires for claim]
Fax = [enter number of document requires for claim]
Others = [enter other document requires for claim]
Number of Others Document = [enter number of document requires for claim]

7. Click on button to save your works.

Date Created: December 8, 2014 Page 15

Job Aid

8. Click on button to check the distribution line.

Receivable = [unbilled receivable]

Revenue = [unearned revenue]

Sample:
Receivable: 31.301.0000.140210.000.00000.000
Revenue: 31.301.0000.140210.000.00000.000
9. Click on button to return to Transaction screen.

Page 16 Date Created: December 11, 2014

Job Aid

10. Click on button to enable letter of credit ready for transaction.

Date Created: December 8, 2014 Page 17

Job Aid

Adjust Letter of Credit Remaining Balance

Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Receivables Transaction function.

Navigation: TPM_ABS_AP_INVOICE_USER or TPM_IPC_AP_INVOICE_USER > Transactions > Letter

of Credit (Enter)

Step Action
1. From the Transaction screen, click on icon to enter to Find Transactions screen.
Enter the following information into the parameter:

Transaction Date From = [enter with start date for any transactions you would like to
query]
Transaction Date To = [enter with end date for any transactions you would like to
query]
Class = Guarantee

2. Click on button to run the query.

Page 18 Date Created: December 11, 2014

Job Aid

3. From the Transaction screen, navigate to menu Action > Adjust to enter to adjustment
screen

4. In the Adjustment screen, enter the following information:

Activity Name = INVOICE CANCELLATION

Type = Invoice
Amount = [enter with adjustment amount]
GL Date = [enter with expected adjustment GL Date]
Adjustment Date = [enter with adjustment date]

5. Click on button to return to Transaction screen.

Date Created: December 8, 2014 Page 19

Job Aid

Page 20 Date Created: December 11, 2014

Job Aid

Cancelling Letter of Credit Adjustment

Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Receivables Transaction function.

Navigation: TPM_ABS_AP_INVOICE_USER or TPM_IPC_AP_INVOICE_USER > Transactions > Letter

of Credit (Enter)

Step Action
1. From the Transaction screen, click on icon to enter to Find Transactions screen.
Enter the following information into the parameter:

Transaction Date From = [enter with start date for any transactions you would like to
query]
Transaction Date To = [enter with end date for any transactions you would like to
query]
Class = Guarantee

2. Click on button to run the query.

Date Created: December 8, 2014 Page 21

Job Aid

3. From the Transaction screen, navigate to menu Action > Adjust to enter to adjustment
screen

4. In the Adjustment screen, enter the following information:

Activity Name = COMM OFFSET

Type = Line
Amount = [enter with adjustment amount]
GL Date = [enter with expected adjustment GL Date]
Adjustment Date = [enter with adjustment date]

Page 22 Date Created: December 11, 2014

Job Aid

5. Move to Account, IDs tab to check the distribution account. Make sure this adjustment
using the same revenue distribution account as per initial transaction.
6. Click on button to return to Transaction screen.

Date Created: December 8, 2014 Page 23

Job Aid

Create Deposit (Advance Collection)

Using the TPM_ABS_AR_SU or TPM_IPC_AR_SU responsibility assigned to you, navigate to the
Receivables Transaction function.

Navigation: TPM_ABS_AP_INVOICE_USER or TPM_IPC_AP_INVOICE_USER > Transactions >

Transactions

Step Action
1. Review the following information in the invoice header to make sure it align with TPM
policies and GST Regulation which issued by Royal Malaysian Customs.

Source = DEPOSIT
Number = [enter with LC Number received from customer]
Class = Deposit
Type = TRADE LOCAL DEPOSIT or TRADE EXPORT DEPOSIT
Reference = [leave it blank or enter reference number if any]
Date = [enter with deposit date]
GL Date = [enter with expected GL Date]
Currency = [enter with deposit currency, for local transaction choose Rate
Type = Daily while for overseas choose Rate Type = Corporate]

Bill To = [select accountee as per contract/sales agreement]

Payment Terms = [select payment terms as per contract/sales agreement]

Due Date = [automatically calculated based on payment terms and entry

Page 24 Date Created: December 11, 2014

Job Aid

Step Action
date]

2. Select Distibutions tab to enter remaining letter of credit information

Issuing Date = [enter with letter of credit issuing date]

Expiry Date = [enter with letter of credit expiry date]
Amount = [enter with letter of credit amount]
Item = [leave this field blank]
Memo Line = [leave this field blank]
Description = Generic Commitment

3. Click on button to save your works.

Date Created: December 8, 2014 Page 25

Job Aid

4. Click on button to check the distribution line.

Receivable = [deposit receivable]

Revenue = [deposit]

5. Click on button to return to Transaction screen.

Page 26 Date Created: December 11, 2014

Job Aid

6. Click on button to enable letter of credit ready for transaction.

Date Created: December 8, 2014 Page 27