Tag: aging report

Inventory Inactivity & Obsolescence report

Requirement: We need a reliable way to measure how long items have been sitting without movement at each location. The default aging report in NetSuite has helped us get part of this visibility, but it does not pull last movement dates or values accurately enough. We’re requesting an Inventory Inactivity & Obsolescence report that shows,… Continue reading Inventory Inactivity & Obsolescence report

Customer Aging Report Using Saved Search

var invoiceSearchObj = search.create({    type: “invoice”,    filters:    [       [“type”,”anyof”,”CustInvc”],        “AND”,        [“mainline”,”is”,”T”],        “AND”,        [“amountremaining”,”greaterthan”,”0.00″]    ],    columns:    [       search.createColumn({          name: “entity”,          summary: “GROUP”,    … Continue reading Customer Aging Report Using Saved Search

Customize the A/P Aging summary for displaying the purchased quantity.

A/P aging report can be customized to display the quantity purchased. The quantity received is displayed by adding the ‘Item: Current quantity available’ field into the report. The quantity which is yet to be received is displayed by adding the ‘Item: Current quantity on order’ into the report as shown below. For getting the quantity… Continue reading Customize the A/P Aging summary for displaying the purchased quantity.