Fast-Weigh Web Portal
| To add the NetSuite Accounting Integration to your Fast-Weigh subscription, contact us at 865-219-2980 or support@tacinsight.com . |
![](https://img.zohostatic.com/zde/static/images/info.png)
The NetSuite integration also works great with our Avalara integration!
Integration overview
Fast-Weigh has a direct 2-way integration with the NetSuite accounting system.
With the integration, you can:
Fetch :
- Customers
- Hauling vendors
- Products
Post :
NetSuite setup checklist:
There are a few things you'll need to sure are set within NetSuite for the integration to work:
Integration authentication setup:
Oauth2 enabled:
- Setup > Company > Enable Features > Manage authentication
- Make sure the Oauth2 box is checked
Authorizing user:
Integration header setup
Automated sync authentication:
Invoicing and Vendor Bill setup:
Enable manual invoice and credit memo numbers (Fast-Weigh needs to control and post it's own sequence)
- Setup > Company > Auto-Generated Numbers
Document Numbers subtab:
(Optional) Setup custom body and transaction fields to store ticket info posted from Fast-Weigh. These can be used in NetSuite forms and reporting.
Customization > Lists, Records & Fields > Transaction Body Fields > New
- Note: NetSuite automatically prefixes custom body fields with "custbody_". If you intend to use these fields please make note to prefix the field name accordingly when searching for it.
- fw_order_number
- fw_order_info
- fw_order_job
- fw_order_lat
- fw_order_long
- fw_order_direction
- fw_order_paytype
- fw_order_udf1
- fw_order_udf2
- fw_order_udf3
Customization > Lists, Records & Fields > Transaction Line Fields > New
- Note : NetSuite automatically prefixes custom line item fields with "custcol_". If you intend to use these fields please make note to prefix the field name accordingly when searching for it.
- fw_ticket
- fw_hauler
- fw_truck
- fw_ticket_udf1
- fw_ticket_udf2
- fw_ticket_udf3
Fast-Weigh setup checklist:
Default Queries and Settings Extended Values:
Default Customer Query:
SELECT SUBSTR(entityid, 0, 10) as CustomerID, customer.id as QBID, companyname AS CustomerName, BUILTIN.DF(CustomerSubsidiaryRelationship.subsidiary) as CompanyCode, BUILTIN.DF(terms) as Terms, email as InvoiceEmail, BUILTIN.DF(salesrep) as Salesperson, BillToAddress.Addr1 As Address1, BillToAddress.Addr2 As Address2, BillToAddress.Addr3 As Address3, BillToAddress.City As City, BillToAddress.State As State, BillToAddress.Zip As Zip, BillToAddress.Country As Country FROM customer LEFT OUTER JOIN EntityAddressbook AS DefaultBilling ON ( DefaultBilling.Entity = Customer.ID ) AND ( DefaultBilling.defaultbilling = 'T' ) LEFT OUTER JOIN EntityAddress AS BillToAddress ON ( BillToAddress.nkey = DefaultBilling.AddressBookAddress ) LEFT OUTER JOIN CustomerSubsidiaryRelationship ON ( CustomerSubsidiaryRelationship.Entity = Customer.ID ) where customer.isinactive = 'F'
Default Hauler Query:
SELECT entityid as HaulerID, SUBSTR(companyname, 1, 50) as HaulerName, id as VendorAPNum, SUBSTR(email, 1, 70) as ContactEmail, SUBSTR(phone, 1, 14) as ContactPhone, SUBSTR(BillToAddress.Addr1, 1, 30) As Address1, SUBSTR(BillToAddress.Addr2, 1, 30) As Address2, BillToAddress.Addr3 As Address3, SUBSTR(BillToAddress.City, 1, 25) As City, BillToAddress.State As State, SUBSTR(BillToAddress.Zip, 1, 10) As Zip, BillToAddress.Country As Country from vendor LEFT OUTER JOIN EntityAddressbook AS DefaultBilling ON (DefaultBilling.Entity = vendor.id) AND (DefaultBilling.defaultbilling = 'T') LEFT OUTER JOIN EntityAddress AS BillToAddress ON (BillToAddress.nkey = DefaultBilling.AddressBookAddress) where category = '9' and isinactive = 'F'
Default Product Query:
SELECT SUBSTR(itemid, 1, 15) as ProductID, SUBSTR(description, 1, 50) as ProductDescription, BUILTIN.DF(saleunit) as UoM, id as QBID FROM item