Automatic Invoice Posting of Forwarding Agent against Shipment Cost Document

[Neeraj_Jain]

Hello everyone,

The following process will shed light on How to post Automatic Invoice Posting of Forwarding Agent for Shipment Cost Document.

Problem Statement:

The problem is that invoices of forwarding agents are being posted manually through journal voucher, in which, shipment cost number/shipment number is being entered manually in the narration or in a text field. Due to this, manual reconciliation is being conducted between Shipping Cost Document and Forwarding Agent Invoice as there is no synchronization between these documents and duplicate invoice is being posted along with payments disburse to vendors.

Solution:

To overcome the above problem the following configuration to be completed to post Automatic Invoice Posting of Forwarding Agent against Shipment Cost Document.

Step-1:               Map Vendor Partner Role IP (Invoicing Party) with Freight Carrier Account Group.

Step-2:               Define Item Category for Shipment Cost type by following path:

Step-3:              Define Item Category for Shipment Cost type as per your business requirements.

Step-4:              Assign Purchasing Data with respective Transportation Planning Plant and Plant by following path:

Step-5:         Purchase Organization, Purchasing Group to be mapped with Transportation Planning point, shipment cost type and Plant.

Step-6:         Assign respective Cost Element with respective GL account for respective company code by following path.

Step-7:         Condition type FT00 to be added in respective Shipment Cost Pricing Procedure and maintain with respective access sequence in transaction code – TK11.

Step-8:         Below these options to be ticked in respective Freight Carrier Vendor.

Step-9:         ERS output/pricing conditions to be maintained for respective forwarding agent.

Step-10:      After configuring/maintaining above settings/conditions ERS Service PO and Service Entry Sheet will be automatically created at the time of saving of Shipment Cost Document and display under “Service Procurement” tab of Shipment Cost Document. Also, Shipment Number displayed under “Purchase Order History” tab of Purchase Order.

Step-11:         After above steps, go to transaction MRRL and post the ERS invoice or schedule a batch job for program “RMMR1MRS” to avoid manual intervention to post the ERS invoice.

Step-12:         Now go to transaction FBL1N and check respective Freight Vendor Account to check posting/amount of Freight Vendor.

To Conclude:

Once the above steps will be executed successfully the business will get the correct account balance of freight vendor to avoid any dispute in the future related to duplicate invoicing or payment. It will also reduce the efforts of manual reconciliation.

Thanks for your interest! Please share feedback, comments or suggestions below.

Best Regards,
Neeraj Jain
SAP Technical Manager in HCL Technologies Limited

[hsj]

Very informative.

Thanks Neeraj for sharing detail document.

[suhailahmedgoodwala]

Informative content.

[madhu_babu]

Very useful. Thanks for detailed explanation with screen shots.

[naveena_s]

Very informative information. Thanks for sharing Neeraj.