Freight Settlement

Settlement in TM 9.0
New functionalities with TM 9.0
Ananth Bhat – SAP Development, Transportation & Logistics
December 2012
Agenda
Shipper Functionality
– Freight Cost Distribution
LSP / Freight Forwarder
– Forwarding Settlement
o ERP Printing Enhancements
o Execution based Settlement
– Internal Settlement
Air Freight Settlement Process extension (Freight Settlement)
– Charge Correction Advice Document (CCAD)
Credit memo on Freight Settlement
Q&A
© 2011 SAP AG. All rights reserved.
2
Freight Cost Distribution
Shipper Functionality
Cost Distribution - for Shipper Industries
What is Cost Distribution?
Accurate freight cost allocation across orders & materials for material valuation and order
profitability analysis
SAP TM
SAP ERP
Inbound Delivery
• Freight Settlement Document
(with cost distribution at delivery
item level)
• Agency Business
Document
Outbound Delivery
• Freight Settlement Document
(with cost distribution at delivery item
level)
• Agency Business
Document
Material Valuation
(with freight costs
per material)
CO-PA Sales Order
Profitability
• Direct item-level or hierarchy-based freight cost distribution via weight; volume; weight * distance
• Full freight cost visibility in all relevant SAP TM & ERP documents
(freight orders, bookings, settlement docs, sales, purchasing, stock transfer orders, agency billing docs..)
•BADI for customer-specific charge type rules / cost distribution calculation (i.e. pallet, distance)
• Freight Cost Posting in SAP ERP at Material level for Material valuation as well as Sales order
profitability
© 2011 SAP AG. All rights reserved.
4
Cost Distribution – Concept
SAP ERP
7a
7b
Incoming
Invoice
AB Posting
MIRO
CO-PA
ERP orders/deliveries
1
SAPERP
Material Valuation
6a
MM-PO
MM-SES ...
CO
6b
TM 8.x
TM 9.0
OTRs/DTRs
2
Transfer FSD + Distributed Costs
to ERP
FUs
FOs
FBs
© 2011 SAP AG. All rights reserved.
3
4
FSD
5
Distributed
Costs
5
Typical Posting Pattern for FSD with Cost Distribution
Inbound Freight Cost Posting
Outbound Freight Cost Posting
6a. Freight Settlement
Document (FSD) (Step
6a)
Freight Clearing
Account (GBB)
GR/IR Freight
(WRX)
100
6b. VB posting for
distributed costs (Step
6b)
6a. Freight Settlement
Freight Clearing
Document (FSD)
Account (GBB)
(Step 6a)
100
Freight Clearing
Account (FR1)
© 2011 SAP AG. All rights reserved.
100
100
6b. VB posting for
distributed costs
for Mat 1 / Delivery 1
for Mat 2 / Delivery 1
for Mat 3 / Delivery 2
GR/IR Freight
(WRX )
Freight Expense
Account (TM1)
50
30
20
50
30
20
(Step 6b)
Freight Clearing
Account (FR1)
BSX/PRD
Inventory or
Material Price
difference
for Mat 1
50
50
for Mat 2
30
30
for Mat 3
20
20
6
Outbound Delivery
Freight Order with 2 Outbound deliveries
© 2011 SAP AG. All rights reserved.
8
Freight Settlement document
© 2011 SAP AG. All rights reserved.
9
Cost Distribution – Summary & Detail
© 2011 SAP AG. All rights reserved.
10
FSD Posting – Step 6a
© 2011 SAP AG. All rights reserved.
11
Freight Cost Split Posting in SAP ERP (Step 6b)
© 2011 SAP AG. All rights reserved.
12
Account Assignments from Source to Post Freight Cost
Sales order Item Account Assignment
AB Document Item Account Assignment
© 2011 SAP AG. All rights reserved.
13
Postings to Financials of the distributed Freight Cost
© 2011 SAP AG. All rights reserved.
14
Cost Distribution – Summary for TM 9.0
1. Cost Distribution take place in Freight Order (FO) Freight Booking (FB) and
Freight Settlement Document (FSD).
2. Transfer of the distributed cost to SAP ERP is only done with the Freight
Settlement Document (FSD)
3. Distribution of the cost to the Level of Delivery Item for Shipper Scenario
4. Distribution of the Cost by Weight, Volume and Distance & Weight within TM.
5. Customer extension possible via BADI to do other kinds of distribution like
piece, pallets, distance and other aspects like weights etc.
6. Automatic distribution of the Freight Cost at the time of FSD creation.
7. SAP ERP integration as a Single step via intermediate Account postings.
1. FSD integration posting as in TM 8.x (PO/SES)
2. Material Valuation/CO-PA Posting
8. Freight Invoice variance posting in SAP ERP also enabled to post variances
to Material Valuation / CO-PA
© 2011 SAP AG. All rights reserved.
15
Forwarding Settlement Enhancements
ERP Printing Enhancements
SAP TM – Customer Freight Invoicing Simple Overview
Process
Customer
Need for
Transportation
SAP ERP –
SD
SAP TM
Details of
what
needs to
Be
transporte
d
Create Forwarding
Order
Enriched
Printing of
Customer
Invoice with
TM data
Simulate
Printing of
Customer
Invoice
© 2011 SAP AG. All rights reserved.
P/IWSRMI
Create forwarding
settlement document
Create billing
document (invoice)
17
Simulate Customer Invoice in SAP TM
© 2011 SAP AG. All rights reserved.
18
Summary - FWSD Simulation and printing
Ability to Do a Simulation of the Printing of the FWSD with TM and ERP Data
in TM prior to transferring the FWSD from TM to ERP.
TM Data Transfer enriched from TM to ERP. ERP now has additional TM
Logistical data and other data transferred with the FWSD.
Customer Enhancement possible to send Customer specific fields and print
them eventually also from ERP on the Customer Billing documents.
© 2011 SAP AG. All rights reserved.
19
Forwarding Settlement Enhancements
Execution based Settlement
Business Scenario
Trailer
FWO 1
PM1
FWO2
Container
FWO 1
FWO2
Multiple FWOs from the Customer to be moved together.
Billing based on the (Full) Trailer/ Full Container basis across the multiple
FWOs
© 2011 SAP AG. All rights reserved.
21
Scenarios for Execution Based Forwarding Settlement
Buyers Consolidation in Ocean Scenario (Supported from release TM 8.1)
o Multiple FWO’s consolidated in Container for Main carriage and On Carriage
o Consolidated Charge calculation using FCL rates for main and On Carriage.
Trailer Based Consolidated settlement – Land (New in TM 9.0)
o Multiple FWO consolidated on Trailer for Execution
o Consolidated charge calculation using Trailer load.
© 2011 SAP AG. All rights reserved.
22
Execution Based Forwarding Settlement - 1/4
Forwarding Agreement
Agreement for Execution based Settlement
Trailer Based Charge Calculation and customer settlement on the basis of
execution.
© 2011 SAP AG. All rights reserved.
23
Execution Based Forwarding Settlement - 2/4
Trailer Document
© 2011 SAP AG. All rights reserved.
24
Execution Based Forwarding Settlement - 3/4
Forwarding Settlement Document
© 2011 SAP AG. All rights reserved.
25
Execution Based Forwarding Settlement - 4/4
Forwarding Settlement Document – Charge Data
© 2011 SAP AG. All rights reserved.
26
Difference between Execution Based and FWO based
settlement
Execution Based
Settlement
FWO Based settlement
Settlement Item
Execution Document –
viz Trailer or Container
FWO
Charge Calculation
Per Execution document
viz Trailer or Container
FWO
Charge Group look up
Per execution document
viz. Trailer or Container
and is across FWOs on
the Execution document
FWO
Data Source (Stage +
Logistical quantities)
Execution Document viz., Controlled via the
Freight Booking Item or
Settlement profile
Trailer Document
© 2011 SAP AG. All rights reserved.
27
Internal Settlement
LSP / Freight Forwarder Functionality
Scenarios for Internal Settlement
1.
Internal Settlement from an internal organization in your company to
another internal organization to recover costs incurred in delivering
transportation services for a forwarding order
2.
Internal settlement to settle the cost of providing internal resources in a
scenario of freight orders with own resources.
© 2011 SAP AG. All rights reserved.
29
Cost Transfer via Internal settlement - Scenario
Nürnberg issuing
invoice to Dallas
Station (Main
carriage)
INCO Term
FOB
$2200
CSI-STA-NUE
Nürnberg Station
Export Station
Nürnberg issuing
invoice to Shipper
CSI-CU-NEU
$ 500
Shipper:
CSI-CU-NUE
Nürnberg
Rotterdam issuing
Internal invoice to
Nürnberg (internal
Rating) (Main carriage)
Dallas issuing invoice
to Consignee CSICU-DLS
$ 2200
$2800
CSI-CFS-RTM
Rotterdam CFS
CSI-CFS-NWK
Newark CFS
Export CFS
Import CFS
CSI-STA-DLS
Dallas Station
Consignee:
CSI-CU-DLS
Dallas
Import Station
FSD from Carrier 1
for pre-carriage
FSD from Carrier 2
for Main Carriage
FSD from Carrier 3
for On-Carriage
Payee Nürnberg
Payee Rotterdam
Payee Dallas
$400
$2000
$400
Company
Code DE
Company
Code NL
Legends
External Settlements
Internal Settlements
© 2011 SAP AG. All rights reserved.
Company
Code US
Cargo Movement
Internal Settlement
Document
External Settlement
Document
Carrier Settlement
Document
30
Internal Settlement – Master Data Setup
Internal Agreement
Internal Agreement – based on Internal Rates.
© 2011 SAP AG. All rights reserved.
31
Internal Settlement – Process Flow
Internal Settlement Creation
© 2011 SAP AG. All rights reserved.
32
Internal Settlement – Resource Based
Own Resource Based Freight Order Execution.
Resource Ownership defined in the Resource Master (Example Owning
organization for Trailer, Truck).
Resource As a Basis (Calculation Resolution Base) for the calculation of
Freight Costs
© 2011 SAP AG. All rights reserved.
33
Internal Settlement – Resource Based
© 2011 SAP AG. All rights reserved.
34
Internal Settlement -- Freight Order with Own Resources
© 2011 SAP AG. All rights reserved.
35
Resource Based internal Settlement
© 2011 SAP AG. All rights reserved.
36
Summary of Internal Settlements
Internal settlement Supports Two Variants
1.
Internal Settlement from an internal organization in your company to
another internal organization to recover costs incurred in delivering
transportation services for a forwarding order
2.
Internal settlement to settle the cost of providing internal resources in a
scenario of freight orders with own resources.
3.
Internal Settlement support Inter and Intra Company Transactions.
4.
New FWSD category - internal settlement
5.
ERP integration
1.
2.
Inter Company Process – SD Billing document integration
Intra Company Process – Via CO Document Posting
© 2011 SAP AG. All rights reserved.
37
Charge Correction Advice Document
Air Freight Settlement Extension (Freight Settlement)
Air Freight Settlement process overview
© 2011 SAP AG. All rights reserved.
39
Sample IATA CASS Settlement Report
© 2011 SAP AG. All rights reserved.
40
Charge Correction Advice Document
© 2011 SAP AG. All rights reserved.
41
Credit Memo on Freight Order
Credit memo for Freight Order
Ability to create Credit Memo from TM for a Freight Document – FO or FB
Credit memo with reference to the Freight order or Freight booking.
Pre Requisite
A successful transfer of a FSD to SAP ERP.
© 2011 SAP AG. All rights reserved.
43
Credit memo For Freight Order 1/3
© 2011 SAP AG. All rights reserved.
44
Credit memo For Freight Order 2/ 3
© 2011 SAP AG. All rights reserved.
45
Credit memo For Freight Order 3/3
© 2011 SAP AG. All rights reserved.
46
Summary – CCAD and Credit Memo
TM Supports two new categories of FSD to support follow on processes on
Freight Settlement
– Charge Correction Advice Document (CCAD) – Air Freight Booking
–Credit Memo – FO and Ocean Freight Booking
TM ERP integration of the above documents enhanced to handle credit
posting.
© 2011 SAP AG. All rights reserved.
47
Questions
Thank You!
Contact information:
Ananth Bhat
Title : Product Owner (Invoicing) Transportation Management
SAP Labs Bangalore
[email protected]
© 2012 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any
purpose without the express permission of SAP AG. The information contained
herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain
proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of
Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5,
System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries,
zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390
Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6,
POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes,
BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF,
Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere,
Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM
Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other
countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or
registered trademarks of Adobe Systems Incorporated in the United States and/or
other countries.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects
Explorer, StreamWork, and other SAP products and services mentioned herein as
well as their respective logos are trademarks or registered trademarks of SAP AG
in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal
Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business
Objects products and services mentioned herein as well as their respective logos
are trademarks or registered trademarks of Business Objects Software Ltd.
Business Objects is an
SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other
Sybase products and services mentioned herein as well as their respective logos
are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP
company.
All other product and service names mentioned are the trademarks of their
respective companies. Data contained in this document serves informational
purposes only. National product specifications may vary.
The information in this document is proprietary to SAP. No part of this document
may be reproduced, copied, or transmitted in any form or for any purpose without
the express prior written permission of SAP AG.
Oracle and Java are registered trademarks of Oracle and/or its affiliates.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and
MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®,
World Wide Web Consortium, Massachusetts Institute of Technology.
© 2012 SAP AG. All rights reserved.
50
© 2012 SAP AG. Alle Rechte vorbehalten.
Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind,
zu welchem Zweck und in welcher Form auch immer, ohne die ausdrückliche
schriftliche Genehmigung durch SAP AG nicht gestattet. In dieser Publikation
enthaltene Informationen können ohne vorherige Ankündigung geändert werden.
Die von SAP AG oder deren Vertriebsfirmen angebotenen Softwareprodukte
können Softwarekomponenten auch anderer Softwarehersteller enthalten.
Microsoft, Windows, Excel, Outlook, und PowerPoint sind eingetragene Marken
der Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5,
System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries,
zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390
Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6,
POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes,
BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF,
Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere,
Netfinity, Tivoli und Informix sind Marken oder eingetragene Marken der IBM
Corporation.
Linux ist eine eingetragene Marke von Linus Torvalds in den USA und anderen
Ländern.
Adobe, das Adobe-Logo, Acrobat, PostScript und Reader sind Marken oder
eingetragene Marken von Adobe Systems Incorporated in den USA und/oder
anderen Ländern.
Oracle und Java sind eingetragene Marken von Oracle und/oder ihrer
Tochtergesellschaften.
HTML, XML, XHTML und W3C sind Marken oder eingetragene Marken des
W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects
Explorer, StreamWork und weitere im Text erwähnte SAP-Produkte und
-Dienstleistungen sowie die entsprechenden Logos sind Marken oder
eingetragene Marken der SAP AG in Deutschland und anderen Ländern.
Business Objects und das Business-Objects-Logo, BusinessObjects, Crystal
Reports, Crystal Decisions, Web Intelligence, Xcelsius und andere im Text
erwähnte Business-Objects-Produkte und -Dienstleistungen sowie die
entsprechenden Logos sind Marken oder eingetragene Marken der Business
Objects Software Ltd. Business Objects ist ein Unternehmen der SAP AG.
Sybase und Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere und
weitere im Text erwähnte Sybase-Produkte und -Dienstleistungen sowie die
entsprechenden Logos sind Marken oder eingetragene Marken der Sybase Inc.
Sybase ist ein Unternehmen der SAP AG.
Alle anderen Namen von Produkten und Dienstleistungen sind Marken der
jeweiligen Firmen. Die Angaben im Text sind unverbindlich und dienen lediglich zu
Informationszwecken. Produkte können länderspezifische Unterschiede
aufweisen.
Die in dieser Publikation enthaltene Information ist Eigentum der SAP. Weitergabe
und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem
Zweck und in welcher Form auch immer, nur mit ausdrücklicher schriftlicher
Genehmigung durch SAP AG gestattet.
UNIX, X/Open, OSF/1 und Motif sind eingetragene Marken der Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame und
MultiWin sind Marken oder eingetragene Marken von Citrix Systems, Inc.
© 2012 SAP AG. All rights reserved.
51