Vishal Chaudhari
04/07/2025, 6:10 AMCeligo AI
04/07/2025, 6:10 AMAI generated answer (using internal Slack threads):To calculate the landed cost and landed cost plus PO rate, you can create a saved search on the item receipt record. Here are the steps: 1. Go to Reports > Saved Searches > All Saved Searches > New. 2. Select Item Receipt from the list. 3. On the Criteria subtab, you can add your specific criteria. If you want only the first record, you can sort by date and limit the number of results to 1. 4. On the Results subtab, add the fields you need. For landed cost, you can add the field 'Landed Cost'. For PO rate, you can add the field 'Rate' from the Purchase Order line (you may need to join to the Purchase Order record to get this field). 5. To calculate the landed cost plus PO rate, you can create a Formula (Numeric) field with the formula
{landedcost} + {purchaseorder.rate}
.
Please note that the 'Landed Cost' field will only be available if you have the 'Track Landed Costs' feature enabled in your account. If you don't see this field, you may need to enable this feature (Setup > Company > Enable Features > Accounting subtab > Items & Inventory section > Track Landed Costs).
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
04/07/2025, 6:10 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825916708
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.825869
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.823680937
Celigo AI
04/07/2025, 6:10 AM