PriceTransactions
PriceTransactions[transaction]⟹table
provides a table listing the transactional pricing information for all materials in transaction.
PriceTransactions[notebook]⟹table
provides a table listing the transactional pricing information for all materials from received transaction orders in notebook within the last month.
PriceTransactions[notebook, dateRange]⟹table
provides a table listing the transactional pricing information for all materials from received transaction orders in notebook in the time period defined by the dateRange.
PriceTransactions[team]⟹table
provides a table listing the transactional pricing information for all materials from received transaction orders in notebooks financed by team within the last month.
PriceTransactions[team, dateRange]⟹table
provides a table listing the transactional pricing information for all materials from received transaction orders in notebooks financed by team in the time period defined by the dateRange.
Details
- All items received by the ECL are charged a handling cost upon arrival (this applies to items originating from sent, dropshipped, and ordered transactions where the product is acquired through an external supplier). The handling cost consists of a receiving cost for each model object in a particular transaction, and an additional cost for each sample's weight or sample volume measurement, if applicable.
- All items shipped from the ECL to the user are charged a handling cost, packaging materials, shipping costs, and aliquoting, where applicable.
- For pending transactions to the user that are not yet shipped, shipment cost is estimated based on the latest shipping price report (Object[Report, ShippingPrices]) available for the transaction's source site, shipper, shipping speed, and shipping container(s).
- For clarity, all of the above described pricing components (receiving, handling, shipping, packaging and aliquoting) are displayed as individual entries in the output.
- Transactional pricing information is only calculated for non-cancelled transactions; pending or partially received transactions are included in the pricing.
- For the Team or Notebook overloads fully received transaction are priced; all other transactions are filtered out and not displayed in the output.
- By default, if Teams or Notebooks are specified and no date range is provided, the function defaults to showing transactions received in the past 30 days.
- Note that the prices displayed in this documentation are only for the sake of presentation and do not represent actual prices.
Input
Output
General Options
Examples
Basic Examples (4)
Displays the transactional pricing information in a given transaction as a table:
Displays the transactional pricing information for a list of all types of transactions as one large table:
Displays the transactional pricing information for transactions tied to a given notebook:
Displays the transactional pricing information for all transactions tied to a given financing team:
Additional Examples (9)
Displays the transactional pricing information for transactions tied to multiple notebooks:
Displays the transactional pricing information for all transactions tied to multiple financing teams:
Specifying a date span excludes transactions that fall outside that range:
Date span can go in either order:
Transactions whose samples are measured upon arrival are charged a volume-, weight- or count-measurement fee per sample, in addition to the receiving fee per model:
Pricing may be estimated for a pending transaction that is shipped to the user:
If a transaction has been canceled, do not include it in the transactional pricing:
If a transaction has been refunded, do not include it in the transactional pricing:
If a transaction has been canceled, do not include it in the transactional pricing:
Options (7)
Consolidation (3)
Specifying Consolidation -> Notebook groups all items by Notebook and sums their transactional prices in the output table:
Specifying Consolidation -> Transaction groups all items by Source and sums their transactional prices in the output table:
Specifying Consolidation -> Material groups all items by Material and sums their transactional prices in the output table:
OutputFormat (4)
If OutputFormat -> Association, returns a list of associations matching MaterialsPriceTableP:
If OutputFormat -> TotalPrice, returns a single price summing the transactional cost of all materials:
If OutputFormat -> TotalPrice is specified, this overrides the Consolidation option and returns the total summed price:
If OutputFormat -> Association is specified, this overrides the Consolidation option and returns a list of associations matching MaterialsPriceTableP:
