Gloria George C – knowledgebase JJ

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

Customer Aging Report Using Saved Search

Proposal For Price List Structure Implementation

Proposal Summary Bigrig Group needs a price list structure implementation based on specific price levels for each item. Requirement The Bigrig Group need to implement a new price list structure for subsidiary, Big Rig Partz CAN. The %age for Base Price and Retail Price which needs to be implemented in the NetSuite as given… Continue reading Proposal For Price List Structure Implementation

Saved Search To Retrieve The Last Three Purchase Orders

Record Type: Transaction (as Purchase Orders are transaction records). Criteria: Type is Purchase Order: This filters the search to only include Purchase Orders. Main Line is True: Ensures that only the main line of transactions is considered. Date Created or Date of Purchase Order: Choose one of these date fields to sort the purchase orders.… Continue reading Saved Search To Retrieve The Last Three Purchase Orders

PO and IR Rate Sync

Typically, when there’s a change in the rate specified in purchase orders, the corresponding rates in previously generated item receipts won’t be automatically adjusted to the updated rate. To address this, we can employ the provided script to ensure that the rates in item receipts are synchronized with any changes made to the rate in… Continue reading PO and IR Rate Sync

Proposal for automation Script for creating Blanket Return Authorization for Photography

Proposal Summary This proposal describes the automation script for creating Blanket Return Authorization for Photography. Requirement A client would like to implement an automation script to handle below two cases: Part 1 – every month on the first of the month they need a script that creates a blanket Return Authorization. Use the Simplified form… Continue reading Proposal for automation Script for creating Blanket Return Authorization for Photography

Proposal For ChannelAdvisor – NetSuite Integration Using ChannelAdvisor Connector

Proposal Summary Dealmed Medical Supplies would like to integrate Channel Advisor with NetSuite using the ChannelAdvisor connector. Requirement The requirement is to configure the ChannelAdvisor connector to enable the ChannelAdvisor integration with NetSuite for tracking the transactions. Prerequisites ChannelAdvisor Profile ID (NOTE: If we are an existing ChannelAdvisor customer with active accounts, it is highly… Continue reading Proposal For ChannelAdvisor – NetSuite Integration Using ChannelAdvisor Connector

Proposal For Item Rate Population on Purchase Order Based on Various Factors

Proposal Summary This proposal outlines a customized solution to populate the rate on the purchase order based on various factors from purchase contract. Requirement Hay Australia is required to divide the item rates into 4 different aspects: Item Rate, Storage Rate, Freight Rate, and TopUp Rate. All these rates need to be added up as… Continue reading Proposal For Item Rate Population on Purchase Order Based on Various Factors

Proposal For Lavy Item Line Automation On Purchase Order

Proposal Summary Hay Australia needs Levy item line automation on the Vendor Bill. This proposal outlines a customized solution to have a system to automate the Lavy item line on purchase orders. Requirement Hay Australia would like to a have a solution to automate the Lavy item line on Vendor Bills. Hay Australia record levies… Continue reading Proposal For Lavy Item Line Automation On Purchase Order

Gross Amount altering done by NetSuite

We have recently completed an integration with a third-party application, which involves the creation of cash sales within NetSuite for a specific customer, “4902 Aria Super Market Customer”. In the process of generating these cash sales, we have been setting the gross amount and tax rate directly within the item line, rather than specifying the… Continue reading Gross Amount altering done by NetSuite