Eunice_C

hi @Clarisa De Torres-Oracle it worked now that i added per-account instead of None. Thanks for your help on this.

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Aug 4, 2023 8:47AM

@Clarisa De Torres-Oracle unfortuantely this doesnt work. Thanks for your help. Kind regards, Eunice

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Aug 3, 2023 9:13PM

@Clarisa De Torres-Oracle is amount net of tax field the foreign currency amoutn net of tax? It is foreign currency net of tax that i am looking for.

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Aug 3, 2023 8:05AM

@Clarisa De Torres-Oracle sorry it seems my comment was nto posted. i still receive error message after selecting none. The customer name is now displaying correctly. Thanks. Please see saved searh set up below.

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Aug 1, 2023 1:18PM

@Clarisa De Torres-Oracle I receive an error message to say the 'Error:Field not found' Thanks.

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Jul 26, 2023 4:10PM

@Clarisa De Torres-Oracle also part of this report, i would like to show the customer name without the parent hierarchy. Currently on the report it shows as ID+ customer name : customer name e.g. C001 BADRO : BADRO. how Can i view as C001 BADRO only? I tried some suggested formulas but receive the error message ERROR:…

in How to show Net Amount Foreign Currency on saved search that match the value on transactions? Comment by Eunice_C Jul 26, 2023 10:33AM

hello @Clarisa De Torres-Oracle I am doing another report and have the same error message with the formula {netamountnotax}/{exchangerate}. I follow the same steps above but the error message still appears. this is a saved search for customer daily sales /credit notes consolidated to give just the daily total per customer.…

in saved search for customer daily sales foreign currency net of vat Comment by Eunice_C Jul 26, 2023 9:53AM

@Clarisa De Torres-Oracle Thank you it worked. Just slight rounding issues. I wonder if it is possible to show the transaction subtotal on the report in the transaction currency whcih would also produce the net amount foreign currency? I would like to see if this would then match exactly the transaction, Thanks

in How to show Net Amount Foreign Currency on saved search that match the value on transactions? Comment by Eunice_C May 18, 2023 1:04PM

@Kristoffer Viray-Oracle it didnt work. It is not giving the total with this. I need to get the total value of the shipped quantities. I tried a formula but it doesnt seem to be pulling through to the field. The field remains blank. Please see screenshots below.

in how to pull total amount on item fulfilment Comment by Eunice_C Dec 6, 2022 12:19PM

@Niks Blando-Oracle I have managed to do some additional work on this and I am managing to pull the information from the saved search to a new body field on the IF. However the information pulling through to the IF is not correct. It is the value of the SO and not the value of the items shipped. It also needs to include…

in how to pull total amount on item fulfilment Comment by Eunice_C Dec 1, 2022 3:26PM

Hello @Niks Blando-Oracle Sorry for the delay. Please see screenshots below of saved search. How can I get the amount field to reflect on the Item fulfilment as a new body field? Thanks.

in how to pull total amount on item fulfilment Comment by Eunice_C Dec 1, 2022 1:27PM

@Niks Blando-Oracle thanks very much. Would I be able to pull this infor into a custom transaction body field on the item fulfilment? If so please advise how I could do this? Thanks.

in how to pull total amount on item fulfilment Comment by Eunice_C Nov 29, 2022 5:10PM

@Ivy Lopez-Oracle Thanks very much! That solved it!

in Internal ID not in saved search but appears on saved search in non-administrator role Comment by Eunice_C Mar 8, 2022 3:13PM

@Mikko De La Fuente-Oracle it is an item fulfilment search.

in Internal ID not in saved search but appears on saved search in non-administrator role Comment by Eunice_C Mar 8, 2022 3:10PM

Please see pictures showing the same role on different users with two different views.

in Internal ID not in saved search but appears on saved search in non-administrator role Comment by Eunice_C Mar 8, 2022 3:09PM

@Ivy Lopez-Oracle Thanks for your response.

in How can I export the adjust inventory worksheet view via CSV from a report or saved search? Comment by Eunice_C Mar 8, 2022 2:42PM

@Shamaine Chan-Oracle Thanks very much for yoru response. Kind regards, Eunice

in Is it possible to link multiple Sales orders to a single Purchase Order Comment by Eunice_C Aug 26, 2021 9:06AM

Thanks @Pauline Joy Cac-Oracle I will try this. :)

in Add countryof origin to advanced PDF invoice Comment by Eunice_C Mar 25, 2021 10:14AM

@Pauline Joy Cac-Oracle Thanks. it seems we will need scripting to automate the fulfilment and invoicing process. Thanks, Eunice

in Fulfilment and invoicing workflow Comment by Eunice_C Mar 23, 2021 9:36AM

@Ivy Lopez-Oracle Thanks for confirming.

in Multiple base prices for single currency Comment by Eunice_C Mar 19, 2021 4:49PM

@Ivy Lopez-Oracle Thanks for confirming.

in Multiple base prices for single currency Comment by Eunice_C Mar 19, 2021 4:49PM

hi @Ivy Lopez-Oracle Netsuite team have implemented a suite script that pulls the base price from a saved search. this means that when we overwrite a base price by csv upload the script always overwrites the prices any time the document is changed or saved. This is a real nightmare and i wonder if there is a way to exclude…

in Multiple base prices for single currency Comment by Eunice_C Mar 19, 2021 11:07AM

@Ivy Lopez-Oracle thank you very much. In this case we need to update the base price in order for it to show on our invoices which you have confirmed is not possible. Kind regards, Eunice

in Multiple base prices for single currency Comment by Eunice_C Mar 17, 2021 9:54AM

@Jack Daryl O Espiel-Oracle @Michelle Jabanes-Oracle Thank you very much! It worked! ?

in Restrict view and access to a customer's transaction records. Comment by Eunice_C Dec 3, 2020 3:07PM

Hello @Jeff Pineda-Oracle & @Michelle Jabanes-Oracle Are you able to help with my follow-up question? Thank you.

in Restrict view and access to a customer's transaction records. Comment by Eunice_C Dec 1, 2020 4:33PM

Hi @Jeff Pineda-Oracle & @Michelle Jabanes-Oracle I checked out these options and since there are some roles working across various departments and locations this would not entirely work in this instance. I also found the suite answers article regarding a workflow to restrict viewing of transactions for private customers…

in Restrict view and access to a customer's transaction records. Comment by Eunice_C Nov 25, 2020 10:34AM

Hello @Jeff Pineda-Oracle, To clarify: We have two business departments in our company. Wholesale & E-commerce. We have sales & operations roles that see all sales order transactions (fulfilment & billing), therefore I would like to restrict what transactions each department can see. If a role can be assigned to a…

in Restrict view and access to a customer's transaction records. Comment by Eunice_C Nov 24, 2020 9:05AM

Hi @Pauline Joy Cac-Oracle I managed to add the ship address to the template. I have another query regarding lines that have been cancelled or closed on a sales order that are still showing on the printed Sales order document. How can these be excluded from the PDF file? Thanks. Kind regards, Eunice

in How to add additional address to invoice, order and proforma advanced pdf Comment by Eunice_C Nov 3, 2020 11:26AM

@Herdi Rana-Oracle Thank you very much. Kind regards, Eunice

in Impact of changing costing preferences for negative stock Comment by Eunice_C Oct 14, 2020 9:22AM

hi @Shamaine Chan-Oracle Thanks for above. When I add received date on the report it is showing dates on lines that have been closed. So I will create a saved search instead. Thanks very much. Kind regards, Eunice

in Empty fields on report Comment by Eunice_C Oct 9, 2020 10:18AM

MFA for Oracle Community

Eunice_C Red Ribbon

Comments