@Tigran Shahnazaryan Could you elucidate the difference between payables and AP balance KPIs? When to use each one

@jenluna It should work but i have not tested this on Purchase transactions

Hi @jenluna, If you want to override defaulted nexus on sale transactions, for example from US nexus to canada nexus or vice versa you could append "&nexusoverride = {internal id of the desired nexus id}" to the URL of sale transaction and press enter. This will override the nexus and determine the tax codes for line…

Thanks for checking.

Hello @Joy Noreen Magoling-Oracle , we can’t waste anymore time on this by sharing all unnecessary screenshots. All the information has been shared at the top. kindly please check with your gurus or engineers on why components are still showing up when they are not in the actual sales order. thanks

Hello @Joy Noreen Magoling-Oracle , I just tried the same thing again that I have shared in the above screenshot with component of is none in the criteria but still same results. can you please check my above screenshots shared above with having component of is none ? Could you please check this behavior with your suite…

Hello @Joy Noreen Magoling-Oracle , Were you able to check with your internal team or gurus on this issue? Kindly please advise on how we can avoid components to show up search reseults. Please dont say to do a search on transaction, we are doing a search of type item for so many valid reasons. Thanks

Hello @Joy Noreen Magoling-Oracle , Like i mentioned in my original post, we have tested this extensively with having different things in criteria but its still showing components of assemblies from BOMR even though they are not present in the actual sales order. Please find the below screenshots of criteria and results…

Hello @Joy Noreen Magoling-Oracle, Were you able to test this with having advanced bill of materials enabled? Like i mentioned in my orginal post above, components that showing in search results are not in the sales order and those components are listed in the BOMR of the assembly. Thanks

Hello @Joy Noreen Magoling-Oracle , we have tried this and it’s not working because we are using advanced bill of materials where bom and bomr are the ones comprises of components not the actual assembly. I did also mention in this in my original post

Hello @Joy Noreen Magoling-Oracle , Our sales orders may contain all types of items, so we cant really limit like that by specifying item type as an assembly. All we trying to do is find a way to avoid of showing components of assembly items in search results which are not there in the actual transaction. Thanks

Hi Ubaid @User_JGEWC , If you have not found any solution yet, here is the sample code for you to create customer and vendor records with the same information and then merge both records by using ENTITY_DEDUPLICATION task type then both records will be merged by maintaining the link under other relationships. Please let me…

Thanks for the update.

Thank you for checking the feasibility on this issue. We understand, its possible through scripts or workflows to set header level field but we are trying to keep our system optimal by not having any custom fields for these simple needs. we would be looking for some way to make this work in the search to send this data to…

Sorry, that does not answer our question. Please advise if cogs amount or rate column of vendor bill can be accessed from dropship item fulfillment. We have a custom field created on item fulfillment to display actual cost of a line item. We need this field to be populated to caculate GPM on invoices/cash sales

Hi, I am currently residing in Dallas, TX. Is there one here that i can join?

Hi @Dominica Sevilla-Oracle , Is this possible to achieve using datasets in analytics?

Hi @Dominica Sevilla-Oracle , what we are looking for is, a way to get an actual cost which is cogs amount value from vendor bills since netsuite cogs posting happens on vendor bill for dropship po’s. We need this for to be able to compute actual gpm for commissions and others answers or suggestions you have provided might…

Hello, Any update on this?

Thank you @Elychelle Gulen, Yes, i think this will work for now

Hi Thanks for your testing and reply that’s the work around we currently have right now to get the unit price from the (amount/quantity in transaction units) but this can’t be accurate in all the cases because there might be times where amount may not be equal to unit price*quantity thats why we are looking to get item…

Thank you @Katerina Winklerova-Oracle Looking forward for your update on this

we could not find reset button on commerce category record. Is this button available only in the latest versions?

For this to show only contact names, go to set preferences and check only show last subentity check box