POs (Vendor Bills) Import Workflow

The POs (Vendor Bills) import workflow lets you:

Create new vendor bill records in NetSuite first and then import them into SuiteProjects Pro as purchase order.
Update vendor bill records in NetSuite and use the NetSuite <> SuiteProjects Pro integration to update the corresponding purchase order record in SuiteProjects Pro.

When importing a vendor bill into SuiteProjects Pro as purchase order, the following records are created in SuiteProjects Pro:

Purchase order — A single purchase order is created or updated in SuiteProjects Pro to match the NetSuite vendor bill.
Purchase items — Each vendor bill line item marked for export on the NetSuite vendor bill imports into a purchase item.
Purchase requests —A purchase request record is created for each vendor bill line item marked for export on the NetSuite vendor bill. This is because in SuiteProjects Pro, purchase request and request item in SuiteProjects Pro must be associated to a single project, whereas in NetSuite, vendor bills can reference multiple projects.
Request items — Each purchase request includes one request item.
Fulfillments — A fulfillment record is created for each purchase item.

Note:

You can also import vendor credits from NetSuite into SuiteProjects Pro as purchase orders with negative purchase items. See POs (Vendor Credits) Import Workflow.

You can import purchase orders instead of vendor bills from NetSuite into SuiteProjects Pro as purchase orders using the POs (Purchase Orders) import workflows. The POs (Vendor Bills) and POs (Purchase Orders) import workflows are mutually exclusive. See POs (Purchase Orders) Import Workflow.

Important:

Changes made to purchase order records in SuiteProjects Pro after the initial import are not exported back to NetSuite.

For information about vendor bills in NetSuite, see Vendor Bills (External link to NetSuite SuiteAnswers | Answer ID 11156).

For information about field mapping definitions for this workflow, see POs (Vendor Bills) Import Field Mapping Definition.

Requirements and Downstream Dependencies

This workflow is mutually exclusive with the POs (Purchase Orders) import workflow.

The following workflows must also be enabled:

Matching project records must exist in both NetSuite and SuiteProjects Pro before you can import vendor bills from NetSuite into SuiteProjects Pro as purchase orders.

Matching vendor records must exist in both NetSuite and SuiteProjects Pro before you can import vendor bills from NetSuite into SuiteProjects Pro as purchase orders.

Note:

You can use the POs (Vendor Bills) import workflow and Expense Reports (Expense Reports) export workflow in conjunction to import vemdor bills from NetSuite into SuiteProjects Pro as purchase orders and to export expense reports from SuiteProjects Pro to NetSuite as vendor bills. See Expense Reports (Expense Reports) Export Workflow.

Exporting expense reports from SuiteProjects Pro to NetSuite as vendor bills requires the associated user record in SuiteProjects Pro being matched with a vendor record in NetSuite. To use both workflows in conjunction, enable the Employees (Vendors) import workflow and use the SuiteProjects Pro: User or Vendor [custentity_oa_user_or_vendor] field on the vendor record in NetSuite to determine whether the vendor should be imported into SuiteProjects Pro as a vendor or as an employee (user). See Employees (Vendors) Import Workflow.

After you import vendor bills from NetSuite into SuiteProjects Pro as purchase orders, you can use project billing rules to create product charges based on purchase items and fulfillments, add these charges to your invoices in SuiteProjects Pro, and export the invoices to NetSuite. Markups can be used.

The NetSuite vendor bill billable [netsuite_vb_billable] box is checked on the purchase item in SuiteProjects Pro if the vendor bill line item is billable in NetSuite. When exporting invoices with product charges for purchase items imported into SuiteProjects Pro using the POs (Vendor Bills) import workflow, these charges export as billable line items on the NetSuite invoice Billable Items subtab.
- Use the Bill Line mapping group to export information on the product charges created from purchase items. See Bill Line Mapping Group.
- Use the Vendor Bill Line mapping group to export information on the purchase items. See Vendor Bill Line Mapping Group.
If the NetSuite vendor bill billable [netsuite_vb_billable] box is NOT checked on the purchase item in SuiteProjects Pro or if you are using Invoices (Invoices) workflow settings modifying the default behavior, charges export as invoice line items on the NetSuite invoice Items subtab, and not as billable line items on the Billable Items subtab.

The following Invoices (Invoices) workflow settings modify the default behavior:
- You can check the Disable vendor bill linkage on invoices in NetSuite integration to remove the vendor bill reference on the invoice line item. See Disable vendor bill linkage on invoices in NetSuite integration.
- You can also check the Use Service item instead of Product item during invoices export for purchase charges to reference a service item instead of a product item on the invoice line item. See Use Service item instead of Product item during invoices export for purchase charges
The following Invoices (Invoices) import workflow mapping groups are used to export billable purchase items imported from a NetSuite vendor bill:
- Use the Invoice Line mapping group to export information on the product charges created from purchase items. See Invoice Line Mapping Group.
- Use the Purchase Line mapping group to export information on the purchase items. See Purchase Line Mapping Group.

Supported Features

Workflow Settings

Filters

Advanced Mapping

Real-Time

SuiteProjects Pro Within NetSuite

Monitored Fields

Check mark

Run the integration manually, use a scheduled integration run to create or update the SuiteProjects Pro purchase order record after you create or update the vendor bill record in NetSuite. See Running the Bulk Import and Export Integration on Demand and Scheduling the Integration to Run Automatically.
Setup the real-time integration to create or update the SuiteProjects Pro purchase order record when the vendor bill form is saved in NetSuite. See Configuring Real-Time Record Import from NetSuite into SuiteProjects Pro.
View and edit the SuiteProjects Pro purchase order record from the NetSuite UI using the SuiteProjects Pro Within NetSuite (SuiteProjects Pro NetSuite Single Sign-On Integration) feature. See Enabling Access to SuiteProjects Pro From Within NetSuite.

Setting up the POs (Vendor Bills) Import Workflow

Use the following steps to set up the workflow.

To set up the POs (Vendor Bills) import workflow in NetSuite

In NetSuite, do one of the following:
- Go to Setup > Company > General Preferences (Custom Preferences), if you are using the SuiteScript 1 versions of SuiteProjects Pro SRP Integration (Bundle ID 369637) bundle scripts.
- Go to Customization > Lists, Records and Fields > Records > [View list forSuiteProjects Pro: Integration Settings] > [View SuiteProjects Pro Integration Settings Record] , if you are using the SuiteScript 2 versions of SuiteProjects Pro SRP Integration (Bundle ID 369637) bundle scripts.
Check the Vendor Bill to SuiteProjects Pro PO Integration box.
Click Save.
Go to Setup > Company > Enable Features, and click the Transactions subtab.
Check the Advanced Receiving box under the Shipping & Receiving section. The Advanced Receiving feature is required to create purchase item receipts in NetSuite.
Click Save.
Go to Setup > Accounting > Invoicing Preferences and clear the Combine Billable Items on Invoices box. this feature is not compatible with the POs (vendor Bills) import workflow.
To let employees view projects and items and check the Billable and Export to SuiteProjects Pro boxes for vendor bill line items and vendor bill records, go to Home > Set Preferences and check the Validate SuiteProjects Pro PO/Vendor Bill box on the Custom Preferences tab.

To set up the POs (Vendor Bills) import workflow in SuiteProjects Pro

In SuiteProjects Pro, go to Administration > NetSuite Connector.
Click the Tips button then NetSuite Connector Administration.

The NetSuite Connector administration form appears.
Check the POs (Vendor Bills) box under the Imports section.
Click Save then Close.
If the purchaser integration is not enabled, designate a purchaser to use when importing vendor bills into SuiteProjects Pro as purchase orders. To do so:
1. Go to Administration > Application Settings > Purchases > Purchasers > [ Select a purchaser].
2. Check the NetSuite Purchase Order Integration purchaser [netsuite_purchaser] box.
3. Click Save.
Note:
To create a purchaser, you must create at least one record for each of the following record types in Administration > Application Settings > Purchases > Accounts payable locations, Receiving locations, Carriers, Shipping terms, and F.O.B. locations.

If the purchaser integration is enabled, matching employee records must exist in SuiteProjects Pro and NetSuite for employees creating purchase orders in NetSuite, and purchaser records marked as NetSuite purchaser must exist for these employees in SuiteProjects Pro. For more information about the purchaser integration, see Enable purchaser integration
Go to Administration > NetSuite Connector > Mapping.
Click New workflow then POs (Vendor Bills).
Click POs (Vendor Bills) in the list of integration workflows.
Modify the field mapping definition table for the Tasks (Project Tasks) import workflow as required. See Mapping SuiteProjects Pro Fields and NetSuite Fields and POs (Vendor Bills) Import Field Mapping Definition.
Click the switch next to the workflow name to activate or to deactivate the workflow.
Click Save.
(Optional) Add the POs (Vendor Bills) import workflow to a workflow group and schedule it to run automatically. See Scheduling the Integration to Run Automatically.