Vernita Bronze Trophy

Hi @Patrick Fresnosa-Oracle My understanding is that so long as the vendor bill and customer invoice are part of subsidiaries within the same grouping, they should eliminate. This is the structure: The customer invoice is from subsidiary A. The vendor bill is from subsidiary B. The transactions are paired using…

Hi @Red Velasco-Oracle This is the custom form: Payment option is showing as a separate field to the refund method field. the field id for payment option is: paymentoption thanks

getCurrencyRate

Hi @Richard James Uri-Oracle I have searched the filing cabinet looking for file names which contain 'ext'. I can only find: Is it correct that all library files are linked to script records? (similar to the above screenshot) Or can they be referenced in a script without showing up on the script record? Thanks

Hi Gaurav Thanks for the suggestion. I think the custom transaction won't work since there isn't a way to create bank payment batches for it. I have decided to go with my original thought: grey out the 'For Electronic Payment' "button until another custom field (ápproved for refund' is checked after approval

Hi @Micah Timbol-Oracle "Using the Australia Bank Feeds SuiteApp in the NetSuite Sandbox environment only connects to SISS Sandbox, thus the bank data that will be imported are all fictitious." That statement is not correct. The data returned is real data, When filling in the SiSS data connection form, it asks you to…

Thanks @Jervin Nicholas Teopengco-Oracle That works! For the old records, I have updated the values using a CSV import and the values from the workflow history saved search

Thanks @Micah Timbol-Oracle This is a new account which is undergoing testing in sandbox before being migrated to production. I wanted to confirm that I didn't need to fill in more than one form: One for sandbox to get access from the bank and, later, for production to get access. Based on what you have linked, it sounds…

Subscription Plan

Actually, found the reason: Even though it displays as 'Yes' for the 'posting' field, the result is evaluating to 'T' or 'F'. This amended formula works: CASE WHEN {transaction.posting} LIKE 'T' then 'YES' else 'NO' END

false..

Hi @Nicole Mendoza-Oracle Over 300. Thanks

Hi @Clarisa De Torres-Oracle thanks for that. I was wanting to print customer deposit transaction PDFs and not deposit slips. Is it possible to do that? thanks

Hi @Angelica Mae Segador-Oracle Thanks but that is not what I was after. I was wanting to source individual fields. For example, just address line 2 on a customer deposit PDF

Hi @Micah Timbol-Oracle To confirm I have understood this correctly: Getting access to a bank feed using the Suiteapp means it is available in both environments (Sandbox and Production) without having to fill in multiple forms for SISS? However, it is recommended to disconnect the sandbox one when the production one is…

Thanks @Angelica Mae Segador-Oracle Is it possible to reorder them so they are moved to the bottom of the list in the Classic Centre?

True

Hi @Jervin Nicholas Teopengco-Oracle Thanks for the detailed test results. To confirm: if I wanted the action in state 2 to occur at 10:05 pm : The transaction enters State 1 at 6:39pm, There is a 1 hour delay before the state 1 action (send email) occurs. Because of there being no free processor queues, this doesn't…

Hi @Jervin Nicholas Teopengco-Oracle Yes, I need a way to specify which template (XML file) to use when creating a traveller PDF. The work order and BOM traveller suiteapp allows this by allowing the user to define which folder the template is stored in: However, there doesn't appear to be an equivalent in the SCM bundle.…

Hi @Patrick Fresnosa-Oracle Yes, all subsidiaries are in the same instance. However, to prevent the transactions from eliminating (such as customer invoices from Japac which is the vendor bill for USA), the transactions will be regular transactions and not intercompany transactions (i.e. not paired and not using customer…

HI @Richard James Uri-Oracle The search: varexpensereportSearchObj=search.create({ type:"expensereport", filters: [ ["type", "anyof", "ExpRept"], "AND", ["mainline", "is", "F"], "AND", ["taxline", "is", "F"], "AND", ["trandate", "within", startDate, endDate], "AND", ["expensecategory","noneof","@NONE@"], "AND",…

Thanks @Tris Mendoza-Oracle So the parent item BOM does not need to be added as a component to the child item's BOM?

Advanced Financials

Hi @Wee Ming and @Jeremy Guimaras-Oracle Yes, there is an expense line as well. Is there a way to turn off the option to receipt for expenses? thanks

Option B

Hi @Veronica Steluta Mincior-Oracle and @Vajrala Madhu Reddy That Suiteanswer is describing making the option available for items. Previously, it was greyed out on the item record (off memory) if the item had transactions against it. That doesn't apply here. This is is a service item that is newly created and has never…

Hi @Patrick Fresnosa-Oracle This is what the structure looks like in NetSuite: International Head Office isn't a real subsidiary in the sense that there is no legal entity for this in reality. It is designed to allow JAPAC and America to exist in the system. There is no consolidated reporting for the 'International Head…

Map/Reduce

Hi Patrick. Correct. If the net amount is recoded to the project subsidiary, it doesn't make sense for the tax to be sitting against the employee subsidiary. i can't see a way to fix this so I had hoped there was a setting that would allow the system to recode the tax inclusive amount in the adjustment journal., Thanks

Hi @Veronica Steluta Mincior-Oracle The custom role with the missing field is a SuiteSuccess FF PRM-AP and AR Combination role (the permissions of those two roles have been combined to form a single role). The role it is being compared to is a SuiteSuccess FF PRM-Accounting Manager role. This is the role where the…