Remove Duplicates and negative values from item fulfillment saved search without using Mainline

The Main Line filter cannot be used with the item fulfillment search. If the main line filter is set to true, only the quantity for the first item on the item fulfillment will be extracted. All other items and their quantities will be excluded from the saved search. Multiple negative quantities are displayed in results due… Continue reading Remove Duplicates and negative values from item fulfillment saved search without using Mainline

Automatic Location Assignment and Supply Allocation

This article describes how Automatic Location Assignment works along with Supply Allocation When allocating inventory to sales order lines, the Supply Allocation feature considers both current and future inventory. The Automatic Location Assignment (ALA) feature works with the Supply Allocation feature to accelerate and enhance the order fulfillment process: ALA calls Supply Allocation to determine… Continue reading Automatic Location Assignment and Supply Allocation

Automatic Location Assignment

The Automatic Location Assignment feature lets you configure NetSuite to assign fulfillment locations automatically to sales order lines. Enabling Automatic Location Assignment Navigate to Setup > Company > Enable Features. On the Transactions subtab, under the Shipping & Receiving section, check the Automatic Location Assignment box. After Enabling, Auto Assign Location button will be enabled… Continue reading Automatic Location Assignment

Inactivate Contacts using mass update.

Requirement: Delete Contact records We cannot delete the contact records as it have related transaction records. However we can make the same inactive. Inactivate contact records which are inactive for last two years. Steps Navigate to Lists > Mass Update > Mass Updates Contact Management: Click Plus Sign (+) Click Inactivate Contacts Title of Action: Enter Title Click Criteria Filters:  Select Transaction Fields… Transaction Filter: Select Date Date: Select on or… Continue reading Inactivate Contacts using mass update.

Payment before fulfillment in Order to Cash Process

To setup Payment before fulfillment in Order to Cash Process, enable the feature Invoice in Advance of Fulfillment To enable the feature, Navigate to Setup > Accounting > Accounting Preferences., Under the Order Management tab, in the Invoicing section, check the Invoice in Advance of Fulfillment box. After we enable this feature, when we create… Continue reading Payment before fulfillment in Order to Cash Process

Apply Deposit to Multiple Customer’s Invoices

Scenario: we have to apply a customer deposit to multiple customers invoices. Solution : Create a Journal Entry and then individually apply it to individual Invoices.  Suite Answer Id:34686 Create a journal entry. In first line add the customer deposit account name, customer name and the amount needed to be debited from the account. Add… Continue reading Apply Deposit to Multiple Customer’s Invoices

Adding Member Item Quantity Available Sublist in Purchasing/Inventory Subtab

Steps I. Create a Saved Item Search  The saved search will give the list of member items within an item group and their available quantity per location Navigate to Reports > Saved Searches > All Saved Searches > New, then select Item.2. Add Search Title.3. Under Results subtab, add the below:— Name— Member Item— Formula (Numeric) | Formula = NVL({memberitem.locationquantityavailable},0) | Custom Label = Member Item Quantity Available —… Continue reading Adding Member Item Quantity Available Sublist in Purchasing/Inventory Subtab

Resolving the error message “The following Bin numbers are not available: Bin_Name”

When trying to ship an order, the user is encountering the following error message: “The following Bin numbers are not available: Bin_Name”. There are two reasons why the error is happening: 1.User created a Bin Putaway Worksheet then Inventory Worksheet within the same day. The Inventory Worksheet’s transaction order is set to last transaction in… Continue reading Resolving the error message “The following Bin numbers are not available: Bin_Name”

Parent customer record name in a Customer Saved Search.

While creating a customer saved search to get the details of all the subcustomers, Parent customer name is not available in the Results fields of the search. All we can do is to get the “Name” field for parent customer field. But the “Name” field adds up the name of parent customer name and subcustomer… Continue reading Parent customer record name in a Customer Saved Search.