Author: Manju

Update ‘ADJUST QTY. BY’ in Inventory Adjustment using CSV import

We can update ADJUST QTY. BY in inventory adjustment record. For that we have to specify the Line Id for each of the Items. Also, we need to eliminate the line Id 0 from the list. Then we have to give Location( line level), item name , ADJUST QTY. BY, line Id and internal Id… Continue reading Update ‘ADJUST QTY. BY’ in Inventory Adjustment using CSV import

Why the customize option is not there in Report Schedules

The customize option is not there for some schedules in the Report schedule page. Also, the name of the schedule is not matching with any reports in the account. There is no details about any of the name of the Report in the Report schedule page. This is because the mentioned Report is a standard… Continue reading Why the customize option is not there in Report Schedules

Updates are not reflected in the schedule Reports

We created a Report and scheduled. We have updated the Report by adding filters. But in the Scheduled Email, the updates done in the Report are not reflected.ie, the email is sent with the old content. We edit and save the Report Schedule. But the content does not get updated. Solution Create a new schedule… Continue reading Updates are not reflected in the schedule Reports

Bin Creation Using CSV Import

Create an Excel file with the following fields Bin Number External ID Location Memo (if needed) Then Got to the Import CSV Records Page, Choose Supply Chain as Import Type and Bin as Record type. Map the above mentioned fields. Then Save. We cannot perform Bin transfer using CSV Import.

How to include MOQ in Supply Planning

When using Demand Planning module, the supply plans are created as per the demand thus projected. If we have a Minimum Order quantity for placing purchase orders from a vendor, we have to do the following. Suppose our supply plan suggests to procure 37 units every month to meet the projected demand If the MOQ… Continue reading How to include MOQ in Supply Planning

How to set Default Location in Purchase order form.

We can set the default location in a purchase order which is considered as the preferred location. This can be set by Go to Go to Setup → Accounting → Accounting Preferences → Order Management Under the Purchasing subtab, set the Default Location for Purchase orders This can be done only for a single location… Continue reading How to set Default Location in Purchase order form.

Mapping fields from Inbound Shipment to Item Receipt

By using the Standard features of NetSuite, we cannot map fields from Inbound Shipment to Item Receipt If we use workflow on Item Receipt, then the fields in the Inbound shipment won’t be listed even though there is a field named Inbound Shipment in IR. On using Sourcing and Filtering options for custom fields in… Continue reading Mapping fields from Inbound Shipment to Item Receipt

Supply Planning

The supply plan is where NetSuite compares the demand plan– what I will need, in other words– and what you’re expected to have. From that comparison, the supply plan determines if you need to procure any additional stock. And when I say procure, you might buy those goods from a vendor, or they might be… Continue reading Supply Planning

Exchange Rate Fluctuations on Advanced payment applied Vendor Bills

The difference in exchange rate may cause difference in amount in vendor prepayment and vendor bill. Suppose if the vendor has multiple currencies and the price of the Item is $2500. On creating the PO, the exchange rate was 3.75. But when applying a vendor prepayment having exchange rate 3.73, the amount difference is around… Continue reading Exchange Rate Fluctuations on Advanced payment applied Vendor Bills