3962157

If your Items vary in cost calculation, you can definitely assign different Costing Methods on them. With regard to your samples inventory, if you track them on separate Item records and if your goal is to simply track the quantity per Location and no value will be assigned to them, you may still use Average Costing. -…

in Tracking Product Samples Without Using Average Costing Comment by 3962157 Jun 17, 2016 9:36PM

Yes, the Component Quantity in the Planned Standard Cost will not impact the Component Quantity in the Assembly Item (BOM) record and Work Order. The default Component Quantity populated in the Work Order will be based on the Component Quantity set in the Assembly Item (BOM) record at the time of Work Order creation. It is…

in Planned Standard Cost Comment by 3962157 Jun 15, 2016 10:26PM

Cost calculation in the system is per Item per Location basis. Thus, if you receive damaged or sample Items to a different Location, it will not impact the 'Location Average Cost' of your regular/warehouse/fulfillment Locations regardless of the cost of the received damaged or sample Items. If you are referring to the…

in Average Costing and Open Box or Damaged items Comment by 3962157 Jul 4, 2016 11:33AM

Hi Paul, The alternate solution will apply to Item types that track inventory (Inventory Items and Assembly Items). Since Inventory Reports are not available to those that do not track inventory, I cannot think of an alternate solution that may work for other Item types. The ability to expose GL Account Number on an Item…

in Saved Search to show GL account numbers of items Comment by 3962157 Jul 8, 2016 9:05AM

Displaying GL Account Numbers in an Item Saved Searches is not currently possible and this is logged under Enhancement #133436. As an alternate solution, you may customize an Inventory Report instead. You can customize any of the available Inventory Reports in NetSuite depending on your goal. For example, you may customize…

in Saved Search to show GL account numbers of items Comment by 3962157 Jul 4, 2016 1:52PM

Since an Item Receipt is an inventory-adding transaction, you would also need to reduce the inventory. The GL Impact of an Item Receipt is: (DR) Inventory Asset (CR) Inventory Received Not Billed To reverse this, you may enter a negative Inventory Adjustment. 1) Navigate to Transactions > Inventory > Adjust Inventory. 2)…

in Reverse incorrect Receipt? Comment by 3962157 Jul 4, 2016 11:59AM

Location subtab in the Item record is not customizable. Thus, it is not possible to another column on the said subtab to show the daily demand. You may consider adding an Item Sublist instead. First, create a Saved Search. Then, configure the Sublist. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2.…

in Show daily demand per item Comment by 3962157 Jul 4, 2016 4:58PM

The Average Cost showing in your Item record after importing transactions to NetSuite is computed as the sum of all inventory-affecting transactions (like Item Fulfillment, Item Receipt, Inventory Adjustment, among others) divided by the current Quantity On Hand. Please note that 'non-posting' transactions (like Purchase…

in COGS for historical transactions Comment by 3962157 Jul 4, 2016 1:19PM

You may defer the increase in the Item's Quantity On Order by not setting a Location in the Purchase Order or setting it to "Pending Approval" status. Note that if a Purchase Order has no Location, it will not increase the Item's Quantity On Order even if it is already approved. With regard to Purchase Order status, it is…

in Purchase orders not received until later date Comment by 3962157 Jul 5, 2016 8:16PM

Inventory-adding transactions in NetSuite increase Inventory Asset Account. However, since you do not want to impact your Inventory Asset Account, assigning an Asset Account type will not work. Further, since you intend to track inventory of Lot Numbers, using Non-Inventory Items will not work. In this regard, you may…

in Lot Numbered Item w/o tracking as an asset? Comment by 3962157 Jul 4, 2016 9:47PM

Please note that CSV Import of Inventory Adjustment is not yet possible in NetSuite. This is currently logged under Enhancement #227644. However, if your intention is to simply adjust the "value" of the Items without changing the quantity, this can be done through CSV Import of Inventory Worksheet instead. - Note that…

in Inventory Current Value Adjustments Comment by 3962157 Jun 22, 2016 9:57PM

There are two other sources of Quantity On Order in the Item record, aside from open Purchase Orders. - When Multi-Location Inventory feature is enabled, Transfer Orders will also impact Quantity On Order in the Item record. Quantity On Order in the 'To Location' (or receiving/destination Location) will be increased by…

in Quantity On Order Is Wrong!!! Comment by 3962157 Jun 15, 2016 9:34PM

Please note that in NetSuite, the computation of the balance of Inventory Asset is not limited to Beginning Inventory, Purchases and Sales (and Returns) only. - The system considers all inventory-affecting transactions like Inventory Adjustment, among others. Aside from checking the details of the Inventory Accounts by…

in Inventory Mgmt Reports for Audit Purposes Comment by 3962157 Jul 4, 2016 3:48PM

If you intend to track the quantity on hand of your Items used solely for maintenance contracts, you would need to use an Inventory Item type since Non-Inventory Items do not track inventory/quantity on hand. To make sure that your maintenance contract Items will not be added on sales transactions, you may opt not to…

in Inventory items being held for Maintenance contracts Comment by 3962157 Jul 4, 2016 4:27PM

Please note that price of a Kit/Package Items is not dependent on its components' prices and can be assigned several Price Levels. If you still need to display the prices of the Member Items, you can create an Item Sublist in the Item record. First, you would need to create a Saved Search. Then, configure the Sublist. Here…

in Member Pricing on Kits Comment by 3962157 Jul 4, 2016 1:35PM

In inventory tracking: If you intend to track separate inventory/quantity on hand for the Parent Item, you would need to use Assembly Item. Item Group and Kit/Package do not track inventory/quantity on hand. They depend on the availability of the Components. In costing: Since the Assembly Item maintain its own…

in Item groups vs Assemblies Comment by 3962157 Jun 17, 2016 6:50PM

You can create an Item Sublist in the Item record. First, you would need to create a Saved Search. Then, configure the Sublist. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2. Choose 'Item'. 3. Mark "Public" and "Available as Sublist View" checkboxes. 4. On the Criteria tab > Standard subtab > Add…

in Show Quantity sold on Item Record Comment by 3962157 Jun 22, 2016 9:03PM

If you would like to capitalize those expenses associated with your training classes (Inventory Items), you can maximize the Landed Cost feature. - Associating Landed Cost to your Item Receipts will increase the value (Inventory Asset) of your Items. - You may enter a Vendor Bill to record the payable related to your…

in Associate costs with Item--maybe Landed? Comment by 3962157 Jun 17, 2016 9:03PM

You can maximize the Physical Inventory Worksheet in NetSuite and use it as your count sheet instead. 1. Navigate to Reports > Inventory/Items > Physical Inventory Worksheet. 2. Set the "As of" filter to today's date or your count date. 3. Export the Report to Excel then use the "Physical Count" column to enter your actual…

in Physical Inventory Variance Reporting Comment by 3962157 Jul 4, 2016 2:55PM

You may create a Saved Search on all inventory-affecting within the preferred timeframe. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2. Choose Item. 3. On the Criteria tab > Standard subtab > Add Filters: - Transaction Fields... Account = select all Inventory Asset accounts assigned to Items -…

in Search for recently changed inventory levels Comment by 3962157 Nov 7, 2016 5:05AM

If you are referring to the Line ID of the Member Items under Components tab of the Assembly Item record, it is not currently possible. It is logged under Enhancement #242854. But if you are referring to numbers/quantity values of the Member Items (like Quantity On Hand and Quantity Available, among others), these…

in Search for Assembly member items Comment by 3962157 Jul 4, 2016 7:09PM

The standard navigational path in checking your Cost Categories tagged as Landed is Setup > Accounting > Accounting Lists (using Administrator role). - Set Type dropdown to Cost Category. - View the Cost Category record then verify if Cost Type is set to Landed. To have a Saved Search version of this list, here are the…

in Landed cost category search Comment by 3962157 Nov 6, 2016 11:26PM

You may create a Transaction Saved Search for all Web orders grouped by Customer. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2. Choose 'Transaction'. 3. On the Criteria tab > Standard subtab > Add Filters: - Source = Web - Shipping Line = No - COGS Line = No - Tax Line = No - Main Line = No 4. On…

in Items Ordered Search Comment by 3962157 Jul 4, 2016 6:12PM

COGS calculation depends on the cost of the Item at the date of the transaction. For example, the cost of the Item as of 1/1/2016 is $100, it will also be the COGS amount on an Item Fulfillment dated 1/1/2016. - Thus, if the current cost of the Item is $150 and the standalone Invoice that you will be imported to NetSuite…

in Import COGS info for Sales Invoices Comment by 3962157 Jul 4, 2016 8:08PM

If you are customizing a Report, go to Filters link then mark "Show in Filter Region" checkbox for the filter/s that need to be displayed. If you are customizing a Saved Search, go to Available Filters tab, then mark "Show in Filter Region" checkbox after adding the needed filters.

in How can I show multiple filters on Purchase Orders Reports? Comment by 3962157 Jul 4, 2016 6:34PM

You may create a Transaction Saved Search to display both the quantity purchased and sold within a specific period. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2. Choose Transaction. 3. On the Criteria tab > Standard subtab > Add Filters: - Type = Sales Order and Purchase Order - Main Line = False -…

in Items purchased report with sales Comment by 3962157 Jul 4, 2016 10:15PM

To know the Items associated with certain Price Levels, you may create an Item Saved Search. Here are the steps: 1. Go to Lists > Search > Saved Searches > New. 2. Choose 'Item'. 3. On the Criteria tab > Standard subtab > Add Filter: - Inactive = No 4. On the Results tab > Columns subtab > Add Fields: - Name - Display Name…

in Pricing in Price Levels Comment by 3962157 Jul 4, 2016 11:13AM

If it is a Transaction-type Report, you may directly look for {serialnumberquantity}, which is the internal ID of the Serial/Lot Number column in the transaction. If it is an Item-type Report, you will need to use Transaction record link. It will be {transaction.serialnumber}.

in How to locate serial numbers--Crystal Reports Comment by 3962157 Nov 7, 2016 12:00AM

To edit the value in the Department field on an Item Fulfillment, you would need to customize the form first. Here are the steps: 1. Open any Item Fulfillment. 2. Click Customize > Customize Form (on the upper right hand corner). 3. Go to Screen Fields tab > Columns subtab. 4. Mark 'Show' for "Department". 5. Mark "Form is…

in How Do You Edit Departments on Fulfilments Comment by 3962157 Jul 4, 2016 5:25PM

You may also create a new Price Level instead of updating your current prices. To create a new Price Level, 1. Navigate to Setup > Accounting > Accounting Lists > New. 2. Select 'Price Level'. This new Price Level may then be assign in the transaction level when entering an order for an Item available for clearance sale.…

in Clearance items for wholesale/distribution company without website Comment by 3962157 Jul 5, 2016 3:03PM

3962157 Newbie

Comments