Forum Stats

  • 3,679,583 Users
  • 57,524 Discussions
  • 190,820 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
NetSuite Maintenance - September 25
Please note that on Saturday, September 25, 2021, at 10:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 180 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Cheers to 1️⃣0️⃣ years of #SuiteWorld! 🎉 We’re celebrating by extending the Super Saver Pass AND launching the digital On Air experience TODAY! Whether you join us in-person or digitally, we can’t wait to make even more memories with you. https://lnkd.in/dGpPpmUV
Webinar | COSTING 101: Learning the Basics of Inventory Costing webinar was a success! Please take a minute to fill out this short survey. For those who missed it - Don't worry! Here's the link to the recorded session!
NetSuite Support Assistant: A quicker way to get answers to your basic NetSuite questions
The NetSuite Support Assistant is a convenient chatbot SuiteApp that provides quick responses to your basic questions directly from your NetSuite Account.
Click NetSuite Support Assistant Now Available for more details.
Release Preview 2021.2

If you would like to receive a 2021.2 Release Preview account, please opt -in to take advantage of the Release Preview access period to prepare and become familiar with the new NetSuite capabilities. For details, see Requesting a Release Preview Account.

If you receive a Release Preview account in 2021.2, you can access it several weeks before your production account is scheduled for an upgrade to the new release of NetSuite. Notifications with details about Release Preview availability are sent to the account administrators as described in Release Preview Notifications. Release Preview availability information is also posted on the New Release portlet.

Common Custom transaction field for transactions

Hormese Paul
Hormese Paul Member, forum_userscommunity_users Posts: 134 Red Ribbon

Hi all,

I need to create a transaction column field that can be applied to both sale transactions and inventory transfers.

I Need a default value in that field as Quantity*2 to be shown for each line item.

NVL({quantity}*2,{quantityonhand}*2).

It is giving me a quantity field not found in the transfer order column.

CASE WHEN {type} = 'Inventory transfer' THEN {quantityonhand}*(1/6) ELSE {quantity}*(1/6) END

I write the formula in the decimal number type custom field's formula by ticking the formula checkbox.


Please let me know if I may need to create two different fields or as a single field that will work both transactions (sales order and inventory transfer).

Answers

  • Emilia Ironov-Oracle
    Emilia Ironov-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 703 Gold Trophy

    Hi Paul,


    Thank you for creating this thread!  

    Please allow our gurus/members to look into this and update you for any findings. 

    We will get back to you as soon as possible!  

     

    Anyone else who has an insight? Feel free to reply to this thread! 

    Kind regards,

    Emilia Ironov - Oracle | Ask a Guru

  • Joahnna Given Uy-Oracle
    Joahnna Given Uy-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 135 Silver Badge

    Hi paul,


    Good day. Just to confirm, the value is showing correctly when you used the formula CASE WHEN {type} = 'Inventory transfer' THEN {quantityonhand}*(1/6) ELSE {quantity}*(1/6) END, but it is not showing on both ales Order and Inventory Transfer?


    Would it be possible to send a screenshots of the custom line field that was created, the Sales order Record, and the Inventory Transfer? Please remove any confidential information on the screenshots you'll attach.


    Thank you,

    Joahnna

  • Joahnna Given Uy-Oracle
    Joahnna Given Uy-Oracle Member, forum_netsuite_mod, ORACLE_EMPLOYEE Posts: 135 Silver Badge

    Hi @Hormese Paul ,


    May I request for an update for the additional information/


    Thank you,

    Joahnna