Blue Skies Blue Ribbon

Hi @Shiela Marie Villaluz-Oracle Thank you for your support. Best Regard,

Hi Nina Thank you for your support Best regard

Hi @Niks Blando-Oracle Thank you for your support. Best Regard

Hi @Niks Blando-Oracle Thank you for your support Best Regard

Hi @Angela Bayliss Thank you for the suggestion. I will give that a try and see how it works.

Hi @Angela Bayliss , Thank you for your response. I do use the AR Aging Detail report regularly However, I need a saved search for a different report, and I'm currently unable to retrieve the remaining amount as of a specific date. That’s why I’m curious if there are any suggestions for alternative fields or methods that…

Hi @Ayitah Tallada-Oracle Thank you for your support

Hi Gurus I am also experiening an issue with the rate changing when switching vendor in a purchase order. Has anyone found any solutions for this problem within NetSuite? Best Regards

Thank you so much @Katerina Winklerova-Oracle

Hi @Katerina Winklerova-Oracle , I need some information including Name, Description, Expense Account, Subsidiaries, and other fields on the saved search of Expense Category. Thank you for your support

Thank you so much @Patrick Fresnosa-Oracle @Joy Noreen Magoling-Oracle

Thank you for your support @Dominica Sevilla-Oracle I need to use the Import CSV function, so it cannot sort. Do you have any idea about this?

You should read this article Custom Segments and Custom Fields in Fixed Assets Management Records and Transactions Answer Id: 70166

Thank you for your support @Joy Noreen Magoling-Oracle "Also when exporting from NetSuite, we may also manually change the file type from XML Spreadsheet to Microsoft Excel Workbook before saving the file." => I've tried this suggestion, but I cannot change to another format

Thank you @Kristoffer Viray-Oracle The SuiteAnswer article Custom Segments and Custom Fields in Fixed Assets Management Records and Transactions Answer Id: 70166 is useful

Thank you @Katerina Winklerova-Oracle

Hi @Patrick Fresnosa-Oracle, Thank you for your detailed support. The Currency Revaluation transaction doesn't record Amount (Foreign Currency). So if I make a manual journal entry with foreign currency amount, it will make the wrong bank account balance. Have any solution to make a journal entry for a foreign bank account…

Thank you for your support @Patrick Fresnosa-Oracle I need revalue for the Bank Account type, it doesn't have customer/vendor. I tried an alternative solution to revalue the Bank Account type by making a Journal entry, but the bank accounts are in foreign currency so I cannot make a Journal entry with base currency. Have…

Thank you @Patrick Fresnosa-Oracle

@Dominica Sevilla-Oracle thank you for your support

Hi @Dominica Sevilla-Oracle I selected All on the Restrict field, but it will stay N/A

Thank you @Micah Timbol-Oracle , @Dominica Sevilla-Oracle I have tried to check, but none of the period ranges has zero value. I compare this period with the last period as below

Thank you @Dominica Sevilla-Oracle The Criteria doesn't work with my Invoice saved search (it shows No Search Results Match Your Criteria). Maybe I will use Sales Order Saved search instead.

Thank you @Dominica Sevilla-Oracle , I have tried the formula case when {accounttype} = 'Cost of Goods Sold' then {grossamount} else 0 end, but the column show value 0. I think no linking between Invoice and Cost of goods sold.

Thank you @Dominica Sevilla-Oracle , I have tried it, field Fulfilling/Receiving Transactions Fields: COGS Amount works for Sales Order saved search but it doesn't work for Invoice saved search. My Invoice saved search: Criteria: Type = Invoice Result: Document Number, Item, Quantity, Amount (Gross), Fulfilling/Receiving…

Thank you @Patrick Fresnosa-Oracle

Thank you @Jack Daryl Espiel-Oracle

Thank you for your support @Patrick Fresnosa-Oracle

Thank you @Joy Noreen Magoling-Oracle ?

Hi @Patrick Fresnosa-Oracle , Thank you for your support, I have tried your solution but isn't work. It is one report, bellow my detail step by step Setup Layout: Group by Department Setup columns: Row: Financial row (Department), Custom segment (Sale channel), Custom segment (Brand), Account Line (Name) Columns: Budget…