Define landed cost for Inter-Site stock transfer

SUGGESTED

Is there a way to define landed cost for an inter-site stock transfer?  I tried with Invoice element, but it's not working as expected.  

Customer wants to pro-rate an estimated transportation cost by amount to a inter-site PO.  So, cost mark-up is not considered here.

  • 0

    if the 2 sites belongs to 2 different companies, the sales price should value the receipt (including invoicing elements, but I haven't tested this on inter-site transfer). At worst it should work on inter-site shipment and receipt.

    If the 2 sites belongs to the same company, the cost issue is the cost received, no mark-up are possible. Here a suggestion I have never tested: use inter-site shipment and receipt and then create an additional invoice (of the mark-up value expected) on the inter-site receipt.

  • 0 in reply to Julien Patureau

    Additional Invoice works fine for Inter-Company (Inter-Sites between 2 different companies), but not for Inter-Sites within same company, because no invoice generated for inter-site within same company.  So, upon creation of Additional Invoice, inter-site PO No, Receipt No is not available for selection.

    I tried to test with Invoice Element, but not working as well.

    Inter-Site price list works for a fix amount that acts as a markup, but my customer wants to prorate a define estimated freight cost amount by order.  

    Any other thoughts? 

  • 0 in reply to Sage Employee
    SUGGESTED

    I'd like to clarify on my previous reply above.  

    After further testing, I found out Invoice Elements do work for my scenario, but not the price list.  

    My Purchase Invoice Elements setup is as below:

    • Value Type = Amount
    • Source = Order Supplier
    • Element presence = order footer
    • Line Distribution = Amount pro rata
    • Transfer rule = Amount pro rata
    • Stock valuation = Yes
  • 0 in reply to Sage Employee

    Hi Jennifer,

    What about the journal generated from the receipt? has the cost of invoice element been added to the inventory cost?

  • 0 in reply to Mahmoud Lulu

    Yes.  The total amount entered at invoice element has been proportion out by amount according to the Line Distribution setting, and added to inventory cost at receiving site during GRN.