Skip to main content

Acumatica Import Scenario - Importing Attributes

Acumatica Attributes are type of pre-defined custom fields that users can utilize in capturing data, validating or storing information across Customers, Vendors, Inventory and various other data entry screens such as Leads, Opportunities, Projects, AP, AR etc.

There are 5 different attribute types that you can store data in Acumatica

  1. Text: A text box into which the user can type text (Control Value 1)
  2. Combo: A list box users can use to type or select options (Control Value 2)
  3. Not available :)
  4. Checkbox: A check box users can select or clear (Control Value  4)
  5. Datetime: An element for selecting date and time (Control Value 5)
  6. Multi Select Combo: A list box where users can select multiple options (Control Value 6)

You can manually configure each attribute by navigating to Configuration --> Common Settings --> Attribute screen and create attributes if they are fewer to keyin, however if you have large set of attributes that you would like to collect across different entities then your better off creating them in spreadsheet and then importing through an Import Scenario.

Step 1: To create an Import Scenario navigate to System --> Manage --> Data Providers, create a new
data provider with provider type as Excel Provider (PX.DataSync.ExcelSYProvider), load the file and populate the Schema source object and fields.

Step 2: Create a new Import Scenario, pick the data provider created and the sheet to process, map the spreadsheet fields with Acumatica fields to process the import process of the data to create new attributes/records.

Step 3: Create a new Import by Scenario process and prepare the data and import, and you just loaded attributes, its values and sort order.

The benefit of importing data allows you to create attributes in spreadsheet as master sheet and you can repeat the process of importing on other instances, comes in handy during testing & go live imports makes your implementation process easier.


Popular posts from this blog

Acumatica Snapshot creation without switching on Maintenance mode Warning

New Security Feature: Snapshot creation without switching on Maintenance mode.

One of the really cool things for System administrator dealing with Acumatica is taking snapshots and being able to re-create another instance or Company, however this led to creating bad records or corrupted data as we are taking snapshots other users might be using the system and there was a good chance of data corruption.

In the latest release 2017 R2 Acumatica now warns user with a message "The snapshot may contain corrupted data because you are not in maintenance mode." letting you know not to take snapshot of the live instance without switching the maintenance mode.

Step 1: Navigate to System --> Management --> Apply Updates, click on the button "Schedule Lockout" and specify the reason for lockout 

Step 2: Navigate to System --> Management --> Manage Companies and click on Create Snapshot

Step 3: Don't forget to remove the lockout. 

Such incremental features allows Acu…

Manage 3dCart Orders, eCommerce distribution made easy with Acumatica Cloud ERP

Selling Online should be as easy as shopping itself - 3dCart.
While we say managing 3dCart orders within Acumatica should be as easy as a click.

Our custom integration package for 3dCart allows business owners to download orders from 3dCart shopping software into Acumatica Cloud ERP for distribution and processing of orders.
We just did build an import scenario or API/Web service to download orders, instead we built the framework to accommodate your growing business, multiple websites orders can now be processed in Acumatica, that's the power of Acumatica framework.

We have several options for order processing in Acumatica
a) Manual type the order - nope old style
b) Import scenario allows to import orders exported from your ecommerce site - Still is bit manual to export/import process
c) Using Web services build an interface to connect multiple websites to import open orders - right way to scale your business.

Acumatica-3dCart Integration We built 3dCart integration with Acumatic…

Demo of Acumatica eSignature Proof of Delivery From InfoSourcing Inc

Acumatica eSignature Plugin demonstration of Proof of delivery feature, the video covers configuration settings, enabling and capturing a signature on shipment screen along with the custom report.

For more product demo's please contact InfoSourcing Inc, we will provide with 14-day trial version for your SaaS or PCS or PCP version.