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.

Parents
  • 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?

Reply Children