I have an idea regarding the integration of a custom record for Amazon settlement transactions in Celigo within our system. It could be beneficial to explore the option of linking this custom record to the Item level as an additional parent record. This would expand our reporting capabilities and enable us to create a saved search in NetSuite. Such a search would provide insights into Amazon transactions by settlement ID and brand, facilitating better analysis and decision-making

Interesting idea, @linavokolans. I’m with Celigo. Would you be willing to discuss the details further with our team? If so, I can DM you with contact details, etc.

@matt.graney Thanks, but will that be possible becasue i see that locked and maybe it can't be edited

I’m not sure, but it’s probably worth discussing, especially if it will make your life easier

@linavokolans I think the record that would be added to should be Celigo Amazon Settlement Item Price. You can add a custom field of type List/Record -> Item and set the Record Is Parent checkbox. Just make sure to choose the Subtab you want to see the data on in the item record.

@wes_w Hey Thank you so much, so to add the custom field is it in the Celigo Amazon Settlement Item Price?

Yes. You can add a field of Type List/Record and point to the Item record