PF
08/29/2024, 2:13 AMCeligo AI
08/29/2024, 2:13 AMAI generated answer (using internal Slack threads):Based on the conversations, it appears that a project cannot be directly linked to a revenue element. However, the revenue element is created from the items on a sales order. Here's a simplified flow: 1 Sales Order with multiple items leads to 1 Revenue Arrangement, which then leads to multiple Revenue Elements, and finally to multiple Revenue Plans (both actual and forecast). The connection between a Revenue Plan and transactions or sales orders is through the Revenue Element. The
revenueElement.source
holds the document id and revenueElement.referenceid
holds the internal id. However, these are stored as text and not as a link.
To update Revenue Plans, you can use the "Update Revenue Plans" feature in NetSuite. This can be set to run automatically or manually based on your accounting preferences. However, it's not clear if this can be triggered from a script.
When it comes to changing the Recognition Account in a revenue element, it seems that it's not directly possible because it's linked to the item record sales account on the sales order. If you need to change this, you would have to delete the revenue arrangement, update the rev rec rule on the item record, and then regenerate the revenue arrangement/elements. This is only possible if the Revenue Plan has not yet posted any rev rec JEs.
******
Disclaimer:
This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******Celigo AI
08/29/2024, 2:14 AMSlack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820916057
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.814895451
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.811307311
Celigo AI
08/29/2024, 2:14 AM