Payables and Cash Management - EBS (MOSC)

MOSC Banner

Payables Import changing item and tax amount in distributions

edited Jul 13, 2015 10:00AM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered

I am trying to import invoices with multiple lines with some lines that have taxes already calculated.  In order to get them to import I am following the use case below:


Column               Line 1          Line 2          Line 3          Line 4

Line Type              ITEM               ITEM          TAX          TAX

Amount               100               50                    10               5

Line Group          1                    2               1                    2

Prorate               Y                    Y                    Y               Y

Tax Regime                                                  A               A

Tax                                                                 B               B

Tax Status                                                       C               C

Tax Rate                                                       D               D

But it is creating distributions like below:

Line 1     Dist 1     Item                              95

Line 1     Dist 2     Recoverable Tax          15

Line 2     Dist 1     Item                              47

Line 2     Dist 2     Recoverable Tax          3

How do I get the import to keep the amounts in the distributions as entered in the interface table and not change them?

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