Best Of

Oh apparently that is a system flag field! Are you all still missing a column though showing a certain qty or stage of fulfillment? I believe that "Total To Date" adds both "Fulfilled" and "Invoiced" as well as "Picking" and "Packed" in the case of using those features. (At least from what I see online and from behavior in our account)

Hi @Dext3r,

This behavior is expected, as Work Orders can no longer be modified once an Assembly Build has been created.

As an alternative, users can take the following actions:

• To reduce the quantity: Close the Work Order, which will change its status from In Process to Closed. After closing, an Assembly Unbuild transaction can be used to remove any excess assemblies from inventory.
• To increase the quantity: Create a copy of the original Work Order and include a note in the Memo field indicating that it continues from a previously closed Work Order. Enter the additional quantity to be produced in this new Work Order.

Hope this helps with your concern.

Respectfully,

Trixie

Hi @User_ZA0IY,

I believe you have Payment Instruments Enabled in your account since it's part of the requirement in setting up ACH in SuiteCommerce.

Under the Customer Record > Financial Tab > Payment Instrument Subtab, the New ACH button should be present.

Possible reason for it is that you might have no ACH Payment Method created in your NetSuite Account.

Navigate to Setup > Accounting > Accounting List > FILTERS Type = Payment Method

Click New button > In the form, populate Name for the Payment Method > Set Type field = ACH > Select the Associated Payment Processing Profile > Set the Account to deposit to.

Hope this resolves the problem of New ACH button missing in the Customer Record.

————— 

If you found this response helpful and think it might assist others with similar questions, mark 'Yes' beside 'Did this answer your question?'. Doing so will help the community find solutions more efficiently, saving them time reading through all replies. You'll also be on your way to earning your next Answer Accepter badge💎. 

Hi @Dext3r,

Other formulas that should work are:

• CASE WHEN {custbody5} IS NOT NULL THEN '<div style="background-color:yellow; color:black; font-weight:bold;">' || {custbody5} || '</div>' ELSE 'Empty' END

or

• CASE WHEN {custbody5} IS NULL THEN 'Empty' ELSE '<div style="background-color:yellow; color:black; font-weight:bold;">' || {custbody5} || '</div>' END

😊

Hi @User_QQ76D

Create a custom record (e.g., Custom Intercompany Staging) and create the following custom fields. 

1. From Subsidiary: custrecord_icto_from_sub (Type: List/Record > Subsidiary)
2. To Subsidiary: custrecord_icto_to_sub (Type: List/Record > Subsidiary)
3. From Location: custrecord_icto_from_loc (Type: List/Record > Location)
4. To Location: custrecord_icto_to_loc (Type: List/Record > Location)
5. Item: custrecord_icto_item (Type: List/Record > Item)
6. Quantity: custrecord_icto_qty (Type: Integer or Decimal)
7. Created Order: custrecord_icto_created_order (Type: List/Record > Transaction) (Uncheck 'Mandatory')
8. Error Log: custrecord_icto_error_log (Type: Long Text) (Uncheck 'Mandatory')

Save the following code as a .js file (e.g., UE_Create_ICTO_From_Staging.js) and upload it to your File Cabinet.

/**

• @NApiVersion 2 .1
• @NScriptType UserEventScript
• @NModuleScope SameAccount
• Description: Automatically creates an Intercompany Transfer Order when a Custom Staging Record is created via CSV or UI.
  */

define(['N/record', 'N/log'], (record, log) => {

const afterSubmit = (context) => {

    // Only run on creation of a new staging record (prevents duplicates if someone edits the record later)

    if (context.type !== context.UserEventType.CREATE) {

        return;

    }


    const stagingRec = context.newRecord;

    const stagingRecId = stagingRec.id;

    const stagingRecType = stagingRec.type;


    try {

        // 1. Get values from the custom staging record

        const fromSubsidiary = stagingRec.getValue({ fieldId: 'custrecord_icto_from_sub' });

        const toSubsidiary = stagingRec.getValue({ fieldId: 'custrecord_icto_to_sub' });

        const fromLocation = stagingRec.getValue({ fieldId: 'custrecord_icto_from_loc' });

        const toLocation = stagingRec.getValue({ fieldId: 'custrecord_icto_to_loc' });

        const item = stagingRec.getValue({ fieldId: 'custrecord_icto_item' });

        const quantity = stagingRec.getValue({ fieldId: 'custrecord_icto_qty' });


        // Validate that required fields are present

        if (!fromSubsidiary || !toSubsidiary || !fromLocation || !toLocation || !item || !quantity) {

            throw new Error('Missing required fields on the staging record.');

        }


        // 2. Initialize the Intercompany Transfer Order

        // We use dynamic mode so NetSuite automatically sources pricing, accounts, etc.

        let ictoRec = record.create({

            type: record.Type.INTER_COMPANY_TRANSFER_ORDER,

            isDynamic: true

        });


        // 3. Set Header Level Fields

        ictoRec.setValue({ fieldId: 'subsidiary', value: fromSubsidiary });

        ictoRec.setValue({ fieldId: 'tosubsidiary', value: toSubsidiary });

        ictoRec.setValue({ fieldId: 'location', value: fromLocation });

        ictoRec.setValue({ fieldId: 'transferlocation', value: toLocation });


        // Default order status to Pending Fulfillment (Optional - configure as needed)

        ictoRec.setValue({ fieldId: 'orderstatus', value: 'B' }); 


        // 4. Add the Line Item

        ictoRec.selectNewLine({ sublistId: 'item' });

        ictoRec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'item', value: item });

        ictoRec.setCurrentSublistValue({ sublistId: 'item', fieldId: 'quantity', value: quantity });

        ictoRec.commitLine({ sublistId: 'item' });


        // 5. Save the Intercompany Transfer Order

        let newIctoId = ictoRec.save({

            enableSourcing: true,

            ignoreMandatoryFields: false

        });


        log.audit('ICTO Created successfully', `Staging ID: ${stagingRecId} | ICTO ID: ${newIctoId}`);


        // 6. Update Staging Record with the success link

        record.submitFields({

            type: stagingRecType,

            id: stagingRecId,

            values: {

                'custrecord_icto_created_order': newIctoId,

                'custrecord_icto_error_log': 'Success'

            }

        });


    } catch (error) {

        log.error('Error creating ICTO', `Staging ID: ${stagingRecId} | Error: ${error.message}`);


        // If it fails, update the staging record with the error message so the user can fix it

        record.submitFields({

            type: stagingRecType,

            id: stagingRecId,

            values: {

                'custrecord_icto_error_log': error.message

            }

        });

    }

};


return {

    afterSubmit: afterSubmit

};
});

Deploy the Script

1. Go to Customization > Scripting > Scripts > New.
2. Select your uploaded .js file.
3. Click Create Script Record and name it something like “UE Create Intercompany Transfer Order”.
4. Go to the Deployments tab.
5. In the Applies To dropdown, select your Custom Record (e.g., Custom Intercompany Staging).
6. Set Status to Released and Log Level to Debug.
7. Save.