Home > Aria6 User Documentation > NetSuite Connector > Using the Aria-NetSuite Connector

Using the Aria-NetSuite Connector

Overview

There are several places in the NetSuite UI that allow you to create, edit, or view Aria data. Each of these is covered in the following sections.

Transactional Data

Category
Aria Transaction
NetSuite Transaction

Invoice

Invoice

Invoice

Voided Invoice

Credit Memo

Payment

Check

Payment

Voided Check

Journal Entry

Electronic Payment

Payment

Voided Electronic Payment

Journal Entry

3rd Party Payment

Payment

Voided 3rd Party Payment

Journal Entry

Reinstated Payment transaction

Payment

Voided Reinstated Payment transaction

Journal Entry

Refunds

Refund of Electronic Payment

Journal Entry

Voided Refund of Electronic Payment

Journal Entry

Refund of External Payment

Journal Entry

Voided Refund of External Payment

Journal Entry

Credits/Write Offs/Reversals

Cash Credit

Journal Entry

Voided Cash Credit

Journal Entry

Credit from Overpayment

Journal Entry

Voided Credit from Overpayment

Journal Entry

Refund-Related Reversal

Credit Memo

Voided Refund-Related Reversal

Journal Entry

Write-off

Journal Entry, Apply to invoice via $0 payment

Balance Forward, Balance Transfer

Balance Forward

Journal Entry

Voided Balance Forward

Journal Entry

Negative Balance Forward

Journal Entry

Voided Negative Balance Forward

Journal Entry

Balance Transfer from Account

Journal Entry, Apply to Invoice

Balance Transfer to Account

Journal Entry

Non-transactional Data

Aria

NetSuite

Account

Customer

Plan

Non-inventory Item

Service

Non-inventory Item

Non-subscription Offering

Non-inventory Item

Make Journal Entries

The first place in NetSuite where you can access Aria data is in the Transactions tab. Click Transactions, then click List next to Make Journal Entries, which is listed under the Financial heading.MakeJournalEntries1.jpg

When you view a list of journal entries (as shown below), you are seeing what it looks like when an Aria journal entry is mapped to a journal entry in NetSuite.

In the screen shown below, note the Internal ID. This correlates to the External ID in Aria.

MakeJournalEntries2.jpg

When you select a journal entry, you see the following screen. Note the tab showing Aria Transaction Detail with the Aria Event No.

MakeJournalEntries3.jpg

Invoices

You can access Aria data in the NetSuite Transactions tab. Click Transactions, then click either Create Invoices, or List or Search (next to Create Invoices, see below). Create Invoices appears under the Sales heading.

Invoice1.jpg

When you view an invoice in NetSuite, you can click Aria Transaction Detail to access the tab where you see Aria data associated with the invoice (see below). Each of the fields listed on the Aria Transaction Detail tab is populated with information generated from Aria.

Note: When a new invoice is created, there is also an Aria Transaction Detail tab where you can enter Aria-related information.

Invoice2.jpg

Aria-related items on the Aria Transaction Detail tab and on the Items tab correspond to values that are stored in Aria. For example, Aria Account Number is the account number associated with this invoice in Aria; Aria Paid Date is the date the invoice was marked as paid in Aria; and so on.

Customer Payments

Aria data can be accessed in the NetSuite Transactions tab. Click Transactions, then click Accept Customer Payments, or List or Search (next to Accept Customer Payments). Accept Customer Payments appears under the Customers heading.

CustomerPayments.jpg

When you view a payment in NetSuite, you can click Aria Payment Detail to access the tab where you can view the Aria Payment ID.

Notes: When a new payment is created, there is also an Aria Payment Detail tab where you can enter Aria-related information.

A payment associated with a closed accounting period is automatically assigned to the next open accounting period.

Credit Memos

You can access Aria data from the NetSuite Transactions tab. Click Transactions, then click either Issue Credit Memos, or List or Search (next to Issue Credit Memos). Issue Credit Memos appears under the Customers heading.

CreditMemos1.jpg

When you view a credit memo in NetSuite, you can click Aria Transaction Detail to view Aria data that is associated with the memo (see below). Each of the fields listed on the Aria Transaction Detail tab are populated with information generated from Aria.

Note: When a new memo is created, there is also an Aria Transaction Detail tab where you can enter Aria-related information.

CreditMemos2.jpg

Aria-related items on the Aria Transaction Detail tab and the Items tab correspond to values that are stored in Aria. For example, Aria Account Number is the account number associated with this credit memo in Aria; Aria Currency CD is the currency code associated with this memo in Aria; and so on.

Customers

Aria data can be accessed through the NetSuite Lists tab. Click Lists, then click either Customers, or New or Search (next to Customers). Customers is listed under the Relationships heading.

Customers1.jpg

When you view a customer’s information in NetSuite, you can click Aria Billing Information to access the tab where you can view all the Aria data associated with that client. Each of the fields on the Aria Billing Information tab is populated with information generated from Aria. See the screen below for more information.

Note: When a new customer record is created, there is also an Aria Billing Information tab where you can enter Aria-related information.

Customers2.jpg

All the items listed on this tab correspond to values that are stored in Aria. For example, Aria Account Number is the account number associated with this customer in Aria; Aria Master Plan No is the number of the master plan associated with that client in Aria; and so on.

Items

You can access Aria data in the Lists tab. Click Lists, then click either Items, or Search (next to Items). Items is listed under the Accounting heading. After clicking either Items or Search, a list of items appears on screen. Click any item from the on-screen list to view it.

Items1.jpg

When you view an item in NetSuite, there are three fields that correspond to Aria information (see below). These fields are:

  • Internal ID: The External ID in Aria.
  • Item Name/Number: The Aria item, service, or plan number (depending on the type of item).
  • Display Name/Code: The Aria item, service, or plan name (depending on the type of item).

Items2.jpg

Apply a Payment from NetSuite

Any payments that are applied in NetSuite are migrated to Aria immediately. A payment associated with a closed accounting period, is automatically assigned to the next open accounting period.

  1. Click Transactions > Sales > Create Invoices > List

ApplyPayment1.jpg

  1. To apply an external payment search for an Open invoice.
  2. Select an Open invoice and click View to apply a payment.
  3. Click the Aria Transaction Detail tab to view the amount that is due on the invoice.
 

ApplyPayment3.jpg

  1. Click the Accept Payment button. The selected invoice is checked.
  1. Click the Payment Method tab. Select a Payment Method from the drop-down and enter the required details about the selected payment method.

ApplyPayment5.jpg

  1. Click Save. A Confirmation window displays.

ApplyPayment6.jpg

  1. To view a payment received from NetSuite in Aria, go to Accounts > Select an Account> Account Overview > Recent Payments.  Payments from NetSuite are labeled as External payment.  

External Payment_NetSuite.png

You can also view the payment on the Payments & Credits screen.

 

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.