Oracle Certification, Database Administration, SQL, Application, Programming Reference Books
Calculate VAT on Freight

Setup steps are as follows :

1. Setup an inventory item called Freight. Put a valid UOM, Tax Code, and Pick User Item Type as 'Freight'
    and make sure that this item is an Invoicable Item and Invoice Enabled item.

By defining Freight Charges as an inventory item enables the AutoAccounting to treat this item as a Freight item and use freight Account rather than Revenue Account for the Freight Charges.

If you are not implementing Oracle Order Entry than you can always pick this new item as a line and Oracle Receivables will calculate the Tax on this freight item as it does for any other item.

2. If you are implementing Oracle Order Entry then set the following profile options
     a) Tax: Invoice Freight as Revenue to 'Yes'. This option will enable freight amount entered in the Oracle
         Order Entry Ship Confirm Screen is passed as a taxable line to Oracle Receivables.

     b) Tax: Inventory Item as Freight to  the item you have defined for Freight Charges.

Return to : Oracle Database, SQL, Application, Programming Tips