Lines - Single Transaction
As per standard Oracle functionality, minimum transaction header data must be entered before line data can be entered. These are: Transaction Type and Customer Number. Conditionally mandatory based on setup are: Transaction Number, Transaction Date and Terms, Currency Exchange details, Instrument details and Sales Rep details.
To enter ‘Lines’ data, position your cursor in the ‘Lines’ section of the worksheet, on the row you wish to enter the transaction data. Then double-click in one of the cells or alternatively click on the ‘Forms’ button and select ‘Lines’.
The Lines section of the worksheet is split into seven subsections
a) Lines
The ‘Lines’ form allows you to enter the line information for a transaction.
If the Unit Selling Price and/or Quantity are amended, the total will become out of balance and be highlighted red
The 'Total Amount' column is important and used for a multitude of data validation checks. If this is left in an out of balance state, the invalid amounts will be written to the sheet when you click 'Ok'. Wizard validation will subsequently fail as the Wizard recognizes the calculation error.
Select ‘Ok’ to write the data to your worksheet. Select ‘Cancel’ to return to the worksheet without updating the sheet.
b) Tax Exemption
Use the Tax Exemption tab to enter Tax Handling, Exemption Certificate and Exemption Reason at the line level when creating a transaction. The ‘Ship To’ details are reference fields only and will not be uploaded as the Oracle API currently does not support this data. List of Values for ‘Exemption Certificate’ are populated based on your selection of the Ship To Cust Name/Cust Number.
Note: The Tax Exemption tab will only appear if the Profile Option ‘eBTax: Allow Override of Customer Exemptions’ is set to Yes at an applicable level.
c) Tax Information
Use the Additional Tax Determining Factors window to enter additional R12 tax information for a line as appropriate.
d) R12 Tax
Update existing or enter new tax lines in the Wizard according to your requirements. All entries and changes apply to a combination of Tax Regime and Tax.
Note - The “R12 Tax” tab is only available in the form in an R12 environment.
The ‘Tax Code’ field is also available for R12 use should your EBS-Tax configuration allow this. This field is in the 'Lines' subsection.
Notes regarding entering Tax lines:
· If using the Tax Code column this can be used on the same row as the Line information
· If using R12 tax, this should be entered using the Line Type of Tax, under the Tax Line
· A Tax Code and R12 Tax cannot exist on the same row for the line.
e) Line Descriptive Flexfields
Enter your Descriptive Flexfield Transaction Line information in this form.
f) Interface Line Descriptive Flexfields
Enter your Interface Flexfield Transaction Line information in this form.
g) Global Line Descriptive Flexfields
Enter your Global Flexfield Transaction Line information in this form.
Refer to section:
