Background While NetSuite is strong as a general-purpose ERP platform for distributors, there are some business flows where the system out-of-the-box does not have ready-to-go algorithms. One such practice is called Consignment Sales. Instead of the dropship model where a seller does not possess the good but then instructs a supplier to ship directly to… Continue reading Automate NetSuite Consignment Sales Obligation Programs
Tag: Netsuite
Learn How To Automatically Apply NetSuite Landed Costs from Purchased Freight
NetSuite Landed Cost Considerations Note, I have seen many organizations attempt to track actual landed costs against item receipts. The primary challenges of tracking actuals have to do with the fact that actual costs may take significant time to be known; vendors may present their bills well past the time that services were rendered. In… Continue reading Learn How To Automatically Apply NetSuite Landed Costs from Purchased Freight
Rescheduling Scheduled or Map/Reduce NetSuite Script Considerations
Background In our professional services practice, we created a tool called “Queue Manager” to help us with complex NetSuite jobs. The Queue Manager simply is a record structure to help us understand when we want to schedule or queue up background processing work — using it helps us optimize the way we use threads/processors in our… Continue reading Rescheduling Scheduled or Map/Reduce NetSuite Script Considerations
NetSuite Vendor Bill Created From Purchase Order References
Background NetSuite’s general transaction architecture is to generate child records from copies of parent records. For example, on the Sales Order, when it is time to bill, the resulting invoice is effectively a copy with a cross-reference via the Created From field. This pattern is used extensively in the NetSuite environment. Yet, there may be use cases… Continue reading NetSuite Vendor Bill Created From Purchase Order References
Learn the SuiteScript Pattern to Generate Target Purchase Orders from Sales Orders
Background We have clients that are in industries that use both drop ship purchase orders and third party assembly operations. In many of these operations, the sales process is sufficiently complicated where every sales order requires consideration of one or more suppliers that will ultimately produce (an element of) the fulfillment. When creating the sales order, the… Continue reading Learn the SuiteScript Pattern to Generate Target Purchase Orders from Sales Orders
How To: Link a Standalone NetSuite Vendor Bill to a Purchase Order Accounting
Background While subject to a separate article, during a client implementation of a consignment sales flow, we sought to couple the specific sale of an item to the creation of a related vendor bill. In this case, since the items were serialized, we knew exactly where we acquired the item by looking it up via… Continue reading How To: Link a Standalone NetSuite Vendor Bill to a Purchase Order Accounting
Celigo Integration with NetSuite: A Powerful iPaaS for Seamless Automation
Celigo is a leading Integration Platform as a Service (iPaaS) that enables businesses to connect NetSuite with other cloud-based or on-premise applications, streamlining data flow and automating business processes. With its intuitive interface and robust integration capabilities, Celigo is especially popular among NetSuite users looking to enhance operational efficiency and reduce manual effort. Why Use… Continue reading Celigo Integration with NetSuite: A Powerful iPaaS for Seamless Automation
Default Payment Account Hierarchy
The following is the hierarchy that NetSuite uses for its default payment account: Payment Method Note: This can be found in Setup > Accounting > Accounting Lists > Type: Payment Method If Deposit To is marked, either: Undeposited Funds, or Specific Account selected If no Account is selected, it will default to Settlement Bank Account… Continue reading Default Payment Account Hierarchy
Currency Exchange Rate Record
In NetSuite, the Currency Exchange Rate Record is used to define the exchange rates between different currencies used in the system. This is crucial for financial transactions, reporting, and conversions when dealing with multi-currency accounts and international business. Here’s a detailed breakdown of what the Currency Exchange Rate Record is and how it functions: Purpose… Continue reading Currency Exchange Rate Record
To enable multi-currency in the Vendor bill
Client Business Scenario The client is purchasing items from an international vendor in USD. In the same vendor bill, the client needs to record local expenses (such as custom duties, freight, carrier charges) that are paid to Indian authorities in INR. The business expectation is to record both the USD and INR amounts in a… Continue reading To enable multi-currency in the Vendor bill