Version: 1.0.0
Audience: User &
Administrator
Vendor/Customer: Vendor
Required Setup and Configuration
- Configure eXtendNS2NS setup screen and provide search id under field Invoice Search to filter which invoices will be sent to your customer
- Create a scheduled
deployment of eXtendNS2NS Send Invoice
M/R script for automating the
process.
- You have been granted access to your customer's account using customized vendor centre role. Please see Authenticate Customer NetSuite Accounts for more information.
Once, the invoice is sent to the customer then on the invoice record under eXtendNS2NS subtab EXTENDNS2NS INVOICE LAST SENT AT field gets filled with the date-time stamp at which the invoice was transmitted to the customer's account. And the log details will show the information regarding the data which was transmitted.
For steps for resending invoice, please refer this article.
The Invoice data is sent in a JSON
format, below is the list of fields which are
mapped by default to the JSON keys which will be sent to the customer:
| Field | Type | Mapping
Field | Remarks |
|---|---|---|---|
| invoice number | String | tranid (Invoice
Transaction Number) | |
| invoice date | Date | trandate (Invoice
Transaction Date) | |
| Purchase Order# | String | otherrefnum
(PO#) | |
| memo | String | memomain
(Memo) | |
| billto > accountname | String | billaddressee
(Bill To Addressee) | Billing Address
Field |
| billto > address1 | String | billaddress1
(Bill To Address 1) | Billing Address
Field |
| billto > address2 | String | billaddress2
(Bill to Address 2) | Billing Address
Field |
| billto > address3 | String | billaddress3
(Bill To Address 3) | Billing Address
Field |
| billto > city | String | billcity (Bill To
City) | Billing Address
Field |
| billto > state | String | billstate (Bill
To State) | Billing Address
Field |
| billto > zipcode | Integer | billzip (Bill To
Zip) | Billing Address
Field |
| billto > country | String / Enum | billcountry (Ship
To Country) | 1. Valid ISO
Country codes to avoid
errors |
| billto > phone | Phone | billphone (Bill
To Phone) | Billing Address
Field |
| billto > attention | String | billattention
(Bill To Attention) | Billing Address
Field |
| shipto > accountname | String | shipaddressee
(Ship To Addressee) | Shipping Address
Field |
| shipto > address1 | String | shipaddress1
(Ship To Address 1) | Shipping Address
Field |
| shipto > address2 | String | shipaddress2
(Ship To Address 2) | Shipping Address
Field |
| shipto > address3 | String | shipaddress3
(Ship To Address 3) | Shipping Address
Field |
| shipto > city | String | shipcity (Ship To
City) | Shipping Address
Field |
| shipto > state | String | shipstate (Ship
To State) | Shipping Address
Field |
| shipto > zipcode | Integer | shipzip (Ship To
Zip) | Shipping Address
Field |
| shipto > country | String /
Enum | shipcountry (Ship
To Country) | 1. Valid ISO
Country codes to avoid
errors |
| shipto > phone | Phone | shipphone (Ship
To Phone) | Shipping Address
Field |
| shipto > attention | String | shippingattention
(Ship To Attention) | Shipping Address
Field |
| Terms | String | terms
(Terms) | |
| Due Date | Date | duedate (End
Date) | |
| Currency | Currency | currency
(Currency) | |
| Amount (Total) | Currency | total (Amount
(Transaction Total)) | |
| Amount (Net) | Currency | netamount (Amount
(Net)) | This
is
not available directly from
body field in search. So it is
the sum of
netamount from
lines. |
| Amount (Paid) | Currency | amountpaid
(Amount Paid) | |
| Amount (Remaining) | Currency | amountremaining
(Amount Remaining) | |
| Amount (Discount) | Currency | discountamount
(Amount Discount) | |
| Amount (Tax) | Currency | taxtotal (Amount
(Tax)) | |
| Amount (Shipping) | Currency | shippingamount
(Amount (Shipping)) | |
| Line > Item Id | String | item (Item) | From the vendor’s
perspective |
| Line > lineType | String | This is the
identifier of the line item in
customer account. If the line item type is ship item then it will be sent as ShipItem, if line item type is tax item then it will be sent as TaxItem and all other item types will be sent as ItemLine. | |
| Line > Sequence # | Integer | linesequencenumber (Line Sequence
Number) | |
| Line
> Quantity
Ordered | Decimal | This
can’t
be possible for now as this
line level joining to the
parent record. | |
| Line > Quantity Invoiced | Decimal | qunatity (Line
item Quantity) | |
| Line > UOM | String /
Enum | Added a mapping
in transformer.js file. | Map to valid list
of ISO Codes so, that can be
easily exchanged cross NetSuite
accounts. |
| Line > Description | String | memo (Line item
description) | From search line
item description is available
in memo field. |
| Line > Unit Price | Currency | rate (Line item
rate) | |
| Line > Amount | Currency | amount (Line item
amount) |