Version: eXtendPS-SE 1.4.2 and above
Audience: Administrator
Overview
Before the invoicing service can be made available to distributors, it needs to be configured. This configuration involves mapping fields from the NetSuite invoice record to the corresponding fields in the PromoStandards invoice API response.
Configuration
- Go to eXtendTech → eXtendPS-SE → Invoice Setup.
- Configure the fields in the General
Configuration section as follows:
- Saved Search ID
for Invoicing Results*– Specify the saved search id which contains invoices to be returned by the service.
- Allow Sub-customer’s
Invoices – This
checkbox determines whether to show the invoice record for sub-customers in
response or not.
- Do Not Add Tax Fields In
Search –This checkbox determines whether to send
tax information in the invoice response or not.
- Configure the fields in the WSDL
Mappings (General) section as follows:
- Invoice Line Item ID
(0.0.1 Only) *- Invoice column field ID in the Saved Search ID
for Invoicing Results saved search whose value will be sent as the invoiceLineItemNumber in the invoice response.
- Purchase Order Line Item
Number- Invoice column field ID in the Saved Search ID
for Invoicing Results saved search whose value will be sent as the purchaseOrderLineItemNumber in the invoice response.
- Invoice Date- Invoice creation date field present in above specified Invoicing
result saved search. Recommended field for this is {trandate}
- Invoice Number- Invoice number field in above specified Invoicing result saved
search. Recommended field for this is {transactionnumber}
- Sales Order Number Field
– Sales Order
number field whose value will be sent over Invoice service response. Recommended field for this is {tranid}
- Purchase Order Number- Purchase Order number field in above specified Invoicing result
saved search. Recommended field for this is {otherrefnum}
- Bill to Account Name- Bill To account name field in above specified Invoicing result saved
search which will be invoiced for the purchase order. Recommended field for
this is {customermain.companyname}
- Bill to Account Number- Bill To account number field in above specified Invoicing result
saved search which will be invoiced for the purchase order. Recommended
field for this is {customermain.accountnumber}
- Ship to Account Name- ShipTo account name field in above specified Invoicing result saved
search which will be invoiced for the purchase order. Recommended field for
this is {shipaddressee}
- Ship to Account Number- ShipTo account number field in above specified Invoicing result
saved search which will be invoiced for the purchase order. Recommended
field for this is {customermain.accountnumber}
- FOB ID- FOB point field in above specified Invoicing result saved search.
- Invoice Currency –Currency field in above specified Invoicing result saved search. Recommended
field for this is {subsidiary.currency}. More details regarding invoice currency configuration can be found in this link. Note: This field will not be available on Non-Multi Currency account.
- Fill in the fields of the WSDL
Mappings (Invoice 1.0.0) section as follows:
- Line Item Part Id – Line item part Id
field on Invoice record. Recommended
field {item.itemid}
- Line Item Product Id – Line item product
Id field on Invoice record. Recommended
field {item.parent}
- Line Item Charge Id – Line item charge
Id field on Invoice record.
- Line Item Number –Line item number field
on Invoice record. Recommended field {line}
- Item Ordered Quantity – Line item
ordered quantity field on Invoice record.
- Quantity – Line item quantity field on
Invoice record. Recommended field {quantity}
- Item Back Ordered Quantity – Line item
back ordered quantity field on Invoice record.
- Item UOM – Line item UOM field on
Invoice record. Recommended field {unit}
- Item Description – Line item description
field on Invoice record. Recommended
field {memo}
- Item Unit Price – Line item rate field
on Invoice record. Recommended field {rate}
- Item Extended Price – Line item extended
price field on Invoice record.
- Distributor Product Id – Line item distributor
product Id field on Invoice record.
- Distributor Part Id – Line item distributor
part Id field on Invoice record. Recommended
field {item.vendorname}
- Purchase Order Version – Purchase Order
version field on Invoice record.
- Payment Terms – Payment terms field on
Invoice record. Recommended field {terms}
- Bill To Email – Bill to email address
for your Invoice. Recommended field {customermain.email}
- Ship To Email – Ship to email address
for your Invoice. Recommended field {customermain.email}
- Payment Due Date – Due date of your
Invoice. Recommended field {duedate}
- Sales Amount – Subtotal amount of
Invoice, excluding taxes, shipping & handling charges. Recommended field {subtotal}
- Shipping Amount – Total shipping amount
applied on Invoice. Recommended field {shippingamount}
- Handling Amount – Total handling amount
applied on Invoice. Recommended field {handlingamount}
- Tax Amount – Total tax amount applied on
Invoice. Recommended field {taxtotal}
- Total Amount – Grand total amount
applied on Invoice. Recommended field {totalamount}
- Advanced Payment Amount – Total advanced
payment amount applied on Invoice. Recommended
field {amountpaid}
- Amount Due – Total due amount of the
Invoice. Recommended field {amountremaining}
- Taxes Tax Jurisdiction Field – Jurisdiction/State
field on tax item. Recommended field {taxitem.state}
- Taxes Tax Type Field – Tax type field on
tax item.
- Taxes Tax Amount Field – Tax amount
field on tax item. Recommended field {amount}
Note: You can specify the column number of the results of the search specified on Saved Search ID for Invoicing Result field on setup under above mentioned setup fields. In this case the values will be picked from the search column specified by you in these fields. - Line Item Tax Type Mapping
(Sub-Tab)- Specify mappings between NetSuite’s tax type against
PromoStandards tax type.
- UOM Mapping (Sub-Tab)- Specify mappings between NetSuite’s UOM against
PromoStandards UOM.
- NetSuite UOM - This field will show you the list of all UOM types created in your NetSuite account. Select the required unit type against which you want to create the UOM mapping.
- NetSuite UOM Unit Name - Specify the name of the unit present under the selected UOM type for which you want to create UOM mapping. As shown in below screenshot, you will have to specify Each if you want to create the mapping against this unit name.
- PromoStandards UOM - Select the PromoStandards UOM which will be mapped with your NetSuite UOM.
- Currency Mapping
(Sub-Tab)- Specify mappings between NetSuite’s Currency against PromoStandards
Currency. Note: If no currency mapping is provided then USD will be returned as currency in invoice response.