Need help on Freight Payments and Reconcilation

[Former Member]

Hi..!

The fallowing are the client requirements and help me to understanding.

1. Ability to change Fright Exp to COGS.

2. GL Reconciliation freight payment to billed amount.

3. Ability to audit freight invoices - confirm carrier payments reconcile with delievaries to prevent duplicate payments.

4. Enable operations finance to easily clear freight payable GL account after actually paid.

Rds,

Anil

Edited by: anil kumar on Jun 10, 2011 9:23 AM

[Former Member]

Thanks,

[sanilbhandari]

Hi

Coming to your requirements, this is how it has been done for one of the biggest retailers in india:

1. Ability to change Fright Exp to COGS.

We have implemented the transportation module along with COPA. In our COPA, the COGS and freight expense have been mapped to sa,e value field in COPA

2. GL Reconciliation freight payment to billed amount.

Done a z development, where in the shipment document of transportation is made and released to FI only after the SD Billing invoice has been done

3. Ability to audit freight invoices - confirm carrier payments reconcile with delievaries to prevent duplicate payments.

Since billing is done after delivery and shipment is done against a billing document, there is a built in check that expenses are accounted only after recieveable is created and dispatch done. Note that in std sap, shipment happens after delivery and before billing. we have done a z development

4. Enable operations finance to easily clear freight payable GL account after actually paid.

the freight bill is processed for vendor invoice verification only after the proof of delivery is receieved by operational finance

regards

sanil