Slobodan Sobic Blue Ribbon

Hello @ojn, There is no standard method to achieve your request, however there is SuiteAnswer: 27296 document and you can check it if this works for you. If you need someone to develop this, let me know. Regards,

Hello @ojn , There is a solution to attach pdf of transaction and send email via suitescript. Let me know if you are looking for this approach. Regards,

Hello @Vernita , Would you be able to share the source code of the Advance PDF ? If not, you should be able to edit the field in the source code to ${record.amount?abs}. Obviously, you need the correct ID of the field. If you are not familiar with the source code, feel free to provide it and I will get back to you with…

@Niks Blando-Oracle , Any update on this ? Regards,

Hello @Pamela Pierce-Oracle, Will the in-person sessions offer any downloadable eBooks or other resources for participants in case there are the interesting sessions in the same time ? Regards,

Hello @ZShah , The field you are looking for is called : Applying Transaction Applied to Transaction If you have any questions, please feel free to contact me. Regards,

Hello @User_JKLFU , Could you please add item column ? Then you will see the output and where is the issue. Also, please send us the screenshot with item column included. Regards,

Hello @PaulFleetwood, Would you be so kind and send the csv file with the results you have with explanation which values should be converted/replaced ? (please do not forget to hide sensitive information) Regards,

Hello @Excelsis Sia , I think you will have a quicker respond via ticket. Please create a case for this. Regards,

Hello @User_L8T63, Would you be so kind and provide more details on this matter ? I am not sure what you want to achieve here and what results you are expecting. It would be helpful if you can give me more information and the results if any. Regards,

Hi @Nilanjan Biswas-Oracle , You are right. I am not sure what else to add here. Have you tried to log out and log in and see if there is feature available ? Regards,

Hello, Have you tried under the Setup > Integration ? Please let me know, Regards,

Yes, it is. You can share me the Account Type for those transactions. There should be values such as "Income" etc… and I can develop the expression based on that. However, we can include all these transactions as well in the previous expression. Regards,

Hello, Remove the comma "," symbol at the end of Account.balance. Let me know if everything is working as expected. Regards,

Hello, Would you be so kind and confirm have you checked correctly if there is not open Purchase Order and how ? Kindly provide a screenshots of the all purchase orders related to this item with statuses: Pending Supervisor Approval, Pending Receipt, Partially Received, Pending Billing/Partially received. (do not forget to…

Try this: Field: Formula (numeric) Formula: CASE WHEN {type} = 'Item Fulfillment' OR {type} = 'Work Order' THEN ({quantity}*-1) ELSE {quantity} END I hope it helps, if you need any further assistance please let me know. Regards,

Hello @Benjamin Paul - USA , It should be under the Account table as balance and as @Nicole Mendoza-Oracle mentioned above, feel free to share the query. Regards,

Hello @Javier P. , Would you be so kind and provide the results (don't forget to hide sensitive information) so I can see on which transaction types you don't have the negative quantity. @Vajrala Madhu Reddy I am not sure if this has the issue with the permissions. Also if you have a Main Line = 'True' in criteria you wont…

Hello @FazeprooF , Remove "Ship Via" from criteria and let me know what you have in results now ? Regards,

Hello @User_569R9 , No, you should run a manually query for netsuite connection you have. It's one nested query, it depends how your organizations calculates the profit and which transactions are considered. It will create a table. Just simple create a workbook from that custom dataset. If you can specify the fields and…

@User_569R9 that's right. Since you have a connection navigate to: And again, if you need any assistance develop the custom sql query feel free to contact me. Regards,

If you are familiar with Oracle SQL and if you have established NetSuite2.com connection in NSAW, you can bring the data with manual sql query function. Also have you tried with this: ?

Hey @User_569R9 , I am unsure if you will have the opportunity to complete this project. If needed, I would be happy to offer my assistance. We can develop a custom SQL query to accomplish this task. Regards,

Oh….I see. Then I guess the ideal workaround would be to create own custom dataset to make more understandable.

Hi @User_569R9, I am not sure that I understand you correctly. Can you please provide more details on this topic and what you want to achieve here ? Regards,