send feedback

❮ Previous Next ❯

Payment processing

About Payment Processing

Payment Processing is used to equip companies with transaction, subscription, usage based billing, and any hybrid models. Using this feature allows for better flexibility and control over billing and revenue processes. Advanced Inventory provides a mobile app solution to facilitate the payment process through a hand held mobile device. The Advanced Inventory app is integrated to work with the NetSuite payment processing functions.

Functional Process

In NetSuite, Payment Processing is created based on criteria determined by the type of sale, customer requirements, product and/or service sold, billing schedule, transportation, and type of payment.

The following list defines the four main steps in the Payment Processing life cycle.

Invoice
Customer Payment
Credit Memo - if applicable
Refund - if applicable

Environment Considerations

To ensure optimal communication between the NetSuite interface and the Advanced Inventory app, refer to the following recommendations for the Payment Processing feature.

Customer Account information should be set up correctly.
A valid payment process should be defined. For more information, refer to the NetSuite WMS Advanced Setup Guide and view Payment Item and/or Invoice, as well as Customer Credits or Customer Refunds. Both areas will provide more in-depth information on customer billing and payment.

Process a payment function

The Payment Processing feature addresses the major functions that make up the entire payment life cycle.

The following steps provide a generic outline of the payment process from the Advanced Inventory app through the NetSuite interface.

The end user logs into the applicable Advanced Inventory App on a device.
The user enters or selects the order to fulfill.
The user selects the lines on the order to fulfill.

If the user does not select or deselect any lines or changes quantities, the process will assume all lines are to be fulfilled and the item fulfillment will match the base transaction upon NetSuite upload.
If a user deselects any item lines or changes quantities, the Item Fulfillment will be created based on the user's selection or input upon NetSuite upload.

The fulfillment data is saved/stored in the device.
The user is prompted to enter variables to create an invoice, credit memo, or refund.
The user selects variables to support the desired process.

For example, when creating a sales invoice, variables may include customer, project, start date, end date, due date, PO#, memo information, etc.
Another possible example could be when issuing a credit memo, variables may include customer, return authorization, return number, etc.

Payment/Credit Memo details are saved/stored within the device
Data is batched and transmitted to NetSuite through the Advanced Inventory NetSuite connectors.
NetSuite receives and uploads the data.
NetSuite fulfills the processing.

The user will receive an error message if the payment or credit is not processed correctly.

DSI Invoice record definitions

The following table provides the names and definitions for fields associated with the Payment Processing feature and Advanced Inventory Invoice.

invoice

Hierarchy

Parent record

None

Child record

None

Name	Internal ID	Type	Required	Help
Account	account	select	FALSE	Select the Accounts Receivable account that will be affected by this transaction. Select New to set up a new account. For details on accounts, go to List Account > Chart of Accounts.
Handling Cost	althandlingcost	currency	FALSE	The handling cost automatically calculates depending on the shipping method you select in the Ship Via field. To change the cost of handling, go to Lists > Shipping Items and select the shipping method with the handling cost you want to change.
Shipping Cost	altshippingcost	currency	FALSE	The shipping cost automatically calculates depending on the shipping method you select in the Ship Via field above. To change the cost of a shipping method, go to Lists > Shipping Items and select the shipping method you want to change. If you use UPS Real-Time rates, shipments over 150lbs are broken up into shipments less than or equal to 150lbs for charging.
Amount Paid	amountpaid	currency	FALSE	Displays the total amount paid for this invoice.
Amount Due	amountremaining	currency	FALSE	Displays the total amount due for this invoice.
Amount Due	amountremainingtotalbox	currency	FALSE
Approval Status	approvalstatus	select	FALSE
Balance	balance	currency	FALSE	Displays the total of all outstanding invoices for this customer.
Billing Address Line 1	billaddr1	text	FALSE
Billing Address Line 2	billaddr2	text	FALSE
Billing Address Line 3	billaddr3	text	FALSE
Bill To	billaddress	address	FALSE
Billing Addressee	billaddressee	text	FALSE
Bill To Select	billaddresslist	select	FALSE	Select the appropriate billing address for this transaction. * Select New to enter a new billing address to be used for this transaction and saved with the associated entity record. * Select Custom to enter a new billing address to be used for this transaction only (and not saved with the associated entity record). * Select the Edit icon to edit an existing billing address.
Billing Attention	billattention	text	FALSE
Billing Address City	billcity	text	FALSE
Billing Address Country	billcountry	text	FALSE
Billing Account	billingaccount	select	FALSE
	billingaddress	summary	FALSE
Shipping address is residential	billisresidential	text	FALSE
Billing Phone	billphone	text	FALSE
Billing Address State	billstate	text	FALSE
Billing Address Zip Code	billzip	text	FALSE
Class	class	select	FALSE
Consolidated Balance	consolidatebalance	currency	FALSE
Coupon Code	couponcode	select	FALSE
	createddate	datetime	FALSE
Created From	createdfrom	select	FALSE
Created From	createdfrom	select	FALSE	This field shows the sales order this invoice is created from. Select the link to open the sales order.
Currency	currency	select	TRUE	If you do not use the Multi-Currency Customers feature, the currency of the customer you are creating this transaction for is shown here. If you use the Multi-Currency Customers feature, select the transaction currency you want to create this transaction in. This customer's primary currency is selected by default. If you have already selected items on this transaction, selecting a new currency refreshes them to show the price in the new currency (except for items you entered custom prices for) and recalculates tax and gross profit.
Currency	currencyname	text	FALSE	This customer's currency is shown in this field. All currency amounts on this transaction are shown in this currency.
Currency Symbol	currencysymbol	text	FALSE
Custom Form	customform	select	TRUE	If you customized an invoice form, select it here, or click New to customize a new invoice form.
Deferred Revenue	deferredrevenue	currency	FALSE	Deferred Revenue: amount of revenue deferred on this transaction.
Department	department	select	FALSE
Disc. Amt.	discountamount	currency	FALSE	The amount listed here is the discount your customer will receive if he or she pays this invoice according to the terms you have set.
Disc. Date	discountdate	date	FALSE	The date listed here is the date your customer must pay this invoice by in order to receive a discount. The discount your customer receives is based on the terms you have set for the customer.
Discount	discountitem	select	FALSE	You can select a discount for this invoice. NetSuite fills the Rate and Discount Total fields based on the discount you choose. Leave this field blank if you do not want to apply a discount to this transaction. To create new discount items, go to List Item > Items and select New. On the New Item page, click Discount.
Rate	discountrate	rate	FALSE	NetSuite enters the rate for the discount item you selected. You can change the discount rate for this cash refund. Enter the discount as a dollar amount like 10.00, or as a percentage like 10%.
Discount	discounttotal	currency	FALSE	NetSuite enters the amount discounted on this invoice. If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes.
Due Date	duedate	date	FALSE	Type or pick the due date for this invoice. If you do not assign a due date, this invoice will not appear on aging reports.
	email	emails	FALSE
End Date	enddate	date	FALSE	Type or pick the end date for this invoice. If an invoice is created from a sales order that includes a Start Date and End Date, those dates autofill on the invoice when the order is billed.
Customer	entity	select	TRUE	Select the customer for this invoice. Select New to set up a new customer. Go to List > Customer Job > Customers for details about existing customers.
Nexus	entitynexus	select	FALSE
Est. Gross Profit	estgrossprofit	currency	FALSE	Estimated Gross Profit: Read-only field that equals the revenue amount minus the Est. Cost. At the transaction level, it equals the gross profit of all lines, factoring transaction-level discounts and markups.
Est. Gross Profit Percent	estgrossprofitpercent	percent	FALSE	Estimated Gross Profit Margin, as a percentage: Read-only field that equals the Est. Gross Profit divided by revenue, expressed as a percentage. At the transaction level, it equals the gross profit percent of all lines, factoring transaction-level discounts and markups.
Exchange Rate	exchangerate	currency2	TRUE	The currency's exchange rate is shown in this field. You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here.
Exclude Commissions	excludecommission	checkbox	FALSE	Check this option to exclude this transaction and its subordinate transactions from inclusion in all commission calculations.
Amount	expcostdiscamount	currency	FALSE	The rate you enter automatically appears here. If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select.
Discount/Markup	expcostdiscount	select	FALSE	If you want to add a discount or markup to the cost of the expenses you are billing, select it from the list. To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page. To create a new discount or markup, go to Lists > New Item and click Discount or Markup.
Print	expcostdiscprint	checkbox	FALSE	Check this box if you added a discount or markup and want to print it on the invoice.
Rate	expcostdiscrate	rate	FALSE	The rate for the discount or markup item you selected automatically appears here. If you want, enter a new rate. Rates can be entered as dollar amounts and percentages.
Taxable	expcostdisctaxable	checkbox	FALSE	Check this box if the expenses you are billing are taxable.
Tax Code	expcosttaxcode	select	FALSE
Tax Rate	expcosttaxrate1	percent	FALSE	NetSuite inserts the GST rate based on the tax code you assigned to this expense. To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes. To change the assignment of a tax code to an item, go to Lists > Items.
ExternalId	externalid	text	FALSE
FOB	Fob	text	FALSE	Enter the location where the customers technically acquire ownership. For example, if your customers own goods as soon as they ship and pay the shipping costs from your location to theirs, you might enter Our warehouse.
Gift Certificate	giftcertapplied	currency	FALSE
Handling Cost	handlingcost	currency	FALSE	The handling cost automatically calculates depending on the shipping method you select in the Ship Via field. To change the cost of handling, go to Lists > Shipping > Shipping Items and select the shipping method with the handling cost you want to change.
Handling Tax Rate	handlingtax1rate	text	FALSE	The tax rate for the tax code selected shows here.
Handling Tax Code	handlingtaxcode	select	FALSE	Select the tax code that determines the tax for handling charges.
Base Currency	isbasecurrency	checkbox	FALSE
Enable Item Line Shipping	ismultishipto	checkbox	FALSE
Taxable	istaxable	checkbox	FALSE
Amount	itemcostdiscamount	currency	FALSE	The rate you enter automatically appears here. If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select.
Discount/Markup	itemcostdiscount	select	FALSE	If you want to add a discount or markup to the cost of the items you are billing, select it from the list. To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page. To create a new discount or markup, go to Lists > New Item and select Discount or Markup.
Print	itemcostdiscprint	checkbox	FALSE	Check this box if you added a discount or markup and want to print it on the invoice.
Rate	itemcostdiscrate	rate	FALSE	The rate for the discount or markup item you selected automatically appears here. If you want, enter a new rate. Rates can be entered as dollar amounts and percentages.
Apply Before Tax	itemcostdisctaxable	checkbox	FALSE	Check this box if you want the discount or markup you entered to be applied before taxes.
Tax Code	itemcosttaxcode	select	FALSE
Tax Rate	itemcosttaxrate1	percent	FALSE	NetSuite inserts the GST rate based on the tax code you assigned to this item. To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes. To change the assignment of a tax code to an item, go to Lists > Items.
	lastmodifieddate	datetime	FALSE
Lead Source	leadsource	select	FALSE	Select the lead source associated with this transaction. If you use the Marketing Automation feature, select the campaign you want to associate with this transaction's revenue.
Tracking #	Linkedtrackingnumbers	text	FALSE
Location	location	select	TRUE
Memo	memo	text	FALSE
Customer Message	message	textarea	FALSE	The text of the customer message you select in the Select Message field appears here. You can edit the message or enter a new customer message for only this transaction.
Select Message	messagesel	select	FALSE	Select a customer message to appear on this form. For example, you may add "Thank you for your business!" Choose from the list of existing customer messages stored in Accounting Lists. The text of the selected message appears in the Customer Message field. In this field, you can optionally edit the message or enter a new customer message for only this transaction. To add messages to appear in the Select Message field, go to Lists > Accounting Lists > New, and select Customer Message.
Promo Code	Muccpromocodeinstance	text	FALSE
Next Approver	nextapprover	select	FALSE
Nexus	nexus	select	FALSE
Opportunity	opportunity	select	FALSE	If you are entering this transaction for an opportunity, select the opportunity. You can create opportunity records at Edit > Create Opportunities.
PO #	otherrefnum	text	FALSE	To make it easy for your customers to locate this invoice in their own records, enter their purchase order number here.
Partner	partner	select	FALSE	The partner associated with this customer appears in the Partner field. You can change the partner for this transaction.
Posting Period	postingperiod	select	TRUE	Select the period you want to post this invoice to. If a period is closed, you cannot post to that period.
Promotion	promocode	select	FALSE	If you want to apply a multiple-use coupon code to this transaction, select the promotion here. If you want to apply a single-use coupon code, enter the code in the Coupon Code field. The promotion for that coupon code is shown here. Customers associated with a partner can only use coupon codes from that partner's promotions. If you select a promotion associated with a partner, this transaction is attributed to that partner for reporting purposes. You can choose to have a promotion selected by default at Transactions > Campaign Setup > Marketing Preferences in the Default Promotion Code on Sales Transactions field. Create new promotion codes at Lists > Referral Code > Promotions > New.
Promo Code	promocodepluginimpl	text	FALSE
Recognized Revenue	recognizedrevenue	currency	FALSE	Recognized Revenue: cumulative amount of revenue recognized for this transaction.
Recurring Bill	recurringbill	checkbox	FALSE
Return Tracking #	Returntrackingnumbers	text	FALSE
Revenue Status	revenuestatus	text	FALSE	The possible values for this field are: 1. Pending: indicates that no recognition has occurred. All revenue is still deferred. 2. In Progress: indicates that some recognition has occurred. 3. Completed: indicates that all recognition has occurred. No deferred revenue remains.
Rev Rec on Rev Commit.	Revreconrevcommitment	checkbox	FALSE	Check this check box to create a Revenue Commitment or Revenue Commitment Reversal. * On a Sales Order, the Revenue Commitment replaces an invoice * On a Return Authorization, the Revenue Commitment Reversal replaces a credit memo. NetSuite creates all applicable Revenue Recognition schedules the Revenue Commitment or Revenue Commitment Reversal.
Sales Effective Date	saleseffectivedate	date	FALSE	You can change the sales effective date for this transaction. The sales effective date determines which commission plan and historical sales team this transaction applies to.
Choose Team	salesgroup	select	FALSE	Select a sales team to associate with this transaction. To create a sales team, go to Edit > Crm Group > New > Select Sales Team Members.
Sales Rep	salesrep	select	FALSE	NetSuite inserts the sales representative associated with this company on the customer record at Lists > Customers. If a different sales rep is assigned to this transaction, select that sales rep here. To add additional sales reps to this list, go to Lists > New Employee.
Shipping Address Line 1	shipaddr1	text	FALSE
Shipping Address Line 2	shipaddr2	text	FALSE
Shipping Address Line 3	shipaddr3	text	FALSE
Ship To	shipaddress	address	FALSE
Shipping Addressee	shipaddressee	text	FALSE
Ship To Select	shipaddresslist	select	FALSE	Select the appropriate shipping address for this transaction. * Select New to enter a new shipping address to be used for this transaction and saved with the associated entity record. * Select Custom to enter a new shipping address to be used for this transaction only (and not saved with the associated entity record). * Select the Edit icon to edit an existing shipping address.
Shipping Attention	shipattention	text	FALSE
Shipping Address City	shipcity	text	FALSE
Shipping Address Country	shipcountry	text	FALSE
Ship Date	shipdate	date	FALSE	Type or pick a shipping date for this invoice.
Shipping address is residential	shipisresidential	text	FALSE
Shipping Method	shipmethod	select	FALSE	Select a shipping method for this order. If you automatically charge for shipping, the shipping amount is entered in the shipping costs field. To automatically charge for shipping, go to Admin > Shipping. Check the Charge for Shipping box and select Save. You must also set up the charge details of your shipping items. To add or edit shipping items, go to Lists > Ship > Shipping Items.
	shipoverride	text	FALSE
Shipping Phone	shipphone	text	FALSE
	shippingaddress	summary	FALSE
Shipping Cost	shippingcost	currency	FALSE	The shipping cost automatically calculates depending on the shipping method you select in the Ship Via field above. To change the cost of a shipping method, go to Lists > Shipping > Shipping Items and select the shipping method you want to change. If you use UPS Real-Time rates, shipments over 150lbs are broken up into shipments less than or equal to 150lbs for charging.
Shipping Cost Overridden	Shippingcostoverridden	text	FALSE
Shipping Tax Rate	shippingtax1rate	text	The tax rate for the selected tax code shows here.
Shipping Tax Code	shippingtaxcode	select	FALSE	Select the tax code that determines the tax charged for shipping.
Shipping Address State	shipstate	text	FALSE
Shipping Address Zip Code	shipzip	text	FALSE
Source	source	text	FALSE
Start Date	startdate	date	FALSE	If you use the Advanced Billing feature, enter the date for the first invoice to be created. If an invoice is created from a sales order that includes a Start Date and End Date, those dates autofill on the invoice when the order is billed.
Status	status	text	FALSE
	statusRef	text	FALSE
Subsidiary	subsidiary	select	FALSE	This field displays the subsidiary associated with this transaction.
Subtotal	subtotal	currency	FALSE	This field shows the total of the items on this invoice. This is the total before any discounts, shipping cost, handling cost or tax is added to the order.
Update Customer	syncpartnerteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Update Customer	syncsalesteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Tax	taxitem	select	FALSE	A tax item is a tax that you collect at one certain rate and pay to one tax agency for this invoice. NetSuite inserts the tax item for this customer from the record at Lists > Customers. To change it just for this order, select another tax item. To add additional choices to this list, go to Lists > New Item > Sales Tax Item.
Tax %	taxrate	float	FALSE	NetSuite inserts the percentage rate of the tax item from its record at Lists > Items. You can change it here for just this transaction if you wish.
Tax Total	taxtotal	currency	FALSE	NetSuite multiplies the tax rate by the taxable total of line items and enters it here.
Terms	terms	select	FALSE	Select discount terms that will apply to this invoice. To add additional choices to this list, go to Lists > Accounting > Accounting Lists > New > Terms.
Amount	timediscamount	currency	FALSE	The rate you enter automatically appears here. If you entered a percentage in the Rate field, NetSuite multiplies the discount or markup percentage by the total amount of line items you select.
Discount/Markup	timediscount	select	FALSE	If you want to add a discount or markup to the cost of the time you are billing, select it from the list. To see a list of your discounts or markups, go to Lists > Items and select Discount or Markup from the dropdown list at the bottom of the page. To create a new discount or markup, go to Lists > New Item and select Discount or Markup.
Print	timediscprint	checkbox	FALSE	Check this box if you added a discount or markup and want to print it on the invoice.
Rate	timediscrate	rate	FALSE	The rate for the discount or markup item you selected automatically appears here. If you want, enter a new rate. Rates can be entered as dollar amounts and percentages.
Apply Before Tax	timedisctaxable	checkbox	FALSE	Check this box if you want the discount or markup you entered to be applied before taxes.
Tax Code	timetaxcode	select	FALSE
Tax Rate	timetaxrate1	percent	FALSE	NetSuite inserts the GST rate based on the tax code you assigned to this time. To set up tax codes and corresponding tax percentages, go to Lists > Tax Codes. To change the assignment of a tax code to an item, go to Lists > Items.
To Be E-mailed	tobeemailed	checkbox	FALSE	When processing individual invoices: * Check the To Be Emailed box if you want to email this invoice. Then enter the email address in the space to the right of the check box. * You can enter multiple email addresses by separating them with a semicolon. It is important to separate the addresses with only a semicolon, and do not include any spaces. When bulk processing invoices: In the To Be Emailed field: * Select Yes if you want to email this form. * Select No if you do not want to email this form. * Select Respect Customer Preference to send the form based on the default preference on the customer record. Set the preference on the Info subtab of a customer record in the Send Transactions Via field.
To Be Faxed	tobefaxed	checkbox	FALSE	When processing individual invoices: * Check the To Be Faxed box if you want to fax this invoice. Then enter the fax number in the box to the right of the check box if it does not already appear. When bulk processing invoices: In the To Be Faxed field: * Select Yes if you want to fax this form. * Select No if you do not want to fax this form. * Select Respect Customer Preference to send the form based on the default preference on the customer record. Set the preference on the Info subtab of a customer record in the Send Transactions Via field. To fax NetSuite forms, an administrator must first set up fax service at Admin > Printing, Fax, and Email Preferences.
To Be Printed	tobeprinted	checkbox	FALSE	When processing individual invoices: Check the To Be Printed box if you want to print this invoice. When bulk processing invoices: * Select Yes if you want to save this in a queue of invoices to print. * Select No if you do not want to print this form. * Select Respect Customer Preference to send the form based on the default preference on the customer record. Set the preference on the Info subtab of a customer record in the Send Transactions Via field.
Total	total	currency	FALSE	NetSuite computes the total of line items, tax and shipping costs, and then enters it here.
Est. Extended Cost	totalcostestimate	currency	FALSE	Estimated Cost: Estimated cost of the specific number of items; estimated rate x quantity = estimated cost.
Additional Tracking #	trackingnumbers	text	FALSE	Enter the shipment tracking number from the shipping company. If a tracking number is entered in the exact format used by UPS or FedEx and the transaction is saved, the tracking number will show on the transaction as a link to the UPS or FedEx website. You can select the link to check the status of the shipment.
Date	trandate	date	TRUE	NetSuite inserts today's date for the posting date of this invoice. You can type or pick another date. What you enter here determines the date range in which this transaction appears on the Accounts Receivable Register. You can select or enter custom date ranges on registers.
Invoice #	tranid	text	FALSE	NetSuite increases the largest invoice number by one. You can type another number. The next invoice number will revert to the standard pattern.
Transaction Is VSOE Bundle	tranisvsoebundle	checkbox	FALSE	Check this box to include all items added to this transaction as a VSOE bundle.
Unbilled Orders	unbilledorders	currency	FALSE
Auto Calculate VSOE Allocation	vsoeautocalc	checkbox	FALSE	The VSOE allocation amount for a sale can be calculated automatically by checking the Auto Calculate VSOE Allocation box. Allocation is the process to determine the VSOE price for items on a sale. The total VSOE amount allocated is the revenue amount to be recognized for the bundle.

DSI Customer Payment record definitions

The following table provides the names and definitions for fields associated with the Payment Processing feature and Advanced Inventory Customer Payment.

customerpayment

Hierarchy

Parent record

None

Child record

None

Name	Internal ID	Type	Required	Help
	account	select	FALSE	Click the button to the left and then select the account where you want to deposit the amount received. For example, an approved credit card payment might go directly into your checking account, but an unapproved payment would go into the non-posting account specifically for unapproved payments.
Credits	allowemptycards	checkbox	FALSE
Applied	applied	currency	FALSE	NetSuite keeps track of the total applied payments here. You can apply payments by placing or clearing check marks in the Apply column next to the appropriate invoices at the bottom of the page. If you want, you can change dollar amounts in the Payment column next to these invoices. When you do this, the Applied field automatically updates.
A/R Account	aracct	select	FALSE	Select the Accounts Receivable account that will be affected by this transaction. Click > New to set up a new account.
Auth. Code	authcode	text	FALSE	If you have a NetSuite merchant account, then this field autofills with the authorization code as soon as the charge is approved. If you do not have a NetSuite merchant account, enter the authorization code you receive when the charge to the customer's credit card is validated outside of NetSuite, such as by a card-swipe terminal.
Auto Apply	autoapply	checkbox	FALSE	Check this box to automatically apply payments to the oldest open receivable. If you clear this box, the payment amount defaults to unapplied and you must later apply the payment amount to an open receivable. Note: When you enter a customer payment and check the Auto Apply box, only the payment you enter on the transaction is applied. Other existing credits and deposits are not automatically applied against open receivables. Once you check or uncheck the Auto Apply box on a payment and save it, the box retains the setting the next time you enter a payment.
Balance	balance	currency	FALSE	NetSuite shows you the balance in this customer account.
CC Approved	ccapproved	checkbox	FALSE	Place a check mark in this box only after the credit card charge has been validated outside NetSuite, such as by a card-swipe terminal. If you have a Internet Merchant Solutions (IMS) merchant account, then this field is automatically filled as soon as the charge is approved.
AVS Street Match	ccavsstreetmatch	select	FALSE	This field shows the AVS result code that is returned from Verisign when a credit card transaction takes place. The codes returned could be: Y - The address information submitted did match. N - The address information submitted did not match.
Expires (MM/YYYY)	ccexpiredate	ccexpdate	FALSE	Enter the credit card's expiration date using this format: MM/YYYY.
Detail	Cchold	text	FALSE
Detail	ccholdetails	textarea	FALSE
IAVS Match	cciavsmatch	select	FALSE
Purchase Card BIN	ccispurchasecardbin	checkbox	FALSE	This box is marked when NetSuite determines that the credit card entered is a purchase card. If you use the Send Purchase Card Data feature and the Process as Purchase Card box is also checked, this credit card payment will be processed by NetSuite as a purchase card. Contact your NetSuite account representative for more information.
Name on Card	ccname	text	FALSE	NetSuite enters the cardholder name from the default credit card on the customer's record. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Financial subtab of the customer's record, verify that the Cardholder Name field contains the correct information.
Credit Card #	ccnumber	ccnumber	FALSE	If payment is by credit card, enter the card number here. Enter numbers only, without spaces. NetSuite is a secure site. If a NetSuite merchant gives a customer access to view payment information, only that merchant and that customer will be able to see this number.
Credit Card Processing Profile	ccprocessoraccount	text	FALSE
CSC	ccsecuritycode	text	FALSE	Enter the three digit code found on the back of Visa, MasterCard, and Discover cards; for American Express cards, enter the four digit code found on the front of the card.
CSC Match	ccsecuritycodematch	select	FALSE	This field shows the Card Security Code (CSC) result code returned to VeriSign when a credit card transaction takes place. The possible codes are: 1. Y: The code submitted did match. 2. N: The code submitted did not match. 3. X: The credit card company does not support CSC, or no information was returned to VeriSign.
Card Street	ccstreet	text	FALSE	NetSuite enters the street address from the customer's billing address. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Address subtab of the customer's record, make sure the default billing address contains the correct street address.
Card Zip Code	cczipcode	text	FALSE	NetSuite enters the zip or postal code from the customer's billing address. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Address subtab of the customer's record, make sure the default billing address contains the correct zip or postal code.
Charge Credit Card	chargeit	checkbox	FALSE	Check this box to make this payment by charging the credit card chosen in the Credit Card Select field.
Check #	checknum	text	FALSE	If payment is by check, enter the check number here. It will appear on reports such as the 2-line Undeposited Funds register.
Class	class	select	FALSE	Select a class to associate with this transaction. To create a new class, select New. For details on existing classes, go to Lists > Classes.
Consolidated Balance	consolidatebalance	currency	FALSE
	createddate	datetime	FALSE
Credit Card Select	creditcard	select	FALSE	Select a credit card stored on the customer record to use as the payment method. Click New to enter a new credit card.
Credit Card Processor	creditcardprocessor	select	FALSE	Select the credit card processor you want to use for this transaction. You can set up credit card processors at Admin > Set Up Credit Card Processing.
Currency	currency	select	TRUE
Currency	currencyname	text	FALSE	This customer's currency is shown in this field. All currency amounts on this transaction are shown in this currency.
Currency Symbol	currencysymbol	text	FALSE
Customer	customer	select	TRUE	Select the customer. If you use projects, select the appropriate project rather than the master customer account. Go to Lists > Customers for details about existing customers and projects.
Customer Code	customercode	text	FALSE
Custom Form	customform	select	TRUE
Issue No.	debitcardissueno	text	FALSE	If the card is a debit card, enter the card's issue number.
Department	department	select	FALSE	Select a department to associate with this transaction. To create a new department, select New. For details on existing departments, go to Lists > Departments.
Nexus	entitynexus	select	FALSE
Exchange Rate	exchangerate	currency2	TRUE	The currency's exchange rate is shown in this field. You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here.
ExternalId	externalid	text	FALSE
Ignore AVS	ignoreavs	checkbox	FALSE	Check the Ignore AVS box to ignore the results of the Address Verification System (AVS) pre-authorization check. If you choose to ignore the AVS check, when a customer's address information does not match the billing address of the credit card account, then Cybersource still processes the payment.
Ignore CSC	ignorecsc	checkbox	FALSE
	inputpnrefnum	text	FALSE
Base Currency	isbasecurrency	checkbox	FALSE
Override Hold	ispurchasecard	text	FALSE
Recurring Payment	isrecurringpayment	checkbox	FALSE	This box is checked if this payment was created for a recurring cash sale. Payments marked as recurring can be successfully processed even if the credit card expires during the billing schedule. You should not check this box for standalone payments. You should only check this box for transactions with recurring payments. It can be used for cash sale sales orders with billing schedules or memorizes cash sale sales orders.
	lastmodifieddate	datetime	FALSE
Location	location	select	FALSE	Select a location to associate with this transaction. To create a new location, select New. For details on existing locations, go to Lists > Locations.
Memo	memo	text	FALSE	If you wish, enter a memo to describe this payment. It will appear on reports such as the 2-line Accounts Receivable register that NetSuite merchants and their guest-customers can see (if given permission to log in and view their transaction history).
Nexus	nexus	select	FALSE
Override Hold	overridehold	checkbox	FALSE
Override Hold	overrideholdchecked	checkbox	FALSE
Payment Amount	payment	poscurrency	TRUE	Enter the currency amount of the payment here.
Override Hold	paymenteventdate	datetime	FALSE
Reason	paymenteventholdreason	select	FALSE
Override Hold	Paymenteventpurchasedatasent	text	FALSE
Status	paymenteventresult	select	FALSE
Override Hold	paymenteventtype	text	FALSE
Override Hold	paymenteventupdatedby	text	FALSE
Payment Method	paymentmethod	select	FALSE	Select the payment method for this payment. To add additional choices to this list, go to Lists > Accounting Lists > New > Payment Method.
Pending	pending	currency	FALSE	If your customer has unapproved credit card payments, NetSuite automatically fills in the sum amount of these payments here. If you validate credit card payments outside of NetSuite, these payments will be pending until they are approved. Once payments are approved, check the Card Approved box.
P/N Ref.	pnrefnum	text	FALSE	If you accept credit card payments, the Verisign authentication code appears here once the payment is approved.
Posting Period	postingperiod	select	FALSE	Select the period you want to post this payment to. If a period is closed, you cannot post to that period.
Soft Descriptor	softdescriptor	text	FALSE
Status	status	text	FALSE
	statusRef	text	FALSE
Subsidiary	subsidiary	select	FALSE	This field shows the subsidiary associated with this transaction.
Payer Authentication Status	threedstatuscode	text	FALSE
	tobeemailed	checkbox	FALSE
To Apply	total	currency	FALSE
Date	trandate	date	TRUE	NetSuite inserts today's date for the posting date of this payment. You can enter or select another date. What you enter here determines the date range in which this transaction appears on the Accounts Receivable Register.
Payment #	tranid	text	FALSE	This is the document number automatically generated for the transaction by NetSuite.
Unapplied	unapplied	currency	FALSE	NetSuite shows the difference between amounts available to apply to payments and payments you have actually applied. To make this equal to 0.00, you can (1) change the Payment Amount above, (2) check the Apply Existing Credits check box above, or (3) change Payment amounts below.
Undep. Funds	undepfunds	radio	FALSE	If you are entering a payment that will be deposited to a bank account later, click Undep. Funds. If you are entering a payment that has already been deposited, click Account and select the bank account.
Valid From / Start Date (MM/YYYY)	validfrom	ccvalidfrom	FALSE	Enter the date when this card first became valid.

DSI Cash Refund record definitions

The following table provides the names and definitions for fields associated with the Payment Processing feature and Advanced Inventory Cash Refund.

cashrefund

Hierarchy:

Parent record

None

Child record

None

Name	Internal ID	Type	Required	Help
Account	account	select	FALSE	Select the cash or bank account from which you are refunding this money.
Credits	allowemptycards	checkbox	FALSE
Handling Cost	althandlingcost	currency	FALSE	This is the amount the customer was charged for handling.
Shipping Cost	altshippingcost	currency	FALSE	This is the amount the customer was charged for shipping.
			FALSE
Billing Address Line 2	billaddr1	text	FALSE
Billing Address Line 1	billaddr2	text	FALSE
Billing Address Line 3	billaddr3	text	FALSE
Bill To	billaddress	address	FALSE
Billing Addressee	billaddressee	text	FALSE
Bill To Select	billaddresslist	select	FALSE	Select the appropriate billing address for this transaction. Select New to enter a new billing address.
Billing Attention	billattention	text	FALSE
Billing Address City	billcity	text	FALSE
Billing Address Country	billcountry	text	FALSE
	billingaddress	summary	FALSE
Shipping address is residential	billisresidential	text	FALSE
Billing Phone	billphone	text	FALSE
Billing Address State	billstate	text	FALSE
Billing Address Zip Code	billzip	text	FALSE
Credit Card Approved	ccapproved	checkbox	FALSE	Place a check mark in this box only if the credit card transaction has been performed outside NetSuite, such as by a card-swipe terminal. If you have a NetSuite merchant account, then this field is automatically filled as soon as the transaction is approved.
Expires (MM/YYYY)	ccexpiredate	ccexpdate	FALSE	Enter the credit card's expiration date using this format: MM/YYYY.
Detail	cchold	text	FALSE
Detail	ccholdetails	textarea	FALSE
Purchase Card BIN	ccispurchasecardbin	checkbox	FALSE	If you use the Send Purchase Card Data feature, this box is marked when NetSuite determines that the credit card entered is a purchase card. If the Process as Purchase Card box is also checked, this credit card payment will be processed by NetSuite as a purchase card. Contact your NetSuite account representative for more information.
Name on Card	ccname	text	FALSE	NetSuite enters the cardholder name from the default credit card on the customer's record. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Financial subtab of the customer's record, verify that the Cardholder Name field contains the correct information.
Credit Card #	ccnumber	ccnumber	FALSE	If refund is by credit card, enter the card number here. Enter numbers only, without spaces. NetSuite is a secure site. If a NetSuite merchant gives a customer access to view payment information, only that merchant and that customer will be able to see this number.
Credit Card Processing Profile	ccprocessoraccount	text	FALSE
Card Street	ccstreet	text	FALSE	NetSuite enters the street address from the customer's billing address. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Address subtab of the customer's record, make sure the default billing address contains the correct street address.
Card Zip Code	cczipcode	text	FALSE	NetSuite enters the zip or postal code from the customer's billing address. If the field contains no value or the wrong value, check the customer's record at Lists > Customers. On the Address subtab of the customer's record, make sure the default billing address contains the correct zip or postal code.
Process Credit Card	chargeit	checkbox	FALSE	If refund is by credit card, place a check mark in this box to process the credit to the customer's charge account over the Internet. You must have previously set up a NetSuite merchant account for this to work.
Class	class	select	FALSE
Coupon Code	couponcode	select	FALSE
	createddate	datetime	FALSE
Created From	createdfrom	select	FALSE	This field shows the return Authorization this refund is created from. Click the link to open the return authorization.
Credit Card Select	creditcard	select	FALSE	Select a credit card stored on the customer record to use as the method to refund this payment. Click New to enter a new credit card.
Credit Card Processor	creditcardprocessor	select	FALSE	Select the credit card processor you want to use for this transaction. You can set up credit card processors at Admin > Set Up Credit Card Processing.
Currency	currency	select	TRUE	If you do not use the Multi-Currency Customers feature, the currency of the customer you are creating this transaction for is shown here. If you use the Multi-Currency Customers feature, select the transaction currency you want to create this transaction in. This customer's primary currency is selected by default. If you have already selected items on this transaction, selecting a new currency refreshes them to show the price in the new currency (except for items you entered custom prices for) and recalculates tax and gross profit.
Currency	currencyname	text	FALSE	This customer's currency is shown in this field. All currency amounts on this transaction are shown in this currency.
Currency Symbol	currencysymbol	text	FALSE
Customer Code	customercode	text	FALSE
Custom Form	customform	select	TRUE	If you customized a cash refund form, select it here, or click New to customize a new cash refund form.
Issue No.	debitcardissueno	text	FALSE	If the card is a debit card, enter the card's issue number.
Deferred Revenue	deferredrevenue	currency	FALSE	Deferred Revenue: amount of revenue deferred on this transaction.
Department	department	select	FALSE
Discount	discountitem	select	FALSE	You can select a discount for this cash refund if one was used on the original sale. NetSuite fills the Rate and Discount Total fields based on the discount you choose. Leave this field blank if you do not want to apply a discount to this transaction. For details on existing discount items, go to Lists > Items and select Discount in the type field in the footer. To create new discount items, go to Edit > Items > New and click Discount.
Rate	discountrate	rate	FALSE	NetSuite enters the rate for the discount item you selected. You can change the discount rate for this cash refund. Enter the discount as a dollar amount like 10.00, or as a percentage like 10%.
Discount	discounttotal	currency	FALSE	NetSuite enters the amount discounted on this cash refund. If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes.
	email	emails	FALSE
Customer	entity	select	TRUE	Select the customer for this refund. If you are using jobs, select the appropriate job rather than the master customer account. To create a new customer record, select New. For details on existing customers and projects, go to Lists > Customers.
Nexus	entitynexus	select	FALSE
Est. Gross Profit	estgrossprofit	currency	FALSE	Estimated Gross Profit is a read-only field that equals the revenue amount minus the Est. Cost. At the transaction level, it equals the gross profit of all lines, factoring transaction-level discounts and markups.
Est. Gross Profit Percent	estgrossprofitpercent	percent	FALSE	Estimated Gross Profit Margin, as a percentage: Read-only field that equals the Est. Gross Profit divided by revenue, expressed as a percentage. At the transaction level, it equals the gross profit percent of all lines, factoring transaction-level discounts and markups.
Exchange Rate	exchangerate	currency2	TRUE	The currency's exchange rate is shown in this field. You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here.
Exclude Commissions	excludecommission	checkbox	FALSE	Check this option to exclude this transaction and its subordinate transactions from inclusion in all commission calculations.
ExternalId	externalid	text	FALSE
Handling Cost	handlingcost	currency	FALSE	Enter the amount the customer was charged for handling.
Tax Rate	handlingtax1rate	text	FALSE	The tax rate for this tax code is shown here.
Handling Tax Code	handlingtaxcode	select	FALSE	Select the tax code that determines the tax for handling charges.
	inputpnrefnum	text	FALSE
Base Currency	isbasecurrency	checkbox	FALSE
Override Hold	ispurchasecard	text	FALSE
Taxable	istaxable	checkbox	FALSE
	lastmodifieddate	datetime	FALSE
Lead Source	leadsource	select	FALSE	Select the lead source this transaction is associated with. If you use the Marketing Automation feature, your list of lead sources is your list of campaigns. If you do not use Marketing Automation, you can create new lead sources at Lists > CRM Lists > New > Lead Source.
Location	location	select	TRUE
Memo	memo	text	FALSE	If you wish, enter a memo to describe this cash refund. It will appear on reports such as the 2-line Undeposited Funds register.
Customer Message	message	textarea	FALSE	Edit the message you selected in the Select Message field, or enter a new message here. If you choose to print, email or fax this transaction to the customer, this message shows on the transaction.
Promo Code	muccpromocodeinstance	text	FALSE
Nexus	nexus	select	FALSE
Check #	otherrefnum	text	FALSE	If required, enter the customer's original check number.
Override Hold	overridehold	checkbox	FALSE
Override Hold	overrideholdchecked	checkbox	FALSE
Partner	partner	select	FALSE	The partner associated with this customer appears in the Partner field. You can change the partner for this transaction.
Override Hold	paymenteventdate	datetime	FALSE
Reason	paymenteventholdreason	select	FALSE
Override Hold	paymenteventpurchasedatasent	text	FALSE
Status	paymenteventresult	select	FALSE
Override Hold	paymenteventtype	text	FALSE
Override Hold	paymenteventupdatedby	text	FALSE
Payment Method	paymentmethod	select	FALSE	Enter the customer's original payment method.
Authorization ID	paypalauthid	text	FALSE
Process PayPal Payment	paypalprocess	checkbox	FALSE
PayPal Status	paypalstatus	text	FALSE
PayPal Tran. ID	paypaltranid	text	FALSE
P/N Ref.	pnrefnum	text	FALSE	If you accept credit card payments, the Verisign authentication code appears here once the payment is approved.
Posting Period	postingperiod	select	TRUE	Select the period you want to post this refund to. If a period is closed, you cannot post to that period.
Promotion	promocode	select	FALSE	Select a promotion code to apply to this transaction. Customers associated with a partner can only use that partner's promotion codes. If you select a promotion code associated with a partner, this transaction is attributed to that partner for reporting purposes. Create new promotion codes at Edit > Promotion Codes > New.
Promo Code	promocodepluginimpl	text	FALSE
Recognized Revenue	recognizedrevenue	currency	FALSE	Recognized Revenue: cumulative amount of revenue recognized for this transaction.
Create Check	refundcheck	checkbox	FALSE	Place a check mark in the box after Create Check if you wish to refund money by check. Clear this box if you want to issue a cash or credit card refund.
Revenue Status	revenuestatus	text	FALSE	The possible values for this field are: 1. Pending: indicates that no recognition has occurred. All revenue is still deferred. 2. In Progress: indicates that some recognition has occurred. 3. Completed: indicates that all recognition has occurred. No deferred revenue remains.
Rev Rec on Rev Commit.	revreconrevcommitment	checkbox	FALSE	Check this check box to create a Revenue Commitment or Revenue Commitment Reversal. * On a Sales Order, the Revenue Commitment replaces an invoice * On a Return Authorization, the Revenue Commitment Reversal replaces a credit memo. NetSuite creates all applicable Revenue Recognition schedules the Revenue Commitment or Revenue Commitment Reversal.
Sales Effective Date	saleseffectivedate	date	FALSE	You can change the sales effective date for this transaction. The sales effective date determines which commission plan and historical sales team this transaction applies to. If this return is created from a sales transaction, the sales effective date from the sale shown in the Created From field is set by default for this refund.
Choose Team	salesgroup	select	FALSE
Sales Rep	salesrep	select	FALSE	NetSuite inserts the sales representative associated with this company on the customer record at Lists > Customers. If a different sales rep is assigned to this refund, select that sales rep here. To add additional sales reps to this list, go to Edit > Employees > New.
Shipping Address Line 1	shipaddr1	text	FALSE
Shipping Address Line 2	shipaddr2	text	FALSE
Shipping Address Line 3	shipaddr3	text	FALSE
Ship To	shipaddress	address	FALSE
Shipping Addressee	shipaddressee	text	FALSE
Ship To Select	shipaddresslist	select	FALSE
Shipping Attention	shipattention	text	FALSE
Shipping Address City	shipcity	text	FALSE
Shipping Address Country	shipcountry	text	FALSE
Shipping address is residential	shipisresidential	text	FALSE
Ship Via	shipmethod	select	FALSE	Enter the method used to ship this order to the customer.
	shipoverride	text	FALSE
Shipping Phone	shipphone	text	FALSE
	shippingaddress	summary	FALSE
Shipping Cost	shippingcost	currency	FALSE	Enter the amount the customer was charged for shipping.
Shipping Cost Overridden	shippingcostoverridden	text	FALSE
Tax Rate	shippingtax1rate	text	FALSE	The tax rate for this tax code is shown here.
Shipping Tax Code	shippingtaxcode	select	FALSE	Select the tax code that determines the tax charged for shipping.
Shipping Address State	shipstate	text	FALSE
Shipping Address Zip Code	shipzip	text	FALSE
Soft Descriptor	softdescriptor	text	FALSE
Source	source	text	FALSE
Subsidiary	subsidiary	select	FALSE
Subtotal	subtotal	currency	FALSE	This field shows the subtotal of the items on this cash refund. This is the total before discounts, shipping costs, handling costs or taxes are added to the refund.
Update Customer	syncpartnerteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Update Customer	syncsalesteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Tax	taxitem	select	FALSE	A tax item is a tax that you collect at one certain rate and pay to one tax agency for this sale. NetSuite inserts the tax item for this customer from the record at Lists > Customers. To change it just for this refund, select another tax item. To add additional choices to this list, go to Lists > New Item > Sales Tax Item.
Tax %	taxrate	float	FALSE	NetSuite inserts the percentage rate of the tax item from its record at Lists > Items. You can change it here for just this transaction if you wish.
Tax Total	taxtotal	currency	FALSE	NetSuite multiplies the tax rate by the taxable total of line items and enters it here.
To Be E-mailed	tobeemailed	checkbox	FALSE	Check this box if you want to e-mail this cash refund form. Then, enter the e-mail address in the space to the right of the check box. You can enter multiple e-mail addresses by separating them with semicolons. It is important to separate the addresses with only semicolons, and do not include any spaces.
To Be Faxed	tobefaxed	checkbox	FALSE	Check this box if you want to fax this cash sale refund. Enter the fax number in the space to the right of the check box if it doesn't already appear. To fax NetSuite forms, an administrator must first set up fax service at Admin > Printing, Fax and E-mail Preferences.
To Be Printed	tobeprinted	checkbox	FALSE	Check this box if you wish to save this in a queue of cash refund forms to print. Otherwise, you can click Print below to submit and print this form at once.
Print Check	toprint2	checkbox	FALSE	Place a check mark in the box after Print Check if you are creating a check and if you wish to print that check.
Total	total	currency	FALSE	NetSuite computes the total of line items and tax, and then enters it here.
Est. Extended Cost	totalcostestimate	currency	FALSE	The estimated cost of the specific number of items. This is calculated as: estimated rate x quantity = estimated cost.
Date	trandate	date	TRUE	NetSuite inserts today's date for the posting date of this cash refund. You can type or pick another date. What you enter here determines the date range in which this transaction appears in the A/R and A/P registers. You can select or enter custom date ranges on registers.
Refund #	tranid	text	FALSE	NetSuite increases the largest refund number by one. If you wish, you can type another number. The next refund number will revert to the standard pattern. You can enter a maximum of 45 characters in this field.
Transaction Is VSOE Bundle	tranisvsoebundle	checkbox	FALSE	Check this box to include all items added to this transaction as a VSOE bundle.
Valid From / Start Date (MM/YYYY)	validfrom	ccvalidfrom	FALSE	Enter the date when this card first became valid. Use the format MM/YYYY.
Auto Calculate VSOE Allocation	vsoeautocalc	checkbox	FALSE	The VSOE allocation amount can be calculated automatically by checking the Auto Calculate VSOE Allocation box. Allocation is the process to determine the VSOE price for items. The total VSOE amount allocated is the revenue amount to be recognized for the bundle.

DSI Credit Memo record definitions

The following table provides the names and definitions for fields associated with the Payment Processing feature and Advanced Inventory Credit Memo.

creditmemo

Hierarchy:

Parent record

None

Child record

None

Name	Internal ID	Type	Required	Help
Account	account	select	FALSE	Select the Accounts Receivable account that will be affected by this transaction. Click New to set up a new account.
Handling Cost	althandlingcost	currency	FALSE	The handling cost automatically calculates depending on the shipping method you select in the Ship Via field. To change the cost of handling, go to Lists > Shipping Items and select the shipping method with the handling cost you want to change.
Shipping Cost	altshippingcost	currency	FALSE	The shipping cost automatically calculates depending on the shipping method you select in the Ship Via field above. To change the cost of a shipping method, go to Lists > Shipping Items and select the shipping method you want to change. If you use UPS Real-Time rates, shipments over 150lbs are broken up into shipments less than or equal to 150lbs for charging.
Amount Used	amountpaid	currency	FALSE
Amount Remaining	amountpaid	currency	FALSE
Amount Remaining	amountremaining	currency	FALSE
Applied	applied	currency	FALSE	NetSuite displays the amount of credit you applied below.
Auto Apply	autoapply	checkbox	FALSE	Check this box to automatically apply credit to the oldest open receivable. If you clear this box, the credit amount defaults to unapplied and you must later apply the credit amount to an open receivable. Once you check or uncheck the Auto Apply box on a credit memo and save it, the box retains the setting the next time you enter a credit memo.
Balance	balance	currency	FALSE
Billing Address Line 1	billaddr1	text	FALSE
Billing Address Line 2	billaddr2	text	FALSE
Billing Address Line 3	billaddr3	text	FALSE
Bill To	billaddress	address	FALSE
Billing Addressee	billaddressee	text	FALSE
Bill To Select	billaddresslist	select	FALSE	Select the appropriate billing address for this transaction. Select New to enter a new billing address.
Billing Attention	billattention	text	FALSE
Billing Address City	billcity	text	FALSE
Billing Address Country	billcountry	text	FALSE
	billingaddress	summary	FALSE
Shipping address is residential	billisresidential	text	FALSE
Billing Phone	billphone	text	FALSE
Billing Address State	billstate	text	FALSE
Billing Address Zip Code	billzip	text	FALSE
Class	class	select	FALSE
Consolidated Balance	consolidatebalance	currency	FALSE
Coupon Code	couponcode	select	FALSE
	createddate	datetime	FALSE
Created From	createdfrom	select	FALSE
Currency	currency	select	TRUE
Currency	currencyname	text	FALSE	This customer's currency is shown in this field. All currency amounts on this transaction are shown in this currency.
Currency Symbol	currencysymbol	text	FALSE
Custom Form	customform	select	TRUE	If you customized a credit memo form, select it here, or click New to customize a new credit memo form.
Deferred Revenue	deferredrevenue	currency	FALSE	Deferred Revenue: amount of revenue deferred on this transaction.
Department	department	select	FALSE
Discount	discountitem	select	FALSE	You can select a discount for this credit memo if one was applied to the original sale. NetSuite fills the Rate and Discount Total fields based on the discount you choose. Leave this field blank if you do not want to apply a discount to this transaction.
Rate	discountrate	rate	FALSE	NetSuite enters the rate for the discount item you selected. You can change the discount rate for this cash refund. Enter the discount as a dollar amount like 10.00, or as a percentage like 10%.
Discount	discounttotal	currency	FALSE	NetSuite enters the amount discounted on this credit memo. If this discount item is taxable, the discount is applied before taxes. If it is not taxable, the discount is applied after taxes.
	email	emails	FALSE
Customer	entity	select	TRUE	Select the customer for this credit. If you are using projects, select the appropriate project rather than the master customer account. To create a new customer record, select New. For details on existing customers and projects, go to Lists > Customers.
Nexus	entitynexus	select	FALSE
Est. Gross Profit	estgrossprofit	currency	FALSE	Estimated Gross Profit: Read-only field that equals the revenue amount minus the Est. Cost. At the transaction level, it equals the gross profit of all lines, factoring transaction-level discounts and markups.
Est. Gross Profit Percent	estgrossprofitpercent	percent	FALSE	Estimated Gross Profit Margin, as a percentage: Read-only field that equals the Est. Gross Profit divided by revenue, expressed as a percentage. At the transaction level, it equals the gross profit percent of all lines, factoring transaction-level discounts and markups.
Exchange Rate	exchangerate	currency2	FALSE	The currency's exchange rate is shown in this field. You can edit the exchange rate for this transaction only, or you can update the currency record with the exchange rate you enter here.
Exclude Commissions	excludecommission	checkbox	TRUE	Check this option to exclude this transaction and its subordinate transactions from inclusion in all commission calculations.
ExternalId	externalid	text	FALSE
Handling Cost	handlingcost	currency	FALSE	Enter the amount the customer was charged for handling.
Handling Tax Rate	handlingtax1rate	text	FALSE	The tax rate for this tax code is shown here.
Handling Tax Code	handlingtaxcode	select	FALSE	Select the tax code that determines the tax for handling charges.
Base Currency	isbasecurrency	checkbox	FALSE
Enable Item Line Shipping	ismultishipto	checkbox	FALSE	Check this box if you want to allow shipping to more than one address, using alternative shipping methods, for this transaction. Checking this box adds the fields Ship To, Carrier and Ship Via fields to the Item line. Search "Multiple Shipping Routes" in the Help Center for more information.
Taxable	istaxable	checkbox	FALSE
	lastmodifieddate	datetime	FALSE
Lead Source	leadsource	select	FALSE	Select the lead source this transaction is associated with. If you use the Marketing Automation feature, your list of lead sources is your list of campaigns. If you do not use Marketing Automation, you can create new lead sources by going to Lists > CRM Lists > New and clicking Lead Sources.
Location	location	select	FALSE
Memo	memo	text	FALSE	If you wish, enter a memo to describe this credit. It will appear on reports such as the 2-line Accounts Receivable register that your customers can see if you give them permission to log in and view their transaction history.
Customer Message	message	textarea	FALSE	Select a customer message that will appear on the Credit Memo form. To add additional choices to this list, go to Lists > Accounting Lists > New > Customer Message.
Select Message	messagesel	select	FALSE	Select a customer message to appear on this form. For example, you may add "Thank you for your business!" Choose from the list of existing customer messages stored in Accounting Lists. The text of the selected message appears in the Customer Message field. In this field, you can optionally edit the message or enter a new customer message for only this transaction. To add messages to appear in the Select Message field, go to Lists > Accounting Lists > New, and click Customer Message.
Promo Code	muccpromocodeinstance	text	FALSE
Nexus	nexus	select	FALSE
PO #	otherrefnum	text	FALSE	For your customers' convenience, you can enter their purchase order number here.
Partner	partner	select	FALSE	The partner associated with this customer appears in the Partner field. You can change the partner for this transaction.
Posting Period	postingperiod	select	TRUE	Select the period you want to post this credit memo to. If a period is closed, you cannot post to that period.
Promotion	promocode	select	FALSE	Select a promotion code to apply to this transaction. Customers associated with a partner can only use that partner's promotion codes. If you select a promotion code associated with a partner, this transaction is attributed to that partner for reporting purposes. Create new promotion codes at Edit > Promotion Codes > New.
Promo Code	promocodepluginimpl	text	FALSE
Recognized Revenue	recognizedrevenue	currency	FALSE	Recognized Revenue: cumulative amount of revenue recognized for this transaction.
Revenue Status	revenuestatus	text	FALSE	The possible values for this field are: 1. Pending: indicates that no recognition has occurred. All revenue is still deferred. 2. In Progress: indicates that some recognition has occurred. 3. Completed: indicates that all recognition has occurred. No deferred revenue remains.
Rev Rec on Rev Commit.	revreconrevcommitment	checkbox	FALSE	Check this check box to create a Revenue Commitment or Revenue Commitment Reversal. * On a Sales Order, the Revenue Commitment replaces an invoice * On a Return Authorization, the Revenue Commitment Reversal replaces a credit memo. NetSuite creates all applicable Revenue Recognition schedules the Revenue Commitment or Revenue Commitment Reversal.
Sales Effective Date	saleseffectivedate	date	FALSE	You can change the sales effective date for this transaction. The sales effective date determines which commission plan and historical sales team this transaction applies to. If this credit memo is created from a return authorization, the sales effective date from the return shown in the Created From field is set by default for this credit memo.
Choose Team	salesgroup	select	FALSE
Sales Rep	salesrep	select	FALSE	NetSuite inserts the sales representative associated with this company on the customer record at Lists > Customers. If a different sales rep is assigned to this transaction, select that sales rep here. To add additional sales reps to this list, go to Edit > Employees > New.
Shipping Address Line 1	shipaddr1	text	FALSE
Shipping Address Line 2	shipaddr2	text	FALSE
Shipping Address Line 2	shipaddr2	text	FALSE
Ship To	shipaddress	address	FALSE
Shipping Addressee	shipaddressee	text	FALSE
Ship To Select	shipaddresslist	select	FALSE
Shipping Attention	shipattention	text	FALSE
Shipping Address City	shipcity	text	FALSE
Shipping Address Country	shipcountry	text	FALSE
Shipping address is residential	shipisresidential	text	FALSE
Shipping Method	shipmethod	select	FALSE	Enter the method used to ship this order to the customer.
	shipoverride	text	FALSE
Shipping Phone	shippingcost	currency	FALSE	Enter the amount the customer was charged for shipping.
Shipping Cost Overridden	shippingcostoverridden	text	FALSE
Shipping Tax Rate	shippingtax1rate	text	FALSE	The tax rate for this tax code is shown here.
Shipping Tax Code	shippingtaxcode	select	FALSE	Select the tax code that determines the tax charged for shipping.
Shipping Address State	shipstate	text	FALSE
Shipping Address Zip Code	shipzip	text	FALSE
Source	source	text	FALSE
Status	status	text	FALSE
	statusRef	text	FALSE
Subsidiary	subsidiary	select	FALSE
Subtotal	subtotal	currency	FALSE	This field shows the total of the items on this credit memo. This is the total before any discounts, shipping cost, handling cost or tax is added to the order.
Update Customer	syncpartnerteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Update Customer	syncsalesteams	checkbox	FALSE	Check this box if you want to update the sales team on the customer's record with changes you make here.
Tax	taxitem	select	FALSE	NetSuite inserts the tax item for this customer from the record at Lists > Customers. To credit a previous sale, duplicate the tax item from that sale.
Tax %	taxrate	float	FALSE	NetSuite inserts the percentage rate of the tax item from its record at Lists > Items. To credit a previous sale, duplicate the tax rate from that sale.
Tax Total	taxtotal	currency	FALSE	NetSuite multiplies the tax rate by the taxable total of line items and enters it here.
To Be E-mailed	tobeemailed	checkbox	FALSE	Check this box if you want to e-mail this credit memo. Then enter the e-mail address in the space to the right of the check box. If you don't check this box, the credit memo won't be e-mailed. You can enter multiple e-mail addresses separated by a semicolon with no spaces.
To Be Faxed	tobefaxed	checkbox	FALSE	Check this box if you want to fax this credit memo. Enter the fax number in the space to the right of the check box if it doesn't already appear. To fax NetSuite forms, an administrator must first set up fax service at Admin > Printing, Fax and Email Preferences.
To Be Printed	tobeprinted	checkbox	FALSE	Check this box if you wish to save this in a queue of credit memos to print. Otherwise, you can click Print below to submit and print this credit memo at once.
Total	total	currency	FALSE
Est. Extended Cost	totalcostestimate	currency	FALSE	Estimated Cost: Estimated cost of the specific number of items; estimated rate x quantity = estimated cost.
Date	trandate	date	TRUE	NetSuite inserts today's date as the date of this order. You can type or pick another date.
Credit #	tranid	text	FALSE	NetSuite increases the largest credit memo number by one. If you wish, you can type another number. The next credit memo number will revert to the standard pattern. You can enter a maximum of 45 characters in this field.
Transaction Is VSOE Bundle	tranisvsoebundle	checkbox	FALSE	Check this box to include all items added to this transaction as a VSOE bundle.
Unapplied	unapplied	currency	FALSE	NetSuite displays the remaining amount of credit to be applied.
Unbilled Orders	unbilledorders	currency	FALSE
Auto Calculate VSOE Allocation	vsoeautocalc	checkbox	FALSE	The VSOE allocation amount can be calculated automatically by checking the Auto Calculate VSOE Allocation box. Allocation is the process to determine the VSOE price for items. The total VSOE amount allocated is the revenue amount to be recognized for the bundle.

Create an invoice

To create an invoice using the Payment Processing feature, refer to the following examples.

Create an invoice

From customer, estimate, opportunity, salesorder, project approvalstatus values: 1 = pending approval, 2 = approved.

A standalone invoice that is not directly connected to an order.

Example Using DSI_RecordCreate

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "shaggy.rogers@dsiglobal.com",
		"recordtype": "invoice",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "950"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "createdfrom",
					"newvalue": "26547"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}]
	}]
}

Bill Invoice – Fully Bill

Fully billing/invoicing everything not already billed.

Example DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "e.scrooge@dsiglobal.com",
		"fromrecordtype": "salesorder",
		"fromrecordid": "26547",
		"torecordtype": "invoice" ,
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}]
	}]
}

Bill Invoice – Partial

Example DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "nobody@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "30976",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "approvalstatus",
				"value": "2"
			}
		}],
		"sublists": [{
			"sublistid": "apply",
			"lines": [{
				"refnum":"INV10000012",
				"nvpair": [{
					"columnid": "amount",
					"value": "100.00"
				}]
			}]
		}]
	}]
}

Create a payment

To create a payment, using the Payment Processing feature, refer to the following example.

Create a Payment from an Invoice

To create a payment from an invoice, refer to Create an invoice.

Create a Payment from a Customer

When the invoice to pay is known, the call is similar to creating the payment from an invoice.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "nobody@dsiglobal.com",
		"fromrecordtype": "customer",
		"fromrecordid": "2956",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "approvalstatus",
				"value": "2"
		}],
		"sublists": [{
			"sublistid": "apply",
			"subrecordname":"",
			"lines": [{
				"linenum": "",
				"refnum":"INV10000006",
				"nvpair": [{
					"columnid": "amount",
					"value": "24.03"
				}]
			}]
		}]
	}]
}

Create a Payment from a Customer - No Invoice

When not applying the payment as it is created, the target field, payment, is required.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "everybody@dsiglobal.com",
		"fromrecordtype": "customer",
		"fromrecordid": "2956",
		"torecordtype": "customerpayment",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "payment processed by Advanced Inventory"
		}],
		"targetfields": [{
				"fieldid": "payment",
				"value": "24.03"
			},{
				"fieldid": "approvalstatus",
				"value": "2"
		}]
	}]
}

The payment must then be “applied” to one or more transactions later using DSI_RecordUpdate.

Example Using DSI_RecordUpdate

{
	"internalid": "32077",
	"recordtype": "customerpayment",
	"tranid": "",
	"mc_user": "guy.smiley@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Applied to INV10000006"
	}],
	"updatecolumns": [{
		"sublistid": "apply",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "24.03"
			}]
		}]
	}]
}

Create a credit memo

To create a credit memo using the Payment Processing feature, refer to the following examples.

Create Credit Memo from Invoice – Full Credit

From Invoice fully credit whole invoice.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "arthur.pendragon@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "25634",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Credit Memo created by Advanced Inventory"
		}]
	}]
}

Create Credit Memo from Invoice – Partial Credit

To credit just specific line(s) and/or less than full amount on line. Note, another linenum field must be specified in the lines nvpair; this is the line number of the item being credited on the invoice.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "arthur.pendragon@dsiglobal.com",
		"fromrecordtype": "invoice",
		"fromrecordid": "25634",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "credited by Arthur",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
		}],
		"sublists": [{
			"sublistid": "apply",
			"subrecordname":"",
			"lines": [{
				"linenum": "1",
				"serialnumbers": "",
				"nvpair": [{
					"columnid": "amount",
					"value": "12.99"
				},{
					"columnid": "linenum",
					"value": "1"
				}]
			}]
		}]
	}]
}

Create Credit Memo from Return Authorization (RMA)

From Return Authorization (RMA), the credit memo is not applied to anything. It is created for all the item lines on the RMA; to be applied to a later purchase.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "Merlin.Ambrosius@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"fromrecordid": "30071",
		"torecordtype": "creditmemo",
		"location": "2",
		"sourcefields": [{
			"fieldid": "",
			"value": ""
		}],
		"targetfields": [{
			"fieldid": "approvalstatus",
			"value": "2"
			}]
	}]
}

Create Stand Alone Credit Memo

You can create a stand-alone credit memo associated with an entity (customer) with no transaction. An unapplied credit memo must have at least one item in the item sublist. NetSuite provides special item types that may be appropriate; such as non-inventory item, other charge, markup, or discount. You can set the rate of an item to credit different amounts.

Example Using DSI_RecordCreate

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "h.k.phooey@dsiglobal.com",
		"recordtype": "creditmemo",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"subrecordname":"",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1008"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				},{
					"columnid": "rate",
					"newvalue": "125.50"
				}],
			}]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "credit for 1 Spacely Sprocket"
		}]
	}]
}

Apply Stand Alone Credit Memo

The credit must then be “applied” to one or more transactions later using DSI_RecordUpdate. You must specify the linenum of the transaction on the credit memo's apply sublist (use DSIRecordUpdate or DSI_RunSearch).

Example Using DSI_RecordCreate

{
	"internalid": "32777",
	"recordtype": "creditmemo",
	"tranid": "",
	"mc_user": "guinevere.pendragon@dsiglobal.com",
	"updatefields": [{
		"fieldid": "memo",
		"newvalue": "Applied to INV10000006"
	}],
	"updatecolumns": [{
		"sublistid": "apply",
		"subrecordname":"",
		"lines": [{
			"line": "1",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "24.50"
			}]
		},{
			"line": "2",
			"nvpair": [{
				"columnid": "apply",
				"newvalue": "T"
			},{
				"columnid": "amount",
				"newvalue": "75.50"
			}]
		}]
	}]
}

Create a cash refund

Refunds require the enhanced permission role. To create a cash refund using the Payment Processing feature, refer to the following examples.

Create a Cash Refund

Cash Refund can be created by transforming from cashsale or returnauthorization.

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "josey.pussycats@dsiglobal.com",
		"fromrecordtype": "cashsale",
		"fromrecordid": "25648",
		"torecordtype": "cashrefund",
		"tolocation": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "refunded by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "created by Advanced Inventory"
		}],
		"lines": [{
			"item": "1314",
			"qty": "1"
		}]
	}]
}

Example Using DSI_TransactionTransform

{
	"transform": [{
		"mc_user": "jem@dsiglobal.com",
		"fromrecordtype": "returnauthorization",
		"fromrecordid": "30071",
		"torecordtype": "cashrefund",
		"tolocation": "",
		"sourcefields": [{
			"fieldid": "memo",
			"value": "refunded by Advanced Inventory"
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Truly, truly outrageous"
		},{
			"fieldid": "account",
			"value": "1"
		}],
		"lines": [{
			"item": "1314",
			"qty": "1"
		}]
	}]
}

Create Standalone Cash Refund

While not best practice, you can also create a standalone cash refund.

Example Using DSI_RecordCreate

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "h.k.phooey@dsiglobal.com",
		"recordtype": "cashrefund",
		"entityid": "2956",
		"location": "2",
		"subsidiary":"1",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "customer",
			"value": "2956"
		},{
			"fieldid": "account",
			"value": "1"
		}]
	}]
}

Create a cash sale

Cash sale is a combined order and fulfillment usually used at point of sale. If applicable, any bin/lot/serial number info is required. To create a cash refund using the Payment Processing feature, refer to the following examples.

Create a Standalone Cash Sale

Example Using DSI_RecordCreate

The following fields are required to create a atandalone cash sale.

Subsidiary
Location
Entity (customer)
One or more item lines with item and quantity

{
	"recordcategory": "transaction",
	"create": [{
		"mc_user": "I.M.Weasel@dsiglobal.com",
		"recordtype": "cashsale",
		"location": "2",
		"subsidiary":"1",
		"entityid":"2956",
		"sublists": [{
			"sublistid": "item",
			"lines": [{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1314"
				},{
					"columnid": "quantity",
					"newvalue": "2"
				}],
    			"inventorydetail": {
    			    "item":"1314",
    			    "location":"2",
    			    "quantity": "2",
    			    "unit": "",
    			    "inventoryassignment":	[{
    			        "line": "",
        				"binnumber": "Alpha-1",
        				"binid": "",
        				"quantity": "2",
        				"inventorynumber": "",
        				"inventorynumberid": ""
        			}]
    		    }
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1008"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    },{
				"nvpair": [{
					"columnid": "item",
					"newvalue": "1009"
				},{
					"columnid": "quantity",
					"newvalue": "1"
				}]
		    }]
		}],
		"targetfields": [{
			"fieldid": "memo",
			"value": "Cash sale created by Advanced Inventory"
		},{
			"fieldid": "entity",
			"value": "2956"
		}]
	}]
}

There was a problem loading this topic

Mobile Enterprise Platform

Payment processing

About Payment Processing

Functional Process

Environment Considerations

Process a payment function

DSI Invoice record definitions

DSI Customer Payment record definitions

DSI Cash Refund record definitions

DSI Credit Memo record definitions

Create an invoice

Create an invoice

Bill Invoice – Fully Bill

Bill Invoice – Partial

Create a payment

Create a Payment from an Invoice

Create a Payment from a Customer

Create a Payment from a Customer - No Invoice

Create a credit memo

Create Credit Memo from Invoice – Full Credit

Create Credit Memo from Invoice – Partial Credit

Create Credit Memo from Return Authorization (RMA)

Create Stand Alone Credit Memo

Apply Stand Alone Credit Memo

Create a cash refund

Create a Cash Refund

Create Standalone Cash Refund

Create a cash sale

Create a Standalone Cash Sale