Sync accounts from Crunchwork into Netsuite as customers
Upon creation of account (in Crunchwork), then sync with Netsuite
Any time the profile changes in Crunchwork, then sync with Netsuite.
Please take note that changes made in Netsuite will be overwritten by changes in Crunchwork.
Sync vendors from Crunchwork to Netsuite as ‘suppliers’
Upon creation of vendor profile (in Crunchwork), then sync with Netsuite.
Any time the profile changes in Crunchwork, then sync with Netsuite.
Please take note that changes made in Netsuite will be overwritten by changes in Crunchwork.
Sync customer invoices from Crunchwork to Netsuite
When an invoice is marked “Approved” in Crunchwork
Then sync invoice to Netsuite with the following information:
Client reference number (Claim Number)
Location (ie, North Lakes)
Legal entity (ie, entity, QLD, VIC, NSW) (Subsidiary)
Class (ie, Make Safe, Report Fees, Tender, Do & Charge)
Each line item and it’s $$
Department (ie, Major Works, Construction, Restorations)
Sync invoices with the type “Credit note” as a Credit Note to Netsuite
Create an invoice and choose type “Credit Note” against the record.
Add negative value line items to the invoice
Mark invoice as ‘approved’
Sync the ‘Credit Note’ invoice into Netsuite as a Credit Memo
Note, anyone you wish to invoice will need to be created in Crunchwork as an "Account" first before assignign them to an invoice.
Sync invoice PDFs into Netsuite File Cabinet
There are two folders in the File Cabinet for NetSuite (AR and AP). Invoices for customers will be sent to the "AR" folder upon regular syncing.
AP Process
Trade sends their invoice to supervisor/accounts team
AP team finds the related purchase order in Crunchwork
AP team reconciles the purchase order with the trade invoice with the following actions:
Add trade invoice number and invoice issue date to the purchase order
Click ‘show reconciliation’ and reconcile each line item
Review budget allocation at the bottom of the page
Update purchase order status to ‘reconciled’
Ensure that the trade invoice is uploaded against the related Crunchwork job, in the event that the supervisor hasn’t attached the trade invoice to the job already