x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 138 subscribers
  • Views 1061 views
  • Users 0 members are here
Browse Forums
Announcements
234
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
209
topics
410
replies
Sage Intelligence Reporting
121
topics
322
replies
Lee Sommerfeldt

What mechanism sets price for Intersite Orders?

SOLVED
Posted By

Hello All,

Encountering something in our Sage X3 setup that I'm having trouble hunting down the source for. We have some Inter-site orders between us and some distribution companies. For this transaction, we want the gross price to be set to 0 automatically since it's just an inventory transfer to an inter-site BP. The issue is that some of our products' pricing appears when we submit the Purchase Order from the Inter-site BP from our main facility. However, newer items aren't having this issue. In the image below, you'll see that 2 of the products have a price automatically filled in, while the last one defaults to zero (the desired behavior). I cannot figure out how to get the price to stop filling in.

My suspicion is that it's related to the Supplier tab in the Product record, as this was the only notable difference in setup between the items that do have a price auto-fill and those that don't. However, even when editing the Supplier tab to try to keep it from connecting to our Price List, the prices still ended up auto-filling.

Thank you in advance for any help you can provide. 

Top Replies

  • 0
    SUGGESTED

    Hi ,
    I see you are in a inter-site flow but not inter-company flow (same company linked to the supplier site and customer site). 
    In that case, I don't understand why you worry about the price. Price in inter-site are not used! There are no invoicing process (no margin, no profit) and the stock value received will be based on the stock value issued on the supplier site. So if using average cost, the AVC at the time of the delivery validation will be used as order price to value the stock received on the other site disregarding the price set in the purchase and sales orders.

    I hope this helps.

  • 0 in reply to Julien Patureau

    Else you can use the action menu on the PO line to understand where the default price came from:

  • 0 in reply to Julien Patureau

    Hi Julien,

    Thank you for your response. We'd like to avoid having the price included as it can otherwise appear in our reporting of Sales Order data. For example, the PMD order site in the image I attached is treated as its own BP, so I believe it would be intercompany. I've used the Price Explanation function which just tells me "Default Price" as the reason. This brings me back to my original question of "where is this price coming from?" We've encountered another item where not only does the price fill in, it is the incorrect price. There is no Purchasing Price List set up for these items. 

  • +1 in reply to Lee Sommerfeldt
    verified answer

    To retreive where the price come from:
    1/Check if you have a valid price list for this product.

    2/If you have multiple ones, then look for the price list associated to the reason code Default (usually this is the code 2).

    3/If no price matches - I guess because not applicable to inter-site -, then check the base price set on the product:

    4/Last, the system allows to use the standard cost as default price (parameter value PURPRICE)
    So check of the amount matches the standard cost valid at the time of the PO creation.

  • 0 in reply to Julien Patureau

    Thank you Julien. This was it!

*Community Hub is the new name for Sage City