User_KAGURA Red Ribbon

Hi @Patrick Fresnosa-Oracle Thanks! However, why does this only happen to one item line, whereas there are other lines with the same setup? Also, there are three lines for that specific item in this RA with the same revrec rules, and all were recognized but only one is logged as unplanned in the report.

Thanks @Patrick Fresnosa-Oracle. This SO has an invoice for some items but not for the item in question. However, why did this only happen for that specific item line? There are other lines that haven't been invoiced, yet they were not included in the unplanned deferred revenue. Is there another solution than running the…

Hi @Clarisa De Torres-Oracle, the Customer is still active while both the invoice and credit memo don't have location and department. I would like to mention that again this invoice is an invoice for billable expense, if that matters. Thanks!

B. 90 Days

Hi @Tigran Shahnazaryan thanks! But I found the reason and I believe it is because the SOs, WOs, TOs are not defaulted to commit in the Accounting Preferences. Users need to manually commit items in transactions and while they are uncommitted they are included in the back ordered items.

Hi @Tigran Shahnazaryan Supply Allocation is not enabled in our instance. Additionally, this is the commitment preference:

Hi @Tigran Shahnazaryan How do I check journals that were created manually? I tried running a transaction search using the System Notes fields criteria (journals created via UI), but the journals don’t have system notes. However, I am sure that there are manually created journals posted to the Deferred Revenue account.…

Hi, we escalated this to NetSuite Support. Thanks for your insights! @Clarisa De Torres-Oracle

Hi, we just escalated this issue to Netsuite Support. Thanks for your help! @Clarisa De Torres-Oracle

@Jam Amper-Oracle Can we use another report, such as Item Reports, as the base report and customize it to show only work order transactions?

@Jam Amper-Oracle Ideally, this is the presentation of the report that we want to achieve: We would like to have a subtotal for each item and a total for the start date. Also, some of these fields are found in the item record. If this can't be achieved by a report, can it be done using a saved search or anlytics > workbook?

Hi @Clarisa De Torres-Oracle I forgot to mention that the invoice doesn't have a Revenue Arrangement. I guess that it cannot be generated because the following are the items' revrec rules: Standalone Invoice 1 - immediate on fulfillment/fulfillment Standalone Invoice 2 - combination of immediate on fulfillment/fulfillment,…

@Clarisa De Torres-Oracle How to check if the revenue of the standalone invoice is recognized? Will there be a Revenue Recognition Journal Entry in the invoice's related records? If so, the invoice's related record is only a payment and nothing else.

Hi @Clarisa De Torres-Oracle , the amount of the invoice is correct which is 150 and there were no indications that it was changed. Also, how can I change the Billed 300 to 150 so that the unplanned deferred revenue for this RA will be removed? This RA is completely recognized already.

If that's the case, I feel like the most probable reason is that it was detached since the file's description is it is added via drag and drop. I am not sure tho if the file drag and drop is only applicable on records or if users can drag and drop in uploading directly to the cabinet.

Hi @Francesca Nicole Mendoza-Oracle I don't use ODBC Driver, so I am trying the first one you suggested which is to check the naming convention of tables and fields using the Schema Browser and Records Catalog. However, I am not certain which fields I can compare with. Can you specify a field to compare, except Transaction…

@Patrick Fresnosa-Oracle One sample record is Project, the Accounting Period sublist. Is there a way to filter out the displayed periods in the dropdown? But we want to know how to do this in general, not only for Project records. Thanks!

Hi @Tigran Shahnazaryan I just tried using a saved search as a condition and it worked! Thanks!

To those who might have the same issue, we resolved this by enabling the Recalculate Snapshot On Inventory Count Reject preference. 

Hi everyone! I figured this out and used ${.now?string("dd/MM/yyyy HH:mm:ss")}. Just sharing in case anyone else has the same concern. Thank you!

Hi @Lea Orzales オルザレス・レア -Oracle Is your solution only applicable as columns in the statement pdf? I also have a similar concern where I need to show Invoice fields (custom fields and Ship To) in the header of the customer statement advanced pdf.

Hi @Olivier Gagnon NC , I am trying basic pdf too for Bill of Materials. I ticked the columns in custom form but it did not show in the PDF.

Hi @Clarisa De Torres-Oracle thank you but we've actually already sorted this out. We added 'Applied To Link Type is Order Bill/Invoice' in the criteria, after which the summary amounts were correct and no longer doubled.

@Patrick Fresnosa-Oracle Thank you so much!

Hi @Elychelle Gulen-Oracle Thank you but I already sorted this out. I just need to add the criteria Sub Of and set it to -none-.

Hi @Wee Ming This might really needs scripting. Thank you!

Hi @Wee Ming we tried it before but we cannot find a subsidiary triggering client field.

Hi @Wee Ming Thank you for that! But can we have it not before record submit? Because sometimes the location is different, so users would just like it to default but can be changeable.

Thank you so much for your insights @Tigran Shahnazaryan and @Wee Ming . I actually have sorted this out by customizing the report like this: I added the column Customer/Project: Company Name and removed Customer/Project: Name (Grouped). I appreciate your answers. Again, thank you!

Hi @Patrick Fresnosa-Oracle thank you for the fast response. And yes this worked! Thank you again!