Videos uploaded by user “Douglas Johnson”
Importing Excel data into Acumatica Cloud ERP
Demonstration of how to import sales orders from an Excel spreadsheet. A sales order can have a single line or multiple items. The import is done using Acumatica integration tools. These tools allow you to map Excel spreadsheets and other input sources to Acumatica screens.
Views: 2656 Douglas Johnson
Acumatica Integrated Ecommerce
Overview of integration with Acumatica Cloud ERP and Magento eCommerce. Video shows managing inventory items, placing an order that instantly appears for shipping, merging online and offline orders on a shipment, getting shipping status and tracking numbers from the eCommerce site, and receiving progress updates via email.
Views: 1658 Douglas Johnson
Acumatica New User Interface in 2017 R2
Demonstration and explanation of the new Acumatica UI including workspaces, user configuration, search, and help.
Views: 2488 Douglas Johnson
Overview of Acumatica Cloud CRM Software
Overview and high level discussion of Acumatica CRM architecture
Views: 5575 Douglas Johnson
Purchase Requisition Workflows in Acumatica
Description and demonstration of requisition workflows in Acumatica. Includes three flows demonstrating internal requests, internal requests with vendor bidding, and a customer request-quote-order process. Shows how workflows are created.
Views: 3729 Douglas Johnson
Acumatica Purchase Order Management
Overview of Purchase Orders using Acumatica Cloud ERP software. Shows end to end flow including placing order, approving PO, workflow notification, and receipt of order.
Views: 4514 Douglas Johnson
Acumatica Fixed Assets Overview
Overview of fixed assets in Acumatica. Shows creating an asset from a vendor invoice or purchase order, running depreciation, changing asset salvage value and expected life, and disposing an asset.
Views: 1865 Douglas Johnson
Reconciling bank cash accounts in Acumatica
Demo how to reconcile bank statements in Acumatica Cloud ERP. See how to import transactions, match transactions, add transactions, and mark transactions as cleared and reconciled.
Views: 2498 Douglas Johnson
Acumatica Mobile Field Services Preview
Upcoming preview demo of mobile features which will soon be available in the Acumatica Field Services Edition software. The demonstration example shows how dispatch, field workers, and finance can complete a customer while sharing real time data
Views: 1121 Douglas Johnson
Acumatica Manufacturing - Build to Order
Acumatica Manufacturing Suite overview. After a brief overview, see now to produce items directly from a sales order using inventory from the Acumatica Distribution Suite.
Views: 1091 Douglas Johnson
2016 Acumatica ERP Outlook Integration
Demonstration of Acumatica ERP integration with Outlook via an Exchange plug-in. The Acumatica 6 feature makes it easy for sales and support personnel to quickly add contacts and information received via email to Acumatica ERP.
Views: 2374 Douglas Johnson
Acumatica Customization - Adding a Button
Demonstration of how to to customize screens in Acumatica by adding buttons and controls.
Views: 1924 Douglas Johnson
Link a Web Form to Acumatica Using Web Services
Create a form on any website and use it to publish information to Acumatica using web services. Watch a simple 3-step process of: (a) locating and linking Acumatica web services to an ASPX website, (b) creating a simple web form, (c) using C# code to publish the form results to Acumatica.
Views: 1546 Douglas Johnson
Cloud ERP - use Acumatica to consolidate financials across systems and currencies
This video provides 12 steps to create a financial consolidation using Acumatica Cloud ERP. The steps involve creating companies with different charts of accounts, creating currencies, uploading currency rates, creating reporting ledgers, account mapping, entering transactions, creating the currency translation, importing data, and creating a consolidated report.
Views: 2284 Douglas Johnson
Inter Company Accounting in Acumatica
Overview of inter-company accounting options in Acumatica Cloud ERP 5.0. Includes comparison of related entities (branches) and stand-alone companies. The demo shows a GL transaction as well as an inventory transfer between entities.
Views: 2728 Douglas Johnson
Inventory Management and Distribution Overview
Overview of inventory management in the Acumatica Distribution Management Suite
Views: 1899 Douglas Johnson
Processing Landed Costs in Acumatica
Demo of landed costs in Acumatica. Reviews process of entering PO, receiving goods, and entering vendor invoices after goods have been received.
Views: 1717 Douglas Johnson
Acumatica and Exchange - Setup and Sync
Demonstration of how to configure Exchange (Office 365) to synchronize email, contacts, calendar items, and tasks with Acumatica. Three parts: 1. Setup and configuration of server, policies, and users 2. Demo of syncing Outlook and Acumatica via Exchange 3. Demo of using a mobile Android device to sync with Acumatica
Views: 3939 Douglas Johnson
Acumatica Cloud ERP Overview
ERP software overview demonstration. Covers key Acumatica value propositions: customizations, unlimited users, multiple deployment methods, workflow, mobile devices, 100% web based, B2B portal, integrated CRM, drill down reporting.
Views: 2155 Douglas Johnson
Corporate Structures and Inter-company Transcations
Setup a corporate hierarchy in Acumatica 2018 R1. Video shows how to convert 2 branches in 2017 R2 to a 3 company hierarchy in 2018 R1. Learn how to process an AP Bill across multiple companies and setup a unit set to see the reporting results.
Views: 275 Douglas Johnson
Advanced Reporting using GL Subaccounts in Acumatica
Acumatica provides flexible account and subaccount structures to match your business needs and provide powerful reporting features. This video shows how to create segments and use them for reporting purposes.
Views: 1637 Douglas Johnson
HubSpot integration with Acumatica using Azuqua
Integrate HubSpot marketing automation with Acumatica CRM and ERP software using Azuqua and web services. A live example shows the three systems interact to shuttle a lead from HubSpot to Acumatica. At the end, learn how to setup Azuqua to work with Acumatica.
Views: 267 Douglas Johnson
Customizing Cloud ERP - Adding Fields and Modifying Screen
This short 5 minute video shows how you can add a new tab to a Purchase Order screen and add 5 new fields to the database. The video shows that the fields are immediately available for order entry and reporting.
Views: 1720 Douglas Johnson
Salesforce CRM Integration with Acumatica ERP
Discussion of how to synchronize leads and accounts in Salesforce CRM with Acumatica Cloud ERP. Video explains concepts and then provides a demonstration of a data import and data change. Acumatica Partners: if you want setup document, email me.
Views: 1671 Douglas Johnson
Assigning Work in Acumatica Cloud ERP
Demonstration of assignment rules and approval maps in Acumatica. Assignment rules allow you to define who is responsible for following up on sales leads, responding to customer service cases, approving expense claims, verifying time sheets, and many other tasks.
Views: 1539 Douglas Johnson
Printing from the Acumatica Cloud
Acumatica has pre-released something called Device Hub which allows you to print pick lists and invoices to a local printer. You can also use Device Hub to connect other devices such as scales.
Views: 373 Douglas Johnson
Acumatica OData feed to Power BI
Use Microsoft Power BI to publish data visualizations for Acumatica Cloud ERP data. Learn how to create the data feed using Power BI Designer and create basic visualizations using the demo data.
Views: 1928 Douglas Johnson
Acumatica Journal Entry Process
Demonstration of the efficiency of making a journal entry into Acumatica Cloud ERP. Shows making an entry into the general ledger and some of the accounting features that are included with Acumatica.
Views: 2251 Douglas Johnson
Localization Features in Acumatica Cloud ERP
Demonstration of Acumatica localization tools that allow the selection of different languages and reflect regional formatting preferences. See how to add languages and perform translations in Acumatica. Localize text on screens, reports, error messages, and even data within the database. Manage date and time formatting according to the country where you are located.
Views: 831 Douglas Johnson
Installing Acumatica On-Premises
An accelerated view of installing the Acumatica Cloud ERP software on a Windows Server running IIS and a Microsoft SQL Database. The process shows installation wizards as well as installation options.
Views: 1174 Douglas Johnson
Customizing Dashboards in Acumatica
Demonstration of how to customize dashboards using pre-configured widgets. Video shows adding wiki articles, graphs, and charts directly from the Acumatica application.
Views: 3243 Douglas Johnson
VAT Taxes in Acumatica
Overview of tax logic in Acumatica with short example of setting up Canadian VAT (GST, HST, PST) taxes.
Views: 1327 Douglas Johnson
Mobile Device Support in Acumatica
Short demo of mobile device support in Acumatica including tablets and phones. Illustration of how to use mobile framework to modify fields and form layout on mobile device.
Views: 741 Douglas Johnson
Managing Acumatica Themes / Skins
Short demo of how to create and modify themes in Acumatica so you can pick a unique look and feel for your cloud ERP application. Since Acumatica is a web application, applying skins/themes is easy.
Views: 388 Douglas Johnson
Acumatica Migration Mode for AP and AR documents
Demo and discussion of how you can quickly import historical AP and AR documents without impacting the Acumatica GL entries or the customer and vendor balances.
Views: 358 Douglas Johnson
2017 Salesforce integration
Demonstration of the real-time synchronization of products, contacts, customers, and opportunities between Salesforce and Acumatica.
Views: 354 Douglas Johnson
Reporting with Power BI AppSource Data
Demo showing how to implement Power BI reporting using the Acumatica AppSource data inside Microsoft Power BI. See how changes in Acumatica CRM are immediately available to Power BI. During the demo learn about the OData connection as well as the advantages of Power BI over Excel. For demo showing PowerBI desktop with generic inquiry data, please visit: http://youtu.be/pfx4Y95AyO8
Views: 184 Douglas Johnson
Acumatica Reporting Tools Overview
Demonstration three reporting utilities that are included with Acumatica. The first is a web-based financial reporting tool. The second is a Windows-based desktop utility that allows you to create custom views of your data. The third is a generic inquiry designer for building database queries.
Views: 2673 Douglas Johnson
Data Filtering in Acumatica Cloud ERP
Demonstrates different types of data filters in Acumatica Cloud ERP that provide rapid access to data. Filters can be saved, shared, and set as default within an organization.
Views: 1676 Douglas Johnson
Generic Inquiries for rapid data reporting
Demonstration of how to use the 'generic inquiry writer' for building database queries. Inquiries can be saved, added to the Acumatica menus, and added to dashboards for real-time reporting. Inquiries are run against the Acumatica data access classes so that all business logic and security rules are preserved when running a SQL-like inquiry.
Views: 1177 Douglas Johnson
Inter-Company Transactions - Setup Company (Branch)
Demonstration of how to create a new company (branch) in Acumatica and set up automated inter-company transactions. Includes creating a transaction and updating reports.
Views: 1824 Douglas Johnson
Scheduling Work in Acumatica
Explanation and demo of how to schedule work in Acumatica so you can process recurring tasks.
Views: 610 Douglas Johnson
Workflow Automation and Overview
Overview of automation tools inside Acumatica Cloud ERP software with a deeper dive into some of the specific processes around automation steps.
Views: 1849 Douglas Johnson
Credit Card Payments using APS and Acumatica
Demo showing how Acumatica ERP supports PCI compliant credit card payment processing using American Payment Solutions. The video shows examples of processing and a short description of how to setup the process.
Views: 260 Douglas Johnson
Restricting Access to data in Acumatica Cloud ERP
Acumatica allows customers to restrict access to specific data values. This demonstration shows how to restrict data access to specific customer accounts based on the user who is currently logged in. Other videos (such as http://youtu.be/8PSMdwIE_4M) show how to restrict access to screens, reports, and entire objects.
Views: 910 Douglas Johnson
2017 UOM and Pricing Improvements
Demo and description of Acumatica Cloud ERP 2017 R2 distribution enhancements including unit of measure pricing improvements. Areas covered include: (a) Pricing by warehouse (b) Price adjustments by UOM (c) UOM pricing by vendor ID
Views: 485 Douglas Johnson
Importing Data from an External System
Demo of how to build a new data access class and screen to accept data from an external system. By building a new screen, you can easily view and modify the imported data as well as include it in Acumatica reports. Details illustrated in this video.
Views: 1449 Douglas Johnson
Shipping in Acumatica
Demo of shipping enhancements in Acumatica 2018 R2. Includes international shipments using USPS via Stamps.com, UPS, FedEx, and other carriers. See how to process shipments from prepaid orders obtained from commerce, point of sale, or other external systems.
Views: 112 Douglas Johnson
Using Excel to Display OData from Acumatica Cloud ERP
Learn how to expose Acumatica ERP data via an Open Data Protocol (OData) feed using a generic inquiry. See how to open the data feed using Microsoft Excel and then format the data into Pivot Tables and Pivot Graphs.
Views: 2460 Douglas Johnson
Approve and Pay Bills in Acumatica
See how the workflow engine inside Acumatica allows you to route bills to the appropriate people for approval. After approval, process the bills according to vendor terms, payment methods (such as ACH and check), and due date.
Views: 847 Douglas Johnson