-
NetSuite Admin Tip | Why a Revenue Arrangement May Not Appear on an Invoice’s Related Records
As a NetSuite administrator, you may be asked to investigate why a Revenue Arrangement does not appear under an Invoice record’s Related Records > Revenue Arrangements subtab, even though the same Invoice is visible from the Revenue Arrangement’s Related Records subtab. At first, this may look like a missing relationship,…
-
NetSuite Admin Tip | Error while viewing Revenue Arrangement Record
When a sales transaction (such as Sales Order, Invoice, etc) is approved and a Revenue Arrangement is created, the user is unable to view or open the Revenue Arrangement record. An error message appear when the user attempts to access the record. Why does this happen? By default, no Revenue Arrangement form is marked as…
-
A scheduled script saving a Revenue Arrangement throws creation type percent error
The error thrown: THE_CREATION_TYPE_PROJECT_PROGRESS_REQUIRES_THE_EVENTPERCENT_COMPLETE_AMOUNT_SOURCE_CHANGE_EITHER_THE_CREATION_TYPE_OR_THE_AMOUNT_SOURCE_TO_THE_CORRECT_VALUE I can't find any documentation on this error code. How to resolve?
-
No revenue arrangement with T&M billing
Hello, I have set up a project with T&M billing type. Unfortunately when billing the hours, no revenue arrangement is created. The Item used for invoicing has a 'recognize when billing' revenue recognition rule and a department added. However, no department is shown on the Invoice. Could the missing of the department be…
-
Voiding Revenue Arrangements in Bulk
Is there a way to void revenue arrangements in bulk possibly by utilizing the mass update feature?
-
Reallocate Revenue Arrangements in Bulk
Hi Experts, We are trying to reallocate revenue arrangements in bulk for a specific period (based on date). does NS offer a standard way of doing that insted of doing via Customized SCript? Please advise.
-
Error when updating revenue arrangement
I read Suite ID 104188, but this one seems different. ORA-00001: unique constraint (NLCOMPANY.ALLREVRECRULEUNIQUENAMEIDX) violated BAD SQL STATEMENT:INSERT INTO RevenueRecognitionRule ( nkey, sName, kRecognitionType, kMethod, kRevRecStartDateSource, kRevRecEndDateSource, kEndDateChangeImpact, kAmountSource, binactive,…
-
Reinvoicing a fulfilled SO
Hi, Inside our current set-up I found multiple cases where our system seems to lack a rev rec trigger for cases of the following type: SO Based SO fulfilled (triggers rev rec initially) Invoiced (only BS postings as expected) Credited (because wrong customer) --> also triggers negative rev rec which causes total revenue =…
-
Mass update revenue arrangement via csv upload
Hi Experts, Can we do a bulk update on Revenue arrangement (just like other transactions like Sales order) via csv upload? We have a requirement for updating a Custom field at RA header level for all existing revenue arrangements. This custom field is different for different RAs and cannot be updated via 'Edit Revenue…
-
How Can I Update Revenue Arrangements Automatically When Source is Updated?
Hi, Gurus! :) I have a scenario for you please. How can a revenue arrangement be updated automatically once the source is updated? For example, if an outside system processes a sales order and then pushes it to NS, and revenue arrangement is created based on that SO, if the SO is updated, ARM's revenue arrangement will not…