DocVision PDF Automation Configuration Checklist for Acumatica
DocVision PDF Automation Configuration Checklist for Acumatica
When you're ready to transform your sales operations by automating document entry, having a clear roadmap is the difference between a bumpy start and a seamless transition. At Biz-Tech Services, we know the key to success with DocVision PDF Automation, our solution for Portable Document Format, or PDF, scan and import, is preparation. This pre-launch checklist walks your business through the essential steps to make sure your Enterprise Resource Planning system, or ERP, is fully ready to turn incoming customer documents into accurate orders instantly. Follow it, and you'll maximize efficiency, reduce data-entry mistakes, and get your team ready for go-live.
Establishing your foundational configuration
Your journey begins with the core connection between Acumatica and the cloud infrastructure it relies on. First, confirm that your Azure setup is complete, so your ERP can use cloud services like storage and virtual machines to process incoming files. Within the connection settings, verify that your Application Programming Interface key, or API key, along with the API version and the base web address, are all entered correctly.
We always recommend using the Test Credentials feature before you move forward. Running that test confirms the system can communicate with the cloud platform, which is the essential backbone for importing your customer Purchase Order files, or POs, and converting them into sales orders.
Preparing your customer and inventory data
Once the connection is established, your next priority is data preparation. DocVision uses a per-customer PDF mapping approach, which means you can adapt to the unique document structure of every client you serve. For each unique format you receive, you create a template ID.
A critical part of this stage is setting up your customer cross-references. Make sure the system can accurately identify the customer values and locations on the PDF and map them to the matching records in Acumatica. That way, when a document arrives, the system knows exactly which customer account to credit and where the goods should ship.
After the customer setup, prepare your item data through the inventory cross-reference system. You can manually map individual PDF line items to your Acumatica inventory IDs, or, if you have a high volume of items, import those mappings in bulk from an Excel file. This step is vital, because it bridges the gap between how your customers describe a product and how it's stored in your database.
Mapping and validation points
With your data prepared, you move into fine-tuning your document mappings, where you define exactly which pieces of information from the PDF are extracted and where they land in your system. First, confirm the mapping of your header fields, like the date or customer name, using the Sales Order Advanced target. Next, make sure you've mapped the transaction details using the Sales Order Details Advanced target.
During this, pay close attention to the Dynamic PO Number setting. If a customer document happens to be missing a purchase order number, the system can flag it and issue a warning, letting you choose an alternative number so the process keeps moving.
And before you consider a template ready for production, learn the validation signals in the interface. When you review an imported document, watch the color indicators. Green means everything is mapped correctly and you're ready to generate an order. Yellow means some items aren't linked yet, and you should use the Validate Items button to resolve them. Red signals a specific error that needs your attention before the order can proceed.
User access and security
Because DocVision is built natively for Acumatica, it's designed to work inside your existing secure environment. Before going live, verify that your user permissions are configured correctly. The system respects your established audit trails and security protocols, so only authorized team members can generate or modify orders. And because it's a native integration, you don't have to worry about external dependencies compromising your data security or your system's performance.
Final testing and go-live readiness
The final step is a full test of the end-to-end workflow. Practice importing a document, then use the three-dots menu to select Generate Sales Order. Confirm that the system successfully creates the order and that the Generated checkbox is automatically selected on the document record.
For high-volume operations, we suggest testing the batch-processing capabilities. On the Generate Sales Orders screen of DocVision Integration, you can filter by document number and process many orders at once, which is a big part of the time savings your business is after. It is available on Import Documents screen as well to create individual Sales Orders. Finally, get your team familiar with the generic inquiry built specifically for DocVision. It acts as your central command center, where you can track all your document numbers, template IDs, and generation dates in one place.
The single most important takeaway for go-live readiness is that validation is the key to automation. When your cross-references are accurate and your templates validate with a green status, you can trust the system to handle the heavy lifting of data entry. If you're ready to see how these configurations work in the real world, visit biz-techservices.com to schedule a demo and start your journey toward a more efficient, automated future.
CRV Configuration Checklist for Acumatica Beverage Distributors
CRV Configuration Checklist for Acumatica Beverage Distributors
Managing a beverage distribution business in California brings unique regulatory requirements, especially when it comes to the California Redemption Value, or CRV. When you run on an Enterprise Resource Planning system, or ERP, like Acumatica, accuracy isn't just a goal, it's a requirement for compliance and financial integrity. At Biz-Tech Services, we know the move to automated environmental-fee tracking can feel complex, which is exactly why a thorough pre-launch checklist matters. This checklist makes sure your system is configured correctly, your data is prepared, and your team is ready for a smooth go-live.
Required configuration: defining the foundation
The first step toward automated compliance is setting up the CRV items themselves. In Acumatica, these are Non-Stock Items, designed to be added automatically to sales transactions whenever you sell beverages that fall under the state's recycling program. Here, ECOFEE is the non-stock item. So first, confirm that your CRV non-stock items are created and correctly categorized, and that they're available in both the inventory and the sales modules.
Once those items exist, your next task is to bridge the gap between your beverage products and these fees. On the Stock Item screen for each beverage, go to the Price and Cost tab and select the matching non-stock CRV item in the designated field. That link is what tells the system exactly which fee to apply when a specific beverage is sold.
Data preparation: pricing and units of measure
Next, make sure your pricing and unit data are carefully prepared. It's not enough to link a beverage to a CRV fee; you also have to define the fee's specific value. On the Stock Item screen, focus on two areas. First, verify the CRV amount field on the Price and Cost tab, which lets you define a separate price for the fee item.
For many distributors, though, the fee isn't one-size-fits-all; it often depends on the container size or volume. To handle that, confirm the setup on the General tab of the Stock Item screen, where another CRV amount field sets the fee based on the selected Unit of Measure, or UOM. With that in place, whether you're selling a single bottle or a full case, the system calculates the redemption value precisely.
Customer validation: controlling the automation
Once your items are configured, validate your customer records, because not every customer or transaction requires CRV tracking, and the system lets you toggle the automation at the source. Confirm that the Include in CRV checkbox is set correctly on the customer's default location on Customer Locations screen. This is a critical validation point, since that checkbox decides whether the fee item automatically appears on a sales order based on the location of the Customer.
As you prepare for launch, we suggest auditing your customer list to make sure this flag is active for all of your relevant California-based accounts. That way the automation runs only when it should, which prevents unnecessary manual corrections during a busy sales cycle.
User access and tracking points
As you move closer to go-live, make sure your team knows how to verify the automation is working. We've enhanced the standard Acumatica screens to give clear visibility into these fees. In particular, make sure your sales and warehouse teams are familiar with the new Parent Item and Child Item fields, which we've added to the Sales Orders, Shipments, and Invoices screens. They make it easy to identify the main beverage product, the parent, and its associated environmental fee, the child, which matters a lot in a high-speed distribution environment.
Testing: the sales order workflow
Before you officially flip the switch, a rigorous testing phase is essential, and we recommend a series of end-to-end tests in a sandbox environment. First, confirm the automation by going to the Sales Orders screen and choosing a customer whose location is flagged to include these fees. When you add a parent beverage item to the order, watch for the system to automatically add the matching CRV item as a new line.
During that test, pay close attention to the details. The system should give the child item the same quantity and the same warehouse as the parent. If the fee line appears instantly, with matching quantity and warehouse, you know your configuration is sound.
Go-live readiness and final validation
The final stage is confirming readiness across the whole document lifecycle, because compliance doesn't stop at the sales order; it has to flow through to the final invoice. So verify that the parent-and-child relationship is visible not just on the sales order, but also on the shipment and the invoice. That end-to-end visibility keeps both your financial reporting and your customer's billing accurate and transparent.
The real takeaway for go-live readiness is this: consistency between your Stock Item settings and your customer location flags is what drives a successful, automated environmental-fee program. When those elements line up, the system removes the burden of manual entry and reduces the risk of regulatory errors.
If you're ready to see how these automated workflows can transform your beverage distribution business, we'd love to help. Visit biz-techservices.com today to schedule a demo and see the Acumatica CRV configuration in action.
Consignment Processing Configuration Checklist for Acumatica
Consignment Processing Configuration Checklist for Acumatica
Launching a new module inside your Enterprise Resource Planning system, or ERP, is a significant milestone for any growing business. At Biz-Tech Services, we know the key to a successful go-live isn't just the software itself; it's the preparation you put in before the first order is ever entered. And when you're managing inventory held at your customers' locations, visibility and accuracy are everything. So we've put together this pre-launch checklist to make sure your Acumatica environment is fully ready for Consignment Processing.
Phase one: required system configuration
Your first step is the technical foundation. You need to make sure the Consignment Processing customization project is correctly installed in your Acumatica environment. On the Customization Projects form, we recommend you first validate the project to catch any conflicts with your existing setup, and then publish it for your tenant. That uploads the package to your database and compiles the files that switch on the consignment features.
After the installation is verified, move to the Sales Order Preferences form. This is where you define the DNA of your consignment transactions, and you need to confirm that three specific order types are established. First, verify a consignment order type, typically labeled CN, created from the Transfer Order template. Next, make sure a consignment invoice order type, or IN, is set up from the Invoice Order template. And finally, confirm a consignment return order type, or CR, also built on the Transfer Order template. Within these same preferences, designate a default consignment warehouse to streamline your data entry later on.
Phase two: warehouse and customer data preparation
With the core preferences set, your next focus is your warehouse structure. Go to the Warehouses form to identify the locations that will hold consigned stock. For every warehouse you use for this purpose, make sure the Use for Consignment checkbox is selected. This is a critical validation point, because only warehouses with that setting can be chosen as destination warehouses on your consignment orders. Remember, in this workflow your standard warehouses serve as the source of the items, while the consignment warehouse acts as the destination.
Once your warehouses are ready, prepare your customer records. On the Customers screen, go to each client taking part in your consignment program. You can associate a specific consignment warehouse directly with a customer, and this step is vital for accuracy. A warehouse set at the customer level overrides the general default from Sales Order Preferences, so items are always tracked to the right location for that specific partner.
Phase three: process validation and user access
Before you let your team process live transactions, you need to validate the workflow and make sure everyone understands the specific triggers the system requires. A key training point for your staff is the shipment confirmation process. Unlike a standard sale, a consignment shipment needs a second action to move the inventory. Confirm that users know how to find and use the Update Inventory button, under the Actions menu, once a shipment is confirmed.
You should also validate that the system is automating the background tasks correctly. When that Update Inventory action runs, verify that Acumatica automatically generates and releases a transfer-type purchase receipt. That's the mechanism that issues items out of your main warehouse and receives them into the consignment warehouse. If this step is missed, your inventory valuation and quantities won't reflect the stock actually sitting at the customer's site.
Phase four: testing and go-live readiness
The final stage is end-to-end testing of the two most common post-shipment scenarios: selling and returning. First, create a test consignment order and move it to a Consignment, or Partial Consignment, status. At that point, verify that the Consignment Sell Items and Consignment Return Items buttons are properly enabled in the Actions menu.
Perform a test sell to make sure the item selection window correctly shows the available open quantities, and confirm that selecting an item and adding it generates a consignment invoice order. For returns, follow the same steps to make sure a consignment return order is created, and that the Update Inventory action on that return correctly updates your balances.
As a final readiness check, we recommend configuring your physical inventory types for consignment stock. On the Physical Inventory Types form, confirm you have a type created with the Consignment Inventory Count checkbox enabled, so you can count stock held at customer locations. And verify that the system calculates the book quantity by summing the open quantities from your active consignment orders, so when you reconcile, you're billing the customer accurately for any variances found during the count.
The bottom line
The single most important takeaway for go-live readiness is that consignment success depends on the smooth transition of statuses, from open, to consignment, and eventually to closed once every item is either sold or returned. If your configuration and data preparation follow this checklist, you'll have the visibility you need to manage your distributed inventory with confidence.
For more on optimizing your Acumatica experience, or to see a live walkthrough of these steps, visit biz-techservices.com for a demo.
How to Set Up ServiceTitan in Acumatica
How to Set Up ServiceTitan in Acumatica
Managing a field service business is a constant balancing act. You have your team out in the field using ServiceTitan to deliver great customer service, and your back-office team working in your Enterprise Resource Planning system, or ERP, which is Acumatica. The real-world problem many businesses face is the data gap between these two worlds. When your systems don't talk to each other, you're stuck with manual data entry, missed invoices, and inventory numbers that never quite match up.
At Biz-Tech Services, we know your time is better spent growing your business than double-checking spreadsheets. That's why we built a seamless integration. In this guide, we'll walk you through the initial setup and connection, to get your ServiceTitan data flowing into Acumatica correctly.
The foundation: the ServiceTitan Store
The most important thing to understand is that the entire integrator rests on one foundation: the ServiceTitan Store setup. Before you can import a single invoice or sync a vendor, you have to configure the Store in Acumatica. If this isn't set up correctly, the system simply can't work.
The Store setup is the brain of the integration. It controls everything, from how customers are created to how your warehouses and branches are mapped. To get started, you use the Connection Settings tab to enter your API credentials, and then the Test Credentials feature to confirm Acumatica is successfully talking to ServiceTitan. Once the connection is live, you assign a store code and a description so you can easily identify it.
Mapping your financials and business units
Once the connection is established, you make sure the money lands in the right place. That starts with mapping your General Ledger accounts, often shortened to GL. You tell the system exactly which GL accounts in Acumatica should correspond to your activities in ServiceTitan.
Next comes your organizational structure. Your business likely uses different business units in ServiceTitan to track different types of work, and you map those business unit IDs directly to your Acumatica branches. This makes sure every transaction is attributed to the correct part of your company. You also map your terms, which tells Acumatica how to handle payment timing and due dates based on your ServiceTitan settings.
Managing customers and vendors
A big benefit of this integration is that you don't have to create the same customer twice. In the Store settings, you turn on the Import Customer option, and the system automatically creates a new customer in Acumatica if one doesn't already exist. You can even set it to override the billing and shipping addresses, so the most current information from the ServiceTitan invoice is what stays in your ERP.
The same logic applies to the people you buy from. By turning on the Import Vendor option, the system can generate your ServiceTitan vendors inside Acumatica. You can let it create them automatically, or manually map your existing ServiceTitan vendors to your current Acumatica vendor list.
Inventory, warehouses, and trucks
For field service companies, inventory is often the hardest thing to track, and the integrator simplifies it by mapping your pricebook items. When you turn on the Import Item option, the system can generate stock and non-stock items in Acumatica automatically. As a rule, your materials and equipment from ServiceTitan become stock items, while your services are created as non-stock items.
But where is that inventory located? You handle that through warehouse mapping. You take your ServiceTitan warehouse and truck IDs and map them to specific Acumatica warehouses. That way, when a technician pulls a part off a truck, the integrator knows exactly which warehouse inventory to adjust in your financial records.
The workflow: invoices, payments, and purchase orders
With the foundation built, you can look at the actual flow of work. When you turn on the invoice and payment options, you gain a lot of control. You can import invoices with specific statuses, or filter them by date. And if you activate payment, the system imports the payment information along with the invoice. In many cases, when an invoice and its payment are both ready in ServiceTitan, they come in together, and the payment is automatically applied to the right invoice in Acumatica.
There's one important rule to remember about purchase orders, or POs. In this ServiceTitan connector, you can't import a receipt or a bill unless the related purchase order has already been imported into Acumatica. The system is built to keep a clean paper trail. When you import the PO first, it can then attach any later receipts or bills to that specific order, so your PO history is always accurate.
Finally, for businesses that prefer a different accounting method, there's a journal entry option. If you choose not to activate the full invoice import, you can instead bring your ServiceTitan data in as journal entries, posted directly into the General Ledger.
The bottom line
The most important thing to remember is that the ServiceTitan Store setup is the foundation of the entire ServiceTitan integrator. Get the mapping right here, and your data flows seamlessly from the field into your books.
Setting this up correctly the first time saves hundreds of hours of manual correction later. If you're ready to stop chasing data and start growing your business, we're here to help. Visit biz-techservices.com to schedule a demo and see this ServiceTitan connector in action.
How to Set Up Salesforce in Acumatica
How to Set Up Salesforce in Acumatica
Every day, your business relies on two powerhouses: Salesforce for your Customer Relationship Management, or CRM, and Acumatica for your Enterprise Resource Planning, or ERP. But when these two systems aren't talking to each other, your team is stuck manually moving data between sales, finance, and inventory. That gap leads to slow order processing, outdated customer information, and missed opportunities. At Biz-Tech Services, we designed our integration to bridge that gap, giving you real-time synchronization so everyone in your organization makes decisions from the same up-to-date information.
Let's walk through how to set up this connection step by step, so you can start seeing a unified view of your business.
Connecting the systems
The heart of the integration is a screen we call the Salesforce Store. Think of it as your central hub, where you define exactly how data flows between the two platforms.
Your first step is to establish the secure connection in the General Info tab. Here, you enter your Salesforce instance address and your API credentials, including your username, password, client ID, and client secret. Once those are in, there's a Test Credentials button that gives you immediate feedback on whether the connection is valid.
Configuring your order flow
Once the connection is live, you tell Acumatica how to handle incoming sales for SalesForce Integrator. In the Order Settings tab, you define the default order type and the warehouse for every order that comes in from Salesforce.
One of the most important parts of this setup is how you handle taxes. You can use an external tax calculation service, like Avalara, or you can map the system to import taxes exactly as they were calculated in Salesforce.
To keep your shipping and payment data clean, you use cross-reference options. These let you link specific values from Salesforce, like a FedEx Ground shipping method, to the matching ship-via code in Acumatica. That way, when an order arrives, Acumatica knows exactly how to process it without manual intervention.
Managing customers and products
A successful SalesForce integration means your customer data is always in sync. In the customer information section, you decide whether the system should automatically create a new customer record in Acumatica whenever a new order is imported. If you enable that, it pulls in the email, contact info, and customer class automatically.
If you already have a large database in Acumatica, you can use the Export Salesforce Customers screen to push those records into Salesforce as accounts. If a customer has a primary contact, that person is created as a contact in Salesforce at the same time. And you can always confirm a record is linked by looking for the Salesforce Account ID right on the customer screen in Acumatica.
Next, your inventory. Under item settings, you can have the system create new items in Acumatica based on your Salesforce products. It uses the Salesforce product SKU to find a matching inventory ID in Acumatica, and you can even automate unique product IDs with a predefined numbering sequence.
Setting prices and discounts
To keep your sales team accurate, you need consistent pricing. The Price Book Details tab lets you load your Salesforce price books directly into Acumatica. From there, you use the Export Salesforce Price Books screen to add products to a price book or update list prices. Just remember that items must be in your standard price book before they can be added to any custom one.
Promotions are handled through the Export Salesforce Discounts screen. You can create or update discount codes in Acumatica and sync them to Salesforce as either line-level or document-level discounts. That makes sure the price the customer sees in the CRM matches the final invoice in the ERP.
The daily workflow: import and two-way sync
With everything configured in SalesForce Connector, your team uses the Import Salesforce Orders screen. You select a date range, hit Get Orders, and you see all the pending sales. You import them one by one or all at once, turning those Salesforce opportunities into Acumatica sales orders instantly.
The real beauty of this integration is that it's bidirectional. If you need to update a shipping address, add a new line item, or change a discount code in Acumatica, you use the Sync Orders to Salesforce screen to push those changes back to the CRM. That keeps your sales reps informed about the status and final details of every deal.
Visibility across the business
The ultimate goal of this setup is total visibility. Through the Salesforce Orders inquiry screen, your finance team can see the original Salesforce order details, while your sales team can see the resulting Acumatica sales order number and status, without leaving their preferred environment. We even sync internal notes from Salesforce into the Acumatica sales order, so no piece of communication is lost through SalesForce Connector.
The bottom line
The one clear takeaway is that automation eliminates the manual gaps that slow your business down. By following these setup steps, you make sure your sales and finance teams are always working in perfect harmony.
If you're ready to see how this integrator can transform your workflows, visit biz-techservices.com to schedule a live demo. We look forward to helping you connect your business for growth.
How to Set Up PayPal in Acumatica
How to Set Up PayPal in Acumatica
Send PayPal invoices, track payment status, and reconcile — all from inside Acumatica. Generated in NotebookLM from the product PDF.
Managing payments shouldn't feel like you're playing a game of tag between two different systems. For many businesses, the gap between their cloud Enterprise Resource Planning software, or ERP, and their payment processor is a source of constant manual data entry and human error. You end up jumping back and forth between Acumatica and the PayPal portal just to see whether a customer has paid.
At Biz-Tech Services, we designed the PayPal Integration to bridge that gap. It lets you send PayPal payment invoices directly from Acumatica, monitor payment status in real time, and update your records automatically when money is received. Let's walk through how to set it up.
Preparing your tools
Before we dive into the software, your business needs a few things ready. First, you must have a PayPal Business account, because personal accounts don't support the Application Programming Interface, or API, that invoicing requires. You'll also need your PayPal API application credentials, specifically your Client ID and your Client Secret.
To find these, log in to the PayPal developer website and create a new application under My Apps and Credentials. That's where you copy your ID and Secret, for either a testing environment, known as a Sandbox account, or your live production account. Inside Acumatica, make sure the Accounts Receivable, or AR, and Sales Orders modules are active, since those are the primary areas where the integrator lives.
Connecting the payment method
The first major step is telling Acumatica how to talk to PayPal, and we do that by creating a dedicated payment method. On the Payment Methods screen, you create a new record and give it a clear description, like PayPal. The most important part of this step is selecting PayPal in the Means of Payment field.
Once you do that, a new PayPal Settings tab appears. This is where you paste the Client ID and Client Secret you gathered earlier. You also enter the base web address for the PayPal API, which is the Sandbox address if you're still testing, or the production address for live business transactions.
We recommend using the Test Connection button right away, to verify your credentials are accepted. Finally, add the specific cash or bank account where these PayPal payments should be posted, on the Allowed Cash Accounts tab.
Linking your customers
Now that the bridge is built, you tell the system which customers will use it. Each customer who plans to pay by PayPal needs a customer payment method configured.
When you open a customer record and go to their payment methods, you add the PayPal method you just created. The critical piece here is the PayPal customer email address. That's the exact address where PayPal delivers the digital invoice. The system pre-fills this email on new payments for that customer, and you can override it for a one-off if you need to.
Sending your first payment request
With the setup complete, you can start sending payment requests. We've built three ways to do this, depending on your workflow.
The most common way is from a sales order. If your business collects payment before shipping, you open the order and use the Create Payment button. Once you add the cash account and a payment reference, a Request PayPal Payment button appears. When you select it, the system automatically creates an Accounts Receivable payment record, sends the invoice to the customer, and puts the payment on hold with a status of Sent.
You can also send requests directly from an invoice, if you've already billed the customer after a shipment, or from the Payments and Applications screen, for standalone deposits that aren't tied to a specific document. In every case, the customer receives a PayPal email with a link to pay, and they can even use guest checkout if they don't have a PayPal account themselves.
Managing the payment lifecycle
Acumatica doesn't just send the link; it mirrors the state of each invoice from PayPal. It's worth remembering that Acumatica checks PayPal on demand, rather than constantly in the background. When you want to check the status of a payment, you select the Remove Hold button on that payment record. The system then calls the PayPal API and updates the status. If the customer has paid in full, the status moves to Paid, and the payment is released in Acumatica automatically.
Partial payments, cancellations, and refunds
The integration handles the what-ifs too. If a customer makes a partial payment, PayPal connector notifies the system of the amount received. Acumatica stores that partial amount and keeps the payment on hold, letting the customer use the same link to pay the remaining balance later, and the payment is released in full only once the whole balance is collected.
If you need to cancel an invoice before it's paid, there's a Cancel PayPal Invoice button that alerts the customer and removes the record in Acumatica, to keep your books clean. By removing the unpaid Payment, the integrator updates the Payment Status in PayPal as well.
For refunds, you use the standard Void Check or Refund actions in Acumatica. We recommend handling all refunds this way, because the integration automatically tells PayPal to return the money to the customer, while at the same time voiding the payment in your Accounts Receivable records.
Streamlining your reconciliation
To stay on top of everything, we've included a Check PayPal Payment Status processing screen. This is your central hub for daily reconciliation. Instead of checking payments one by one, you can see every outstanding PayPal-linked payment in a single grid. You can filter by status, like Partially Paid, and process them all at once to synchronize your records with the latest data from PayPal.
The bottom line
The clear takeaway is that by connecting your payment processor directly to your ERP, you create a single source of truth for your finances, and you cut out the guesswork and manual entry that slow you down.
If you're ready to see how this integration can transform your billing process, visit biz-techservices.com today to request a full demo.
How to Set Up CommerceHub in Acumatica
How to Set Up CommerceHub in Acumatica
Connect the CommerceHub retail network to your ERP with a secure, automated file exchange — generated in NotebookLM from the product PDF.
Scaling your business often means partnering with major retailers like Costco, Home Depot, or Lowe's. These partnerships are a massive win for your growth, but they bring a heavy administrative burden. Managing hundreds of orders, tracking shipments, and keeping inventory accurate across different platforms can quickly become a manual nightmare. You need your e-commerce operations to talk directly to your back-office system. We designed the Biz-Tech Services CommerceHub Connector for Acumatica to bridge that gap.
In this article, we are going to walk you through the initial setup and connection process. This is the foundation of your integration, ensuring that data flows smoothly and securely between your partners and your Acumatica Enterprise Resource Planning, or ERP, system.
Understanding the SFTP connection
The first thing to understand about CommerceHub is how it handles data. Most modern connectors use an API, or Application Programming Interface, for direct communication. However, CommerceHub integrator is unique because it primarily uses SFTP, which stands for Secure File Transfer Protocol.
Think of SFTP as a secure digital post office. Instead of sending messages back and forth instantly, the systems write information into text files. These files are then uploaded to or downloaded from a secure server. To make this work, we use a tool called FileZilla to manage these transfers. In your Acumatica workspace, our connector acts as the engine that reads these files and turns them into actionable data.
To start the setup, you go to the Mappings screen. This is where you configure the connector's behavior and define how it should talk to the outside world. You enter your CommerceHub SFTP credentials, including the host address, the port (which is typically twenty-two for secure transfers), your username, and your password. Once those are set, you define the specific paths where the connector should look for files to import, and where it should place files for export.
The power of store codes
Once your connection is established, we need to talk about store codes. Store codes are the heart of the CommerceHub integration, because they let you manage distinct configurations for each of your retail partners.
Your business doesn't treat a Costco order exactly the same way it treats a Michaels order, and with store codes you don't have to. Each store can be set up with its own unique parameters. You can define a specific transaction type, a description, and even assign a default customer in Acumatica for that retailer. This level of customization means that when an order comes in, it already fits the specific requirements of that partner.
Mapping your items
For the integration to work, Acumatica needs to know that the item named in a CommerceHub file is the same item sitting in your warehouse. We handle this through the cross-reference tab.
On this screen, you map your Acumatica inventory IDs to the specific item IDs used in the CommerceHub files. This makes sure that when you import an order, the system identifies the products correctly. Without this mapping, the automation would stop in its tracks. We also provide an inventory template screen, where the items you select are marked for synchronization, so you can export accurate quantities back to your retailers.
Managing your data files
Now that the foundation is laid, the connector manages several types of files to keep your business moving.
First are the purchase order files. The Import Purchase Orders screen pulls orders from CommerceHub into Acumatica. While these orders come in under a default customer, the connector is smart enough to override the address information with the actual shipping address from the order.
Next are the acknowledgement files. Once an order is created in Acumatica, it sits in an open status, waiting to be acknowledged. You use the export screen to send a purchase order acknowledgement back to the retailer, letting them know you've received and accepted the order.
As you fulfill those orders, the system handles shipment and invoice files. The Export Shipment screen finds every order with a confirmed shipment status and prepares that data for CommerceHub. And the Export Invoices screen sends your billing information once an order has been invoiced or released in your system. The integrator contains a similar Export CommerceHub Shipment processing screen for Shimpents.
Finally, there is the inventory file. You can choose to export your on-hand, available, or available-for-shipment quantities. This keeps your retail partners updated on exactly what you have in stock, which prevents overselling.
Handling errors and failed files
Even with a great system, data issues happen. Maybe a file was formatted incorrectly, or an item ID was missing. We've built in two specific places to help you manage this.
The first is the CommerceHub Errors screen. This is a central log where you can see every error message received from CommerceHub across all processes. It gives you the date, the order number, and a detailed message, so you can resolve the issue quickly.
The second is the Import Failed Purchase Orders screen. If an order fails to import during the normal process, it doesn't just disappear. It moves here, where you can review the failed attempts, fix the underlying issue, like a mapping error, and then process them again, so no order is ever lost.
The bottom line
Setting up your CommerceHub integration correctly means moving away from manual data entry and toward a secure, automated file exchange that treats every retail partner with the specific attention they require. By mastering your SFTP connection and your store code configurations, you turn a complex retail requirement into a smooth part of your daily workflow.
If you'd like to see how the CommerceHub Connector can transform your e-commerce operations, visit biz-techservices.com today to request a full demo.
How to Set Up EZCom EDI in Acumatica
How to Set Up EZCom EDI in Acumatica
Generated by NotebookLM from the EZCom Connector documentation — narrator-ready.
Imagine your business is finally landing those massive contracts with national retailers. This is the growth you have worked for, but it comes with a hidden cost. Your office team is suddenly drowning in manual work. They are logging into customer portals, copying order details into your system, and manually updating inventory counts. This manual data entry is slow, expensive, and one small typo can lead to a rejected shipment or a frustrated customer. This is the real-world problem that Electronic Data Interchange, or EDI, is designed to solve.
At Biz-Tech Services, we believe your Enterprise Resource Planning system, or ERP, should be the heart of your operations. That is why we built the EZCom Connector. This integrator creates a seamless bridge between the EZCom EDI platform and Acumatica. The connection is managed by an intermediate server that we control to ensure your data flows accurately and securely. Let's walk through how to set up this connection step by step so your business can stop typing and start growing.
Installing the Framework
The journey begins with bringing the integrator into your Acumatica environment. To do this, you will use the Customization Projects form. This is the workspace where you add the deployment package we provide.
Once the package is uploaded, you must perform a document validation. This is a critical step where the system checks the new files against your specific version of Acumatica to ensure everything is compatible. After a successful validation, you publish the project. This finalizes the installation and adds the new EZCom menu and screens to your workspace.
Establishing the Connection
Now that the software is in place, you need to tell it how to talk to the outside world. Navigate to the General Settings screen. This is where you configure your Application Programming Interface, or API, connectivity. An API is essentially the language the two systems use to communicate.
Inside the settings, you will enter your account information, your unique API Key, and your EZCom administrative credentials. To make sure the bridge is working, use the Test Credentials action. The system will attempt to reach the Biz-Tech intermediate server and verify your account. If it passes, your system is ready to exchange data.
Configuring Your Trading Partners
In the world of EDI, your customers are known as Trading Partners. Every partner has different requirements, so you must define the rules for each one. On the Trading Partners screen, use the action to retrieve your full list of partners directly from EZCom.
For each partner, you will choose a default Order Type for the Sales Orders that the system will create. You also select which EZCom Statuses should trigger an import. Mapping your inventory is the most important part of this step. Under the Inventory Items tab, you link your internal Acumatica IDs to the codes your customer uses, such as a Universal Product Code, or UPC. If you do not map these items correctly, the system will trigger an error during the import process because it won't know which product is which.
Managing Inbound Orders and Changes
With your partners configured, you can begin processing transactions. It starts with the Purchase Order, or PO. On the Import Purchase Orders screen, you can fetch orders for specific partners or for everyone at once. Once the list appears, you can choose to import specific orders or use the Import All function to bring them all into Acumatica as Sales Orders.
Business is rarely static, and customers often modify their orders. If a partner changes an order on the EZCom platform after you have already seen it, you can use the Import Changed Purchase Orders screen. This ensures your records stay accurate without any manual intervention.
Acknowledgements and Routing
Once you have an order, your partner needs to know you have accepted it. This is handled through a Purchase Order Acknowledgement, or PO Ack. When you send a PO Ack from the dedicated outbound screen, the system updates the status in EZCom and automatically changes the status of the Sales Order in Acumatica to Closed.
If your shipment requires specific carrier instructions, you can send a Routing Request to tell the partner the goods are ready. When the partner responds, you simply import the Routing Response. The system will then automatically update your shipment with the correct carrier and service details based on the rules you have set up.
Warehouse Integration and Fulfillment
If you use an external warehouse, the integratior keeps them in the loop too. You can send a Warehouse Order that includes item quantities and UPC codes directly to your fulfillment center. When the warehouse ships the goods, you can import the Warehouse Shipment details. This automatically brings tracking numbers and final quantities back into your Acumatica shipment record, saving you from more manual data entry.
The final step in the cycle is telling the customer the goods are on the way and the bill is ready. You can automate this so that Outbound Shipments and Outbound Invoices are sent the moment you process them in Acumatica. If you prefer more control, you can use the dedicated outbound screens to review and send these documents manually.
Your Path to Automation
The one clear takeaway from this process is that integration is the enemy of error. By taking the time to validate your documents and map your items correctly, you turn a complex web of retail requirements into a smooth, automated workflow.
If your team is spending more time typing than they are selling, we can help. Visit us at biz-techservices.com today to schedule a demo of the EZCom Connector and see how we can streamline your business.
How to Connect DSCO to Acumatica
How to Connect DSCO to Acumatica
Link the Dsco retail network to your ERP so orders flow in and acknowledgements, shipments, and invoices flow back — automatically.
Selling through retailers means moving fast
If you sell through major retailers, there's a good chance your orders come through DSCO Connector. It's the network that connects suppliers like you to the retailers you sell through, passing orders one way and acknowledgements, tracking, and invoices back the other. The catch is the pace. Retailers expect quick acknowledgements and accurate, on-time shipping, and doing all of that by hand between Dsco and Acumatica is slow and risky.
The Biz-Tech Dsco Connector takes that pressure off. DSCO Integration with Acumatica handles retail orders flow in, and acknowledgements, shipments, and invoices flow back automatically. Let's walk through how you connect them.
Step one: enter your DSCO credentials
Setup starts with credentials. Once the connector is installed, a DSCO Integrator workspace appears inside Acumatica. On the Dsco Store screen you enter your connection details, which are your DSCO access token and the base web address for the Dsco service, and then you press Test Credentials. When the connection succeeds, your store is linked and you can set how everything should behave.
Setting up how orders come in
First, you decide how incoming orders are handled. You choose whether each DSCO order becomes a sales order or an invoice in Acumatica, set a default order type, and pick which Dsco order statuses to bring in. You can also decide whether orders should be treated by DSCO Integrator as automatically acknowledged, or whether you'll send the acknowledgement yourself, which matters because retailers watch that step closely.
Mapping items and warehouses
Next you connect the pieces the two systems share. The most important is item matching. In the inventory cross-reference, you tell the integrator how to find each product, usually by its SKU, and link it to the right Acumatica inventory item. You also map your Dsco warehouses to your Acumatica warehouses, so orders pull from the right stock and nothing errors out. You can also pick a default customer to stand behind these orders, so each one is booked correctly even though it arrives from the retail channel rather than a named buyer. And you set up your cancellation reason codes in advance, so they're ready the moment you need them.
The order flow: acknowledge, ship, invoice
With setup done, the order flow runs cleanly. You get and import your Dsco orders, in bulk or one at a time. If you didn't set them to auto-acknowledge, you send the purchase order acknowledgement back to Dsco to confirm you've received the order. When you ship, the connector sends the shipment confirmation to Dsco and sets the tracking number on the order. And when you release the invoice, it sends the invoice across and moves the Dsco order to shipped. Every step the retailer is waiting on happens on its own. Throughout, the order carries its Dsco status with it, so you can always see whether it's been acknowledged, shipped, or invoiced, and refresh it from Dsco if anything changes on the retailer's side.
Handling cancellations
Cancellations are covered too. If you need to cancel a whole order via Export Dsco Canceled Orders screen, or just a single line, you do it right from the sales order and choose the matching DSCO cancel code. The integration then sends the cancellation to DSCO for you, so the retailer's system stays accurate and in step with yours. You can use the Export Dsco Order Item Canceled screen to cansel a single item of order or cansel all the orders to automatically cansell the whole order.
Keeping inventory current
And to keep retailers from ordering what you don't have, the DSCO Integration allows to keep your inventory current in DSCO. It sends your Acumatica quantities up to DSCO, using the combined total across the warehouses you choose and the measure you prefer, like on hand or available, so the stock they see is the stock you actually have. You can let it publish your live Acumatica quantity automatically, or set a specific number to send, which gives you control when you want to hold some stock back.
The bottom line
Once it's connected, DSCO Connector and Acumatica work as one. Retail orders flow in, and acknowledgements, shipments, invoices, and inventory all flow back without anyone re-keying a thing. Your team hits the retailers' deadlines without the manual scramble.
If you'd like help connecting your own Dsco account, the team at Biz-Tech Services does exactly this. Visit biz-techservices.com to book a walkthrough and see your Dsco orders flow straight into Acumatica.
How to Connect ShipStation to Acumatica
How to Connect ShipStation to Acumatica
Link your shipping platform to your ERP so orders flow out for fulfillment and tracking flows back automatically.
Great at shipping, blind to your ERP
If you ship a lot of orders, you probably love ShipStation. It pulls orders from all your sales channels, finds the right carrier, prints labels and packing slips in batches, and emails tracking to your customers. What it doesn't do on its own is keep your ERP in the loop. So someone ends up re-keying orders and tracking numbers between ShipStation and Acumatica by hand.
The Biz-Tech ShipStation Connector removes that step. It links the two systems so orders flow to ShipStation for fulfillment, and shipments and tracking flow back into Acumatica automatically. Let's walk through how you connect them.
Step one: install the package and connect
Setup begins by installing the ShipStation customization package in Acumatica, which adds a ShipStation workspace and the screens you'll use. From there you open the ShipStation Store screen and enter your connection settings, which are your ShipStation consumer key, your consumer secret, and your web address. Then you press Test Credentials, and when the connection checks out, the two systems are linked.
Choosing your direction
Next you choose the direction the integration runs. In one mode, ShipStation to Acumatica, ShipStation is where orders live, and the connector imports those orders, and their shipments, into Acumatica. In the other, Acumatica to ShipStation, your Acumatica orders are sent out to ShipStation to be shipped. If you pick that second direction, you also choose where the shipment itself is created, in ShipStation or in Acumatica, so the workflow matches how your team works.
Bringing orders in from ShipStation
If you're pulling data in from ShipStation, you start by retrieving your connected stores and choosing which one to import from. Then you map ShipStation's order statuses to Acumatica's, so only the orders you want, like the ones already shipped, come across. You decide how those orders are classified in Acumatica, whether their shipments come in along with them, and how customers and items should be handled. The Integration Option on Shipstation Store screen should be selected as Shipstation to Acumatica to be able to see any records on Import ShipStation Orders screen.
Setting up the shipping side
If you're sending orders out to ShipStation instead, you set up the shipping side. You pull in your carriers and their services directly from ShipStation, choose the package types you use, and line up your ShipStation warehouses. And in both directions, you map your shipping methods, your ship-vias, between the two systems, so every order goes out by the right method.
Shipments and tracking, handled automatically
Then comes the part that saves the most time. When an order is shipped, the connector brings the shipment back into Acumatica and attaches the details, including the shipment number and the tracking number, to the right order, then moves it forward to the invoicing stage. If you'd rather drive it from Acumatica, you can create the sales order and shipment there, confirm it, and the connector creates the matching order and shipment in ShipStation, tracking number and all.
Processing the record in Import ShipStation Shipment screen, will add the package data on Shipmnent document.
Keeping ShipStation's automation
And because ShipStation integrator is still doing the shipping, you keep everything it's good at. Batch label printing, carrier rate shopping, and its automation rules all keep working, while Acumatica stays perfectly in step. You get the best of both worlds: powerful, automated shipping, and an ERP that always reflects what actually went out the door.
The bottom line
Once it's connected, ShipStation and Acumatica work as one integration. Orders flow out for fulfillment, tracking flows back to your books, and your team stops copying numbers between two screens. The shipping stays fast, and the records stay accurate.
If you'd like help connecting your own shipping operation, the team at Biz-Tech Services does exactly this. Visit biz-techservices.com to book a walkthrough and see your ShipStation shipments flow straight into Acumatica.
