We are using trade agreement journal to manage the purchase and sales price of our products. Sometimes there are multiple valid (in terms of date and quantity) records of price trade agreement for the same item, but with different prices and different From dates; When creating orders, system will choose one of the trade agreement; The problem is, we don't understand the logic behind the choice. We suspect there are multiple factors involved, but we're not sure of the exact rules:
- The created /modified /posted time of the trade agreement journals
- From dates and To dates
- Prices
- ...
Suppose all of the records in question are for all customers/vendors, and for a specific item; All of them have valid dates and quantities; All of them share the same site, warehouse and currency.
