Screens

 

---

Subjects      ▼

• Settings
• Export

 

---

Settings     ▲ ▼

 

This screen is accessed from the Back Office by selecting the Data Export > Data Portal > NetSuite Rest API > Settings menu option.

 

Tabs     ▲ ▼

• Configuration
• Accounts
• Account Assignment/Mapping Tabs
  For each of the tabs listed below assign/map using the imported NetSuite Accounts to swiftpos Location, Location/Media combinations and Location/Master Group combinations as is appropriate. This can be done in bulk using the Location Group and Account filters, as well as the Apply To options (in the header section of the tab), when available in each of the tabs. Alternatively, this can be done individually row by row, by selecting the Account from the drop down-list of Accounts in the right most column of the grid.
  
  • Media Accounts
  • Cost Of Sales Accounts
  • Sales Accounts
  • Purchase Account
  • Inventory Accounts
  • Freight Accounts
  • Surcharge Account
  • Discount Accounts
  • Rounding Accounts
  • Tax Collected Account
  • Tax Paid Accounts

 

 

Configuration Tab     ▲ ▼

 

Used to configure the Connection, API Export and Location Level properties required for each Location Group (Venue) as required to ensure successful integration to NetSuite.

• Venue - Select from the drop down list the appropriate Location Group (Venue).
• Connection Properties
  Configure the following as provided by NetSuite:
  • Account ID
  • Consumer Key
  • Consumer Secret
  • Token ID
  • Token Secret
  • Company URL
  • Rest Services Path
• API Export Properties
  Configure the following as is appropriate:
  • Custom Property Name
  • Custom Property
  • Approval Status
  • Currency
  • Custom Form
  • Default Class (Journal Entry)
  • Default Class (Vendor Bill/Credit)
  • Default Supplier Account
  • Exchange Rate
• Location Level Properties
  • Department - Select to open the NetSuite Department Records screen to configure the appropriate NetSuite IDs and Descriptions for each Location.
    
    
    
    
  • Location - Select to open the NetSuite  Location Records screen to configure the appropriate NetSuite IDs and Descriptions for each Location.
    
    
    
    
  • Subsidiary - Select to open the NetSuite Subsidiary Records screen to configure the appropriate NetSuite IDs and Descriptions for each Location.
    
    

 

Accounts Tab     ▲ ▼

 

Displays a list of Account as imported (using the Import Chart of Accounts option at the bottom of the screen). Once imported, the remaining tabs to the right can be configured by assigning/mapping the imported Accounts in each of the tabs. For each Account imported the following attributes are displayed:

• Account Number
• Type
• Status
• Account id

 

Media Accounts Tab     ▲ ▼

 

 

Cost of Sales Accounts Tab     ▲ ▼

 

 

Sales Accounts Tab     ▲ ▼

 

 

Purchase Account Tab     ▲ ▼

 

 

Inventory Accounts Tab     ▲ ▼

 

 

Freight Accounts Tab     ▲ ▼

 

 

Surcharge Account Tab     ▲ ▼

 

 

 

Discount Accounts Tab     ▲ ▼

 

 

Rounding Accounts Tab     ▲ ▼

 

 

Tax Collected Accounts Tab     ▲ ▼

 

 

Tax Paid Accounts Tab     ▲ ▼

 

 

Location Group and Account Filters     ▲ ▼

 

Used to assign/map in bulk by selecting the Location Group and the NetSuite Account appropriate to the tab, before using one of the Apply To options available to assign/map it to multiple rows in the grid.

Filters

• Location Group – Select from the drop down list of available Location Groups (Venues).

• NetSuite Account (Media Account) – Select from the drop down list the NetSuite Account that will be used to assign/map to the SwiftPOS Location/Media combination.

 

Apply To Options     ▲ ▼

 

Used to assign/map the selected NetSuite Account to the rows in the grid by using one of the following options:

• Selected Rows – Select to assign/map to all rows that are currently selected in the grid.
• Unassigned Rows – Select to assign/map to all rows that are currently DO NOT have an Account assigned/mapped in the grid.
• Selected Location – Select to assign/map to all rows in the grid that are associated with a selected Location.
• Copy Location – Select to copy the assignments/mappings of a selected Location to another.

 

---

Export     ▲ ▼

 

This screen is accessed from the Back Office by selecting the Data Export > Data Portal > NetSuite Rest API > Export menu option.

 

Sections     ▲ ▼

• General Journals
• Supplier Invoices

 

General Journals     ▲ ▼

• Location Group - Select from the drop down list the Location Group for which data will be exported.
• Include in EOD - Select to ensure the export of data is included as part of the End of Day (EOD) process.

• Location - Select from the drop down list the Location for which data will be exported.

• Trading Date - Select from the drop-down list of dates the date for which data will be exported. If needed select the Refresh option (to the right of the drop-down list) to refresh the Trading Dates displayed.

 

 

• Export - Select to invoke the export. Once completed a prompt will be displayed confirming completion. All exported General Journals can be viewed in the Event Logs.

 

 

• Reset - Select a Trading Date to ensure that General Journal related data for that date are flagged as NOT Exported, so that they can be exported again. Select to display the following prompt:

 

• Reset continued ...
  • Location Group - Select from the drop down list the Location Group for which data will be reset.
  • Location - Select from the drop down list the Location for which data will be reset.
  • Trading Date - Select from the drop down list the Trading Date for which General Journal related data will be reset.

 

 

• Mark ALL as Exported - Select to display the following prompt and thereby ensure ALL General Journal related data in the selected Location is flagged as exported.

 

 

• Mark ALL as Exported continued ...
  • Location Group - Select from the drop down list the Location Group for which data will be flagged as exported.
  • Location - Select from the drop down list the Location for which data will be flagged as exported.

 

 

Supplier Invoices     ▲ ▼

• Location Group - Select from the drop down list the Location Group for which data will be exported.
• Include in EOD - Select to ensure the export of data is included as part of the End of Day (EOD) process.

• Location - Select from the drop down list the Location for which data will be exported.

• Trading Date - Select from the drop-down list of dates the date for which data will be exported. If needed select the Refresh option (to the right of the drop-down list) to refresh the Trading Dates displayed.

 

 

 

• Export - Select to invoke the export. Once completed a prompt will be displayed confirming completion. All exported Supplier Invoices can be viewed in the Event Logs.

 

 

 

• Reset - Select a Trading Date to ensure that Supplier Invoice related data for that date are flagged as NOT Exported, so that they can be exported again. Select to display the following prompt:

 

• Reset continued ...
  • Location Group - Select from the drop down list the Location Group for which data will be reset.
  • Location - Select from the drop down list the Location for which data will be reset.
  • Trading Date - Select from the drop down list the Trading Date for which Supplier Invoice related data will be reset.

 

 

 

• Mark ALL as Exported - Select to display the following prompt and thereby ensure ALL Supplier Invoice related data in the selected Location is flagged as exported.

 

 

• Mark ALL as Exported continued ...
  • Location Group - Select from the drop down list the Location Group for which data will be flagged as exported.
  • Location - Select from the drop down list the Location for which data will be flagged as exported.

 

 

End of article.      ▲