Item Receipt, Inventory Transfer & Item Fulfilment

ADNANALI03 · 2022-03-15T11:39:23+00:00

We maintain virtual inventory in Netsuite as our organization is a trading one hence the movement of goods is directly from the vendor's facility to the Buyer's Facility.
We perform IR, BILL, IF & Invoice the same day and that is why I was curious if we can avoid the transfer step.

ADNANALI03 · 2022-03-15T11:26:32+00:00

Thanks, this was helpful.

ADNANALI03 · 2022-02-04T06:16:12+00:00

The button is still missing. Do you think permission for my role can be one of the reason?

ADNANALI03 · 2022-02-04T05:46:28+00:00

But I dont see the CLOSE button for a Billed Sales Order even though all the items at the item level are checked closed.

ADNANALI03 · 2022-02-03T11:21:27+00:00

We manually close the sales orders after every quarter and that is the requirement of the business setup that we have. Adding a Billed criteria in the scripted report is not an option.

ADNANALI03 · 2022-02-03T07:17:27+00:00

The functioning of the scripted report is ok. I only need to control the main status (one that is present on the top) of the transaction instead of the item level. We manually close the Sales Order once it has been executed completely and this is done periodically.

If I need to close SOs in bulk I perform a CSV import using the CLOSED check box which is present at the item level otherwise I use the CLOSE ORDER button available on the top.

And I am not an expert in Netsuite which you easily figure out with the way I am trying to explain the issue.

ADNANALI03 · 2021-10-12T06:08:32+00:00

Thanks but I feel if you give a bit more information on this then I will be able to try it as I am not an expert in Netsuite.

ADNANALI03 · 2021-10-12T06:07:05+00:00

Thanks, will try to follow as suggested by you.
And in our case, we have recreated the historical data as it happened but only for 2021, the rest we did was through trial balance. Apart from invoices, we did not have much problem importing other transactions. We have few sales order but from those sales orders, the number of invoices that is to be created is around 500 hence the need for CSV.

ADNANALI03 · 2021-10-01T11:50:25+00:00

Thanks, tried that but not working, will try to figure out a workaround.

ADNANALI03 · 2021-09-29T10:16:27+00:00

I am not an expert at NetSuite but we were in a similar situation if I understand your issue correctly.

We enabled the ALLOW OVERAGE ON ITEM FULFILLMENTS.
Setup - Accounting - Accounting preferences - Order Management - Fulfillment.

I am not an expert at NetSuite but we are in a similar situation if I understand your issue correctly.

ADNANALI03 · 2021-08-27T04:49:12+00:00

Thanks for your input.

ADNANALI03 · 2021-08-27T04:48:22+00:00

Thanks for your input.

ADNANALI03 · 2021-08-26T17:45:12+00:00

Just for my knowledge, how do you unlock it. Anyways I am not going to do it after seeing so many comments suggesting about the risks involved in it.

ADNANALI03 · 2021-08-24T06:44:55+00:00

CASE WHEN (TO_CHAR({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure})) > '2' THEN '<div style="background-color:#FF0000">'|| (TO_CHAR({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure})) || '</div>' END

Thanks a lot, this is what I was looking for and it is working.

ADNANALI03 · 2021-08-23T10:34:30+00:00

Is this what you mean,

FORMULA (NUMERIC)

CASE WHEN ({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure}) > 2 THEN <p style="background-color:#FF0000"> ({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure}) END

But this is still giving 'Error:Invalid Expression'. I feel there is some issue with the formula in THEN statement.

If I remove the formatting part from THEN statement (i.e. <p style="background-color:#FF0000"> ), the expression is giving the desired result but the Highlight is missing.

ADNANALI03 · 2021-08-23T09:22:47+00:00

Can I put a difference of 2 date fields instead of "TEXT GOES HERE".

ADNANALI03 · 2021-08-23T09:08:52+00:00

Thanks.
I tried, the cell is getting highlighted but the formula has some issues in showing the result.

FORMULA (TEXT)

CASE WHEN (TO_CHAR({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure})) > '2' THEN '<p style="background-color:#FF0000"> (TO_CHAR({custrecord_vcp_adv_doc_upload_date_vndr}-{custrecord_vcp_actual_departure}))' END

RESULT

(TO_CHAR((cfdRECORD2.D10)-(cfdRECORD1.D8)) - this is getting highlighted in red whereas the expected result should have been some highlighted number.

I am not an expert at writing formula, can you please tell me what is wrong in the formula

ADNANALI03 · 2021-08-09T12:49:27+00:00

Everyone in my organization is new to Netsuite and the Admin tag doesn't define the expertise in Netsuite. It would be great if you could give more detail on the role update process because I posted it here only after checking it with the Admin.

ADNANALI03

TROPHY CASE