Hi @Katerina Winklerova-Oracle Is it supposed to automatically add a bill to the income/expense tab if the bill is created (and not edited) with reference to the related asset in the related asset line field? So far I have found that to not be the case.

Hi @Tiru Chembeti I don't have that checkbox on the subsidiary record. Is that part of the suiteapp? Thanks

Hi @Micah Timbol-Oracle I wanted to set up the expense validation suiteapp so that if expenditure is entered on a supplier bill that exceeds the budget for that line, a warning shows up. I have followed the instructions for the suiteapp though cannot get the validation to work.

Hi @Micah Timbol-Oracle I had already marked one of your comments as the answer. thanks

Thanks for the link @Richard James Uri-Oracle So would this (suitelet) be used in place of the standard location selection drop down in a sales order record? Thanks

Thanks @Katerina Winklerova-Oracle So does that mean the limitations listed on Suiteanswers: shouldn't be an issue here?

I have edited the script though am still getting an error // Create the search using the filters var invoiceSearchObj = search.create({ type: "invoice", filters: filters, columns: [ search.createColumn({ name: "internalid", label: "Internal ID" }), search.createColumn({ name: "trandate", label: "Date" }),…

Hi again Any updates @Niks Blando-Oracle ?

Any updates on this @Niks Blando-Oracle ? thanks

Hi @Katerina Winklerova-Oracle No the bank details are not updated. That might be the issue. I haven't customised it though the common thread with the two accounts where that issue is seen is they have an old bundle.

Hi @Clarisa De Torres-Oracle There is no net amount column available in the transaction dataset from what I can see

Hi @Patrick Fresnosa-Oracle In this case, the subsidiary currency and the parent currency are the same (AUD). It is only the transaction that was conducted in another currency (USD). Why would this use the consolidated exchange rate? Wouldn't the consolidated exchange rate be used when the parent and child subsidiaries…

Hi @Angelica Mae Segador-Oracle Just to clarify, I was wanting the system notes on when a child record was attached to a parent record. Not so much the ability to create a child record (which I can do). But more around when the child record was attached to the parent. From the system notes, i can see that visible on the…

Hi @Tigran Shahnazaryan I saw that though assumed that shouldn't affect the bank details record. There is a default company wide calendar and one on the employee record. Since that error only appears in one of the environments of the account, I believe this is an issue with the script/version of the bundle.

Hi @Clarisa De Torres-Oracle I did and I can't see that field:

Thanks @Clarisa De Torres-Oracle ! That worked Though am I able to access that field in a dataset for transactions? (rather than sales (invoiced))?

Hi @Clarisa De Torres-Oracle That option doesn't appear for me in any of the accounts I am looking at for Sales (Invoiced) dataset

Sorry, related to that @Clarisa De Torres-Oracle , the amount (net) transaction currency field doesn't appear to be in the Transaction dataset. It seems to only be present in the Transaction Line data set

Hi @Patrick Fresnosa-Oracle I am using the transaction data set. The field I am filtering on here is the 'date' field: does the First Fiscal Month represent the Calendar of the Parent Subsidiary? Do you mean is the July First Fiscal Month taken from the parent subsidiary record? That screenshot was from the company…

Hi @Clarisa De Torres-Oracle I don't see any option for conversion: This is the field I am using:

Hi @Patrick Fresnosa-Oracle I have updated the setting, logged out of the account, cleared cache though am still getting the following: This setting has never changed:

Hi @Angelica Mae Segador-Oracle Per the screenshots in my post above, it is possible to create a saved search showing standard cost at different dates. Is the limitation around sourcing it on a transaction record?

Hi Here are the details of the field: The items are mainly 'Lot Numbered Inventory Items' Example: All items have a standard cost sublist on the item record showing what the standard cost is :

Thanks @Tigran Shahnazaryan I wanted to copy a pivot within the same workbook without having to add all the fields to it again Similar to Excel's copy sheet function.

Hi @Kristoffer Viray-Oracle I am trying to populate a transaction line field on an invoice with the standard cost of the item as at the transaction date. I will try to get screenshots from the account thanks

Hi @Richard James Uri-Oracle I couldn't see from my script which function was missing the fieldid

Hi @Micah Timbol-Oracle The current period is set up in Netsuite which is why I am confused over the error in the cash flow report.

Hi this was a new schedule that has not been edited. This particular one is in a sandbox environment though the problem originally arose in production

Hi @Clarisa De Torres-Oracle The Suiteanswers matches what my expectation was Namely, the months with the same number of days should have the same amounts. It is inconsistent with what I am seeing the account however: Months that are 31 days have different amounts For example: Why would May and Oct have different amounts…

Hi @Micah Timbol-Oracle Have you had a chance to look at this yet?