on 12-02-2008 6:17 AM
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
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 RoutesBasic Transportation Functions Transportation Logistic Execution Define modes of transportDefine routes
Use the standard like:
Shipping type: 01
Description: Road
3) Define shipping types :
Basic Transportation Transportation Logistic ExecutionIMG Define shipping types Route Functions
Or through T-code: SM30
PT: 01
Description: Truck
Mdtr: 01
STPG: 0001
4) Define transportation connecting point :
LogisticIMG DefineRoutes Basic Transportation Functions Transportation Execution Define transportation connection pointsroutes
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 ExecutionIMG 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 AccountingAccounting 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 createPrices
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 TransportationPlanning
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.