freight charges, duty charges, and rebate charges

-

 In Oracle Fusion SCM, you manage freight charges, duty charges, and rebate charges through various modules,

 including 

 Pricing, 

 Order Management, 

 and potentially Transportation Management, 

 allowing for allocation, calculation, and tracking of these costs. 

Here's a more detailed breakdown:

1. Freight Charges:

Definition:

Freight charges are costs associated with transporting goods, encompassing various elements like 

transportation, 

fuel, 

and handling. 

Management:

Pricing: Define shipping cost types and pricing rules to calculate freight charges. 

Order Management: Capture and manage freight charges at the sales order level. 

Transportation Management: Integrate with TMS to automate freight cost updates. 

Manual Entry: You can manually enter or override freight charges on sales orders. 

Allocation: Allocate freight charges to specific item lines or across all lines on an invoice. 

Examples:

Base freight cost 

Accessorial charges (e.g., fuel surcharge, handling fees) 

Special handling charges (e.g., hazardous goods) 



2. Duty Charges:

Definition: Duty charges are taxes or tariffs imposed on imported goods. 


Management:

Pricing: Define duty charges as a type of shipping cost. 

Order Management: Capture duty charges at the sales order level. 


Transportation Management: Integrate with TMS to automate duty cost calculation and reporting. 

Landed Cost Management: Include duty costs in the overall landed cost of imported goods. 

Examples:

Import duties 

Customs fees 



Other import-related taxes 

3. Rebate Charges:

Definition: Rebate charges represent amounts paid back to suppliers or customers based on agreed-upon terms. 

Management:

Procurement: Manage supplier rebate programs and track accruals. 

Order Management: Manage rebate amounts on sales orders. 

Rebate Claim: Create and manage rebate claims. 

Rebate Settlement: Settle rebate claims and create vouchers for payment. 


Examples:

Volume discounts 

Supplier rebates 

Promotional rebates 

Key Considerations:

Configuration:

Ensure proper configuration of pricing rules, shipping cost types, and other relevant settings. 

Integration:

Integrate with other modules (e.g., Transportation Management, Procurement) to streamline processes. 

Tax Calculation:

Configure tax rules to accurately calculate taxes on freight and duty charges. 

Reporting:

Use reports to track and analyze freight, duty, and rebate costs. 

Comments

Post a Comment

Popular posts from this blog

Oracle SQL

-
SQL Course Content Topic_Details  1. DB,DBMS,RDBMS,ORDMBS & DB development lifecycle Click Here 2. About Oracle Click Here 3. Client/Server Click Here 4. About SQL Click Here 5. Data, data definitions, schema, and SQL Developer tool and DB install process. Click Here 6. Creating a User/Schema/Account in Oracle DB. Click Here 7. Data types in Oracle. Click Here 8. Creating,inserting a Table in Oracle DB. Click Here 9. Operators in Oracle DB. Click Here 10. Displaying data from Oracle DB. Click Here 12. Where Clause Click Here 13. In,between,Like,Is Operators Click Here 14. Alias, All_users,User tables. Click Here 15.Order by, Distinct,fetch clauses ...
Read more

SubQueries

-
Single Row_SubQuery -------------------- Single-Row Sub-Queries Returns one value SELECT <columns> FROM <table_name> WHERE <col_name> <OP> (SELECT STMNT); > , >=, <, <=, =. <> A single-row subquery in Oracle SQL is a subquery (a query nested inside another query) that returns only one row. The main/outer query uses the inner query result as its conditions If single row sub-query returns more than one row then you will get an error ORA-01422: exact fetch returns more than requested number of rows) It can be used in Select, Where, Having clauses Single Row_SubQuery -------------------- --1. Find who is getting highest salary in the employee table? select max(sal) from emp; select *from emp where sal=(select max(sal) from emp); select max(salary) from employees; select *from employees where salary=(select max(salary) from employees); --2.Find second maximum salary emp? select *from emp where sal=( select max(sal) from emp where sal!=(select max(sa...
Read more

With Clause

-
 WITH Clause  ====================================== What? With Clause is a Sub-Query factoring or (Common Table Expressions-CTEs) This features is introduced in Oracle 9i.Using this feature: We assign query result set to a temporary tables. We can access data from temporary tables in main Select clause as many times we require with out repeating the sub-queries. When? Usage of (2,3 level-Nested Queries) can  be minimized or avoided when using With Clause. If we use sub-queries up to 1 level then performance may be good but when we use 2 level or 3 level sub-queries then there may chance of performance issues when we try to fetch large large volume of data. How to implement CTEs ====================== SELECT deptno,        Sum(sal) total_sal FROM   emp GROUP  BY deptno; --fetch sum of sal for each dept. SELECT Avg(total_sal) FROM  (SELECT deptno,               Sum(sal) total_sal     ...
Read more