@Richard James Uri-Oracle thank you for finding that thread. It's very loosely related to my issue in that we're both asking about SCM mobile customizations. The outcome of that case does lead me to believe that what I'm looking to do may not be possible though.

Yes from what I can tell, those resources only mention how the transaction itself can be written to via WMS additional field configuration. It appears the only way to write to inventory detail is via what is available natively.

@Shorin Rio Daa-Oracle please see the attached screenshots. The first shows that we have created a custom Item Additional Field called "Fabric Width (cm)" and have made it required for purchase orders. We also enabled the standard Heat Code and Supplier Lot Number on POs. The second screenshot is what appears in WMS.…

Thank you @Shorin Rio Daa-Oracle. Please allow me a bit of time to pull together those screenshots for clarification.

I think I may have found part of the answer to this. I found a helpful training in MyLearn titled NSAW: Working with the NetSuite Account Analysis Subject Area that walks through creating an income statement using the Account Analysis Subject Area. It didn't explain much, but I did learn that the TimeSheet Calendar has the…

Hi all, I was hoping someone here could help me understand NSAW Account Analysis works. I was able to get it running and the subject area shows up in OAC. However, I'm really struggling to use it. There doesn't seem to be a field that will consistently give me a transaction number. TYPEBASEDDOCUMENTNUMBER will give me a…

After some more testing I've found this to be an NSAW-specific authentication issue. If I am signed in to NSAW, the portlet displays correctly, otherwise, the site in the iframe refuses to connect to give the opportunity to log in. I imagine it would work if SSO was configured.

@Alex Joves -Oracle assistance in creating a support case would be greatly appreciated. Thank you!

Thanks again for the response @Alex Joves -Oracle . Just confirming, I'm completely fine with the user needing to log in to NSAW in the NetSuite iframe portlet to see the content. Oracle documentation shows how to embed OAC content in an external iframe, but it doesn't work for me. I suppose my question then is whether…

Thank you for the reply @Alex Joves -Oracle . I'm hoping to find a solution that will do something similar to the standard NSAW portlet with the following differences: 1) I don't want to use SAML SSO and 2) I want to be able to access the NSAW content from a NetSuite account that is not linked to the NSAW instance. I want…

I have been trying to do this as well @Elychelle Gulen-Oracle . We have the Account Analysis feature enabled and set up, but we cannot determine how to pull the account balances out of the new subject area. Do you have any guidance on that?

As an update, after digging deeper, we found that the data stopped duplicating in the Data Flow when we removed the transaction type column from the data. So I now know what was causing the issue, but I do not know why adding transaction type to the data (a column with a single value) is duplicating transaction lines.

@JohnW-Oracle thank you for the reply. When you ask for the logical SQL from the NSAW report, is that something OAC will give me, or are you just asking for what the SQL would be? Here are some more details about the issue. In the first screenshot below, I'm using the raw NetSuite - Customer Invoices dataset from the NSAW…

Thank you @Richard James Uri-Oracle . I have sorted this out. The error was due to a combination of not having the role given full permissions on a custom segment referenced on the project record, and not having the custom segments permission on the role set to full.

@Nicole Mendoza-Oracle Thank you! I haven't had the chance to try it yet, but I'll try it soon and report back.

@Nicole Mendoza-Oracle I don't get any error message. I don't think it's executing, or at least nothing shows up in the debug logs. Right now it doesn't do anything.

@Mikko De La Fuente-Oracle Yes it was visible. I was able to find the solution though. The correct code is: {{record:salesorder:{{state:dataRecord:scriptParams:transactionInternalId}},item:line:{{state:dataRecord:scriptParams:transactionLineId}}-custcol_fulfillment_group_id}} The problem is that I had a space after the…

@Mikko De La Fuente-Oracle Thank you for the suggestion. When I remove the double curly brackets from the beginning and end of the syntax, this is what the result looks like in the mobile app: record:salesorder:392, item:line:1-custcol_fulfillment_group_id