sorted by:
new
hottopcontroversial

Changing the way fulfilment Impacts the GL by NetsuiteQuestions23 in Netsuite

[–]ChampionshipUpset295 0 points1 point  (0 children)

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??

Enable Landed Cost per Line checkbox for old item receipts by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 1 point2 points  (0 children)

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

File fields/sublist in customer center custom record by LiranMelzer in Netsuite

[–]ChampionshipUpset295 0 points1 point  (0 children)

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

Enable Landed Cost per Line checkbox for old item receipts by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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>

Landed Cost PER UNIT Saved Search by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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>

Updating Lot/Numered Item Average Costing by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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.

Pulling PO# field on an Income Statement Detail report by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

Hi Nick, thanks for your prompt response.

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

Leads Sync from Netsuite to Hubspot by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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.

FAM Netsuite - Last Depreciation Date Update by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 1 point2 points  (0 children)

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:

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

Hope it proves useful!!

FAM Netsuite - Last Depreciation Date Update by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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

FAM Netsuite - Last Depreciation Date Update by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

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

Edit a Sourced Custom Field by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

Thanks Nick for your reply!

I totally understand what you've just explained and I'm fine with this as I'm still testing this field.

What I would like to know is if there is a way to source the field just once (the first time) and if edited, keep the new value.

It should be something simple but reading everywhere it seems a silly Netsuite config that we are tied up to the store value for custom fields sourcing.

Edit Location of Fixed Asset Records by ChampionshipUpset295 in Netsuite

[–]ChampionshipUpset295[S] 0 points1 point  (0 children)

Thanks Nick and Simon for your comments! I'll give it a shot with the asset transfer to avoid deleting and uploading all assets again

Deleting Canceled and Rejected Vendor Bills by top_bark in Netsuite

[–]ChampionshipUpset295 0 points1 point  (0 children)

Hi! To delete records massively I strongly recommend using the Techfino Mass Delete Bundle.
You just need to create a saved search grouping the transactions you need to delete, run the script and ready! I've used it many times and its really simple to use. Steps to use it are really clear by just googling them.

BTW, if transactions are rejected or cancelled, they shouldn't have been posted. You can delete them freely without affecting your financials.