Custom Guided Wizard
12min
introduction breadwinner was designed to create transactions (sales orders, invoices, purchase orders, etc ) in netsuite from any object(s) in salesforce this can be accomplished either automatically (through triggers and global classes) or via a custom guided wizard the configuration of that guided wizard is detailed below restrictions many of our restrictions are restrictions of netsuite if you can’t create a record in netsuite manually via copying and pasting, then you probably can’t use our custom guided wizard approach to create that same record additionally, breadwinner does not include logic that is already native to salesforce for instance, this tool cannot merge two salesforce fields into one netsuite field however, you may create a salesforce formula that merges those two salesforce fields and use this tool to pull that single formula field into netsuite preparation the following are required for this process an originating object this is the record that contains the information you want to go on the sales order, such as date, customer, etc (this record may optionally have a child object shown as a single related list, with many records in that related list that become the line items in netsuite) a netsuite object (technically, this is an object that is included in the breadwinner managed package, though the object will start with “netsuite”, like netsuite invoice ) you must create a lookup to the originating object a netsuite customer record however, most people reference a salesforce account instead of the netsuite customer, and breadwinner will prompt the user to either select one of the existing netsuite customers associated with that salesforce account or to create a new netsuite customer a formula field on the child object that references the netsuite item (briefly explained below) the netsuite object (typically either the netsuite estimate, sales order, or invoice) must have a lookup to the originating object for instance, if you are creating sales orders from opportunities, you will need to create a lookup field in the netsuite sales order object in salesforce to the opportunity object and we strongly recommend you add the relevant related list to that object’s page layout and the originating object will need either a direct lookup to the salesforce account (either via a lookup or master detail) or a formula field that references a lookup to the salesforce account (or you can create a formula field or a lookup pointing directly to a netsuite customer, instead of the formula field or a lookup pointing to an account) formula referencing the netsuite item when you create a netsuite transaction record (estimate, sales order, invoice, credit memo, etc), you will need to specify at least one line item and those line items will need to specify an existing netsuite item so to create a record from breadwinner, a netsuite item needs to be specified normally this is specified via a formula that points to a lookup to breadwinner's netsuite item, but a direct lookup is technically possible breadwinner has, as part of its managed package, a lookup from salesforce's standard product to breadwinner's netsuite item and, we have a product match tool in breadwinner's setup tab that will help you associate the salesforce products to the netsuite items if breadwinner was used to mass create salesforce products from netsuite items, then this association is already established however, you will need to create an additional formula field in salesforce to reflect this lookup so, if you are creating netsuite records from the opportunity products, or from the order products, you would need a formula on those objects traversing the association between the opportunity products or order products, through the salesforce product, to the final netsuite item and, if you are creating records from salesforce custom objects, you will need a formula (or lookup) from those line item esque custom objects to breadwinner's netsuite item also, there are various restrictions around netsuite items and item groups docid ralgcmm70ue7jycyhpoj that are to known before you start creating any transactions exposing the picklist ids if you wish to create or modify a record with a picklist in netsuite, then you will need to pass breadwinner the id of the picklist option the visibility of picklist ids might not be enabled in your netsuite org to enable visibility of picklist ids (which will only be visible in the customization section of netsuite, and not visible to end users), please go to home > set preferences on the general tab, in the defaults section (usually on the right) you will be able to enable “show internal ids” conventions to follow in button url in the formulas below, the left side of the equation is our field, and the right side of the equation (after the = sign) is for you to populate based on the api names in your salesforce org for instance, if you see button url \&parent account=api field name c then your formula would include \&parent account= \&parent account= , but the api field name c would be replaced by the api name of the field in your salesforce org ease of use tip we have made a custom guided wizard to help you create the netsuite records to view that, simply make a button with the text below, quick save it, add it to the originating object's sales order related list page layout, and click this button should be created on the sales order object (as a button, not an action or link) we recommend setting the name of the button to be something like “new netsuite sales order from the \[something object]” button url /apex/breadwinner ns createsalesorder?testing=true once created, the button should be displayed on the page layout of the object in question (the one you wish to create sales orders from), on the sales orders related list on that object (in the page layout for that object, click the wrench on the related list, and then click "buttons" to change the buttons on the related list) this is also the time to remove the standard "new" button by unchecking it, as the standard "new" button won’t work on custom objects url formula the button url generator docid\ loahvbu12 akyzgp0vs6o will give you the formula you need however, you may wish to further modify the url, or understand it further also, you can create multiple buttons per object, with different formulas to be allowed sales orders to be populated in different ways from different fields when creating formulas in salesforce, you can create a formula over many lines, separated by a new line for readability button on sales order related list you can create a button on the breadwinner sales order object itself as a list button (without multi checkboxes) after creating it, you must display it on the related list of the originating object’s page layout these buttons will be added to the page layout of the originating object by clicking the wrench/spanner on the sales orders related list button or link on originating object you can also create the button or link on the originating object this will be added directly to the page layout of the originating object however, this can cause slight usability issues, so we recommend the button go on the sales orders related list