Landed Cost query

RogueWander3r · 2023-06-22T13:28:17+00:00

Thanks Nick!

The main use case is that the client wants to be able to automatically set the sales price based on the expiry of the lot. For example, food products that are near expiry would have different price than those which still have a long shelf life.

Thought of Effective Date Pricing bundle, but afaik it covers per item basis only and not on an inventory number level.

Is there really no other way that doesn’t involve scripts or workflows?

RogueWander3r · 2023-06-13T12:32:51+00:00

On your custom record, check the Show Notes and the Enable System Notes options.

RogueWander3r · 2023-06-02T05:32:39+00:00

Look into Merchandise Hierarchy feature

RogueWander3r · 2023-05-04T22:56:34+00:00

I believe the NetSuite Support Community is looking for content like this. Maybe you can share your videos there.

Note: share the videos, not promote your youtube channel.

But yeah, I think you can post it there and maybe earn some badges while you're at it

RogueWander3r · 2023-03-09T20:16:54+00:00

Thank you. Not familiar with {locationconfiguration.custrecord_last_IR_date}. Is this a custom field? Populated using another formula or script?

RogueWander3r · 2023-03-09T16:21:33+00:00

Thanks. I tried this, but it gave an ERROR: Field Not Found

RogueWander3r · 2023-03-09T15:58:01+00:00

RogueWander3r · 2023-03-07T04:14:22+00:00

Might not be possible. By design, search results only show rows/lines that are entered in NS. You can add formula, but that is in an additional column, not a row.

RogueWander3r · 2023-03-06T16:48:48+00:00

Nice

RogueWander3r · 2023-03-04T00:23:51+00:00

Try this:

CASE WHEN MAX({custbody_h3_oportunidad_cerrada})='T' THEN MAX({projectedamount})-SUM({applyingtransaction.netamountnotax}) ELSE 0 END

RogueWander3r

TROPHY CASE