Yanie Carpen

Hi @Patricia Ann Divino-Oracle@Patrick Fresnosa-Oracle, Using the Analytics tab in NetSuite, the workbook was created. It displays the decimal places however it doesn't follow the format for some reason (i.e. the settings on the previous screenshot is 2, however, the exported file is displaying all the decimals.) Decimal…

in Format Decimals in SuiteAnalytics for EU Localization Comment by Yanie Carpen Jun 29, 2022 9:28AM

@Michelle Jabanes-Oracle this solved the issue. thank you for helping :)

in AE: Opportunity is being displayed multiple times when using Global Search Comment by Yanie Carpen Mar 8, 2022 4:45PM

@Michelle Jabanes-Oracle apologies for the late response. I'm only typing the record type plus the name of the customer (i.e. opp: ABC Company).

in AE: Opportunity is being displayed multiple times when using Global Search Comment by Yanie Carpen Mar 7, 2022 2:51PM

Hi @Michelle Jabanes-Oracle, we don't have a defined result for this. Just to give a background of what happened is that we used the Global search to look for an Opportunity record using the Customer Name however, when we did that, it reflected duplicate Opportunity Document Numbers even if in reality, it's only one record…

in AE: Opportunity is being displayed multiple times when using Global Search Comment by Yanie Carpen Mar 2, 2022 4:51PM

hi @Michelle Gatdula, apologies for the late response. upon checking, the "GLOBAL SEARCH INCLUDES TRANSACTION NUMBERS" is already unmarked.

in AE: Opportunity is being displayed multiple times when using Global Search Comment by Yanie Carpen Mar 1, 2022 10:25AM

Hi Erick, Apologies for the late response. My colleague was able to solve the problem and it was due to wrong amount being provided on a certain line on the Excel file. That's the reason why the amounts were different in NetSuite vs the Excel file that is imported. Nonetheless, thank you very much for your help.

in Vendor Bill Total Amount and Total Tax Amount not same from Excel Import Comment by Yanie Carpen Dec 14, 2021 12:24PM

What we did is we got the variance of the Total Amount (NetSuite) and the Total Amount (Excel File) which is 15.83 and we divide that to the total GL Impact Lines which is 296. The result of that is 0.0534797297297297. I'll share the screenshot of the GL Impact, the actual Vendor Bill and how we got the variance of 15.83.…

in Vendor Bill Total Amount and Total Tax Amount not same from Excel Import Comment by Yanie Carpen Dec 9, 2021 11:23AM

Hi Erick, attaching the files for your reference. Just a background info for the process: The excel file is provided by our client's vendor and our client imports it using the Suitelet that we made for them. The Suitelet will convert the Excel file to JSON data and creates a custom record that is stored in NetSuite. The…

in Vendor Bill Total Amount and Total Tax Amount not same from Excel Import Comment by Yanie Carpen Dec 7, 2021 2:06PM

hi @Dominica Sevilla-Oracle, haven't tried that one yet since the file from the client can't be imported using NetSuite's built in import (different client excel template vs NetSuite excel template). The discrepancies was encountered using the Suitelet but there are few imports that doesn't have any differences.

in Vendor Bill Total Amount and Total Tax Amount not same from Excel Import Comment by Yanie Carpen Dec 6, 2021 4:53PM

Yanie Carpen Newbie

Comments