Tag: Inventory

Receiving Inventory in Advance of a Bill

If you maintain inventory, you can indicate that items have been received without entering a bill. To receive items without billing them: Go to Transactions > Purchases > Receive Orders. Select a vendor.You can select All to show all purchase orders with a Pending Receipt status. Click Receive in the Process column next to the purchase order you want to receive. On… Continue reading Receiving Inventory in Advance of a Bill

Inventory Cost Template on Items Using Standard Costing

The Inventory Cost Template in NetSuite serves the purpose of enabling items that follow the Standing Costing method to incorporate an additional expense in addition to the item’s regular purchase cost. For instance, suppose an item’s standard cost is $10. In addition to this cost, the vendor applies a shipping cost of, let’s say, 10%… Continue reading Inventory Cost Template on Items Using Standard Costing

Sync Inventory from NetSuite to a specific Source in Magento

To sync inventory from NetSuite to a specific source in Magento , we need to update the settings tab in Celigo as shown below. STEPS 1.Log in to Celigo. 2.Navigate to Settings > General > Multi Source Inventory > Map NetSuite locations to Magento 2 Sources 3.To sync inventory from NetSuite location “Main Warehouse” to… Continue reading Sync Inventory from NetSuite to a specific Source in Magento

Saved Search to Show Inventory-Affecting Transactions in the Item Record

Follow the steps below to create Saved search to show inventory-affecting transaction in the item record: 1. Navigate to Lists > Search > Saved Searches > New > Transaction.2. Under the Criteria tab > Standard sub tab > Filter column, add the following: Account > select the Asset account Posting > is true Main Line > is False 3. Under the Results tab > Columns sub tab > Field column, add the following: Date Number Type Quantity Under the Available… Continue reading Saved Search to Show Inventory-Affecting Transactions in the Item Record

Report creation: On-hand inventory per month

On-hand inventory values of items per month basis can be reviewed by customizing the Inventory valuation standard report. Open the Inventory valuation report by Report> Inventory/ Items> Inventory valuation Click Edit Columns Tab. Add the column Quantity On Hand: Quantity On Hand and set an Alternate Date range. To add another column for another month, repeat step 3. Uncheck the Add… Continue reading Report creation: On-hand inventory per month