Announcement

Collapse
No announcement yet.

Creating single invoice for multiple shipments

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Creating single invoice for multiple shipments

    Hi,
    Wish you all a very happy new year.

    We have an interesting scenario where the service provider’s invoice is generated once in a month and the amount is calculated based on the summation of number of kilometers traveled for individual shipment in the entire month.
    So in a month if we have say 15 shipments, distance traveled for each shipment is noted (manually) and at the end of the month total amount is calculated based on total distance traveled.


    For ex: We have the following rate record for a service provider for each month.
    • Min 30000 INR for 3000 KM
    • Every additional KM is charged at 12 INR


    Shipment
    Date
    Distance traveled
    1
    Jan 05, 2010
    200 KM
    2
    Jan 07, 2010
    350 KM
    n

    Jan 30, 2010
    300 KM
    Total distance
    3100 KM
    Total Invoice amount
    30000 + 12*100=31200 INR

    Creating rate record is not an issue but require suggestions on configuring individual shipments and generating the final invoice?


    Thanks in advance for the help.

    Regards
    Ashoo

  • #2
    Re: Creating single invoice for multiple shipments

    OTM can't assign a rate to multiple shipments, or to a Shipment Group for that matter.
    A manual process could be to create a (dummy) shipment at the end of the month, enter total amount of kms, have OTM rate this, and use this shipment to create the invoice

    Comment


    • #3
      Re: Creating single invoice for multiple shipments

      Thanks Louren,

      Well the issue now which we are facing is how to link this dummy, if I am not wrong its SAW, shipment to individual order releases and then allocate cost to them.

      Comment

      Working...
      X