cancel
Showing results for 
Search instead for 
Did you mean: 

Post shipment Charges.

Former Member
0 Kudos

Hi friends,

We have an issue to handel the post shipment charges as follows, Please suggest if you have any solution.

In a Typical Export consignment, there are various post delivery charges after the Delivery is created ex: Inspection charges, fumigation Charges, CHA Charges, Freight, etc which are not to be recovered from client and needs to be paid to respective vendors.

1.The information is to be captured in SD for information purpose.

2.The payments have to be made to third party based on SD documents, there should not be any duplicate payments possible and there should be a link between SD and FI documents.

3.When payments are made to the service provider Service Tax, Education Cess and Secondary Education cess should be deducted and the amount should hit CENVAT account.

Challenges in SD:

1.The client does not want to use MM route to create Service PO as there are too many transactions to be created.

2.If the amount is made Statistical it is not hitting the GL Account.

3.If it is not made non-statistical it is hitting the Customer Account which should not happen.

Regards

KS

Accepted Solutions (1)

Accepted Solutions (1)

former_member204513
Active Contributor
0 Kudos

Dear Krishna,

I hope your requirement can be addressed in the Transportation process so you can do the settings related to Transportation.

In the transportation after delivery creation before PGI shipment document will be created with service agent after that shipment cost document will be created with reference to the shipment document.

In the shipment cost document you can determine *shipment cost pricing procedure* through this procedure you can capture Inspection charges, fumigation Charges, CHA Charges, Freight, etc and Service Tax, Education Cess and Secondary Education cess should be deducted.

After creation of the shipment cost document you can settle the shipment cost to the service agent through settlement process.

*Creation of Serive agent* (Vendor)

Step: 1

Maintain Purchase Organization

Path: Sprou2014Enterprise Structureu2014Definitionu2014Materials Managementu2014Maintain Purchasing Organization.

Step: 2

Create Purchasing Group

Path: Sprou2014Materials Managementu2014Purchasingu2014Create Purchasing Group.

Step: 3

Maintain Transportation Planning Point to Company Code.

Path: Sprou2014Enterprise Structureu2014Definitionu2014Logistics Executionu2014Maintain Transportation Planning Point

Step: 3A

Assign Transportation planning point to company code.

Step: 4

Assign Purchasing Organizations to Company Code.

Path: Sprou2014Enterprise Structureu2014Assignmentu2014Materials managementu2014Assign Purchasing Organization to Company Code.

Step: 5

Assign Purchasing Organizations to Plant.

Path: Sprou2014Enterprise Structureu2014Assignmentu2014Materials management-- Assign Purchasing Organization to Plant

Step: 6

Create Vendor Account Group

Path: Img u2014Financial Accountingu2014Accounts Receivables and Accounts Payablesu2014Customer Accountsu2014Vendor Accountsu2014Master Datau2014Preparations for Creating Vendor Master Data--Define Account Group

Step: 8

Create Vendor

T-Code: XK01

*Configuration Steps in the Transportation process*

1) Maintain transportation planning point through Menu as follows:

IMG Maintain Logistic Execution  Definition Enterprise Structure  transportation planning point.

Create your own like BP01 enter the general data is required

2) Defining modes of transport:

IMG RoutesBasic Transportation Functions  Transportation Logistic Execution Define modes of transportDefine routes

Use the standard like:

Shipping type: 01

Description: Road

3) Define shipping types :

Basic Transportation Transportation Logistic ExecutionIMG Define shipping types Route Functions

Or through T-code: SM30

PT: 01

Description: Truck

Mdtr: 01

STPG: 0001

4) Define transportation connecting point :

LogisticIMG DefineRoutes  Basic Transportation Functions  Transportation Execution Define transportation connection pointsroutes

Copy the std point and make it FB01 as departure zone and FB02 as destination zone

5) Define routes and stages.

 Logistic Execution IMG Define Define routes Routes  Basic Transportation Functions Transportation routes and stages

Use the standard route and copy it as FB0001 and enter the departure zone and destination as what we created.

6) Defining Transportation Zone:

Basic Transportation Logistic Execution IMG Define transportation Router determination  Route Transportation Functions zones

Use the standard transportation zone depending on the route so as for the example use 0000000003 - Southern Region

7) Maintain country or transportation zone for shipping points

 Logistic Execution IMG  Route determination  Route  Basic Transportation Functions Transportation Maintain country and transportation zone for shipping point

Shipping point be ASH1 and route as 0000000003 which is assigned to country India

😎 Maintain route determination:

Logistic ExecutionIMG Route determination Route  Basic Transportation Functions  Transportation  Maintain route determination

Country of departure: India

Departure Zone: 0000000003

Country of destination: India

Destination Zone: 0000000003

And enter the datau2019s needed like shipping condition 01, etc.

Maintain Transportation relevance for shipping point, sales document type and delivery types.

9) Now create shipping types

IMG Define shipment Shipments  Transportation Logistic Execution types

Copy the standard 0001 and make it to AFIL

10) Define and assign traffic zones through T-Code: T_76 (or) thru menu as follows

IMG Define Basic functions  Shipments cost  Transportation Logistic Execution and assign tariff zones

Copy the standard and make it to FABTARIFF and assign our transportation planning point as ATP1, ATP2 assign tariff zone to every particular transportation planning point

11) Define and assign pricing procedures

Shipments Transportation  Logistic Execution IMG define and assign pricing Price control  Pricing cost procedures

Copy the standard shipping cost pricing procedure SDFC00 to FBSC01

12) Assign purchasing data:

 Logistic Execution IMG Assign purchasing data Settlement  Shipments cost Transportation

13) Assign transportation planning point to shipping condition, purchase organization, purchasing group and to plants.

14) Define Automatic G/L account determination:

 Transportation  Logistics Execution IMG Automatic G/L Account Determination Settlement Shipment Costs

Or through T-code: OMWB

Use G/L account 614000 as used in standard

15) Automatic determination of CO assignments:

IMG Automatic Settlement  Shipment Costs  Transportation Logistics Execution Determination of CO Assignments

Or T-code: OKB9

16) Maintain shipping point address.

 Logistics Execution  Definition Enterprise Structure Define, copy, delete, check shipping point

17) Creating G/L account centrally.

Financial AccountingAccounting  Master Records  General Ledger 

Individual Processing Centrally

Or through T-Code: FS00

18) Enter the G/L account 614000 to the company code AFIL

19) Create transportation condition records:

 Shipment cost  Transportation  Master data Logistic Execution createPrices

Or thru T-code: TK11

Enter condition type FB00 that is freight condition type, which is used as standard in the shipping cost pricing procedure.

Enter the price and save it

Process:

1. The system determines the pricing procedure for the shipment cost item-using transportation planning point, service agent and shipment cost item category

2. Calculation Basis

3. Condition Record

4. Access sequence.

For the sales order, create a delivery using VL01N and pick the goods. Now create a shipment using VT01N and assign the delivery to the shipment document. Make sure to enter the carrier and other details before performing the transportation planning and execution. Save the shipment document and PGI for the delivery would be done automatically.

A shipment represents a physical goods movement between two or more locations.

For the system to create a shipment, shipping-relevant deliveries must exist.

You use Transportation Planning to group pending deliveries into shipments and then to perform the shipments.

The outbound delivery documents contain routes that the system calculates in route determination, and a transportation planning date for the delivery.

Dynamic transportation planning is responsible for grouping together outbound deliveries into shipments that have at least the same route, visit plan type and the same transportation planning date.

The following restrictions can be taken into account for a shipment in Dynamic Transportation Planning:

u2022 Weight

u2022 Volume

u2022 Variable capacity

u2022 Number of stops

u2022 Maximum duration

u2022 Loading units

Create Shipment Document

Use

After the status of the delivery is open for transportation planning, it is possible to create a shipment document to schedule the transportation.

Transportation Create Single document Logistics Logistic Execution  TransportationPlanning

T.code: VT01n

Enter your transportation planning point and shipment type. Press enter.

Creating the shipment cost document

Use

After the deliveries are scheduled by shipment and the shipment is executed, now it is time to maintain and close the shipment document in order to record all relative information and ready for the shipment cost settlement.

Single document Logistics Logistic Execution  Transportation Shipment cost Create

T.code: VI01.

After creation of shipment cost doc. You settle the Shipment cost.

Go to VI02, enter shipment cost no.and press enter.

Then go to Overview -- Fright cost items, Select the line item and double click it.

Go as main menu: Item --> Acc. assignment, you enter G/L acc. and cost center to which the transportation cost will be posted.

On the Standard change, details u2013 Freight cost items screen, then check the check box u201CTransferu201D, which means you will transfer the relative transportation cost to FI/CO, in this case, the system should determined which Purchase Order will used to settle the cost, so after you check the u201CTransferu201D check box.

Press save button on the current screen.

Shipment cost settlement and documents:

Use

After the shipment cost settled in shipment cost document, it has the following affects:

It creates a service entry sheet that refers to the purchase order determined.

It posts acceptance of services performed.

It creates an accounting document for the accruals.

Further subsequent documents are created in FI.

Create Delivery:

T.code: Vl01n

Create TO:

T.code: LT03

Create Shipment Document

Use

After the status of the delivery is open for transportation planning, it is possible to create a shipment document to schedule the transportation.

 Transportation Planning  Create Single document Logistics Logistic Execution Transportation

T.code: VT01n

Enter your transportation planning point and shipment type. Press enter.

Creating the shipment cost document

Use

After the deliveries are scheduled by shipment and the shipment is executed, now it is time to maintain and close the shipment document in order to record all relative information and ready for the shipment cost settlement.

Single document Logistics Logistic Execution  Transportation Shipment cost Create

T.code: VI01.

After creation of shipment cost doc. You settle the Shipment cost.

Go to VI02, enter shipment cost no.and press enter.

Then go to Overview -- Fright cost items, Select the line item and double click it.

Go as main menu: Item --> Acc. assignment, you enter G/L acc. and cost center to which the transportation cost will be posted.

On the Standard change, details u2013 Freight cost items screen, then check the check box u201CTransferu201D, which means you will transfer the relative transportation cost to FI/CO, in this case, the system should determined which Purchase Order will used to settle the cost, so after you check the u201CTransferu201D check box.

Press save button on the current screen.

Shipment cost settlement and documents:

Use

After the shipment cost settled in shipment cost document, it has the following affects:

It creates a service entry sheet that refers to the purchase order determined.

It posts acceptance of services performed.

It creates an accounting document for the accruals.

Further subsequent documents are created in FI.

Generally process is-

1) VL01N

2) VT01

3) VL02N - PGI

4) VI01

5) ML81N u2013 Service Entry Sheet

6) MIRO u2013 Invoice Verification

Shipping docs (VT01) are created before PGI...

You cannot carry out transportation planning or creation of shipment after the goods issue has been executed. Once goods issue is done it means that the material has left your premises so there is no need for a transportation planning after it.

In case you need carry out the shipment documents at the end of the day you could just create the delivery documents during the day and at end of the day create the shipment documents and the goods issue

I hope this will help you,

Regards,

Murali.

Former Member
0 Kudos

Hi Murali,

Thanks for the elobrate solution sounds perfect. But unfortunately Transportation module is out of scope of the project

Regards

KS

Answers (1)

Answers (1)

Lakshmipathi
Active Contributor
0 Kudos

Dear Krishna

My suggestion would be as follows:

In VOFA, for your billing type, have the box "Posting Block" checked so that as and when export billing documents are generated, it has to be manually released to accounting. The purpose for this manual release is due to the reasons explained below.

In V/06, have the condition types (CHA, Inspection, Freight etc) as a header condition and input manually in billing, so that these values will be stored in VBRK table and will not be passed on to FI for which, these condition types should be statistical in your pricing procedure. If any of those charges are fixed, then may be you can maintain the same in VK11 also. So with this SD part is over.

From FI part, what you have to do is that you have to create a zee table with the help of ABAPer and have the check for the combination of SAP billing document reference with vendor bill reference. At any given point of time, if any vendor bill duplicates with SAP billing document, then system should throw an error message and cannot be saved.

In fact, what I would suggest is that have the check for B/L number instead of SAP billing document number bcoz, the relationship between B/L and vendor bill is 'one to one' but for SAP billing documents, it is 'many to one'. So the check can be kept for the combination of B/L number and vendor bill reference. Once the end user access the zee tcode, following fields should be made as mandatory.

- Vendor bill no.& date

- B/L Number

After giving the above two datas and press the enter key, whatever values maintained in the billing document should flow here and if need, these can be changed and make payment accordingly. You can also add multiple fields with editable option, so that, in case, any additional amount needs to be paid can be maintained manually.

Needless to mention you have to apply user exit ZXVVFU01 through which, in VF02, while releasing the billing document manually, two fields should pop up to maintain the B/L number and date. This B/L Date should be the posting date in accounting document. For B/L number, you can write the coding in the user exit in such a way that whatever the end user key in in VF02, the same can be stored in table LIKP - Field BOLNR)

Hope to have given a detailed procedure. Let me know still you need any further clarification.

thanks

G. Lakshmipathi