NetLease Workflow Billing Reference Number
Overview:
Customers using NetLease's automated billing functionality often want a way to default the Reference Number on the created bill. A common setup is having a combination of the date, lease ID, lease name, etc. This can be setup in NetLease via a simple workflow.
While workflows are a native NetSuite feature and are not maintained by Netgain, they can be setup to work on our records since we are a fully embedded app in NetSuite. In order to follow the steps below, your role will need the ability to create workflows in NetSuite.
Step by Step:
- Navigate to Customization > Workflow > Workflows > New
- Fill out the form as pictured below:
- Name = Use a name that will be easily referenced in the future and clearly explains what the purpose of the workflow is
- Record Type = Transaction
- Sub Types = Vendor Bill
- Release Status = Needs to be Released in order to run
- Keep Instance and History = We suggest putting this as "Always" so you have a history to reference if it doesn't run properly
- Scroll down to the second half of the page to the Initiation section. Open the Condition field and set the Field to "Ref. No" and Compare Type to "empty". Click Save.
- Populate the remaining fields as show below:
- Select "Event Based"
- Check the box for "On Create" and "On View Or Update".
- Click Save. The Workflow page will then appear.
- Click anywhere in the "State 1" box on the screen. This will pull up the sidebar for the state. Click the "New Action" button at the bottom of the sidebar.
- Select "Field Value"
- In the popup window, select "Ref. No" as the Field and check the indicator for the "Formula" Value type. The formula is the information that will be used to create the Ref No on the transactions created by NetLease. You can put whatever you like in this field.
- This is an example formula: {trandate} | | ' ' | | SUBSTR({custbody_laa_lease.name}, 0 , 6)
- It will put the transaction date, followed by the first 6 letters of the Lease name field (in this case that will be the ID)
- It will put the transaction date, followed by the first 6 letters of the Lease name field (in this case that will be the ID)
- This is an example formula: {trandate} | | ' ' | | SUBSTR({custbody_laa_lease.name}, 0 , 6)
- Click Save. You can go back to this workflow to change the formula and therefore components of the Ref. No. anytime, but it wont change retrospectively.
