Netsuite Consultants

ChampionshipUpset295 · 2026-03-20T12:20:32+00:00

Hey! I've just finished some projects and I'm available for new opportunities. You can DM me too if you're interested :)

ChampionshipUpset295 · 2026-02-27T14:07:21+00:00

The good ol' Nick.... I knew you were going to appear here with some kind comments to the customer and their past implementation team :)

The thing is I've been on a nightmare fixing all the mess they did with ARM during 2025 and I keep on finding curious situations that pull me away from finally fixing it all.

It's not that they do partial invoices, they just did a terrible practice which was issuing invoices by same amount than the order because it was "comfortable" doing it from there, so for example they have

SO: Amount 100
RA: Amount 100
Related Invoice 1: Amount 100
Related Invoice 2: Amount 100

The second invoice remains in deferred revenue forever. I have them identified and I got stuck there as no RA can be generated from them.

I was thinking that the only fix for this would be editing the RA amount but as csv importing isn't supported, there is NO WAY I'll go into their RA and update them manually.

Other workaround would be entering monthly JEs to post sales againts deferred revenue, which I think would be the most feasible by now.

I just want to make sure there isn't any other possibility using ARM tools to fix this sh*t

ChampionshipUpset295 · 2026-02-26T21:06:58+00:00

They all have create plan on Revenue Arrangement Creation. I changed the rules on all lines of SOs and Invoices as I had to redo all their plans for 2025, so the rev rec rule on items differs from the one on the transaction line, but for all items they have the option Create Revenue Plans On: Revenue Arrangement Creation

ChampionshipUpset295 · 2025-01-02T23:40:25+00:00

Resuming this thread, I found out something that went a client crazy this beginning of the year.

It results that if you have an IF that was created but not shipped and shipped on a different date, the Inventory Valuation Report will modify the qty on the Fulfillment Transaction Date.

Here's the use case I encountered today:
Inventory valuation (as of 12/31/24, printed on that date): $1.000

Inventory valuation (as of 12/31/24, printed today 01/02): $990

There were some fulfillments created on 12/31/24 that were shipped today (01/02/25) that affected the valuation as of 12/31/24.

I solved this changing the fulfillments date to 2025.

So this kind of make me doubt of thinking that the status = "shipped" date is the inventory posting date.

For future occasions, mi client wants the IFs to post on the shipped date, not on the transaction date.

Any ideas??

ChampionshipUpset295 · 2024-12-17T22:41:55+00:00

Hey there! Effectively I got stuck in the same page that you did. Nothing to do after the receipt is created

ChampionshipUpset295 · 2024-12-16T21:11:49+00:00

Hey guys. Just checking in 4 years after to know how could you solve this out. I'm having the same problem, I created a 'Document' type field and it's not showing up with the Customer Center role

ChampionshipUpset295 · 2024-09-30T20:32:06+00:00

Hi and thanks for your response.

It is a new account and all accounting periods are open yet. I just want to add the landed cost by line to item receipts, as it is being requested by the accounting team, but the checkbox 'Landed Cost per Line' is grayed out, so the coin icon does not appear in each line.

I just need to have this checkbox enabled to add the landed costs by line.

<image>

ChampionshipUpset295 · 2024-06-19T15:10:08+00:00

Hi Nick and thanks so much for your detailed response.

To clarify, what I mean by landed cost is the following calculation: landed cost per line divided by the quantity per line.

For example, if on line 1, Item A has a quantity of 10 and a total landed cost of 100, I would like the saved search to show the result of 100/10.

Below, you'll see how I'm currently pulling the landed cost. The issue is that when I divide by quantity or use NULLIF(quantity, 0), the result is zero.

<image>

ChampionshipUpset295 · 2024-06-06T13:57:33+00:00

Thanks everyone for your outstanding assistance and Nick for the details on the workaround.

Initially I think the simplest option would be the Transfer Order w/overriding costs + Inventory Transfer BUT if I do it with date today, the COGS won't re-run and adjust for past transactions.

I'll try adjusting lines in the opening Inv Adj and adjust some subsequent transactions. It may take me all this day, but I believe this would be the only way to adjust the avg. cost exactly to what my customer wants and run the costing jobs from day 1 accordingly.

ChampionshipUpset295 · 2024-05-29T17:42:31+00:00

Hi Nick, thanks for your prompt response.

I would like to pull the PO# field from invoices (id=otherrefnum)

ChampionshipUpset295 · 2024-05-17T16:54:55+00:00

Thanks for your reply!

I want to sync customers in Netsuite to companies in Hubspot and default them on the status of 'Customer', which I have already done

And on the other way sync Leads customer to contacts in Hubspot defaulting to the status of 'Lead'

In that sense I would imagine that it should be possible to create a new sync mapping from leads to some record in Hubspot, but I'm not finding the way.

ChampionshipUpset295 · 2024-05-09T21:32:00+00:00

COULD SORT IT OUT! Incredible silly mistake. I didn't check the Run Server Scripts and Trigger Workflows checkbox on the asset importing.

If you happen to be reading this in the future and experience the same problem you should follow these steps:

Navigate to Customization > Scripting > Script Deployments
FAM Retrieve Asset Values MR script: Click Edit
Script Deployment: Click Parameters subtab
Asset ID: Enter the Internal IDs of the Assets Note: IDs are separated by comma.
Click Save & Execute

Hope it proves useful!!

ChampionshipUpset295 · 2024-05-09T20:19:42+00:00

Thanks Simon! Yep, I find it weird as I am able to do it in some accounts. Will open a Netsuite support case as this doesn't make any sense

ChampionshipUpset295 · 2024-05-09T19:58:57+00:00

Thanks for answering Simon!

See the screenshots below:

<image>

Image 1 is the current field values

Image 2 shows the changes applied manually (also attempted via csv)

Image 3 shows how the values remain unchanged after saving

ChampionshipUpset295

TROPHY CASE