I have created saved search on item recipt to get ...
# ask-stanley-ai
v
I have created saved search on item recipt to get landed cost but i want only 1st record get quantity i want calcualte landed cost and landed cost plus po rate
c
AI 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. ******
Slack 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
Please provide your feedback on this answer.