Payables and Cash Management - EBS (MOSC)

MOSC Banner

How to populate ap.ap_invoice_lines_interface for manual tax line in R12?

edited Jun 14, 2012 9:19AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

We're upgrading from 11i to R12. We're using 3rd party software Sabrix to calculate tax in 11i and R12.

Need to be able to enter a tax line in the Open payables import interface.  From below white paper

USE CASES FOR IMPORTING TAX LINES THROUGH THE PAYABLES IMPORT PROCESS [ID 840262.1]

Use Case 2: Exclusive Manual Tax

Example: An invoice with one ITEM line of 100 USD and one TAX line (manual and exclusive) of 10 USD

 

Populate the data in AP_INVOICE_LINES_INTERFACE as below:

 

Interface Column Name

ITEM Line

TAX Line

LINE_NUMBER

1

2

LINE_TYPE_LOOKUP_CODE

ITEM

TAX

AMOUNT

100

10

LINE_GROUP_NUMBER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center