Hi @OliverK , Thank you for posting again in the community! Let our gurus/members check on this concern and update you for any findings. To everyone, feel free to provide your insights. -Mikko

Hi @CodeMe1010 , Thank you for posting in the community! Let our gurus/members check on this and get back to you with more information. To the community, feel free to comment your insights. -Mikko

Hi @Dirk Nieuwkamp , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your thoughts. -Mikko

For the first one, the article give example on how to update Sublist using Web Services and just include the isClosed in the item list. The isClosed can be found in the Schema Browser Sales Order -> ItemList -> SalesOrderItemList - SalesOrderItem. For the second scenario, let me further check on this again and update you…

May I ask if you need all the results columns? You may have to use summary type of group/min/max so that the result will only include those values that the formula is not null. -Mikko

The lot is included in the inventoryNumber table. The documentation related to this query are for general topics. You just have to explore each articles. See following articles for references: SuiteQL Syntax and Examples oa_tables -Mikko

Hi @Ian T , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. Thank you as well, Mark @User_4DP97 for providing your insights. -Mikko

For sample, you may check this article and use isClosed field in the Sublist for the Closed lined field on the Sales Order Record. For the second one, as mentioned, we could not set the status of the Sales Order to cancel and is also track as enhancement under 91063 WS > Customer is requesting the ability to upload Sales…

You may try this query : SELECT * from inventoryNumber a, inventoryNumberInventoryBalance b where a.item = b.item Then modify the query to select specific column/s. -Mikko

Do you still need assistance on this concern, @user6009036 ? -Mikko

Thank you for sharing your insight, @John Griffin ! Do you still need assistance on this concern, @GLL ? -Mikko

I have tested in sandbox and the connection using TBA works fine. Would you be able to submit a case to support team so they could further check if this could be a potential defect on your account? -Mikko

Could you please share what modification/steps you have done that does not work? -Mikko

Upon further checking, you are correct that it doesn't fire any client/user event triggers. I would suggest file an enhancement request for this scenario. -Mikko

Hi @Benjamin Paul - USA , you can query it using inventoryNumber / inventoryNumberInventoryBalance and query it using item's internal ID. Additionally, you can make use of OA_TABLES to check which tables are available for your account and it contains a remark for what is that table for. -Mikko

Hi @Camila O , could you please provide a screenshot of your criteria and result setup? Also, did you include the mainline in your criteria? -Mikko

Hi @User_H3JQ6 , you can make use of transaction table to check Currency Revaluation Record. You can use type or transaction type column in the transaction table to filter Currency Revaluation Record or directly use the id of the record. You can also check the transactionLine table for related line fields for that…

Hi @JohanvL , You cannot change the status of the Sales Order Record to close/cancel. However, you can update the Closed line field and close the Sales Order. -Mikko

Could you please clarify if you wanted to see a list of FILE Records or other type of records(Contact Record for example) attached to a Record? Also, what Record type you wanted to retrieve a list? This could be possible for example a Sales Order Record, you can make use of Transaction Saved Search and retrieve a list of…

Hi @User_CS3KK , Thank you for posting in the community! Our gurus/members will check on this and get back with more information. To everyone, feel free to comment your ideas. -Mikko

Hi @Radi , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. To everyone, feel free to share your insights. -Mikko

Hi Mark @User_QQ60G , Thank you for posting in the community! Our gurus/members will look into your concern and get back with more information. To everyone, we encourage you to share your thoughts! -Mikko

Hi @KNason76 , Thank you for posting in the community! Our gurus/members will check on your concern and will reply to this thread for any updates. To everyone, feel free to comment your ideas. -Mikko

Nice to see you again, @OliverK ! As you know, our gurus/members will check on this and get back with more information. To the community, do not hesitate to share your insights! -Mikko

Hi @AndreaK2 , Thank you for posting in the community! Please allow some time for the gurus/members to look into your concern and update this thread for any findings. To everyone, feel free to share your thoughts that can help. -Mikko

Hi @GLL , There is a feature that could answer your concern, it is called "Automated Intercompany Management". You may check this article to learn more about this feature. You may also want to discuss this with your Account Manager since after enabling this feature, you cannot disable it again. -Mikko

Hi @Jeff Dickens , you may explore using record.attach(options) to attach file to a record and N/file Module to manipulate a file. Let us know if this helps. -Mikko

How's it going, @Vernita ? Have you tried using the summarize for the send email function? -Mikko

Hi @User_HPB3I , how's it going? Do you still need assistance on this concern? -Mikko

As of the moment, there is no specific time as to when the TIMEOFDAY will be supported. If you could submit a case to support team, that case will be attached to the issue record and you will be notified for any movement. -Mikko