Richard James Uri-Oracle Blue Diamond

Hi, Can you check in the permissions if the Credit Memo and Find Transaction are added to the Role you are using? Navigate to Setup > Users/Roles > Manage Roles Click Edit on the Role Go Permissions >Transactions This might be the possible reason of not returning the right results.

Hi @katherine_15328 , Glad to know that it is okay now! Have a great day!

Hi @katherine_15328 , As per checking, the page is accessible now and you can now logged back in. Thank you!

Hi, @katherine_15328 , We are looking to this issue and and we'll be keeping you updated on the results. Have a great one!

Nice to see you posting here, @KNason76 Kindly allow us to review your concern and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Nice to see you posting here, @Melanie Schaefer Kindly allow us to review your concern and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi, As per checking on the related concerns, for workarounds, try on processing the records by batch.

Hi @User_VDX5O , Can you try this query if this will meet the concern? SELECT * FROM TRANSACTION tr INNER JOIN NextTransactionLineLink tl ON tr.TYPE = tl.NEXTTYPE AND tr.TYPE='CustCred'; or try to use the transaction and NextTransactionLineLink tables to get the Credit Memo and the related record is Invoice. This is based…

Nice to see you posting here, @Maleeka Kindly allow us to review your concern and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @User_VDX5O , Good day! Lists of Credit Memos are located in the transaction table. You can check the "CustCred" value in the type field to see it or just simply write this query, SELECT * FROM TRANSACTION WHERE TYPE = 'CustCred'; Hope this clarifies your concern. Feel free to reply on this thread if you have further…

Hi @Vernita , In InventoryItem, you can set a location to specific inventory item via Internal ID. You can check this browser to see the field. Upon checking, you can also set or get a child of a specific parent class. This is also same with Location and Department. You can also check the addList operations in SOAP Web…

Apologies on this also, yes, according to my testing, it will show if the child is parent of a specific record. Internal ID: 2 | Name: Purch Child

Hi @Vernita , Am I reading this correctly that since it makes reference to parent department set up, this will always be available through a soap integration? (and that is true for both body level fields and sublists) Yes, parent in Department, Class and Location is available since it is showing in the SOAP Schema Browser.…

Hi @User_VDX5O , It is good that it working in your end! Thank you! 😉

Hi, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

Hi @Vernita , Good day! Upon checking all of our resources, here's what I have found. I wanted to confirm first the Departments, Classes and Locations and these are supported in SOAP Web Services. Kindly check the browser to verify your concern. SuiteAnswer Articles and Corresponding Browser: 10949 Location Browser 10903…

Hi @User_VDX5O , Good day! You need to add this format to be able to achieve the date/time object in SuiteQL. TO_CHAR(createddate , date/time format) Format examples: 'DD-MM-YYYY HH24:MI:SS' 'MM-DD-YYYY HH24:MI:SS' 'MON-DD-YYYY HH24:MI:SS' 'YYYY-MM-DD HH24:MI:SS' Given this, you can try this SuiteQL to full the date/time…

Hi @User_E0AJC , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @CRATIV_Jason , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @Buckeye1497 , Thank you for replying to this thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @OliverK , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @SweetBiller , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @Durga Rao , Upon checking all of the resources about the error encounter in the Execution Log. The com.netsuite.suitescript.scriptobject.ScriptNullObjectAdapter tends to come when the script exceeds its execution limits. As you have mentioned, after 1 hour, the Map/Reduce Script turns to have a Failed Status. With…

Hi @User_IJB6M , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @FazeprooF , Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @User_NLK5H , It is good that the concern is now resolved! And thank you for the additional information about the concern. Have a great Tuesday ahead!

Hi @User_F1RAL , Glad to have you with us today and thank you for creating another thread in NetSuite Support Community. Kindly allow our gurus to review your concern and perform their initial investigation. We will reach out again if we have updates on this. To other members of the community, feel free to share your…

Hi @Durga Rao , Can we confirm if there's an error stated in the Execution Log of the Map/Reduce Script Record? This page can be accessed through the concerned Map/Reduce Script record > Execution Log Tab Thank you!

Hi @User_NLK5H , Thank you for that information. This means that when you have replicated the setup in your live account, you don't have any error encounter?

Hi @Lewalsh11741 , Thank you for sharing this information. Please let us know if you need further assistance. Thank you and Have a great Monday ahead!