Hey @shikhagrover ,
I faced a similar issue before. I used the below steps to get it resolved:
- Go to the `Expense Lines` table.
- Open the view where you added the reference column.
To address the currency issue:
- Verify the field `TimeCard.ResourcePlan.SalesRates` is correctly referenced.
- Check the `TimeCard` table for currency settings.
- Ensure `ResourcePlan` settings are correct for project-specific currency.
If the issue persists, consider these steps:
- Create a new `Business Rule` on the `Expense Lines` table.
- Set `When` to `before` and `query`.
- Add a `Condition` if necessary to target specific records.
- In the `Script` field, add:
// Fetch the SalesRates in project-specific currency
var resourcePlan = new GlideRecord('resource_plan');
if (resourcePlan.get(current.time_card.resource_plan)) {
current.time_card.resource_plan.sales_rates = resourcePlan.sales_rates;
}
Alternatively, you can create a `Calculated Field`:
- Navigate to `System Definition` > `Dictionary`.
- Find or create an entry for the `Expense Lines` table.
- Set `Type` to `Calculated`.
- In the `Calculated Value` field, add:
// Calculate the sales rates in project-specific currency
var resourcePlan = new GlideRecord('resource_plan');
if (resourcePlan.get(current.time_card.resource_plan)) {
answer = resourcePlan.sales_rates;
} else {
answer = 0; // Default value if not found
}
Give this a try, and let me know if it doesn't work, I'd be happy to assist.
