How Magento Data Flows into Acumatica ERP

How Magento Data Flows into Acumatica ERP

Magento data flows into Acumatica ERP through a connector that retrieves orders from your Magento store, imports the selected orders as Acumatica documents, and then generates fulfillment events back in Magento once the resulting shipments are confirmed. Everything else the Biz-Tech Services Magento Acumatica integration does, customer creation, payment handling, tax defaults, item creation, inventory quantity updates, and refund processing, hangs off that same inbound-then-outbound path. Understanding the order in which records move is the fastest way to know which setting to change when something does not arrive where you expect it.

The product described here is the Biz-Tech Services Magento Connector for Acumatica ERP, built by Biz-Tech Services, Inc. It links Magento, the e-commerce platform, with Acumatica, the enterprise resource planning system, using connection settings entered in Acumatica and an Application Programming Interface, or API, connection to your store. This article walks the data flow in the order records actually travel: setup and credentials first, then inbound orders, then the customer, payment and tax decisions made during import, then outbound fulfillment, then item and inventory synchronization, and finally where errors surface and what a user checks to confirm the result.

What the Magento Connector for Acumatica Does

The Biz-Tech Services Acumatica Magento Connector is an Acumatica ERP customization that connects a Magento e-commerce store to the back office so that the two systems share orders, customers, and item data. The Biz-Tech Services Acumatica Magento integration requires connection settings on the Magento Store screen. Based on those settings, the Biz-Tech Services Magento Acumatica connector reaches the corresponding store and retrieves orders, and imports the selected orders into Acumatica ERP. When a user confirms the shipments created from those imported orders, fulfillment events are generated in the store for each corresponding order. The Biz-Tech Services Acumatica Magento Integrator also requires default options and the required values for the order import process, which is why the configuration screens matter as much as the processing screens.

The Biz-Tech Services Acumatica Magento integrator is delivered as an Acumatica customization project and is installed from the Customization Projects form, screen ID SM204505. That form is where you add the project, validate it, and publish it for a tenant, and it is also where the publication can later be cancelled or the project exported as a deployment package. The Biz-Tech Services Magento Acumatica integrator must be installed on an Acumatica system carrying one of the following licenses: PCSR, PERP, or SAAS.

The Magento Data Flow at a Glance

Before looking at individual fields, here is the whole path a record travels between the two systems:

  • Credentials are entered and tested on the Magento Credentials screen, where Store Code, Description, Default Store, Username, Password, and Base URL define the connection, and Test Credentials confirms that Acumatica can reach the store through the API.
  • The Magento Store screen holds the configuration that determines the overall functionality of the Biz-Tech Services Acumatica Magento integrator: order import, item import and creation, payment processing, customer management, shipping options, and warehouse settings.
  • Get Orders on the Import Magento Orders screen retrieves the orders, and the processing grid lists only those that hold a qualifying status in the store.
  • Import or Import All creates the Acumatica document defined by Import Magento Orders To and Order Type, applying the customer, payment, tax, discount, item, and warehouse defaults configured on the store screen.
  • The Magento Orders screen records the imported order and links it forward through the Sales Order Number and Invoice Number fields, so a user can trace an order into the Acumatica document chain.
  • Fulfillment runs in Acumatica, and confirming the shipment generates the fulfillment event in Magento, with the Prepare Invoice and Release Invoice steps governed by their own skip and quantity-check settings.
  • Outbound item processes push items, product images, inventory quantities, multi-prices, categories, and publication status from Acumatica to Magento, while the matching import processes pull items and multi-prices back the other way.
  • Refunded orders are retrieved separately on the Import Magento Refunded Orders screen and processed into Customer Refund payments or credit memos depending on how far the original order has progressed.

Each setting discussed below sits at one of those handoffs, which is why a change on the Magento Store screen can alter the outcome of a process run several screens later.

Stage One: Magento Credentials and the Connection to Your Store

Setup begins on the Magento Credentials screen, which is where users set up the credentials that connect the two platforms and make the Biz-Tech Services Magento Acumatica integration between them possible. Store Code functions as a lookup field that identifies the corresponding store, and Description is used to provide a description of that store. Because the connector supports more than one store record, the Store Code is the value that every downstream processing screen uses to decide which store it is talking to.

Selecting the Default Store checkbox marks the store as the default store. This matters more than it looks: on processing screens where a Store Code has to be chosen before anything is retrieved, a default store removes a repeated selection step and reduces the chance of running a process against the wrong store.

What the Connection Settings tab controls

Username, Password, and Base URL are the Magento system credentials used to configure the connection settings. The information specified on the Connection Settings tab is used to test the ability of the system to connect to the store through the API. Test Credentials tests that connection using the credentials from the Connection Settings tab, so it is the correct first check whenever nothing is being retrieved at all. Edit Credentials allows editing of the store credentials, and Redirect to Store Settings opens the Magento Store screen, which is the natural next step once the connection is proven.

Stage Two: The Magento Store Screen Governs the Whole Flow

The configuration defined on the Magento Store screen determines the overall functionality of the Biz-Tech Services Acumatica Magento Connector. It controls the order import process, item import and creation, payment processing, customer management, shipping options, warehouse settings, and other related operations. Users who treat this screen as a one-time setup task tend to misdiagnose later problems, because most unexpected import results trace back to a checkbox or default value here rather than to the processing screen where the problem was noticed.

Default Import Options: what is retrieved and from when

Get Magento selects which Magento entities to retrieve into the Acumatica system. Import Magento Orders To specifies where the orders are imported in Acumatica, and Order Type is the default type of orders to be created by the Biz-Tech Services Acumatica Magento integration. Together those two fields decide what kind of Acumatica document an order turns into, so they should be settled before the first production import rather than after.

Begin Order Date allows the data retrieval to be filtered, which is how your business avoids pulling the entire order history of the store on the first run. Two read-only companions record what has already happened: Last Imported Order Date is the date when the last order was imported, and Last Refunded Order Date is the date when the last refunded order was imported. Get Refunded Data when Receiving Orders retrieves refunded orders during the Get Order process, so refunds can be collected in the same pass rather than as a separate exercise.

Error notifications during order import

Send Email Notifications for Errors informs the user about any errors encountered during the process. An email notification feature exists for failed orders during the order import process, which ensures that users are promptly alerted if an order import encounters issues or failures. Notifications go to the email address added on the order settings tab. They are sent during batch imports and during process updates for the same order, because the system checks all orders again for the selected period during that process. For a store that imports on a schedule, this notification is the practical difference between finding a failed order the same day and finding it at month end.

Inbound: How Magento Orders Become Acumatica Documents

The Import Magento Orders screen allows users to retrieve and import all orders from the store into Acumatica. It is the main inbound entry point, and it is deliberately a two-step screen: retrieval and import are separate actions, so nothing is created in Acumatica simply because it was fetched.

Retrieving orders with Get Orders

The Get Orders button retrieves orders from Magento. After the button is clicked, a timer indicates the elapsed time until the process is complete, and a user can cancel the process of getting orders by clicking the loading icon next to the timer. The processing page shows only orders that hold the statuses Partially Shipped, on hold, Pending, and Processing in the Magento shop. That status filter is the single most common reason an order that exists in Magento never appears in the Acumatica grid.

The Import button enables the import of selected orders into Acumatica. Alternatively, the Import All button imports all orders displayed on the grid. Selective import is worth using during the first weeks of a go-live, because it lets your business validate the resulting documents order by order before switching to bulk runs.

Reading the Magento Orders screen

When orders are retrieved and displayed on the Import Magento Orders screen, each order carries a hyperlink, and clicking the order number navigates to the corresponding Magento Orders screen. That screen presents the initial status of the order and is the record your business returns to when tracing what happened to a given order.

The screen consists of several tabs. Document Details provides information about the items of the order. Addresses provides details about the customer address. Refund Info becomes visible only if the order has been refunded, displaying the relevant refund information. CC Payment provides information about the credit card payment method.

The header fields are where results are read. Order Number displays the Magento order ID. The Magento order status reflects the initial state of the order upon import. Status displays the Magento order status inside Acumatica. Payment Method displays the payment method used for the order, and Ship Via indicates the shipping method used. Sales Order Number displays the sales order number of the order once it is imported, and Invoice Number displays the invoice number once the order is invoiced. Those two fields are the link between the e-commerce record and the Acumatica document chain.

The amount fields complete the picture: Total Lines Amount displays the total sum of item lines, Discount Total displays the discount total for the order, Shipping Total displays the total amount of shipping, Total Tax displays the tax total, and Total shows the order total including taxes and other charges.

The three actions on the Magento Orders screen

Refresh Order updates the Magento order status in Acumatica. This matters because the status stored at import time is the initial state; if the order is later fulfilled in Magento, opening the actions menu and clicking Refresh Order updates the status of the order to match the store. Receive Orders enables the retrieval of individual orders into Acumatica by choosing the store code and setting the order ID, which is the targeted alternative to a full Get Orders run. Import Order, when selected on the corresponding Magento Orders screen, displays a confirmation popup asking whether you want to create a sales order for that order in Acumatica.

Customers, Payments, Taxes, and Discounts During Magento Order Import

The decisions the Biz-Tech Services Acumatica Magento integrator makes while an order is being imported are all configured on the Magento Store screen. These are the settings that determine whether a customer record is created, whether a payment document is produced, which tax defaults are applied, and how discounts land on the resulting Acumatica document.

Customer Information options

Import Customer means the Biz-Tech Services Magento Acumatica integration imports the customer information from Magento into a new customer record in Acumatica. Customer Class is the default customer class set on new customers that do not exist in Acumatica and are created by the Biz-Tech Services Acumatica Magento integration, so it is the field that decides which account and terms defaults a new web customer inherits.

Override Ship Address Information imports the address information of the location the order is going to be shipped to from Magento, and Override Bill Address Information imports the address information of the party who will pay the bill of the order from the store. Notify Customer for Shipment Confirmation means the Biz-Tech Services Magento Acumatica integrator notifies the customer when the order is shipped, if the checkbox is selected. Use Default Group ID allows a default group ID to be selected for the customer sync process, and Default Password for Customers allows a default password to be selected for the new customers being created in Magento.

Payment Options

Skip Magento Payment, when selected, means the order is imported from Magento without payment. That is the right choice when payment capture is handled entirely outside Acumatica. Payment Method is the payment method set on the payment during the order import process, and Payment Type is the type of payment that determines the payment type of the imported order. Release Payment during Order Import releases the payment during the Magento order import process, which removes a manual step but also commits the payment document immediately, so it should be enabled only once the mapping is proven.

Use Credit Card Payment, when selected, displays the CC Payment Mapping tab on the Magento Store screen, allowing the user to configure the corresponding mapping for the credit card payment method used for the order imported into Acumatica. The result of that mapping is what a user later reads on the CC Payment tab of the Magento Orders screen.

Tax Options

Tax ID is the default tax ID set on the orders. Customer Tax Zone is the combined tax of the effective taxes for a particular zone, defined according to the locations of the vendors or customers. Taxable Category is used to create tax categories, or edit existing tax categories, that are applied to products. Is Freight Included In Magento indicates that freight is being taxed in Magento, which is the setting that keeps the two systems from disagreeing about the tax on shipping.

Discount Option

Calculate Discount On Order Lines determines where discounts appear on the resulting document. When it is selected, the system calculates discounts per line, populating the Discount Amount and Discount Code fields in the Sales Orders Document Details table. Alternatively, the system calculates discounts for the entire order and provides the details in the Discount section. The choice affects reporting as much as data entry, because line-level discount data is what makes margin analysis by item possible.

Outbound: Fulfillment Events Sent Back to Magento

Once a Magento order has become an Acumatica document, fulfillment proceeds in Acumatica and the Biz-Tech Services Magento Acumatica integration reports the result back. When a user confirms the shipments created from the imported orders, fulfillment events are generated in the store for each corresponding order. If Notify Customer for Shipment Confirmation is selected on the Magento Store screen, the Biz-Tech Services Acumatica Magento Integration notifies the customer when the order is shipped.

Two Export Default Options on the Magento Store screen control what leaves Acumatica during invoicing. Skip Magento Shipment while Prepare Invoice means the Biz-Tech Services Acumatica Magento connector does not send a shipment creation request to Magento during the Prepare Invoice process in Acumatica. Skip API Request While Release Invoice means the Biz-Tech Services Magento Acumatica integrator sends no API request at all during the invoice release process. Both are useful when a business deliberately handles shipment records on the store side, and both are worth checking first when an expected update never reaches the store.

Two related item settings guard stock at the same points in the flow. Check Magento Qty While Prepare Invoice validates the product quantities in the store during the invoice preparation process, confirming that the required stock is available before the invoice is created. Check Magento Qty While Release Invoice validates the same quantities during the invoice release process to ensure sufficient stock is available. These checks put the quantity validation at the moment the financial document is created rather than after the fact.

Refunds: How Magento Refunded Orders Are Processed in Acumatica

Import Magento Refunded Orders allows users to import refunded orders from the store into Acumatica. The Get Orders button loads the refunded orders onto the screen, after which they can be imported. The system then manages the refunded order import based on how far the original order has already progressed in Acumatica, which is why the same Process button produces different documents in different situations.

  • Case 1, when the refunded order is a sales order in Acumatica that has not progressed with any fulfillments and consists of a single item: pressing Process generates a payment with a Customer Refund type, attaches it to the Payments tab, sets the refunded amount, and closes the order. The sales order status changes to Canceled and all lines are deleted.
  • Case 1, when the order consists of several items and is refunded: the refunded quantity is reduced from the order quantity, and the system creates a payment document and attaches it on the Payments tab for the refunded items, while the order status remains Open.
  • Case 2, when an order shipment has been created but not confirmed: clicking Process triggers the system to find the created shipment, delete it, and then proceed with the actions of Case 1.
  • Case 3, when an order shipment has been confirmed: clicking Process results in the system creating a credit memo and attaching a reference number with Customer Refund type to the Applications.
  • Case 4, when the invoice is prepared but not released: the system creates a credit memo and attaches a reference number with Customer Refund type to Applications after the refunded order is processed.
  • Case 5, when the invoice is released: the system reverses the invoice and generates a credit memo with a Customer Refund type in the reference number attached to Applications.

After those actions, the Processed checkbox on the Refunds tab is automatically checked on the Magento Orders screen for the corresponding order, which means the process is over and the order is Closed. To verify the financial side, follow the Reference number to view the Customer Refund type payment and the refunded amount on the Application History tab.

Customer Export: Sending Acumatica Customers to Magento

The customer export process can be run from the Customers screen as well as from the Export Magento Customer processing screen. On the Customers screen, the Sync Magento Customer button in the Actions command toolbar performs the customer export. Selecting that action from the Actions command menu is what sends the customer to the store.

The Biz-Tech Services Acumatica Magento connector syncs a customer only if three conditions are met, and each one is a common cause of a customer that silently fails to appear in the store. First, the Customer Price Class, which corresponds to Magento customer groups, must exist in both systems. Second, the customer must have a contact. Third, that contact must have a First Name, a Last Name, an Email, and a Magento Customer Password, and the password must be a mixture of letters, numbers, and special characters.

After the customer export process completes, the Magento Customer checkbox becomes checked on the Customers screen and the Magento Customer ID is added under the Magento Customers tab of the Customers screen. Those two indicators are the confirmation a user should look for rather than assuming the export worked. Customer groups themselves are handled on the Customer Groups tab of the Magento Store screen, where customer groups are synced to the Acumatica Customer Price Class.

Item and Inventory Synchronization Between Acumatica and Magento

Item data moves in both directions, and the Magento Store screen carries the settings that decide what is created, what is matched, and which quantity number is sent.

Item Information settings that govern item creation

If the Import Item checkbox is selected, new items are created in Acumatica during the synchronization of orders from Magento, based on the configured settings. If the checkbox is not selected, the program prohibits the import and creation of items unless the corresponding items have already been created in Acumatica. The system searches for the Inventory CD using the Magento Product SKU. If it is found, the system retrieves that item; if it is not found, an error message is displayed stating that the item does not exist in the system.

Import Item Type specifies the item type that should be created, and Item Class selects the item class for imported items, which groups stock or non-stock items with similar properties and provides default settings for new items. Warehouse ID is the default warehouse set on the orders imported from Magento, and UOM, the unit of measure, is used to quantify the inventory items. Replace Missing Products replaces Magento items that do not exist in Acumatica with a selected item during the order import process, if the Import Item checkbox is disabled, which keeps an order importable rather than blocking it on one unrecognized SKU.

Several further options tune the item side of the flow. Use Bulk Sync Items Functionality syncs one hundred items at once, but only if the RabbitMQ module is set up in the Magento system. Import Items on Inventory Details Tab retrieves items to the Inventory Details tab of the Magento Store screen while orders are being imported. Import Product Images allows images to be synced during synchronization if the item has one attached. Date Last Received Item indicates the last date used for retrieving products, which is the item-side equivalent of the order date trackers.

The Inventory Details tab

On the Inventory Details tab of the Magento Store screen, a user can load the items held in both systems and then sync, publish, or unpublish them in the store. Load Acumatica Items retrieves all Acumatica stock and non-stock items and displays them in the table, and the Load Magento Items button retrieves the store catalog the same way. Sync to Magento exports Acumatica items outward, and Sync from Magento brings items back into the Acumatica system.

The supporting buttons make bulk work practical. Check All selects all the items displayed in the table, and clicking it a second time unchecks them. Get Item retrieves a specified item by item SKU or name. Purge deletes all the items displayed in the table. Publish Items in Magento enables the publication of selected items in the store, setting their status to Enabled, and Unpublish Items in Magento removes the Enabled status from the selected items, making them unavailable for purchase. The item details list can be exported and imported as an Excel document.

When items are synced from Acumatica to Magento, a new item is created there and a unique ID for the item is generated. That unique ID is displayed in the Acumatica Magento store record and on the Magento Inventory tab of the stock item. The processes of item synchronization, item publishing, and item unpublishing can also be carried out on the Stock Items and Non-Stock Items screens, so a user working on a single item does not have to return to the store screen.

Warehouse Details and which quantity is sent

The Warehouse Details tab is where the warehouses whose quantities need to be in sync with Magento are added. If one or more warehouses are selected there, the exported item quantity displays the sum of quantities across the selected warehouses. The quantity that is synced from Acumatica to Magento depends on the selected drop-down value: On hand, Available, or Available for Shipment. That choice is worth deliberating over, because it decides whether your store advertises physical stock or committed-adjusted stock.

The outbound item processing screens

Export Magento Inventory Quantities is the screen for syncing Acumatica inventory quantities to Magento. Beforehand, the required items must be chosen on the Inventory Details tab of the Magento Store screen by checking the checkboxes and pressing Save, and the Magento Product SKU and Acumatica Inventory ID fields must also be set on that tab. Only after those actions do items appear on the Export Magento Inventory Quantities processing screen. To sync a quantity, enter the corresponding quantity in the Magento Quantity field for the item, check the checkbox, and click Sync; the item quantity in the store is updated based on that value. Sync All syncs the quantities of all items displayed on the screen.

Export Magento Items allows the export of Acumatica items outward. Items appear on that screen if the Magento Product SKU is set on the item tab of the Magento Store screen. Select the items and export them by pressing Sync or Sync All. After the synchronization process, the Price, Description, Weight, Length, Height, Width, and Category of the item are updated in the Magento shop. If the Biz-Tech Services Magento Acumatica connector does not find some items in the store during synchronization, it creates them automatically. Once the item has been synced, the Magento Item checkbox is checked and the Magento Product ID is added under the Magento Inventory tab of the Items screen.

Export Magento Product Images handles images: if an item has an attached image, the system exports it to the store from this screen. Select the corresponding items and export them by pressing Sync or Sync All.

Multi-price export and import

Item prices can differ based on clients, expiration date, and other factors, and the Export Item Multi-Prices screen exports item multi-prices from Acumatica to Magento. Items appear on that screen only if three conditions are met: the items must be selected and saved on the Magento Store screen, the items must have the Magento Product SKU field set on the Inventory Details tab of that same screen, and they must be added on the Sales Prices screen with their corresponding sales prices. Select the Store Code, check the items whose prices should be exported, and click Export or Export All. After synchronization, the sales price of the item is updated in the Magento store as its sales price.

Import Item Multi-Prices moves the same data the other way, importing item multi-prices from Magento to Acumatica. The same conditions must be met for the required items to appear on the screen. Select the Store Code, check the items whose prices should be imported, and click Import or Import All.

Importing Magento items into Acumatica

The Import Magento Items screen allows you to import Magento items along with their corresponding price, weight, and image into Acumatica. Run the Get Items process, after which the items are displayed on the screen, then select the corresponding items and click Import or Import All to import them into Acumatica. This is the catalog-first path for businesses whose product data is maintained in Magento rather than in the ERP.

Mapping: Cross-References, Attributes, and Categories

Mapping is what keeps the two systems agreeing on the meaning of a value, and it is configured on the Magento Store screen. Cross-Reference options select the entities that should be matched in Magento and Acumatica during the transition. The entities checked in Cross-Reference Options then appear in the drop-down field on the Cross-Reference tab, where Field selects the entity whose values should be matched and the Magento Value and Ship Via columns specify the values that correspond to each other. Separately, the Export Fields to Magento tab is where a user chooses which fields should be updated in the store during the item sync process.

The Inventory Mappings tab organizes the mapping that makes the sync of Acumatica attributes and user defined fields to Magento attributes possible. On that tab you add the properties of the particular attribute that you should choose on the Attributes tab of the Item Class screen. If the Magento property attribute does not exist in the shop, the sync process is not possible, so the store side has to be prepared first.

The Attribute Details tab loads the active options of a particular attribute. Retrieving them requires that the attribute properties have been added on the Inventory Mappings tab. Once the mappings are configured correctly, the active options for the attribute can be retrieved on the Attribute Details tab by pressing the Load Active Attribute Options button. The active options cannot be retrieved if the Acumatica attribute control type and the Magento attribute control type do not match, which is the first thing to check when the button returns nothing.

The Category Details tab exports and imports product categories. To retrieve product categories from Magento, click Get Magento Categories, or create a new category in Acumatica, choose it, and save; then press Sync Magento Categories to generate the new category in the store as well. The product categories list can be exported and imported as an Excel document. Attribute Sets is where a user gets Magento attribute sets.

Where to Monitor Magento Results in Acumatica

The Biz-Tech Services Acumatica Magento connector writes its results into specific fields, checkboxes, and tabs rather than into a single log, so knowing where to look is part of running it. These are the places a user checks to see what actually happened:

  • The Import Magento Orders grid after Get Orders, including the timer that indicates elapsed time until the retrieval process is complete.
  • The Status field on the Magento Orders screen, which displays the Magento order status in Acumatica, refreshed with the Refresh Order action when the order has since been fulfilled in the store.
  • The Sales Order Number field on the Magento Orders screen, which displays the sales order number of the order once it is imported.
  • The Invoice Number field on the same screen, which displays the invoice number once the order is invoiced.
  • The amount fields on the Magento Orders screen: Total Lines Amount, Discount Total, Shipping Total, Total Tax, and Total.
  • The Document Details tab for the items of the order, the Addresses tab for the customer address, and the CC Payment tab for the credit card payment method.
  • The Refund Info tab, which becomes visible only if the order has been refunded, and the Processed checkbox on the Refunds tab, which is checked automatically once refund processing is complete and the order is Closed.
  • The Payments tab of the sales order for the Customer Refund payment, and the Application History tab reached through the Reference number to confirm the refunded amount.
  • The Magento Customer checkbox on the Customers screen and the Magento Customer ID under the Magento Customers tab, which together confirm a successful customer export.
  • The Magento Item checkbox and the Magento Product ID under the Magento Inventory tab of the Items screen, plus the unique ID shown on that same tab of the stock item after a sync to Magento.
  • The Last Imported Order Date, Last Refunded Order Date, and Date Last Received Item fields on the Magento Store screen, which show how far each retrieval process has progressed.
  • The error email sent to the address on the order settings tab when Send Email Notifications for Errors is selected, which reports failed orders during batch imports and process updates.

Magento Acumatica Integration: Frequently Asked Questions

How do I connect Magento to Acumatica?

Connection settings are entered on the Magento Credentials screen, where you supply the Store Code, Description, Username, Password, and Base URL, and optionally mark the record as the Default Store. The information on the Connection Settings tab is used to test whether the system can connect to the store through the API, and the Test Credentials button runs that test. Once the credentials are valid, Redirect to Store Settings opens the Magento Store screen, where the rest of the configuration is defined.

Why is a Magento order not appearing on the Import Magento Orders screen?

The processing page shows only orders that hold the statuses Partially Shipped, on hold, Pending, and Processing in the Magento shop, so an order in any other status will not be listed. The Begin Order Date field on the Magento Store screen also filters data retrieval, which means orders older than that date are excluded. If nothing at all is retrieved, run Test Credentials on the Magento Credentials screen to confirm that Acumatica can still reach the store through the API. For a single known order, the Receive Orders action on the Magento Orders screen retrieves it directly by store code and order ID.

Why was a customer not created in Magento during the export?

The Biz-Tech Services Magento Acumatica connector syncs a customer only when three conditions are met. The Customer Price Class, which corresponds to customer groups, must exist in both systems; the customer must have a contact; and that contact must have a First Name, a Last Name, an Email, and a Magento Customer Password made up of a mixture of letters, numbers, and special characters. If the export appeared to run but nothing arrived, check whether the Magento Customer checkbox was set and whether a Magento Customer ID appears under the Magento Customers tab of the Customers screen.

Why does an order import fail saying the item does not exist in the system?

During order import the system searches for the Inventory CD using the Magento Product SKU. If the SKU is not found and the Import Item checkbox is not selected, the program prohibits the import and creation of the item and displays that error, because it will only use items that already exist in Acumatica. Selecting Import Item lets new items be created during order synchronization based on the configured settings, and Replace Missing Products offers the alternative of substituting a selected item for Magento items that do not exist in Acumatica while Import Item remains disabled.

Can I import Magento orders without payment information?

Yes. Selecting Skip Magento Payment on the Magento Store screen means the order is imported without payment. When payment is imported, Payment Method sets the payment method used during the Magento order import process and Payment Type determines the payment type of the imported order, while Release Payment during Order Import releases the payment as part of the import. Use Credit Card Payment adds the CC Payment Mapping tab so that credit card methods can be mapped explicitly.

What happens in Acumatica when a Magento order is refunded?

Refunded orders are loaded on the Import Magento Refunded Orders screen with Get Orders and then handled by the Process button, and the outcome depends on the stage of the original order. An unfulfilled single-item order produces a Customer Refund payment, the order closes, and the sales order status changes to Canceled with its lines deleted. A multi-item refund reduces the refunded quantity and attaches a payment while the order remains Open. Once a shipment has been confirmed, or an invoice prepared or released, the system produces a credit memo instead, reversing the invoice first in the released case.

How do I publish or unpublish Magento items from Acumatica?

Use the Inventory Details tab of the Magento Store screen. Publish Items in Magento enables the publication of the selected items in the store and sets their status to Enabled, while Unpublish Items in Magento removes the Enabled status and makes those items unavailable for purchase. The same item synchronization, publishing, and unpublishing processes can also be carried out from the Stock Items and Non-Stock Items screens.

Which Acumatica license does the Magento Connector require?

The Biz-Tech Services Acumatica Magento Connector must be installed on an Acumatica system with one of the following licenses: PCSR, PERP, or SAAS. Installation itself is performed on the Customization Projects form, screen ID SM204505, which is used to add the customization project, validate it, and publish it for one or more tenants.

Work With the Biz-Tech Services Magento Connector

The Magento data flow into Acumatica ERP is a single path with configurable branches. Credentials on the Magento Credentials screen open the connection; the Magento Store screen sets the defaults that govern order import, customer creation, payments, taxes, discounts, items, and warehouses; Get Orders and Import move the orders in; fulfillment in Acumatica sends events back out; the item, image, quantity, and multi-price processes keep the catalog aligned in both directions; and refunds are reconciled according to how far the original order had already travelled. Once your business knows which screen owns which decision, tracing any individual record through Acumatica becomes a short exercise rather than an investigation.

If your business runs a Magento store alongside Acumatica ERP and wants order, customer, and inventory data to move between them without manual re-entry, the Biz-Tech Services Magento Acumatica Connector is built for exactly that. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration.


How Amazon FBA and FBM Data Flows into Acumatica ERP

How Amazon FBA and FBM Data Flows into Acumatica ERP

Amazon order data flows into Acumatica ERP through the Biz-Tech Services Amazon Connector, which retrieves orders from Amazon into an intermediate server, imports the selected orders into Acumatica as sales orders or invoices, and then sends purchase order acknowledgements, fulfillment events, refunds, and inventory quantities back to Amazon. The connection is never direct. Every request travels through an intermediate server controlled by Biz-Tech Services, and the settings that govern that connection live on the Amazon Stores screen in Acumatica. Once those settings are in place, the Biz-Tech Services Acumatica Amazon connector handles two distinct fulfillment channels: Fulfillment by Merchant, or FBM, where your business ships the goods, and Fulfillment by Amazon, or FBA, where Amazon ships from its own fulfillment centers.

Those two channels take different paths through Acumatica, and understanding the difference is the key to using the Biz-Tech Services Acumatica Amazon connector well. FBM orders become sales orders that your warehouse picks, packs, ships, and invoices, with acknowledgements and fulfillment documents flowing back at each step. FBA records arrive as transfer orders, purchase receipts, and invoices, because the movement being recorded is a transfer of your stock into Amazon inventory rather than a shipment to a shopper. This article traces the whole path in the order the records travel, names the screens, tabs, buttons, and fields involved at each stage, and points out where users should look when something does not land as expected.

What the Amazon Connector for Acumatica Does

The Amazon Connector is an Acumatica ERP customization from Biz-Tech Services, Inc. that links Amazon, the e-commerce platform, with Acumatica enterprise resource planning. It is delivered as a customization project and must be installed on an Acumatica system carrying one of the supported licenses, PCSR, PERP, or SAAS.

The documented capabilities cover both directions of travel. Inbound, the Biz-Tech Services Acumatica Amazon connector imports Amazon orders as either sales order or invoice document types, creates the customer on the fly when that customer does not yet exist in Acumatica, imports sales tax, and imports payment information. Outbound, it sends purchase order acknowledgements, sends fulfillment documents when shipments are confirmed, and sends inventory status documents so Amazon sees the quantity your business actually has available. A cross-reference layer sits between the two systems and matches items, payments, and Ship Via values so that Amazon terminology resolves to Acumatica records instead of failing.

Several of the outbound actions can be run three ways: from the Actions menu on a single Sales Orders document, from a processing screen where many records are selected and pushed at once, or automatically. Acknowledgements can be sent automatically with a Success status, and fulfillment documents can be sent automatically when an invoice is prepared. That mix matters because a business running a handful of orders a day works differently from one running hundreds, and the same configuration supports both.

The Amazon Data Flow at a Glance

Before looking at individual screens, here is the path records travel through the Amazon Connector from setup to settlement of the last refund:

  • Credentials are entered and tested on the Connection Settings tab of the Amazon Store screen, which confirms Acumatica can reach the Biz-Tech server that fronts Amazon.
  • The rest of the Amazon Store screen defines behavior: FBM Settings and FBA settings tabs, plus Cross-Reference, Warehouse Details, Inventory Details, Carriers Code, Cancel Reasons, and Adjustment Reasons tabs.
  • For FBM, the Get Orders button on the Import Amazon Orders screen pulls Amazon orders into a grid, filtered by Start Date and End Date, where they can be reviewed before anything is committed.
  • The Import or Import All button turns the selected Amazon orders into Acumatica documents, applying the customer, item, tax, payment, and cross-reference rules configured on the store.
  • Outbound acknowledgement is sent from the Sales Orders Actions menu or from the Export Amazon PO Acknowledgement processing screen, which pushes the acknowledgement through the Biz-Tech server to Amazon.
  • Fulfillment follows the standard Acumatica chain, Create Shipment, Confirm Shipment, Prepare Invoice, and Release, with Prepare Invoice fulfilling the order in Amazon.
  • For FBA, Import FBA Shipments creates transfer orders and purchase receipts as stock moves into Amazon fulfillment centers, while Import FBA Orders brings in the resulting FBA sales as invoices.
  • Refunds travel back through Import Amazon Refunded Orders, which produces a customer refund payment or a credit memo depending on how far the original order had progressed.
  • Inventory quantities travel outward from the Export Amazon Inventory Quantity screen, summed across the warehouses listed on the Warehouse Details tab.

FBA and FBM: Two Fulfillment Paths, One Amazon Connector

Fulfillment by Amazon is a service Amazon provides so sellers can streamline logistics and order fulfillment. Under FBA, sellers store their products in Amazon fulfillment centers, and Amazon handles the storage, packing, shipping, and customer service for those items. Fulfillment by Merchant is the opposite arrangement: the seller keeps the stock and ships the order. Because the physical goods behave differently, the Acumatica documents behave differently too, and the Biz-Tech Services Acumatica Amazon integrator keeps the two channels on separate tabs and separate processing screens.

The practical consequence is that FBM is an order-to-cash flow and FBA is partly an inventory-transfer flow. An FBM order becomes a sales order of the type configured on the FBM Settings tab, and your business creates the shipment, enters the tracking number, and confirms it. An FBA record set arrives in pieces: shipments of your stock into Amazon become transfer orders, deliveries become purchase receipts in the destination warehouse, and the actual FBA sales come in as invoices. FBA settings therefore include warehouse mapping and a Destination Order Type that has to be a Transfer order type, which has no equivalent on the FBM side.

Both channels can be reviewed together. The FBM and FBA Orders screen shows both kinds of order in one place, and the distinction between them is indicated by the Fulfillment channel field. When users are not sure which path a given order took through Acumatica, that field is the answer.

Stage One: Installing the Package and Connecting Acumatica to Amazon

The Biz-Tech Services Acumatica Amazon integration arrives as a customization project, a set of changes and additional files used to modify the Acumatica ERP application. Administrators import the deployment package, open it for editing in the Customization Project Editor if needed, validate it, and publish it for one tenant or several. Publishing uploads the package, creates the corresponding customization project, and saves it in the database. None of the Biz-Tech Services Acumatica Amazon connector screens exist until that happens.

What the Amazon Store screen identifies

The Amazon Store screen is the anchor record for everything else. Store Code is a lookup field that indicates the corresponding store, and Description describes it. The data on the General tab is provided automatically for the Store Code entered. When the Default Store checkbox is selected, that store appears automatically whenever a user opens a processing screen or a store screen and clicks into the Store code field. On an installation with a single marketplace this saves a click on every process; on an installation with several stores it prevents the more expensive mistake of running a process against the wrong marketplace.

Which credentials the Connection Settings tab holds

The Connection Settings tab uses the information specified on it to test whether Acumatica can connect to the Acumatica to Biz-Tech server. Get a successful test here before touching any other tab, because a failed import caused by a bad credential looks very similar to one caused by a bad mapping.

The fields on this tab are the OAuth and Amazon identifiers the intermediate server needs. Client ID is the identifier associated with an application that assists with client and server OAuth 2.0 authentication. Client secret is a secret known only to the application and the authorization server, and functions as the application own password. A refresh token is a special key that lets a client retrieve new access tokens without requiring the user to perform a complete login, which is what allows scheduled processes to run unattended. Marketplace is the store location, and AWS Regions are the physical locations where Amazon clusters data centers for application and service delivery in AWS Availability Zones.

The remaining values complete the picture. Consumer Key is the API key a service provider issues to a consumer, and it identifies that consumer. Consumer Secret is the consumer password, used along with the consumer key to request authorization to a user resources. External System Store ID is an identifier used to track data in relation to external systems integrated with the Amazon platform. Seller ID and MWS Auth Token are generated when the new developer authorization process is passed. If any of these are wrong, nothing downstream works.

Stage Two: FBM Settings That Govern How Amazon Orders Import

The FBM Settings tab on the Amazon Store screen decides what an imported Amazon order looks like in Acumatica. Import Amazon Orders specifies where to import the Amazon orders in the Acumatica system, and Order Type is the default type of order the Biz-Tech Services Acumatica Amazon integration creates. The Last Imported Order Date field shows the date the latest order was imported, which is the quickest sanity check that the flow is still running. When the Send Email Notifications for Errors checkbox is selected, the Biz-Tech Services Acumatica Amazon connector sends email notifications listing the Order IDs that hit errors, so nobody has to sit watching a grid.

How customer records are created from Amazon orders

When the Import Customer checkbox is selected, the Biz-Tech Services Acumatica Amazon integration imports the customer information from Amazon into a new customer record in Acumatica. When it is not selected, orders are imported against the default customer instead. This is a real business decision: importing customers gives your business a per-shopper record and history, while a single default customer keeps the customer ledger compact when shoppers are not accounts you intend to manage.

Two checkboxes control addresses. Override Ship Address Information from Amazon Order imports the address of the location the order is going to be shipped to from Amazon. Override Bill Address Information from Amazon Order imports the address information of whoever will pay the order bill from Amazon. Where the Amazon-supplied address must win over whatever is stored on the Acumatica customer, these are the settings that make it win.

How Amazon items are matched or created on import

The Import Item checkbox tells the Biz-Tech Services Acumatica Amazon integrator to import new product information from Amazon into Acumatica when that product does not yet exist in the Acumatica system. If the checkbox is not selected and an unknown item arrives, an error will occur during integration. That single checkbox is behind a large share of first-week import failures, so it is worth checking first when imports stop.

There is a documented nuance about descriptions. If the item already exists on the Stock Items screen, the Biz-Tech Services Acumatica Amazon connector does not update its description, but it does set the Amazon item title as the description in the Line description on the Sales Orders screen. The Acumatica master record keeps your naming, and the order line carries the marketplace wording that a shopper would quote.

Warehouse ID is the default warehouse set on imported orders, and UOM, the unit of measure, is used to quantify the inventory items. When the Insert Item in Inventory Details Tab checkbox is selected, items are retrieved into the Inventory Details tab of the Amazon Store screen while orders are being imported, which builds the mapping table as a side effect of normal trading rather than as a separate data-entry project.

Tax and payment defaults applied during import

Three tax fields sit on the same tab. Taxable Category is used to create or edit the tax categories applied to products. Customer Tax Zone is the combined set of effective taxes for a zone, defined according to the locations of vendors or customers. Tax ID is the client tax identifier. Because the Biz-Tech Services Acumatica Amazon connector can import sales tax from Amazon, these defaults are what the imported tax lands against, and a missing tax zone is a common reason an otherwise valid Amazon order will not post.

Under Payment Options, Payment Method is the default payment method set for the new customer records generated in Acumatica from the Amazon orders. Cross-Reference options is the setting that selects which entities should be matched between Amazon and Acumatica during the transition, and it directly controls the next tab.

Cross-References, Warehouses, Carriers, and Reason Codes

Between the credentials and the processing screens sits a set of tabs whose only job is translation. They are unglamorous and they are where most integration problems are actually solved.

The Cross-Reference tab

On the Cross-Reference tab, the Field column selects the entity whose Amazon and Acumatica values should be matched, and only the entities selected under Cross-Reference Options appear in that drop-down. Amazon Value then specifies which Amazon value must match which Acumatica Value. The documented example to verify afterwards is Ship Via: after the Amazon order import process, the Ship Via value should be visible in the Delivery Settings area of the Shipping tab on the Sales Orders screen. If it is blank there, the cross-reference is the place to look, not the order.

The Warehouse Details tab

The Warehouse Details tab is where your business adds the warehouses that need to be in sync with Amazon. Two behaviors follow from it. If several warehouses are selected on this screen, the exported item quantity is the sum of quantities across those selected warehouses, so Amazon sees pooled availability rather than a single site. And depending on the drop-down value selected, On hand, Available, or Available for Shipment, that is the quantity basis synced from Acumatica to Amazon. Choosing Available for Shipment rather than On hand is how your business avoids advertising stock that is already allocated.

The Inventory Details tab and SKU mapping

To upload a new SKU for an Amazon item, the mapping is created on the Inventory Details tab of the Amazon Store screen. If Import Item is checked on the import settings and an order is imported, the connector generates an Acumatica Inventory ID based on the SKU. To update the SKU afterwards, change the SKU for the existing item on the Inventory Details tab and import again, and no new item is created in Acumatica. That is the documented way to correct a mapping without leaving duplicate inventory IDs behind.

One pricing rule is worth committing to memory: during order import the Biz-Tech Services Acumatica Amazon connector takes the Amazon item price rather than the mapped Acumatica item price. The Amazon order is the commercial record of what the shopper paid, so Acumatica records that number rather than your list price.

Four buttons populate this tab. Get Product by ASIN displays the Amazon item in Inventory Details by its ASIN. Get Product by SELLERSKU does the same by SKU. Load FBA Products loads and displays all Amazon products in the store. Sync From Amazon takes a loaded FBA item and creates that item in Acumatica via the product SKU, which is the fastest way to seed Acumatica with an existing Amazon catalog rather than typing it.

Carriers Code, Cancel Reasons, and Adjustment Reasons

The Carriers Code tab matches Amazon carrier details to the Acumatica Ship Via carrier. The Cancel Reasons tab holds the order cancel reasons, and a cancellation reason must be selected while cancelling orders, so an empty tab blocks cancellations. The Adjustment Reasons tab is populated the same way and its values are required for refunding Amazon orders. Both reason lists can be imported or exported as an Excel file, which is the practical way to load them once and reuse them across tenants.

Inbound: How Amazon FBM Orders Become Acumatica Documents

The Import Amazon Orders screen is the inbound gate for FBM. The user indicates the Store Code, and the screen retrieves data for that store: it pulls as many orders into Acumatica as exist in the selected period and displays all of them in the table, so nothing is committed on retrieval alone.

Retrieving Amazon orders with Get Orders

Step one is clicking the Get Orders button to retrieve orders from Amazon. After the button is clicked a timer indicates the elapsed time until the process is complete, and a user can cancel the retrieval by clicking the loading icon next to the timer. The Start Date and End Date fields filter the data retrieval, which is how your business avoids dragging months of history back on a routine run. Step two is reviewing the retrieved orders to decide which ones need to be imported.

Reviewing an order before importing it

Clicking the Order Number opens the corresponding order in a pop-up window, and the most important information is shown on the Amazon Orders screen. This is also the first place errors surface: if an error appears while importing a corresponding order, the error message is displayed on this screen and explains what should be fixed and in which system. That last part matters, because roughly half of import problems are Amazon-side data and half are missing Acumatica configuration.

Running the import

Step four is selecting the orders that require import. Step five is clicking the Import button to begin the import process, or the Import All button to import every order in the grid. After the Import button is pressed, unselected orders are filtered off the screen so the grid shows only what is being worked. A user can cancel the process of importing orders by clicking close.

If there is an error while processing an order, the error displays on the grid line corresponding to that order, and a user should hover the cursor over the red cross to see additional information about it. For deeper detail, a user can open Tools and then Trace.

Outbound: Sending Amazon PO Acknowledgements from Acumatica

Once an Amazon order exists in Acumatica as a sales order, the first thing that travels back to Amazon is the purchase order acknowledgement. There are two documented ways to export it: one at a time, or several at once.

Acknowledging a single Amazon order

Choose the required order on the Sales Orders screen, click the Actions button, and choose the Send Acknowledgement to Amazon option. After the action finishes, the Acknowledgement status changes to closed. That status change on the sales order is the confirmation that Amazon has the acknowledgement, and it is the field to check when someone asks whether an order was acknowledged.

Acknowledging many Amazon orders at once

For volume, open Export Amazon PO Acknowledgement from Process Orders. This screen sends an API request to the Biz-Tech server, and the server in turn sends a request to the Amazon system to create the acknowledgement for the order. Choose the required orders by checking their checkboxes and press the Process button. The Biz-Tech Services Acumatica Amazon connector can also send acknowledgements automatically with a Success status.

Acknowledging with a Failure status to cancel

If an order must be cancelled, the Amazon acknowledgement is sent with a Failure status instead, and the Cancel reason field is required. The alternative route is Manually export Amazon PO Acknowledgement from Process Orders: choose the required order by checking its checkbox, click the Set Status Failure button, choose the Cancel Reason from the column below, press Save, and then Send Acknowledgement. This is why the Cancel Reasons tab has to be populated during setup; without it the cancellation cannot be completed.

Reflecting an Amazon-side cancellation back in Acumatica

The other direction is also documented. To cancel an order that already exists in Acumatica, cancel the order in Amazon, then open the Amazon Orders screen and press the Update Order button. That button updates the Amazon status in Acumatica so the two systems agree. Without it, Acumatica keeps working an order Amazon has already killed.

Outbound: Exporting Amazon Fulfillments from Shipments and Invoices

After the acknowledgement, fulfillment follows the ordinary Acumatica shipping chain, with the connector attached at two points.

From the Actions menu on the sales order, click Create Shipment. The user is then redirected to the Shipments screen. There, fill in Ship Via, add a Packages record, set a tracking number, and click Confirm Shipment.

Then click Prepare Invoice. Preparing the invoice is what fulfills the exact Amazon order: it sends an API request to the Biz-Tech server, and the server sends an API request to fulfill the order in the Amazon system. The same action can be performed in bulk from the Export Amazon Fulfillments screen by choosing the required shipments and pressing Process. The final step is navigating to the Invoice from Sales Orders and releasing the required invoice, which closes the accounting side of the transaction in Acumatica.

Refunds: Credit Memos and Imported Amazon Refunded Orders

Refunds move in both directions too, and the connector treats a refund initiated in Acumatica differently from a refund initiated in Amazon.

Refunding from Acumatica with a credit memo

To refund an order from the Acumatica side, open Invoices and Memos from Receivables, choose the required invoice, click Actions, and then Reverse. Fill in the Adjustment Reason, save the changes, and release. Releasing sends an API request to the Biz-Tech server, and the server sends an API request to refund the order in the Amazon system. The Adjustment Reason is mandatory, which is the reason the Adjustment Reasons tab is part of store setup.

Importing refunds that started in Amazon

The Import Amazon Refunded Orders screen brings refunds that originated in Amazon back into Acumatica. Press the Get Orders button to load refunded orders, with a timer showing elapsed time until the process is complete. The refunded Amazon orders are displayed on the Amazon Refund screen. Choose the required orders by checking their checkboxes and press Process, or click Process All to import every refunded order shown.

How the connector handles each refund case

What the Biz-Tech Services Acumatica Amazon integrator connector does next depends entirely on how far the original order had progressed, and five cases are defined. In case one the refunded order is still only a sales order with no fulfillment. If it consists of one item, processing creates a Payment of the Customer Refund type, attaches it on the Payments tab, sets the refunded amount, and closes the order; following the Reference number shows that payment and the refunded amount on the Application History tab. The sales order status changes to Canceled and all lines are deleted.

Still within case one, if the order consists of several items, the refunded quantity is reduced from the order quantity and the system creates a Payment document attached on the Payments tab for the refunded items, while the order status remains Open. A partial refund therefore leaves a working order behind rather than cancelling the whole thing.

Case two covers a shipment that has been created but not confirmed: pressing Process finds it, deletes it, and then proceeds with the case one actions above. Case three covers a confirmed shipment, where the system creates a Credit Memo and attaches the Reference number with the Customer Refund type to Applications. Case four, an invoice prepared but not released, produces the same Credit Memo.

Case five is the fully posted scenario, where the invoice has already been released. Here the system reverses the invoice and generates a Credit Memo with a Customer Refund type Reference number attached to Applications. In every case, once the actions complete, the Processed checkbox on the Refunds tab is automatically checked on the Amazon Orders screen for the corresponding order, which means the process is over and the order is Closed. The credit memo itself is created in the Invoices screen of Sales Orders.

Item and Inventory Quantity Sync from Acumatica to Amazon

The Export Amazon Inventory Quantity screen syncs Acumatica and Amazon inventory quantities through the Biz-Tech server. Its behavior is governed by a checkbox on each line, and the distinction is easy to miss. If the checkbox is not selected, the Sync action updates the Amazon inventory quantity based on the number in the Quantity column, that is, the Acumatica quantity. If a user wants to send a different number to Amazon, change the value in the Amazon Quantity column, check the checkbox, and then press the Sync button, and the Amazon inventory quantity is updated to that value.

That override is useful when your business deliberately holds stock back from the marketplace, and it is also the reason listed availability can drift from Acumatica availability without anyone noticing. The quantity sent is still governed by the Warehouse Details tab: the sum across the selected warehouses, on the On hand, Available, or Available for Shipment basis chosen there.

FBA Settings: Configuring Fulfillment by Amazon in Acumatica

The Amazon Store screen carries a tab that provides access to all the settings for Amazon FBA orders. It is organized into order options, warehouse mapping, shipment options, customer information, and a payment option, and each group maps onto a distinct part of the FBA flow.

FBA Default Order Options

Invoice Type is the document created after an Amazon FBA order is received and imported, because an FBA order is imported as an invoice in Acumatica rather than as a sales order to be picked. Begin Order date filters the data retrieval, and Last Imported Order Date records when the last order was imported. Below the dates is a table for mapping Acumatica statuses to Amazon order statuses by selecting the corresponding status, so the connector knows which Amazon states are meaningful in your Acumatica workflow. To retrieve and import an order, the corresponding Order Status checkbox must be selected.

FBA Warehouse and fulfillment center mapping

Destination warehouse sets up the warehouse in Acumatica where Amazon goods or products are intended to be sent or delivered. When the Enable Ship from Mapping checkbox is selected, a mapping section opens between the Amazon Fulfillment Center and the Ship-from Warehouse ID, letting your business map an Amazon fulfillment center to an Acumatica warehouse ID and determine which warehouse ships product to the destination warehouse. If the checkbox is not selected, the section disappears and the single value in the Ship from Warehouse ID field is used instead. Businesses shipping into several Amazon fulfillment centers from several of their own sites need the mapping; a single-warehouse seller does not.

FBA Default Shipment Options

Destination Order Type should be populated with the Transfer order type, because all FBA orders need to be created using that specific order type. A Destination Order Type checkbox is included for transfer order types, and when it is selected the Order Type field is disabled, indicating that it is an Amazon FBA order type. One configuration rule is stated explicitly and is easy to trip over: the same order type can only be configured in one store and cannot be repeated in other stores.

Two checkboxes decide what is retrieved. Select Shipments imports FBA shipments, and Select Deliveries imports FBA deliveries. Two date fields report progress: Last Imported Shipment Date is the date the last shipment was imported from Amazon into an Acumatica transfer order, and Last Imported Deliveries Date is the date the last delivery was imported into an Acumatica purchase receipt. Below the dates, a table displays the corresponding Amazon shipment status to be imported into Acumatica.

Two more checkboxes change the resulting documents. When Release PO Receipt During FBA Shipment Import is selected, the shipment is imported as already released into the purchase receipt, which removes a manual release step for businesses that trust the Amazon numbers. Override FBA Shipment bill address information controls whether the order import overrides the customer addresses and sets the Acumatica order address on the sales order, or sets the customer billing address instead.

FBA customer and payment options

The Customer field sets the default customer used during the order import process from Amazon to Acumatica, and it is required for the Amazon orders import process. Under FBA Payment Option, selecting Import Amazon FBA Payment opens a further field for the payment method name, so a payment method can be set up and imported for the FBA order.

The FBA Process Flow: Shipments, Transfers, Deliveries, and Orders

The FBA flow in Acumatica is best read as two tracks. One track moves your stock into Amazon fulfillment centers and keeps the inventory numbers honest. The other track brings the resulting Amazon sales in as invoices.

Importing FBA shipments as transfer orders

To transfer and update items in a single shipment, the FBA shipments must first be pulled from Amazon Seller Central into Acumatica. When a shipment is imported, it creates a sales order with the Transfer order type already selected and set up in the FBA store. The grid displays the destination warehouse where the item will be received, and the sales order line shows the warehouse the item should be transferred from. Selecting the pre-configured Transfer order type established in the store displays the store code on the Sales Orders screen, which is how a user tells an FBA transfer apart from an ordinary internal one.

Updating warehouses with Update In

Upon confirming the shipment of the transfer order and clicking the Update In button, the system updates the warehouse by transferring items from the source warehouse to the destination warehouse. This is the step where Acumatica inventory finally reflects that the goods are in Amazon custody rather than on your own shelves.

Importing FBA deliveries as purchase receipts

After the items have been updated in the warehouses and the shipments are closed in Seller Central, go to the Import FBA Deliveries screen to retrieve all shipments. They are then displayed on the Purchase Receipt screen and are already in the destination warehouse. Following the purchase order release process, the quantity in the destination warehouse is updated and displayed.

Quantity rules on the Import FBA Shipments screen

The Import FBA Shipments screen handles the retrieval and importation of all shipments from Amazon into Acumatica and creates a purchase receipt based on the received quantity of the shipment. Three quantity outcomes are documented. If the received and shipped quantities are equal, the order imports without any issues. If the received quantity is smaller than the shipped quantity, the order still imports. If the received quantity exceeds the shipped quantity, an error message appears stating that the received quantity is greater than the shipped quantity. To prevent that, item quantities need to be adjusted on the FBA Shipments screen before importing.

Importing the FBA orders themselves

The Import FBA Orders screen gets and imports all Amazon FBA orders into Acumatica according to the dates and statuses configured on the store, and after importing it creates a sales order invoice. Imported FBA orders are displayed on the Invoices screen of Sales Orders, which is where users should look for them rather than in an open sales order list.

Where to Monitor Amazon Results in Acumatica

Most support questions about an Biz-Tech Services Acumatica Amazon integration reduce to one question: did the record make it, and if not, where did it stop? These are the exact places in Acumatica to look:

  • Import Amazon Orders grid, where a red cross on an order line signals a failure; hover over it for detail, or open Tools and then Trace for more.
  • Amazon Orders screen, opened by clicking the Order Number, which shows the key order information and the error message explaining what should be fixed and in which system.
  • Email notifications listing Order IDs with errors, if the Send Email Notifications for Errors checkbox is selected on FBM Settings.
  • Last Imported Order Date on the FBM Settings tab, and its equivalent on FBA settings, to confirm the flow is still running.
  • Acknowledgement status on the sales order, which changes to closed once Send Acknowledgement to Amazon has finished.
  • The Delivery Settings area of the Shipping tab on Sales Orders, where the cross-referenced Ship Via value should appear after import.
  • Payments tab and Application History tab, where a Customer Refund payment and the refunded amount are recorded against the Reference number.
  • Refunds tab on the Amazon Orders screen, where the Processed checkbox is checked automatically once a refund is fully handled and the order is Closed.
  • Invoices screen of Sales Orders, where credit memos from refunds and imported FBA order invoices both appear.
  • FBA Shipments screen, a set of generic inquiries giving compact information about shipments in both Acumatica and Amazon.
  • FBA Destination Warehouse Quantities screen, which tracks warehouse updates and shows item quantities in both the destination warehouse and the current warehouse.
  • FBM and FBA Orders screen, where the Fulfillment channel field identifies which channel each order came through.

Amazon Acumatica Integration: Frequently Asked Questions

What is the difference between FBA and FBM in the Amazon Connector for Acumatica?

FBM, Fulfillment by Merchant, means your business ships the order, so the Biz-Tech Services Acumatica Amazon integrator imports it as a sales order and you run Create Shipment, Confirm Shipment, and Prepare Invoice, with the fulfillment event going back to Amazon. FBA, Fulfillment by Amazon, means your products sit in Amazon fulfillment centers and Amazon handles storage, packing, shipping, and customer service, so the Biz-Tech Services Acumatica Amazon connector imports FBA shipments as transfer orders, FBA deliveries as purchase receipts, and the FBA orders themselves as invoices. The two channels have separate settings tabs and separate processing screens, and the FBM and FBA Orders screen shows both, distinguished by the Fulfillment channel field.

Are Amazon orders imported into Acumatica as sales orders or as invoices?

Both are supported. The Biz-Tech Services Acumatica Amazon integration can import Amazon orders as either the sales order or the invoice document type, and the Order Type field on the FBM Settings tab sets the default for FBM. For FBA the answer is fixed: an imported Amazon FBA order becomes an invoice, controlled by the Invoice Type field on the FBA settings tab, and those invoices appear on the Invoices screen of Sales Orders.

Why does my Amazon order import fail with an item error?

The most likely cause is the Import Item checkbox on the Amazon Store screen. When it is selected, the Biz-Tech Services Acumatica Amazon integrator imports product information for items that do not yet exist in Acumatica; when it is not selected and an unknown Amazon item arrives, an error occurs during integration. Check that checkbox first, then check whether the SKU is mapped on the Inventory Details tab of the Amazon Store screen. The full error text is shown on the Amazon Orders screen and explains what should be fixed and in which system.

How do I see the exact error behind a failed Amazon order import?

There are three places, in increasing order of detail. On the Import Amazon Orders grid, hover the cursor over the red cross on the failing order line to see additional information. Click the Order Number to open the Amazon Orders screen, where the error message states what should be fixed and in which system. For anything still unclear, open Tools and then Trace for the underlying detail.

What does the error "Received quantity is greater than the shipped quantity" mean?

It appears on the Import FBA Shipments screen when the received quantity on an Amazon FBA shipment exceeds the quantity shipped, and it blocks the import. Equal received and shipped quantities import cleanly, and a received quantity lower than the shipped quantity still imports. To clear the error, adjust the item quantities on the FBA Shipments screen before importing again.

How do I cancel an Amazon order from Acumatica?

Send the Amazon acknowledgement with a Failure status and fill the required Cancel reason field. From Process Orders, open Manually export Amazon PO Acknowledgement, check the order, click Set Status Failure, choose the Cancel Reason, press Save, and then Send Acknowledgement. Cancel reasons must already exist on the Cancel Reasons tab of the Amazon Store screen, otherwise the cancellation cannot be completed. If the cancellation happened in Amazon instead, open the Amazon Orders screen and press Update Order to bring the Amazon status into Acumatica.

What happens when an Amazon order is refunded after the invoice was released?

That is case five of the refund logic. When you process the refunded order on the Import Amazon Refunded Orders screen, the system reverses the invoice and generates a Credit Memo carrying a Reference number of the Customer Refund type attached to Applications. Once the actions finish, the Processed checkbox on the Refunds tab of the Amazon Orders screen is checked automatically and the order is Closed. The credit memo itself is created on the Invoices screen of Sales Orders.

Work With the Biz-Tech Services Amazon Connector

Traced end to end, the flow is coherent: credentials on the Connection Settings tab open the channel to the Biz-Tech intermediate server, the FBM Settings and FBA settings tabs decide what imported records look like, the cross-reference, warehouse, carrier, and reason tabs translate Amazon values into Acumatica ones, and the processing screens move orders, acknowledgements, fulfillments, refunds, and quantities in the appropriate direction. FBM runs through sales orders, shipments, and invoices; FBA runs through transfer orders, purchase receipts, and invoices. When something goes wrong, the Amazon Orders screen, the red cross tooltip, the trace, and the Processed checkbox on the Refunds tab tell your business exactly where the record stopped.

If your business sells on Amazon and wants that activity landing in Acumatica ERP as accurate orders, shipments, invoices, refunds, and inventory quantities, the Biz-Tech Services Amazon Connector is built for exactly that. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration.


How Shopify Data Flows into Acumatica ERP

How Shopify Data Flows into Acumatica ERP

Shopify data flows into Acumatica ERP as a controlled two-way exchange: the connector retrieves Shopify orders and imports them into Acumatica as Sales Orders, SO Invoices or AR Invoices, then sends results back out - fulfillment events, tracking numbers, inventory quantities, prices, products and customer data. Every leg of that flow is driven by settings you configure once on the Shopify Stores screen, so understanding the path a record takes is the difference between a Biz-Tech Services Shopify Acumatica integration that quietly works and one that silently drops orders.

This article walks that route end to end for the Biz-Tech Services Shopify Connector, following the direction records actually travel: credentials, inbound orders, the customer and payment and tax decisions attached to them, outbound fulfillment and order export, item and inventory sync, and errors. It names the real screens, tabs, buttons, checkboxes and fields your team will click, because those are what you check when you want to know what the integration did.

What the Shopify Connector for Acumatica Does

The Biz-Tech Services Shopify Connector is an integration between Shopify, an eCommerce platform, and Acumatica, an enterprise resource planning (ERP) system. It is delivered as an Acumatica customization project, published through the Customization Projects screen (SM204505), and requires a license of type PCSR, PERP or SAAS. Once published, it adds configuration, processing and inquiry screens that handle order sync, inventory management, product information sync, customer data sync, and the posting of sales data into Acumatica.

The connector talks to Shopify through its Application Programming Interface, or API, using connection information stored on the Shopify Stores screen. The Biz-Tech Services Shopify Acumatica integration also requires default options and required values for the order import process, which is why the store record carries so many settings. Based on those settings it connects to the corresponding system, retrieves orders, and imports the selected orders into Acumatica. When a user confirms the shipments created from those imported orders, fulfillment events are generated in Shopify for each corresponding order.

The Shopify Data Flow at a Glance

Before drilling into any single screen, it helps to see the whole path a record travels between the two systems:

  • Setup - the connector package is published on the Customization Projects screen (SM204505), then a store is created from the Shopify Stores screen using Add New Store, which opens the Shopify Credentials screen. Test Credentials confirms the connection through the API.
  • Configuration - on the Shopify Stores screen you set Import Settings, Tax Options, Customer Information, Item Information, Payment Options, Cross-Reference Options, Export Item Mappings, Warehouse Details and Order Export Settings. These decide what the connector is allowed to create.
  • Retrieval - the Import Shopify Orders screen pulls orders with Get Orders. Only orders in Fulfilled, Unfulfilled or Partially Fulfilled status appear, filtered by Begin Order Date and afterwards by Last Imported Order Date.
  • Staging - each retrieved order is written to the Shopify Orders screen, which holds its initial state - Order ID, Status, Payment Method, Ship Via, Document Details and Addresses - before it becomes an Acumatica document.
  • Import - Import or Import All turns the staged order into the document type chosen in Import Shopify Orders to: a Sales Order, an SO Invoice or an AR Invoice, with the customer, items, payment and tax treatment your settings allow.
  • Outbound fulfillment - when the shipment created from the imported order is confirmed, and after Prepare Invoice, the connector generates the Shopify fulfillment event and sends the tracking number back, updating the order status.
  • Master data sync - separate processing screens push items, images, quantities, sales prices, template and matrix items, customers, contacts and locations, manually or on a scheduler.
  • Exceptions - refunded orders come in through Import Shopify Refunded Orders, and export errors are logged with messages shown in the export log or notification center.

Setting Up the Connection: Shopify Credentials and Shopify Stores

Nothing flows until the store record exists, and these settings matter more than any other step: almost every downstream behavior - whether a customer is created, whether an item is created, whether a payment is attached - is a checkbox here rather than a decision made at import time.

How do you install the Shopify Connector in Acumatica?

The Biz-Tech Services Shopify Acumatica connector ships as a deployment package you import on the Customization Projects screen (SM204505), the same screen used to add, validate, publish, unpublish, export or delete any Acumatica customization project. On import, the platform uploads the package, creates the corresponding customization project and saves it in the database; publishing that project is what makes the Biz-Tech Services Shopify Acumatica integrator screens appear.

Where do Shopify credentials live?

Open the Shopify Stores screen and click Add New Store. You are redirected to the Shopify Credentials screen, where you complete the setup that integrates Acumatica with Shopify. Two actions govern the connection afterwards: Test Credentials, which tests the connection to the Shopify store through the API using the information on the Connection Settings tab, and Edit Credentials, which allows changes to the stored credentials. If Test Credentials fails, nothing downstream will work, so check it first whenever data stops moving.

The store-level fields that steer the whole flow

The header of the Shopify Stores screen carries the switches that determine which directions are even active:

  • Store Code - a Lookup field indicating the corresponding Shopify store. It is required on the processing screens, so it ties every run to a specific storefront.
  • Default Store - when selected, the default store automatically appears when you open the processing and Store screens and the Store Code field. Useful when you run one storefront and do not want users choosing the wrong one.
  • Use B2B - allows customers to sync business-to-business, or B2B, data to Shopify. When unselected, the connector exports an ordinary customer instead.
  • Use Webhook - enables the webhook logic to function, which is what lets Shopify events trigger Acumatica processing without a manual click.
  • Export Order - activates the logic for exporting orders from Acumatica to Shopify, and makes the Order Export Settings tab appear.

Inbound: How Shopify Orders Become Acumatica Documents

The inbound leg is the heart of the Biz-Tech Services Shopify Acumatica integration. A shopper checks out, the connector retrieves the order, and Acumatica creates a document from it. What that document is, which orders qualify, and how much of the payload survives the trip are all governed by the Import Settings tab.

What document does a Shopify order become in Acumatica?

The Import Shopify Orders to field specifies the document type: Shopify orders can be imported as Sales Orders, Sales Order Invoices (SO Invoice), or Accounts Receivable Invoices (AR Invoice). Order Type represents the default type of orders created by the Biz-Tech Services Shopify Acumatica integration, and Branch determines where the order lands, using the branch values already set up on the store. Choose deliberately: a business that picks, packs and ships needs Sales Orders so shipments and fulfillment events can follow, while a business that only needs revenue recorded may be better served by an invoice.

Which Shopify orders are eligible for import?

Two filters decide what the Biz-Tech Services Shopify Acumatica connector will even look at. Fulfillment Status of Orders reflects the status of the corresponding order that will be imported. Under Order Status you will find the financial statuses; the corresponding checkbox must be selected for an order to be retrieved and imported. If a financial status is left unchecked, orders in that status simply will not appear - the most common reason an order seems to be missing.

Dates form the second filter. Begin Order Date is the date from which the first order should be imported. Last Imported Order Date shows when the last order was imported; for other invoice import processes it counts the date related to the last invoice date, and Last Refunded Order Date and Last Imported Company Date are the equivalents for refunds and companies. Retrieval begins from Begin Order Date only while Last Imported Order Date is not later than it; after that, orders are fetched from that watermark. These fields tell you where the connector believes it left off.

Import behavior options on the store record

Further checkboxes shape how much information travels with each order and how much API traffic the connector generates:

  • Send Email Notifications for Errors - opens a field for an email address, and the connector notifies you of Order IDs that hit errors during retrieval. Turn this on if nobody watches the processing screen all day.
  • Save Order Properties in Document Notes - retrieves order properties into document notes while fetching, preserving detail that has no dedicated Acumatica field.
  • Skip Fulfillment - when selected, no API request is sent during Prepare Invoice and the order status is not updated. This deliberately breaks the outbound fulfillment leg, so leave it clear if you expect Shopify to reflect shipments.
  • Refresh Order When Import Orders - when selected, the connector requests fresh data during import; when unselected it imports without updating anything. Selecting it costs extra API calls but guarantees the current version of the order.

Retrieving and importing Shopify orders

The Import Shopify Orders screen is where the inbound flow executes. Get Orders retrieves orders from Shopify, and a timer indicates elapsed time until the process completes. The page only shows orders with the statuses Fulfilled, Unfulfilled or Partially Fulfilled in the shop. Import then handles selected orders and Import All imports every order in the grid; if an error occurs, the message is displayed on screen with information about the system error. The screen also supports a schedule for getting and importing orders, so the cycle can run unattended.

What the Shopify Orders screen shows you

Each retrieved order carries a hyperlink; clicking the order number navigates to the corresponding Shopify Orders screen, which presents the initial situation of the order as it arrived - the best place to compare what came in against what Acumatica created. It has three tabs: Document Details, with information about the items; Addresses, with the customer address; and the Order ID field, which displays the Shopify order ID and order number.

The rest of the screen carries the linking fields. Status displays the order status in Acumatica, while Payment Method and Ship Via display the methods used. Sales Order Number shows the sales order created if the order was imported, and Invoice Number the invoice number if it was invoiced - so an empty Sales Order Number signals that the order was staged but never converted. Refresh Order updates the status, which matters because it reflects the initial state on import and does not change on its own if the order is later fulfilled in Shopify. Import Order fetches an order by its ID, after which it appears on the Import Shopify Orders screen ready to be imported - the manual path for a single urgent order. This screen is also where you read the raw payment method and Ship Via values when creating Cross-Reference mappings.

Automating the inbound flow with webhooks

Webhooks let Shopify events drive Acumatica instead of waiting for a scheduled run. When Use Webhook for Shopify Order Process Automation, Use Webhook for Shopify Fulfillment Process Automation and Use Webhook for Shopify Refund Process Automation are selected, the connector generates new Order, Fulfillment and Refund processes in the Shopify system. With order process automation on, any order created online is automatically imported into Acumatica on the Sales Orders screen, and the Webhook Order checkbox is then selected on the Shopify Orders screen - a quick way to tell an automated import from a manual one.

To create the mapping, go to the Webhooks screen, fill in the Webhook name and Implementation class, and click Save. A Webhook Uniform Resource Locator, or URL, is generated; that URL must be added to the URL field of the newly created webhook in the Shopify system. Until it is registered there, the Acumatica half has nothing to listen to.

Customers, Payments and Taxes on Imported Shopify Orders

An order is never just lines and totals. Each imported order drags a customer, a payment and a tax treatment behind it, and you control each on the Shopify Stores screen.

How does the connector decide which Acumatica customer to use?

When Import Customer is selected, the Biz-Tech Services Shopify Acumatica integration imports the customer information from Shopify into a new customer record in Acumatica. If it is not selected, orders are imported with the default customer instead - every order lands on one house account. Two checkboxes control addresses: Override Ship Address Information from Shopify Order imports the address the order will ship to, and Override Bill Address Information from Shopify Order the address of the party who will pay the bill. If the corresponding numbering sequence is absent, an error message is displayed, so customer numbering must exist first.

Cross-Reference: translating Shopify values into Acumatica values

The two platforms rarely use the same words for the same thing, and the Cross-Reference tab reconciles them. Cross-Reference Options on the Import Settings tab select the entities to be matched during the transition, and only the checked entities appear in the drop-down on the Cross-Reference tab. Selecting them makes the Ship Via field appear, letting you map the Shopify value to the Acumatica Ship Via value.

Customer assignment works the same way. If Use Tags to Import Customer is selected and the type Code is chosen, you set up the Shopify tags and Acumatica customer (AcctCD) values in the Shopify Value and Acumatica Value fields on the Cross-Reference tab. During import, orders carrying a mapped tag get that customer. If Use def. class if tag is not found is unselected, a new customer is created taking the customer class from the Cross-Reference tab. The same logic works for items.

How are Shopify payments imported?

Payment Options decide whether money travels with the order:

  • Skip Shopify Payment - the order is imported from Shopify without payment.
  • Import Captured CC Tran. as Payment - must be selected for an order that has a payment in Shopify to be imported with that payment. Otherwise the order arrives with none, whatever was collected at checkout.
  • Payment Method - the method set on the payment during the order import process.
  • Payment Type - Payment and Prepayment are the types a user can select during import.
  • Release Payment During Order Import - the payment is imported already released, removing a manual step but also the chance to review it first.

Tax Options

Tax Options set how imported orders are taxed in Acumatica. Customer Tax Zone is the combined tax of effective taxes for a zone, defined according to the locations of the vendors or customers, and Tax ID is the customer tax identifier. Taxable Category creates or edits the tax categories applied to products, and Default Non-Taxable Category sets up an exempt category for non-taxable items and displays them on sales order lines. Because Shopify calculates tax at checkout, these fields keep the Acumatica side of the same order consistent with your tax configuration.

Point of Sale, discount and freight handling

Point of Sale, or POS, orders are placed at the point of sale, often in retail or hospitality. Use POS System enables their importation, POS Customer sets a default customer for them, and Default POS Item sets the default item for that process. Separately, Include Item Discount in Price includes the item discount amount in the order price rather than carrying it separately.

What happens to items that do not exist in Acumatica?

When Import Item is selected, the system may create a new item if it does not already exist in Acumatica during the sync and order import process, and options for imported item type, item class, unit of measure (UOM) and Warehouse ID appear to define the defaults. When Import Item is not selected, new item importation sets the default value of Replace Missing Products as the item name and takes the warehouse from Warehouse ID - so orders still import, but against a placeholder item.

Three functions become available with Import Item on. Use Numbering Sequence for SKU Generation generates a Stock Keeping Unit (SKU) number according to the numbering sequence setup when the system does not find one. Populate Items in Inventory Details adds the item into Inventory Details while importing. Save Item Properties in Line Notes syncs the order with line and header notes in Acumatica.

Outbound: Fulfillment, Refunds and Sales Order Export to Shopify

Once an order lives in Acumatica, the flow reverses. Shipments, invoices, refunds and even orders that started life in Acumatica all have a path back to the storefront.

When does Acumatica send fulfillment back to Shopify?

When a user confirms the shipments created from imported orders, fulfillment events are generated in Shopify for each corresponding order, and after the Prepare Invoice action the tracking number is sent and the Sales Order status is updated accordingly. Skip Fulfillment overrides this: with it selected, no API request goes out during Prepare Invoice and the order status is not updated. One detail on the way in: after the order import process, the Ship Via value appears in the Delivery Settings field on the Shipping tab of the Sales Orders screen.

How are Shopify refunds handled in Acumatica?

The Import Shopify Refunded Orders screen imports refunded orders into Acumatica. Press Get Orders to load them - a timer indicates elapsed time - and they are then displayed on the Shopify Refund screen. What happens next depends on how far the original order had progressed, which is why the same refund can produce very different documents:

  • Case 1 - the order is a Sales Order with no fulfillments yet. If it consists of a single item, pressing Process generates a Payment with the Customer Refund type, attaches it to the Payments tab, sets the refunded amount and closes the order. The status changes to Canceled and all lines are deleted.
  • Case 2 - a shipment was created but not confirmed. Process finds the shipment, deletes it, then proceeds as in Case 1.
  • Case 3 - the shipment has been confirmed. Process creates a Credit Memo and attaches a reference number with the Customer Refund type to the Applications.
  • Case 4 - the invoice is prepared but not released. The system creates a Credit Memo and attaches a reference number with the Customer Refund type to the Applications.
  • Case 5 - the invoice is released. The system reverses the invoice.

How do you export Acumatica Sales Orders to Shopify?

Sales Orders created in Acumatica can be exported to Shopify through a designated export process. If a line item does not exist in Shopify, the system automatically creates a new product there using the Acumatica details; if the customer does not exist, a new customer record is created from the order information. Fields such as order number, date, customer details, item descriptions, quantities and prices are mapped and transferred according to predefined field mappings, and the new products and customers carry key identifying details to match their Acumatica counterparts.

There are two ways to export: the Actions menu on the Sales Order, and the Export Sales Orders processing screen, which shows only Sales Orders with Open or On Hold status, allows export individually or in bulk, and supports scheduler setup. Once exported, an order disappears from the screen and reappears if any updates are made. Exported Sales Orders are not imported back into Acumatica, so this is a one-way publish rather than a round trip. Two further actions manage exported orders: Shopify Cancel Order updates the order status to Cancelled after prompting for a cancellation reason, and Delete Shopify Order removes the order from Shopify entirely.

Order Export Settings: what travels with an exported order

The Order Export Settings tab appears when Export Order is selected. It defines how data is handled on the way out and sets fallback behavior when customer or product records are missing in Shopify:

1. Customer Settings - Export Customer exports customer information from the order; when unchecked, a field appears to specify a default customer used for all exports. Update Shipping Address and Update Billing Address create or update the corresponding address if the customer already exists.

2. Product Settings - Create Product creates new product records in Shopify when an item from the Sales Order does not already exist. When unchecked, the default product under Replace Missing Products is used instead.

3. Default Export Options - Export Once Created means that after creating and saving the order in Acumatica it appears in Shopify automatically. Order Fulfillment Status defines the initial fulfillment status of the exported order, for example Unfulfilled.

4. Export Transactions - specifies the payment status, such as Paid or Authorized. On Shopify Plus, with this selected, creating a payment from the Sales Order Payments tab or the Payments and Applications screen and saving it updates the payment status.

5. Export Tax Details, Export Discount and Export Freight - include the order tax information, discount details and freight data respectively.

6. Status Settings and Type Settings - define which Sales Order statuses (for example On Hold, Open) and Order Types (for example SO - Sales Order) are eligible, which also controls what appears on the Export Sales Orders screen.

After the order is placed, the customer receives notifications related to it, for example order cancellation or export notifications - so these settings have a customer-facing effect, not just an internal one.

Item and Inventory Sync Between Acumatica and Shopify

Product and inventory data is the third major flow, running mostly from Acumatica out to Shopify. It is also the flow most often blocked by an unchecked box, because a switchboard on the store record decides which fields the processing screens may touch.

Export Item Mappings: the master switchboard

The Export Item Mappings tab synchronizes product-related fields with Shopify and syncs the values of the item fields that are selected; fields that do not need updating can have their checkboxes cleared. This setting most often explains a sync that ran successfully but changed nothing: for all processing screens, if the required fields are not selected for creating or updating, the corresponding data - price, description, weight - will not be updated. Two related behaviors: the image checkbox applies to stock items and store export processes but does not influence the image processing screen, and if Track Quantity is clear in both systems an error message should appear during syncing, while if it is clear in Shopify only, the sync updates the quantity and selects that checkbox automatically.

The Shopify Inventory tab

On the Shopify Inventory tab you can load all Acumatica and Shopify items and then sync, publish or unpublish them. Load Acumatica Items retrieves all stock and non-stock items into the table, and Load Shopify Items does the same for the storefront catalog. Sync to Shopify exports Acumatica items outward; Sync from Shopify imports items in, taking the SKU and creating an Acumatica Inventory ID from it. Purge clears the table, and Get Item by ID retrieves a single item. The list can be exported and imported as an Excel document, and item sync, publish and unpublish can also be run from the Stock Items screen.

One asymmetry matters when planning your catalog: the Biz-Tech Services Shopify Acumatica connector does not support the mapping function during the Acumatica item export process, though on the import side you can map Shopify and Acumatica items to each other. When exporting an inventory item outward, the Biz-Tech Services Shopify Acumatica integration sets the item Inventory CD as the SKU, the identifier that keeps the catalogs aligned afterwards.

Inventory Mapping and Shopify metafields

The Inventory Mapping tab organizes the mapping between Acumatica attributes, item currency settings, user-defined fields and Shopify fields, and exports or updates metafields at the product or variant level. Get Metafields retrieves all existing metafields so you can organize the field mapping. Checkboxes specify whether each mapping is used for import or export. Acumatica Property should be set to the Acumatica item category and Shopify Property to the corresponding item category, and the relevant checkbox must be selected before importing or exporting mapped values.

Warehouse Details and quantity export

Warehouse Details is where Acumatica warehouses meet Shopify locations. Load Shopify Locations retrieves them all and lets you map them to warehouses; after the export from Export Shopify Inventory Quantities, the Biz-Tech Services Shopify Acumatica connector updates the quantity in the corresponding location. If several warehouses are selected, the exported quantity is the sum across them, and the drop-down value - On Hand, Available, or Available for Shipment - decides which figure syncs. This is a business decision: On Hand can oversell against allocated stock, while Available for Shipment is the most conservative.

On the Export Shopify Inventory Quantities screen itself, choose the required items beforehand on the Shopify Inventory tab of the Shopify Stores screen by checking the checkboxes and pressing Save. The screen displays the sum of item quantities according to the chosen warehouses and supports a schedule to avoid manual processing. It is possible to update the quantity even if Track Quantity is not selected for that item.

Exporting item data, images and prices

Dedicated processing screens carry specific slices of item data to Shopify:

  • Export Shopify Inventory Items - synchronizes item price, description and weight. Load items into the store first, then select items and press Sync, or Sync All for everything displayed. This only works if the matching checkboxes are selected on Export Item Mappings.
  • Export Shopify Product Images - enabled when the Product Image checkbox is selected on Export Item Mappings. Fill in Store Code, select the items, and press Sync or Sync All. If the checkbox is clear the image is not synced, and punctuation marks in the data will duplicate the image.
  • Export Shopify Inventory Quantities - syncs quantities per mapped location, with scheduler support.
  • Export Shopify Item Sales Prices - exports sales price lists as Shopify B2B catalogs, covered below.

Two behaviors apply across these screens. If the system does not find some items in the store during synchronization, it creates them automatically. And the Is Shopify Item checkbox is checked only for items that came from Shopify and were generated by the connector - a reliable way to distinguish connector-created items from ones your team keyed in.

How do Acumatica sales prices reach Shopify?

The Biz-Tech Services Shopify Acumatica integrator exports sales price lists from Acumatica to your store by leveraging Shopify B2B functionality, supporting customer price classes and individual customers including volume pricing and quantity rules, and synchronizing them as catalogs. Products, customers and customer locations must already be synced, and the customer or location must have a Customer Price Class assigned. What gets exported comes from the Sales Prices (AR202000) screen: prices are tied to a Customer Price Class or a Customer through the Price Code, and volume rules use Break Quantities. Define a Break Quantity greater than 1 to enforce minimum purchase quantities - if only 0 or 1 is defined, no quantity rule is exported.

A catalog is created for each unique combination of Customer Price Class and Currency, named CustomerPriceClassID-CurrencyCode, for example Wholesale-USD, with fixed pricing applied to all products within it. To run the export: assign a Price Class to the customer, confirm the customer and locations are synced, navigate to Export Shopify Sales Prices (BZ501005), select the records configured in Sales Prices (AR202000), and click Process or Process All. The system then creates or updates catalogs, adds prices including quantity breaks, and assigns customers or locations to the correct catalog. If the Price Type is Customer Price Class, the screen uses existing Shopify companies and adds them to the matching catalog.

Template items and matrix items

A Template Item is a base product used to create multiple variations, called Matrix Items. It defines general attributes but is not a sellable product itself - for example a T-Shirt template with Size and Color. Matrix Items are child products generated from a template; each is a unique combination of attributes, stocked, priced and sold separately, such as Red Small with SKU TS-RED-S. The Export Shopify Template Items process syncs template and matrix items separately or together, and after syncing the template item the Shopify Template ID is displayed on the Shopify Product tab.

To sync matrix items, click Sync Matrix Items, go to the Matrix Items tab, select the desired items, and click Include Item in Sync; they then appear on the Shopify Details tab, confirming they are in the store and ready to sync. Sync All Matrix Items syncs every matrix item along with the template product. On the Shopify Product tab, the Shopify Product Data field becomes available once the template item has been synced, and selecting its checkbox displays extra fields such as Custom URL, Meta Description and Page Title. The same logic applies to stock items: with the sync checkboxes selected the connector syncs items as template items with their matrix items, and with them clear it exports ordinary, individual products.

Shopify Collections

The Shopify Collections tab retrieves all collections and displays them in Acumatica when you press Get Collections. Purge All Collections clears them when you want to reload from scratch.

Customer and Company Sync Between Acumatica and Shopify

Customer data flows in both directions, and for B2B storefronts Acumatica is the authoritative side. For bidirectional synchronization with Shopify Plus B2B you must enable Use B2B in the store settings, which ensures Shopify correctly handles company profiles, multiple contacts per company, custom price lists, and customer and contact locations. Each B2B customer may have multiple users, added under the company. To push data outward, create a customer in Shopify with or without a contact, then press Sync Customer from the three-dot menu; Acumatica then updates Shopify with customer and contact data. Acumatica is the source of truth for customer details, so pressing Sync Customer assures the store gets the latest. You can also create and sync a password for a contact account through the Shopify Contact Password field.

The identifiers that link the systems live in specific places: the B2B customer ID appears on the Shopify Customers tab for customers linked to a B2B company; contact IDs are on the Contacts tab of the Customers screen and on the Contacts screen; and Location ID is stored on the Info tab of the Shopify Locations screen, ensuring the correct location is assigned and synced.

Four screens carry the customer flow. Import Shopify Companies imports company data into Acumatica; a company disappears from the screen once imported, indicating success, and filtering is based on the updated date field so only recently updated customers are retrieved. Export Shopify Companies exports customer, contact and location data in batches for bulk updates, and after a successful sync the customer disappears, reappearing only if changes occur. Export Shopify Customers processes customers on the scheduler, automatically or manually. The Shopify Companies screen allows manual import using Get Company by ID and Create Customer, which imports the company as an Acumatica customer along with its contacts and locations.

How the Shopify Connector Reports Errors

Errors surface in three places. On the Import Shopify Orders screen, an error during import is displayed on screen with information about the system error. For Sales Order export, errors such as invalid data or missing required fields are logged, with messages displayed in the export log or notification center. For unattended runs, Send Email Notifications for Errors emails the Order IDs that hit errors during retrieval. Two configuration problems have their own messages: an absent numbering sequence when a customer is being created, and Track Quantity not selected in both systems during item syncing.

Where to Monitor Shopify Results in Acumatica

Once the flow is running, most questions come down to whether a record made it and where it stopped. These are the exact fields, screens and buttons to check, roughly in the order a record travels:

  • Shopify Stores screen, Test Credentials - confirms the connection to the store through the API. If this fails, nothing downstream will run.
  • Shopify Stores screen, Last Imported Order Date - shows when the last order was imported and where the next retrieval starts; compare it against Begin Order Date. Last Refunded Order Date and Last Imported Company Date are the equivalents for refunds and companies.
  • Import Shopify Orders screen - lists retrieved Shopify orders in Fulfilled, Unfulfilled or Partially Fulfilled status waiting to be imported, and displays the error message on screen when an import fails.
  • Shopify Orders screen, Status - the order status as it was on import; use Refresh Order to update it against the current Shopify state.
  • Shopify Orders screen, Sales Order Number and Invoice Number - the sales order created if the order was imported, and the invoice number if it was invoiced. Empty values mean the order was staged but never converted.
  • Shopify Orders screen, Webhook Order checkbox - selected automatically after a webhook-driven import, distinguishing automated imports from manual ones.
  • Sales Orders screen, Shipping tab, Delivery Settings - carries the Ship Via value that arrived with the order after import.
  • Sales Orders screen, Shopify Order ID and store name - displayed after a Sales Order is exported, confirming the order now exists in Shopify.
  • Sales Orders screen, Order is Synced and Exported checkboxes - selected automatically after export. If the order is updated afterward, Order is Synced clears and the order reappears on the Export Sales Orders screen; Mark/Unmark as Synced sets it manually.
  • Export Sales Orders processing screen - lists only Sales Orders in Open or On Hold status still awaiting export. An order that disappears was exported successfully; one that reappears has been edited since.
  • Stock Items screen, Is Shopify Item checkbox and Shopify Product tab - Is Shopify Item is checked only for connector-generated items, and the tab shows the Shopify Template ID plus Export to Shopify, selected automatically when the product exists there.
  • The export log or notification center - where errors from the Sales Order export process are recorded.

Shopify Acumatica Integration: Frequently Asked Questions

Why is a Shopify order not appearing in Acumatica?

Work down the filters in order. The Import Shopify Orders screen only lists orders with the statuses Fulfilled, Unfulfilled or Partially Fulfilled, so an order in another state never shows up. Next check the Order Status section on the Import Settings tab: the corresponding checkbox must be selected for an order to be retrieved. Finally check the dates - retrieval starts from Begin Order Date only while Last Imported Order Date is not later than it, and afterwards orders are fetched from that watermark, so an older order is skipped.

Why was a customer not created in Acumatica from a Shopify order?

The most likely cause is the Import Customer checkbox on the Shopify Stores screen. If it is not selected, orders are imported with the default customer instead of creating a new record. If it is selected and creation still fails, check numbering: an absent numbering sequence produces an error message. If you use tags, confirm the Use Tags to Import Customer setup on the Cross-Reference tab, because when Use def. class if tag is not found is clear, a new customer is created taking the customer class from that tab.

Why did an item price, description or weight not update in Shopify?

This is almost always the Export Item Mappings tab. For all processing screens, if the required fields are not selected for creating or updating, the corresponding data such as price, description or weight will not be updated. Select the appropriate checkboxes there before using the processing screens, then re-run Sync or Sync All on the Export Shopify Inventory Items screen.

Why is Acumatica not sending fulfillment back to Shopify?

Check the Skip Fulfillment checkbox on the Shopify Stores screen. When it is selected, no API request is sent during the Prepare Invoice action and the order status is not updated. With it clear, confirming the shipments created from imported orders generates Shopify fulfillment events, and the tracking number is sent after Prepare Invoice with the Sales Order status updated accordingly.

Can Shopify orders be imported as invoices instead of Sales Orders?

Yes. The Import Shopify Orders to field specifies the document type, and Shopify orders can be imported into Acumatica as Sales Orders, Sales Order Invoices (SO Invoice), or Accounts Receivable Invoices (AR Invoice). Order Type sets the default type created by the Biz-Tech Services Shopify Acumatica integrator, and Branch uses the branch values already set up on the store.

Does the Shopify Connector import payments with the order?

Only if you tell it to. Import Captured CC Tran. as Payment must be selected for an order that has a payment at checkout to be imported with that payment; otherwise it arrives without one, and Skip Shopify Payment does the opposite. Payment Method and Payment Type - Payment or Prepayment - set what is created, and Release Payment During Order Import causes the payment to arrive already released.

How do I run the Shopify integration automatically instead of clicking buttons?

There are two mechanisms. Several processing screens support scheduler setup, including Import Shopify Orders, Export Shopify Inventory Quantities, Export Sales Orders and Export Shopify Customers. Separately, webhooks work in real time: with Use Webhook enabled and Use Webhook for Shopify Order Process Automation selected, any order created in Shopify is automatically imported into Acumatica on the Sales Orders screen, with equivalent options for fulfillment and refunds.

What happens in Acumatica when a Shopify order is refunded?

It depends on how far the order had progressed. If it is a Sales Order with no fulfillments, processing the refund creates a Payment with the Customer Refund type, sets the refunded amount, closes the order, changes the status to Canceled and deletes all lines. If a shipment was created but not confirmed, it is deleted first and the same path follows. If the shipment was confirmed, or the invoice was prepared but not released, the system creates a Credit Memo with a Customer Refund reference in the Applications. If the invoice was already released, the system reverses it.

Work With the Biz-Tech Services Shopify Connector

The Shopify data flow into Acumatica ERP is a chain, and every link is a setting you control. Credentials and store configuration decide whether the Biz-Tech Services Shopify Acumatica connector can connect at all. Import Settings decide which orders qualify and what document they become. Customer Information, Payment Options, Tax Options and Item Information decide how much of the original order survives the trip. Export Item Mappings and the processing screens decide what your storefront sees of your catalog, inventory and prices, and Order Export Settings decides what happens to orders that start life in Acumatica. When you know which screen owns which decision, troubleshooting stops being guesswork.

If your business runs a Shopify storefront on top of Acumatica ERP and you want that data flow configured, monitored and running without manual intervention, the Biz-Tech Services team can help you set it up correctly the first time. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Shopify Connector.


How DocVision Converts PDF Purchase Orders into Acumatica Sales Orders

How DocVision Converts PDF Purchase Orders into Acumatica Sales Orders

DocVision turns a customer's PDF purchase order into an Acumatica sales order without anyone retyping a line. That sounds simple, but the data flow behind it has a clear shape worth understanding: a PDF is imported and becomes a reusable template, the template maps every PDF field to an Acumatica field, cross-references resolve the customer and the items, a review screen shows in color whether the document is ready, and only then is the sales order generated. Knowing which stage a document has reached, and which field controls the next step, is what makes PDF automation dependable rather than unpredictable.

The Biz-Tech Services DocVision product is a PDF scan and import enhancement built natively for Acumatica ERP. Users upload PDF files such as purchase orders or shipping requests and generate the corresponding sales orders inside Acumatica, eliminating manual data entry. This article follows a PDF through the entire flow, from the initial setup and template creation to the generated sales order, and identifies the fields users should monitor at each point.

What DocVision Does in Acumatica

DocVision is an Acumatica ERP enhancement that automates the creation of sales orders from PDF documents. It reads an uploaded PDF, identifies the customer and ship-to information using pre-configured templates, maps the document's values to Acumatica fields, and generates a sales order from the result. Because parsing rules are defined per customer, the same system can handle many different document formats and structures, which matters when every customer sends purchase orders in their own layout.

Several characteristics shape how the product behaves in practice. It is built natively for Acumatica, so it runs without external dependencies and works within Acumatica's secure environment, respecting user permissions and audit trails. It reduces data entry mistakes by extracting information directly from the source document, and it standardizes incoming sales data regardless of the style of the originating document. For high-volume sales operations, that combination of speed and consistency is the point of the product.

The DocVision Data Flow at a Glance

Before looking at individual screens, here is the path a PDF travels to become a sales order:

  • Azure setup establishes and tests the credentials that allow customer purchase order PDF files to be brought in and processed.
  • On the PDF Import Settings screen, a PDF is imported and a template is created, defining the mapping between PDF values and Acumatica values.
  • The system automatically populates PDF FieldName, PDF Value, and the Target Object and Source Field mappings, which can then be adjusted manually.
  • Inventory and customer cross-references resolve the PDF's item and customer values to real Acumatica inventory IDs, customers, and locations.
  • On the Import Documents screen, each document is reviewed, with green, red, and yellow indicating readiness, errors, and mapping warnings.
  • Generate Sales Order creates the order, sets the Generated checkbox, and records the order number and order type against the document.
  • The Import PDF Documents inquiry and the batch generation screen provide oversight across many documents at once.

Each field discussed below sits at one of those handoffs.

Stage One: Azure Setup and Testing Credentials

Setting up Azure in Acumatica allows the ERP system to run on Microsoft's cloud platform using services such as Azure SQL Database, Virtual Machines, and Storage. Beyond the general benefits of scalability, security, performance, backups, disaster recovery, and Single Sign-On through Azure Active Directory, this configuration is what supports importing customer purchase order PDF files so they can be processed and converted into sales orders within Acumatica.

One control on this screen deserves to be used before anything else is attempted. The Test Credentials button confirms that the setup credentials are configured correctly. Running it early is the cheapest way to separate a credential problem from a mapping problem later, and it should be the first checkpoint whenever documents stop arriving.

Stage Two: Building a PDF Template in PDF Import Settings

PDF Import Settings is where the intelligence of the product lives. Pressing the plus button opens a new workspace that allows a PDF file to be imported and a template created from it. Once the PDF is imported, the screen defines the mapping between PDF values and Acumatica values, and that mapping is what every future document of the same format will reuse.

Reading the automatic mappings

After a PDF is imported, the right side of the screen displays the file itself, with the ability to move to the next or previous page and to zoom in and out, so the source document can be read while mapping. The system automatically sets the PDF FieldName and PDF Value entries, and on the Import Mappings tab it also automatically sets the mappings between Target Object and Source Field values. From there it is possible to manually map all PDF fields to the corresponding Acumatica values, correcting or extending what was detected automatically.

Header versus detail mapping: the Target Object rule

One rule governs whether a mapped value lands on the order header or on an order line, and getting it wrong is a common early mistake. To map header fields of a sales order, select Sales Order and then Advanced in the Target Object. To map details on the Sales Order screen, select Sales Order, then Details, then Advanced. The presence or absence of Details in that path is the entire difference between a value appearing once on the order and appearing on each line.

The Active checkbox decides what actually gets written

During sales order generation, only the fields for which the Active checkbox is selected will be uploaded. This is the single most important field to check when a mapped value fails to appear on a generated order. The mapping can be entirely correct and still produce nothing if Active was never selected, which makes this checkbox the first place to look rather than the last.

Handling PDFs that have no purchase order number

Not every incoming document carries a purchase order number, and DocVision handles that case explicitly. Under the Description section there is a Dynamic PO Number field. If there is no purchase order number in the PDF file, this checkbox is automatically selected during the file import process and a warning is displayed reading that the document for the mapping does not have any number and asking you to select an alternative purchase order number.

After that warning appears, a Release PO Number field becomes available, which allows the values of the header to be mapped to existing values of the field. In other words, the system does not simply reject a document without a number; it asks you to nominate which header value should serve as the number instead.

Inventory and customer cross-references

Two cross-reference layers translate the PDF's vocabulary into Acumatica's. Enabling CrossRef for the Inventory ID field makes the Inventory Cross-Reference tab appear, where PDF items can be mapped manually to Acumatica inventory IDs, or where all items can be imported at once via Excel. The Excel route matters for onboarding a customer with a long catalog, since mapping item by item does not scale.

When Cross Reference is selected, the Customer Cross-Reference tab appears, allowing PDF customer values and locations to be mapped to Acumatica customers and locations. This is the mechanism behind the product's customer recognition: the template knows that a particular string in a particular position identifies a specific Acumatica customer and ship-to location.

Stage Three: Reviewing Documents on the Import Documents Screen

The Import Documents screen is the review and correction stage. It allows changes to be made to existing or previously imported documents, and it also enables documents to be imported directly from this screen. Selecting a document number displays the PDF already imported through PDF Import Settings along with all mappings for that document, and it retains the Template ID information, so you can always see which template produced a given result.

The green, red, and yellow color code

Three colors communicate document readiness at a glance, and teaching users to read them saves a great deal of investigation:

  • Green indicates that everything is mapped correctly and the file is ready for generating a sales order.
  • Red indicates that an item line hit an issue during the import process; the line turns red and an error message is displayed in the Error Message field.
  • Yellow indicates a mapping problem, for example items that are not mapped correctly.

The distinction between red and yellow is worth stressing. Red points to a specific failure with a message attached, so the Error Message field tells you what happened. Yellow is a warning that the document is not yet ready, most often because item mapping is incomplete.

Resolving yellow warnings with Validate Items

Yellow warnings are addressed with the Validate Items button. It maps all PDF items to their Acumatica values and displays them on the Details tab, provided those items are already mapped in the Inventory Cross Reference on the PDF Import Settings screen. That proviso is the key to using it well: Validate Items applies existing cross-references, it does not invent them. If an item has never been cross-referenced, validation cannot resolve it and the cross-reference must be created first. The button can be used frequently when PDFs are imported from the same screen.

Stage Four: Generating the Sales Order

On the Documents tab, the Template ID, document number, Order Type, and Customer are displayed, which together confirm that the right template and the right customer were matched before anything is created. Once setup is complete, opening the three dots menu and selecting Generate Sales Order creates a sales order from all the mapped data.

Three results confirm success, and users should check all of them. The order number and order type are displayed against the document, the Generated checkbox is automatically selected, and the document number becomes visible on the Sales Order screen itself. That last item is the important one for traceability, because it means anyone looking at the resulting sales order can see which imported document produced it.

Batch Processing and the Import PDF Documents Inquiry

Two features exist for working across many documents rather than one at a time. A generic inquiry has been created where all document numbers, Template IDs, customer information, and document generation dates can be found, with hyperlinks on those fields that lead directly to the Import Document screen. This is the natural starting point for a daily review, since it answers what came in, under which template, for which customer, and when.

For processing volume, the Generating Sales Orders screen has been modified to allow orders to be imported in batches and sales orders generated from them. The Document Number field can be used to filter by document number and generate the corresponding sales order, which makes it practical to work through a queue of documents rather than opening each one individually.

Where to Monitor DocVision Results in Acumatica

When configuring templates, training users, or investigating a PDF that did not produce the expected order, these are the fields and screens that show what actually happened:

  • The Active checkbox on each mapping, since only fields with it selected are uploaded during sales order generation.
  • The Target Object path, where Sales Order then Advanced maps a header field and Sales Order then Details then Advanced maps a line field.
  • The Dynamic PO Number checkbox and the Release PO Number field, which together handle documents that arrive without a purchase order number.
  • The Inventory Cross-Reference tab, which resolves PDF items to Acumatica inventory IDs and can be loaded in bulk from Excel.
  • The Customer Cross-Reference tab, which maps PDF customer values and locations to Acumatica customers and locations.
  • The color of each line on the Import Documents screen, where green means ready, red means a line-level error, and yellow means a mapping warning.
  • The Error Message field on any red line, which carries the specific reason the line failed.
  • The Template ID retained against each document, which identifies which template produced the mapping.
  • The Generated checkbox, order number, and order type on the Documents tab, which confirm the sales order was created.
  • The document number displayed on the Sales Order screen, which links the finished order back to its source PDF.
  • The Import PDF Documents generic inquiry, for document numbers, Template IDs, customer information, and generation dates across all documents.

DocVision for Acumatica: Frequently Asked Questions

What is DocVision for Acumatica?

DocVision is a Biz-Tech Services enhancement for Acumatica ERP that automates the creation of sales orders from PDF documents. Users upload PDFs such as purchase orders or shipping requests, and DocVision extracts the data using pre-configured per-customer templates and generates the corresponding sales order in Acumatica, removing the manual data entry step.

How does DocVision know which customer a PDF belongs to?

Through the Customer Cross-Reference tab, which appears when Cross Reference is selected. It maps PDF customer values and locations to Acumatica customers and locations, so the system can identify customer and ship-to information from each PDF using the pre-configured template. Because parsing rules are defined per customer, different customers can send completely different document layouts.

What do the green, red, and yellow colors mean on the Import Documents screen?

Green means everything is mapped correctly and the file is ready for sales order generation. Red means an item line encountered an issue during import, with the reason shown in the Error Message field. Yellow means a mapping problem, typically items that are not mapped correctly, which the Validate Items button can often resolve.

What happens if a PDF has no purchase order number?

The Dynamic PO Number checkbox under the Description section is automatically selected during import and a warning appears stating that the document for the mapping does not have any number and asking you to select an alternative. The Release PO Number field then becomes available, letting you map header values to existing values of the field so the document still receives a usable number.

Why is a mapped field missing from the generated sales order?

Check the Active checkbox on that mapping first. During sales order generation only fields with Active selected are uploaded, so a correct mapping with Active cleared produces nothing. If Active is set, verify the Target Object path, since header fields require Sales Order then Advanced while line fields require Sales Order then Details then Advanced.

How do you map PDF line items to Acumatica inventory IDs?

Enable CrossRef for the Inventory ID field, which makes the Inventory Cross-Reference tab appear. From there, PDF items can be mapped manually to Acumatica inventory IDs, or all items can be imported at once through Excel. Once those cross-references exist, the Validate Items button on the Import Documents screen will apply them and populate the Details tab.

Can DocVision generate sales orders in batches?

Yes. The Generating Sales Orders screen supports importing orders in batches and generating sales orders from them, and the Document Number field can be used to filter by document number and generate the corresponding order. The Import PDF Documents generic inquiry gives an overview of all documents, with hyperlinks back to the Import Document screen.

Work With the Biz-Tech Services DocVision Product

DocVision is straightforward once the flow is clear. Azure setup and tested credentials open the door, PDF Import Settings turns a sample document into a reusable per-customer template, the Active checkbox and the Target Object path decide what is written and where, inventory and customer cross-references translate the document into Acumatica's own identifiers, the Import Documents screen shows readiness in color, and Generate Sales Order completes the journey with the document number visible on the finished order. Teams that know which field governs each handoff can turn a stack of customer PDFs into accurate sales orders quickly and consistently.

If your business receives customer purchase orders as PDFs and wants them turned into Acumatica sales orders without manual re-keying, we are glad to help you scope, configure, and roll out DocVision. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Biz-Tech Services DocVision product.


How WooCommerce Data Flows into Acumatica ERP

How WooCommerce Data Flows into Acumatica ERP

The WooCommerce Acumatica integration moves data in both directions, and that is the first thing to understand about it. Orders travel inbound from your store to become Acumatica sales orders, while items, quantities, prices, images, customers, and fulfillment events travel outbound from Acumatica back to WooCommerce. A single configuration screen governs almost all of it. Knowing which setting controls each handoff, and which screen shows the result, is what turns a large connector into a predictable one.

The Biz-Tech Services WooCommerce Connector links WooCommerce, the e-commerce platform, with Acumatica ERP. The integration retrieves orders from WooCommerce and imports the selected orders into Acumatica, and when a user confirms the shipments created from those imported orders, fulfillment events are generated in WooCommerce for each corresponding order. This article follows records through the full data flow in both directions and identifies the fields worth monitoring at every stage.

What the WooCommerce Connector for Acumatica Does

The WooCommerce Connector is an Acumatica ERP customization that synchronizes an online store with the back office. Inbound, it retrieves WooCommerce orders and creates Acumatica sales orders from them, optionally importing customers, addresses, payments, discounts, taxes, and shipping details along the way. Outbound, it exports items, inventory quantities, prices, sales prices, images, and product categories to WooCommerce, publishes and unpublishes products, exports customers, and reports shipment and invoice progress back to the store so order status stays current on both sides.

After the customization package is published, the WooCommerce workspace appears in the Acumatica menu along with its screens. Two of those screens matter more than the rest: WooCommerce Store Preferences manages the connection and the API setup, and WooCommerce Store manages the overall workflow and its configuration. Almost every behavior described in this article traces back to a setting on the second of those two screens.

The WooCommerce Data Flow at a Glance

Before looking at individual screens, here is the path records travel through the Biz-Tech Services Acumatica WooCommerce integration:

  • Credentials are entered and validated on WooCommerce Store Preferences, which also auto-populates the Order Mappings tab.
  • The WooCommerce Store screen defines operating mode, order settings, item settings, mappings, cross-references, warehouses, categories, and webhooks.
  • Get Orders retrieves WooCommerce orders, which are routed to either the Import WooCommerce Orders screen or the WooCommerce Orders screen depending on their status.
  • Import creates the Acumatica sales order, applying customer, payment, discount, tax, and shipping rules from the store configuration.
  • Fulfillment runs Create Shipment, Confirm Shipment, Prepare Invoice, and Release, pushing shipment and invoice information back to WooCommerce.
  • Export Item Processes push items, quantities, images, prices, and publication status outward, in batches of one hundred items per API request.
  • Customer export, refund import, webhooks, and automation schedules run alongside the main order flow.

Each field discussed below sits at one of those handoffs.

Stage One: Credentials and the Two Setup Screens

Setup begins on the WooCommerce Store Preferences screen, where you enter the credentials generated on your WooCommerce website. Store Code is a lookup field indicating the corresponding WooCommerce store name, and Description holds a description of that store. The connection itself relies on the Consumer Key, Consumer Secret, and Base URL, which are the WooCommerce system credentials used during integration, together with the WordPress Login and WordPress Password fields, which hold the WordPress credentials required for authentication.

After entering the credentials, click Test Credentials. If the message confirming that credentials are valid appears, you can proceed to the WooCommerce Store screen. Do not skip this step, because it is the cheapest way to separate a connection problem from a configuration problem later.

Saving this screen does more than store credentials. During the save process, the Order Mappings setup is configured under the Order Mappings tab of the WooCommerce Store screen, and all required default fields are added automatically. That mapping determines how order synchronization is carried out, so a successful save is what makes order import possible at all.

Generating the WooCommerce API keys

The WooCommerce REST API works on a key system that controls access, and those keys are linked to WordPress users on your site. To generate them, go to WooCommerce, then Settings, then Advanced, then REST API, and choose Add Key. Add a description, select the user the key is being generated for, and select the level of access, which can be read access, write access, or read and write access. Selecting Generate API Key produces the Consumer Key and Consumer Secret used on the preferences screen. Choose the access level deliberately, since a read-only key will block every outbound process described later in this article.

Stage Two: The WooCommerce Store Screen Governs Everything

The WooCommerce Store screen is the main screen of the connector, and the configuration defined here determines how the Biz-Tech Services Acumatica WooCommerce connector functions. It controls order import, item import and creation, payment processing, customer management, shipping methods, warehouse mapping, and related settings. Proper configuration of this screen is what ensures accurate synchronization between the two systems.

The three switches that set operating mode

Near the Store Code at the top of the screen, three fields define the system's operating process in advance. When the Use B2B Store checkbox is selected, the system operates in business-to-business mode, synchronizing the customer's contact information and creating a corresponding user account in WooCommerce; when it is cleared, the Biz-Tech Services Acumatica WooCommerce integration handles standard retail workflows instead. The Use Refund Process option enables processing of WooCommerce refunded orders and reveals the Last Refunded Order Date field on the Order Settings tab. Use Webhook adds a Webhook Settings tab to the screen.

A Default Store checkbox in the header sets that store automatically in the Store Code field on the processing screens, which removes a repetitive selection step from daily work.

Two actions worth knowing

Edit Credentials redirects to the WooCommerce Store Preferences screen for editing. Update Synchronized Customers transfers WooCommerce customer information from the WooCommerce Info tab of the Customers screen to the Woo Customer Info tab. This second action is not optional housekeeping: customer synchronization is currently based on the Woo Customer Info tab, so after publishing a new package the existing data must be transferred using this action or customer matching will not work correctly.

The details section of the screen carries several tabs, including Order Settings, Item Settings, Item Mappings, Cross-Reference, Warehouse Details, Item Details, Product Categories, and Inventory Mapping, each configuring its corresponding process.

Inbound: How WooCommerce Orders Become Acumatica Sales Orders

The Order Settings tab configures order synchronization from WooCommerce to Acumatica. Import WooCommerce Orders To specifies the type of Acumatica document the orders become, with Sales Orders creating standard Acumatica sales orders. Order Type defines the default order type for all orders created by the Biz-Tech Services Acumatica WooCommerce integrator, and Warehouse ID specifies the default warehouse assigned to imported orders, which keeps inventory availability and stock management aligned with the right warehouse.

The date fields that control how much is imported

Begin Order Date sets a starting point to filter which WooCommerce orders are retrieved, so only orders created on or after that date are imported, enabling partial or incremental loading. Last Imported Order Date displays the date of the most recent order successfully imported, and the next import begins from that date so orders are neither skipped nor duplicated.

One detail deserves emphasis because it explains behavior that otherwise looks wrong. Orders are imported into Acumatica based on their updated date rather than their created date. An older order that was recently modified will therefore be picked up, which is intentional and keeps changes in sync.

Status filtering and which screen an order lands on

WooCommerce Status determines which orders are imported based on their status, such as Completed, Processing, or On Hold, and only orders matching a selected status are included. The corresponding order status checkbox must be selected for an order to be retrieved and imported at all, which is the first thing to check when expected orders never appear.

Retrieved orders are then routed to one of two screens according to status. Orders with working statuses, documented as on hold, partial shipped, processing, and pending, appear on the Import WooCommerce Orders screen, where the processing page shows partially shipped, on hold, pending, pending payment, and processing orders. Orders with canceled, failed, empty, and completed statuses appear on the WooCommerce Orders screen instead. Understanding this split prevents a great deal of confusion, because an order that is not on the import screen has usually not gone missing; it is simply in a status that routes it elsewhere.

Retrieving and importing

On the Import WooCommerce Orders screen, the Get Orders button retrieves orders from WooCommerce, with a timer showing elapsed time until the process completes. All orders for the selected period are retrieved and displayed at once. The Import button then imports the selected orders, while Import All imports everything displayed on the grid. A scheduler can also be configured on this screen to retrieve orders automatically.

Reading the WooCommerce Orders screen

Each retrieved order carries a hyperlink on its order number that navigates to the corresponding WooCommerce order screen. That screen presents the initial status of the order and organizes detail across several tabs: Document Details for the order's items, Addresses for the customer's address details, Import Fields for information relating to the order mappings configured in the store, and Refund Info, which becomes visible only if the order has been refunded.

The header fields are where users check results. Order ID displays the WooCommerce order ID and order number, Status shows the WooCommerce order status inside Acumatica, and Payment Method and Ship Via show how the order was paid and how it ships. Sales Order Number displays the resulting sales order once the order has been imported, and Invoice Number appears once it has been invoiced. Financial totals are carried in Total Lines Amount, Discount Total, Shipping Total, Total Tax, and Total, the last representing the final amount paid.

Two actions sit on this screen. Import Order retrieves an individual order from WooCommerce by selecting the store code and setting the order ID, which is useful for one-off recovery. Refresh Order updates the WooCommerce order status in Acumatica, which matters when an order is fulfilled in WooCommerce after it was imported.

One caveat about mappings belongs here. The Import Fields tab is populated based on the order mapping during the Get Order process and is then imported into Acumatica during the order import. Changes to the Order Mapping configuration do not affect orders that have already been retrieved. To adjust an already-retrieved order, users must edit it manually from the Import Fields tab before importing it.

Customer, Payment, Discount, and Tax Handling on Import

Customer information options

These options determine whether customer data from WooCommerce is imported and created in Acumatica. Import Customer brings customer information into a new Acumatica customer record. Override Ship Address Information from WooCommerce Order imports the address the order ships to, and Override Bill Address Information from WooCommerce Order imports the address of whoever pays the bill. Customer Class sets the default class applied to new customers created by the Biz-Tech Services Acumatica WooCommerce integration.

If Import Customer and both address options are left unselected, customer data is not imported and the order is created using the default customer information in Acumatica. A table under Customer Information also lets you determine the priority of WooCommerce fields when importing and exporting customers between the two systems.

Shipping and payment options

Shipping Options determine which shipping information is imported, and based on the configured setup the shipping total can be imported as either the Freight Price or the Premium Freight Price.

Payment Options determine whether payment information is imported. Selecting Skip WooCommerce Payment means imported orders carry no payment information and the order is created without recording one. Leaving it cleared reveals further configuration: Payment Method specifies the method assigned during import, such as credit card, PayPal, or bank transfer; Payment Type determines the payment type in Acumatica, such as prepayment, cash, or credit; and Release Payment during Order Import automatically releases the payment at import time so the financial transaction is processed immediately.

Payment authorization and capture

The division of labor between the two systems is worth explaining to finance teams before go-live. In WooCommerce, payments can be authorized at checkout, meaning the customer's card details are verified and funds are reserved by the gateway without being collected. Once the order synchronizes into Acumatica, the system does not attempt to authorize again. Instead it performs a post-authorization, recording the authorization already completed in WooCommerce and bringing it into Acumatica's accounts receivable so financial records stay consistent.

From there the payment can be captured directly in Acumatica when the order is ready to be fulfilled. The practical effect is that WooCommerce secures the funds at order creation while Acumatica collects them at the most appropriate point in your process. The Biz-Tech Services Acumatica WooCommerce connector supports Ebizcharge and Fortis as well as other credit card payment methods, and the corresponding payment method must also be set up in Acumatica for the card payment to process correctly.

Discounts and taxes

Discounts are handled two ways. Line-level discounts are calculated for each individual item, populating the Discount Amount and Discount Code fields in the Sales Orders document details table. Order-level discounts apply to the entire order and appear in the Discount section of the order instead.

Tax options ensure WooCommerce taxes are calculated and applied correctly in Acumatica and provide flexibility for external tax services. Customer Tax Zone is the combined tax of effective taxes for a zone, defined by vendor or customer location. Tax ID holds the customer's tax identifier, and Taxable Category creates or edits the tax categories applied to products. Is Freight Taxable in WooCommerce controls whether freight is taxed on the WooCommerce side, and Use External allows another tax engine such as Avalara to be used where the plugin is in place.

Other order settings worth knowing

Do Not Import WooCommerce Price makes the system ignore WooCommerce prices during import and use the corresponding Acumatica item prices instead; selecting it disables the Send Invoice Info during Release option. Save Properties in Order Notes causes the connector to retrieve notes along with the orders. Send Email Notification for Errors alerts users to failures during import, with notifications going to the email address entered on the Order Settings tab and sent during batch imports and process updates.

Cross-References and Warehouse Configuration

Cross-Reference options specify which entities should be matched between the two systems during synchronization, so that payments, countries, or ship via values in WooCommerce correspond correctly to their Acumatica equivalents and duplicate or mismatched records are avoided. Only entities checked in Cross-Reference Options appear in the dropdown on the Cross-Reference tab, where the actual mappings are created. Get Shipping Methods loads WooCommerce shipping methods so they can be mapped against Acumatica Ship Via values. After order import, the mapped Ship Via value should be visible in the Delivery Settings field on the Shipping tab of the sales order.

The Warehouse Details tab is where you add the warehouses whose inventory quantities need to synchronize with WooCommerce. The system calculates the total quantity across all selected warehouses for each item and displays that combined figure on the processing screen for export, so the store reflects stock across every relevant warehouse. A dropdown determines which quantity is used, with On Hand, Available, and Available for Shipment as the options. This choice directly controls what your store believes it can sell, so it should be made deliberately.

Outbound: Fulfillment Events Back to WooCommerce

When a WooCommerce order is associated with an Acumatica sales order, fulfillment runs in four steps. Click Create Shipment and confirm the pop-up with OK. On the Shipments screen, press Confirm Shipment once Box ID and Tracking Number are set. Click Prepare Invoice. Finally, press Release on the Invoices screen. After the process completes, the order status in both Acumatica and WooCommerce changes to Completed.

Two settings decide what is communicated during those steps. Send Shipment Info during Prepare Invoice sends shipment information to WooCommerce and marks the item as shipped during the prepare invoice process. Send Invoice Info during Release sends invoice information and moves the WooCommerce order to Completed status. The tracking number is updated on the WooCommerce order after Prepare Invoice.

Inventory reacts at defined points as well. After Prepare Invoice, the WooCommerce ordered quantity is reduced from the Available and Available for Shipping quantity fields in Acumatica. After an order refund, the item's quantity is added back to the On Hold, Available, and Available for Shipping fields.

Exporting an order from Acumatica to WooCommerce

The Sales Order screen includes an action for exporting an order to WooCommerce and updating it. Export is supported only for orders with Open, On Hold, and Awaiting Payment statuses, and it works from the mapping configured on the Order Mapping tab. Customer resolution follows a simple rule: if the customer was exported beforehand and carries a Customer ID in the Woo Customer Info tab, the order is created under that ID; otherwise it is created against the Guest customer. Shipping method is exported using the Ship Via mapping from the Cross-References tab. Order status is set to Processing if the sales order has a payment and to On Hold if it does not.

One limitation should be communicated up front: tax export is not currently supported during order export, owing to differences in customer tax zones in WooCommerce. Exporting tax requires Acumatica-to-WooCommerce tax mapping to be configured.

Cancelling a WooCommerce order

The Sales Orders actions menu offers two cancel options that behave very differently. Cancel Order is the standard Acumatica action and cancels only within Acumatica. WooCommerce Cancel Order is the connector's own feature and cancels the WooCommerce order through API requests. Once an order is cancelled on both sides, reopening it in Acumatica does not send a further request to update WooCommerce. If the status is changed manually in WooCommerce and the order retrieved again, it will not appear on the Import WooCommerce Orders screen; it appears on the WooCommerce Orders screen instead, because it already has an associated sales order.

Item Synchronization: The Export Item Processes

Item export is batched for efficiency. During the export process from the Export Item Processes screen, a single API request covers one hundred items, with requests sent before the batch begins.

Item settings that govern creation

On the Item Settings tab, Import Item controls whether new items are created in Acumatica during item synchronization. When it is cleared, the program prohibits import and creation unless the items already exist in Acumatica. The matching logic is worth knowing: the system searches for the Inventory CD using the WooCommerce product SKU, retrieves the item if found, and otherwise displays an error stating that the item does not exist in the system.

Import Item Type specifies the item type to create and UOM is the unit of measure used to quantify inventory items. Last Page Number for Getting Products indicates the last page used when retrieving products. Synchronize Only Changed Items limits the Export WooCommerce Inventory Items screen to items whose details have changed since the last sync. Populate Items in Inventory Details adds items to Inventory Details during import. Use Numbering Sequence for SKU Generation generates a SKU when none is found, provided the numbering sequence exists; without it, and with no SKU on the item, an error appears. The WooCommerce Tax Status and Tax Category ID fields update the WooCommerce item's tax status to match the Acumatica stock item tax category during synchronization.

The five export item processes

Item Sync creates and updates item data in WooCommerce. The process is to select the store code, which is set automatically when Default Store is selected, choose the fields from Item Mapping that should be updated, specify which price fields to export, and then sync items individually, all at once, or on a schedule. Synchronization is bidirectional, so updates can flow either way. Selecting variants of products displays all product variants, and if the system does not find an item in the store during synchronization it creates it automatically. The Is WooCommerce Item checkbox is selected only for items obtained from WooCommerce and generated by the Biz-Tech Services Acumatica WooCommerce connector.

Quantity Sync updates inventory in WooCommerce from Acumatica data. Three requirements must be met for an item to appear: it must already exist as a WooCommerce item in Acumatica, it must be loaded, checked, and saved in the Inventory Details tab of the store, and warehouses and a quantity type must be selected in Warehouse Details. On the processing screen, Quantity is a read-only field showing the item's total across all selected warehouses, while WooCommerce Quantity is editable and specifies what is actually synchronized. That distinction gives you control over what the store sees.

Images Sync exports an item's image when the corresponding checkbox is selected for the product in the Item Mapping tab, exporting the default image configured in the stock item's Description tab, and it handles both products and variants. Item Price updates prices in WooCommerce using either MSRP or Default Price, with the corresponding field value selected in Item Mapping; in both cases it is the Regular Price field on the WooCommerce website that is updated. Publish and Unpublish Item manages product visibility: an item whose status is In Stock is published, and an item with any other status is unpublished. The Selected for Publish/Unpublish field on the Item Details tab controls which items appear on that processing screen. All of these processes can run manually or on a scheduler.

Item Details, categories, and mappings

The Item Details tab loads and manages items directly. Load Acumatica Items retrieves all stock and non-stock items, and Load WooCommerce Items does the same from the store. Sync to WooCommerce exports Acumatica items outward and Sync from WooCommerce imports them inward. Publish Items in WooCommerce gives selected items Published status, while Unpublish changes the status to Last Modified. Check All toggles selection of everything displayed, Purge deletes all items shown in the table, and Get Item By ID retrieves a single WooCommerce item into Acumatica. When an item is synced from Acumatica to WooCommerce, a new item is created there and a unique ID is generated, displayed both in the store screen and on the WooCommerce Inventory tab of Stock Items. The item details list can be exported to and imported from Excel, and synchronization, publishing, and unpublishing can also be performed from the Stock and Non-Stock Items screens.

On the Product Categories tab, Get WooCommerce Categories retrieves categories from the store. To create a category in Acumatica and push it outward, select it, save, then press Sync WooCommerce Categories. Retrieved categories appear on the WooCommerce Categories tab of the stock item screen, where a preferred category can be set and exported with the item, after which WooCommerce selects it automatically. This list can also be exported to and imported from Excel.

The Inventory Mappings tab configures mappings that synchronize Acumatica stock item fields and attribute values with WooCommerce fields. Get WooCommerce Properties loads the product's main fields, meta fields, or attributes. Acumatica Target defines whether a Stock Item or an Attribute is mapped, DAC Name specifies the data access class, and Acumatica Property names the field or attribute. Update in Acumatica and Update in WooCommerce control the direction in which changes apply, Woo Product Level defines whether the WooCommerce field is a main field, attribute, or metadata, and WooCommerce Property names the field loaded by the properties action. One constraint matters here: the connector does not support the mapping function during the Acumatica item export process, only during import from WooCommerce to Acumatica. When exporting an inventory item outward, the item's Inventory CD is set as the SKU.

Item and order mapping tabs

The Item Mappings tab chooses which fields are exported and imported during item sync. The first column holds field names, the Create in Woo column allows those values to be created in WooCommerce, the next column allows updates to values already created there, and Update in Acu applies selected values during import. Some fields, such as SKU, are selected by default because they are required for item creation.

The Order Mappings tab holds the order mapping configuration, loaded and mapped automatically when the preferences screen is saved, and configurable manually thereafter. Load WooCommerce Fields loads or updates all related WooCommerce order fields. Update in WooCommerce and Update in Acumatica control the direction of updates during order synchronization. Original Field indicates an original field, and original fields must be mapped for order synchronization to work. Meta Data should be checked when the WooCommerce target is metadata. Acumatica Target selects between Document for sales order header fields and Details for sales order line fields, Acumatica Property names the field, WooCommerce Field Target specifies Order, Line, or Metadata, and WooCommerce Property names the loaded field.

Template and matrix items

Template items follow their own two-step path. From the Template Items screen, the Sync Template Items to WooCommerce action exports the template, and a successful export generates a WooCommerce Product ID shown under the WooCommerce Product tab. Running Sync Matrix Items to WooCommerce afterward creates the matrix items, which appear as variations under the corresponding template item product in the store.

Customer Synchronization and B2B Mode

One rule frames everything else in this area: individual customers are not imported directly from WooCommerce into Acumatica. Customer information reaches Acumatica through WooCommerce orders instead. When creating a customer during that process, the system searches first by the contact's WooCommerce customer ID, then by billing email, then by account name, and creates a new customer and contact only if no match is found.

In B2B mode, enabled by the B2B Store checkbox, the connector syncs the customer's contact and creates a user in WooCommerce. Before exporting a contact, the system searches for an existing user by the contact's ID, then by email, and finally by a username composed of first and last name. A password must be set on the contact in Acumatica for the export to succeed, and after export the generated WooCommerce ID is written back to the Acumatica contact. If the Woo Customer Info tab is empty and B2B Store is enabled, all contacts are exported as separate users; if B2B Store is not enabled, only the primary contact is exported, falling back to the first available contact when no primary exists.

With B2B Store cleared, standard customer export logic applies, initiated from the Customers screen using the Sync WooCommerce Customer action. The program checks WooCommerce using the customer's email, WooCommerce customer ID, and first and last name combination. If the customer is found, a record is created in the Woo Customer Info tab holding the WooCommerce Customer ID; if not, a new customer is created in the store and its ID written back to the same tab. This process depends on the customer having a corresponding contact, and an error is displayed when one is missing.

Customers can also be linked manually by adding a record on the Customer page, opening the Woo Customer Info tab, and setting the Contact ID, Store Code, WooCommerce Customer ID, and B2B fields. For automatic linking, each customer needs first name, last name, and email, and the record is created automatically during synchronization when the contact's email or first and last name combination matches the WooCommerce username. A dedicated Export WooCommerce Customers processing screen creates and updates customers in the store, individually or all at once, and supports a scheduler.

Refund Processing

Refund handling requires the Use Refund Process checkbox in the store setup. Specify the date from which refunded orders should be retrieved, then click Get Orders, and the system retrieves and displays all matching refunded orders. Refund information is recorded on the Refunds tab of the related WooCommerce order in Acumatica, so the original order and its refund stay linked.

The system then handles refunds according to how far the original order had progressed:

  • If the sales order has had no fulfillment activity and consists of a single item, processing generates a payment of Customer Refund type, attaches it to the Payments tab, sets the refunded amount, and closes the order; the sales order status changes to Canceled and its lines are deleted.
  • If a shipment was created but not confirmed, the system finds and deletes that shipment, then follows the same path as the first case.
  • If a shipment was confirmed, the system creates a credit memo and attaches a reference number of Customer Refund type to the Applications.
  • If an invoice was prepared but not released, the system likewise creates a credit memo and attaches a Customer Refund reference number to Applications.
  • If the invoice was already released, the system reverses the invoice.

In each case, the Processed checkbox on the Refunds tab of the WooCommerce Orders screen is automatically selected once the work is complete, which means the process is finished and the order is closed. Following the reference number shows the Customer Refund payment and refunded amount on the Application History tab.

Webhooks and Automation Schedules

Selecting Use Webhook adds the Webhook Settings tab. With Use Customer Webhook, Use Product Webhook, and Use Order Webhook selected, the Biz-Tech Services Acumatica WooCommerce integrator generates newly created customers, products, and orders in WooCommerce. Creating a webhook means filling out the webhook name and implementation class on the Acumatica Webhooks screen, saving to generate the webhook URL, and adding that URL in WooCommerce.

For scheduled operation, both the order get and order import processes can be automated. For the get process, configure the Get Orders screen and select Import Orders from WooCommerce in the Screen ID field. For the import process, set up the Import All screen and select Import WooCommerce Orders in the Screen ID field. Most of the export item processes and the customer export screen support schedulers as well.

Where to Monitor WooCommerce Results in Acumatica

When configuring the Biz-Tech Services Acumatica WooCommerce integrator, training users, or investigating a record that did not arrive, these are the fields and screens that reveal what actually happened:

  • Test Credentials on WooCommerce Store Preferences, which confirms the connection before anything else is investigated.
  • The WooCommerce Status selections on Order Settings, since an order whose status checkbox is not selected is never retrieved.
  • Begin Order Date and Last Imported Order Date, which bound what the next import will collect, remembering that orders are selected by updated date rather than created date.
  • Which of the two order screens a record appears on, since status routing sends working orders to Import WooCommerce Orders and completed or cancelled ones to WooCommerce Orders.
  • Sales Order Number and Invoice Number on the WooCommerce Orders screen, which confirm that import and invoicing actually produced documents.
  • The Import Fields tab, which holds the mapped values as captured at Get Order time and is the only place to correct them before import.
  • The Delivery Settings field on the Shipping tab of the sales order, which should show the mapped Ship Via value after import.
  • Quantity versus WooCommerce Quantity on the quantity sync screen, where the first is the calculated total and the second is what is actually sent.
  • The quantity type selected in Warehouse Details, which decides whether On Hand, Available, or Available for Shipment is published to the store.
  • The Woo Customer Info tab on the Customers screen, which holds the WooCommerce Customer ID that determines whether an exported order is linked to a real customer or to Guest.
  • The Processed checkbox on the Refunds tab, which confirms a refund has been fully handled.
  • The Get Order Process Error Messages screen, which collects all errors generated during order retrieval.
  • Email error notifications, which alert users to failed imports at the address configured on Order Settings.

WooCommerce Acumatica Integration: Frequently Asked Questions

What does the WooCommerce connector for Acumatica do?

It synchronizes a WooCommerce store with Acumatica ERP in both directions. Inbound, it retrieves orders and creates Acumatica sales orders with their customers, payments, discounts, taxes, and shipping details. Outbound, it exports items, quantities, prices, sales prices, images, categories, and customers, publishes and unpublishes products, and reports shipment and invoice progress back so order status stays current in the store.

Why are some WooCommerce orders not appearing on the import screen?

Check three things. First, the order's status checkbox must be selected in WooCommerce Status on the Order Settings tab, or the order is never retrieved. Second, orders route by status: working statuses appear on the Import WooCommerce Orders screen while canceled, failed, empty, and completed orders appear on the WooCommerce Orders screen. Third, confirm Begin Order Date and Last Imported Order Date cover the period you expect, remembering that selection is by updated date, not created date.

How does payment authorization work between WooCommerce and Acumatica?

WooCommerce authorizes the payment at checkout, verifying the card and reserving funds without collecting them. When the order synchronizes, Acumatica does not authorize again; it performs a post-authorization that records the existing authorization in accounts receivable. The payment is then captured in Acumatica when the order is ready to fulfill. Ebizcharge, Fortis, and other credit card methods are supported, and the matching payment method must exist in Acumatica.

Why was a customer not created in Acumatica from a WooCommerce order?

Most likely because Import Customer and both address override options are unselected, in which case customer data is not imported and the order uses the default Acumatica customer. Note also that individual customers are never imported directly from WooCommerce; customer information only reaches Acumatica through orders.

Which inventory quantity is published to WooCommerce?

Whichever type is selected in the Warehouse Details tab, from On Hand, Available, or Available for Shipment. The system totals that quantity across every warehouse added on that tab. On the quantity sync screen, Quantity is the read-only calculated total while WooCommerce Quantity is editable and determines what is actually sent to the store.

Why did my order mapping change not affect an order?

Because changes to the Order Mapping configuration do not apply to orders that have already been retrieved. The Import Fields tab is populated during the Get Order process using the mapping in force at that moment. To alter an already-retrieved order, edit it manually from the Import Fields tab before importing it into Acumatica.

Can taxes be exported from Acumatica to WooCommerce?

Not currently during the order export process, because of differences in customer tax zones in WooCommerce. Exporting tax on order export requires Acumatica-to-WooCommerce tax mapping to be configured. Taxes on imported orders are handled separately through the tax options on the Order Settings tab, including the option to use an external service such as Avalara.

What is the difference between Cancel Order and WooCommerce Cancel Order?

Cancel Order is the standard Acumatica action and cancels the order only inside Acumatica. WooCommerce Cancel Order is the connector's own action and cancels the order in WooCommerce through API requests. After a WooCommerce cancellation, reopening the order in Acumatica does not send another update to the store.

Work With the Biz-Tech Services WooCommerce Connector

The Biz-Tech Services Acumatica WooCommerce integrator is large, but its shape is simple. Credentials and validated API keys open the connection, the WooCommerce Store screen defines how everything behaves, order settings and status selections determine what comes in and where it lands, customer, payment, discount, and tax options shape the resulting sales order, fulfillment steps push shipment and invoice information back to the store, and the export item processes keep products, quantities, prices, and images current in the other direction. When something does not arrive, the routing rules, the Import Fields tab, and the error message screen tell you where it stopped.

If your business sells through WooCommerce and wants orders, customers, inventory, pricing, and fulfillment synchronized with Acumatica without manual re-keying, we are glad to help you scope, configure, and roll out the connector. Visit https://biz-techservices.com to learn more about our Acumatica integration expertise or to schedule a personalized demonstration of the Biz-Tech Services WooCommerce Connector.


How CRV Lines Flow Through Sales Orders, Shipments, and Invoices in Acumatica

How CRV Lines Flow Through Sales Orders, Shipments, and Invoices in Acumatica

California Redemption Value, or CRV, has to appear on the invoice as its own line, and it has to stay attached to the product that generated it. That is the whole problem CRV processing in Acumatica solves. When a beverage item is added to a sales order, the system automatically creates a second line for its associated CRV item, carries the same quantity and warehouse across, and keeps the two lines linked by parent and child references all the way through shipments and invoices. Understanding where that child line comes from, which fields control whether it appears, and how the link survives downstream is what keeps CRV billing accurate.

The Biz-Tech Services CRV solution for Acumatica handles this automatically rather than asking order entry staff to remember an extra line on every beverage order. This article follows a CRV line through the full Acumatica data flow, from the item configuration that defines it to the invoice where it is billed, and identifies the fields users should monitor at each stage.

What a CRV Item Is in Acumatica

A CRV item in Acumatica is a non-stock item used across the inventory and sales modules to identify products that carry an environmental fee. It is automatically added to sales transactions when you sell beverages that fall under California's recycling program. The distinction that matters most is structural: CRV items are only ever non-stock items. They represent a fee rather than physical goods, so they must never be set up as stock items, and the configuration will not behave correctly if they are.

In practice this means every beverage product you sell has two records behind it. The parent item is the actual product being shipped, and the child CRV item is the environmental fee attached to that product. Acumatica keeps them associated so that pricing, quantity, and downstream document flow stay synchronized.

Why California Redemption Value Matters for Beverage Distributors

California Redemption Value is a refundable deposit applied to eligible beverage containers under the state's beverage container recycling program. Consumers pay the deposit at purchase and recover it when they return the container for recycling. For distributors and retailers in the supply chain, CRV is not revenue in the ordinary sense; it is a pass-through amount that must be charged, tracked, and reported separately from the product price.

That separation is exactly why CRV cannot simply be built into a product's unit price. It needs to be visible as a distinct line on the sales document so that customers can see what they are paying, and so that the business can account for the deposit correctly. Any ERP handling for CRV therefore has to solve two things at once: automatically adding the fee whenever an eligible product is sold, and keeping that fee identifiable as belonging to a specific product line. The Acumatica configuration described below does both.

The CRV Data Flow at a Glance

Before looking at each screen, here is the full path a CRV line travels through Acumatica:

  • A CRV item is created as a non-stock item representing the environmental fee.
  • On the Stock Items (IN202500) screen, the Price/Cost tab of each eligible beverage product points to its CRV item through the CRV Item field.

  • The CRV Amount field on the General tab of the Stock Items screen determines the fee amount based on the selected unit of measure.
  • The Include in CRV checkbox on the customer's default location determines whether CRV applies to that customer at all.
  • When the parent item is added to a sales order for an eligible customer, Acumatica automatically adds the associated CRV item as a new line with the same quantity and warehouse.
  • Parent Item and Child Item fields on the Sales Orders, Shipments, and Invoices screens keep the product and its CRV line identifiable as a pair throughout the document flow.

Each field below sits at one of those handoffs, and knowing which stage a problem occurred at tells you which screen to open.

Step One: Configure the CRV Item as a Non-Stock Item

The flow begins with the fee itself. Before any product can reference a CRV charge, the CRV item must exist in Acumatica as a non-stock item. This is a prerequisite rather than a preference. The CRV Item field described in the next step expects a non-stock item, and configuring the fee as a stock item will break the association.

Businesses selling containers in more than one size category typically need more than one CRV item, since deposit amounts differ by container size under the state program. Setting these up as separate non-stock items, clearly named so that order entry staff and accounting can tell them apart on a document, is worth the small amount of extra effort at configuration time.

Step Two: Link the CRV Item to Its Parent Product

With the fee item in place, each eligible beverage product must be told which CRV item belongs to it. This association is made on the Stock Items screen and is the single most important link in the whole data flow. To configure it, navigate to the Stock Items screen, select the desired item, open the Price/Cost tab, and in the CRV Item field select the appropriate CRV item.

This field is what makes automatic CRV line creation possible. Without it, Acumatica has no way to know which fee applies to which product, and no child line will be generated when the product is sold. When a CRV charge fails to appear on an order, this field is the first place to check.

Step Three: Set the CRV Amount by Unit of Measure

The amount charged is controlled by the CRV Amount field on the General tab of the Stock Items screen. This field determines the amount for the associated CRV item based on the selected unit of measure, which allows a separate price to be defined for the CRV item independently of the product's own price.

The unit of measure dependency deserves attention during setup. Because deposits are levied per container, a product sold in multiple units of measure, such as individual bottles and cases, needs its CRV amount configured so that the resulting charge reflects the number of containers actually being sold. Reviewing this against a real order for each unit of measure you sell is a worthwhile validation step before going live.

Step Four: Enable Include in CRV on the Customer Location

The final piece of configuration determines which customers are charged. An Include in CRV checkbox has been added to the customer default location, and the status of that checkbox controls whether the CRV item is displayed on the sales order for that customer. Selected, and CRV lines are generated. Cleared, and they are not.

Placing this control at the location level rather than at the customer level is deliberate and useful. A customer with several ship-to locations may be subject to the deposit at some and not others, and the location record is where that distinction naturally lives. It also means CRV behavior can be adjusted for a specific customer relationship without touching item configuration that affects everyone.

How CRV Lines Are Created on the Sales Order

With configuration complete, the runtime behavior is simple and automatic. Navigate to the Sales Orders screen and select a customer whose location has the Include in CRV checkbox selected. When the main parent item is added to the order, the system automatically adds the associated CRV item as a new line.

Two attributes are inherited from the parent line rather than being entered by the user: the child CRV line receives the same quantity and the same warehouse as the parent item. This inheritance is what keeps the fee proportional to what is actually being sold. If ten cases are ordered, the CRV line reflects ten, and if the parent line ships from a particular warehouse, the CRV line is associated with that same warehouse. Order entry staff do not need to calculate, add, or adjust anything.

Parent Item and Child Item: Keeping CRV Lines Linked Downstream

A CRV line is only useful if you can tell which product it belongs to, and that becomes harder as documents multiply. To solve this, Parent Item and Child Item fields have been added to the Sales Orders, Shipments, and Invoices screens, specifically to identify the main item and its associated CRV item.

The significance of those three screens together is that the relationship survives the entire order-to-invoice flow. On the sales order, you can see which CRV line was generated by which product. When the order is shipped, the shipment document carries the same parent and child identification. When the invoice is produced, the association is still visible, so the customer's bill can be reconciled line by line and accounting can attribute every deposit to the product that generated it. This is what separates a properly modeled CRV implementation from one where fees appear as anonymous extra lines that nobody can trace.

Where to Monitor CRV Results in Acumatica

When configuring CRV, training users, or investigating an order where the fee looks wrong, these are the fields and screens that show what the system actually did:

  • The CRV Item field on the Price/Cost tab of the Stock Items screen, which defines the association between a product and its fee item and is the first thing to check when no CRV line appears.
  • The CRV Amount field on the General tab of the Stock Items screen, which sets the fee amount for the selected unit of measure.
  • The Include in CRV checkbox on the customer default location, which determines whether CRV lines are generated for that customer at all.
  • The non-stock status of the CRV item itself, since CRV items must always be non-stock items.
  • The Parent Item and Child Item fields on the Sales Orders screen, which confirm that the generated CRV line is correctly associated with its product.
  • The quantity and warehouse on the generated CRV line, which should match the parent line exactly.
  • The Parent Item and Child Item fields on the Shipments screen, which confirm the association survived shipment creation.
  • The Parent Item and Child Item fields on the Invoices screen, which is where the customer-facing result is verified and where accounting reconciles deposits against products sold.

CRV Processing in Acumatica: Frequently Asked Questions

What is a CRV item in Acumatica?

A CRV item is a non-stock item used in the inventory and sales modules to represent the California Redemption Value environmental fee attached to eligible beverage containers. It is added automatically to sales transactions when you sell beverages covered by California's recycling program, appearing as its own line alongside the product that generated it.

Does a CRV item have to be a non-stock item?

Yes. CRV items are only non-stock items. The fee represents a deposit rather than physical goods, and the CRV Item field on the Price/Cost tab of the Stock Items screen expects a non-stock item. Configuring the CRV item as a stock item will prevent the association from working correctly.

Why is the CRV line not appearing on my sales order?

Check three things in order. First, confirm that the Include in CRV checkbox is selected on the customer's default location, since this controls whether CRV items are displayed on the sales order for that customer. Second, confirm that the parent product has the correct CRV item selected in the CRV Item field on the Price/Cost tab of the Stock Items screen. Third, confirm that the CRV item itself is configured as a non-stock item.

How is the CRV amount determined?

The CRV Amount field on the General tab of the Stock Items screen determines the amount for the associated CRV item based on the selected unit of measure. This allows a separate price to be defined for the CRV item, independent of the product's own price, and lets the charge reflect the number of containers represented by the unit of measure being sold.

How do I tell which CRV line belongs to which product?

Use the Parent Item and Child Item fields, which have been added to the Sales Orders, Shipments, and Invoices screens specifically to identify the main item and its associated CRV item. Because those fields exist on all three screens, the relationship remains visible and traceable from order entry through shipment to the final invoice.

Can CRV be applied to some customers but not others?

Yes. The Include in CRV checkbox sits on the customer default location, so CRV behavior is controlled per location rather than globally. A customer with multiple ship-to locations can have the fee applied at some locations and not at others, without any change to item configuration.

What quantity and warehouse does the CRV line use?

The generated child CRV line inherits both from the parent item automatically. The same quantity and the same warehouse are set on the associated CRV line when the main item is added to the sales order, so the fee stays proportional to what is being sold and no manual adjustment is required during order entry.

Work With the Biz-Tech Services CRV Solution for Acumatica

CRV processing in Acumatica is compact but precise. A non-stock CRV item defines the fee, the CRV Item field on each product creates the association, the CRV Amount field sets the value per unit of measure, the Include in CRV checkbox decides which customers are charged, and the Parent Item and Child Item fields keep the fee traceable to its product across sales orders, shipments, and invoices. Configure those five things correctly and CRV billing takes care of itself on every order that follows.

If your business distributes beverages in California and needs redemption value charges applied automatically and reported accurately, we are glad to help you configure and validate CRV handling in your Acumatica environment. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration.

How CRV Lines Flow Through Sales Orders, Shipments, and Invoices in Acumatica

California Redemption Value, or CRV, has to appear on the invoice as its own line, and it has to stay attached to the product that generated it. That is the whole problem CRV processing in Acumatica solves. When a beverage item is added to a sales order, the system automatically creates a second line for its associated CRV item, carries the same quantity and warehouse across, and keeps the two lines linked by parent and child references all the way through shipments and invoices. Understanding where that child line comes from, which fields control whether it appears, and how the link survives downstream is what keeps CRV billing accurate.

The Biz-Tech Services CRV solution for Acumatica handles this automatically rather than asking order entry staff to remember an extra line on every beverage order. This article follows a CRV line through the full Acumatica data flow, from the item configuration that defines it to the invoice where it is billed, and identifies the fields users should monitor at each stage.

What a CRV Item Is in Acumatica

A CRV item in Acumatica is a non-stock item used across the inventory and sales modules to identify products that carry an environmental fee. It is automatically added to sales transactions when you sell beverages that fall under California's recycling program. The distinction that matters most is structural: CRV items are only ever non-stock items. They represent a fee rather than physical goods, so they must never be set up as stock items, and the configuration will not behave correctly if they are.

In practice this means every beverage product you sell has two records behind it. The parent item is the actual product being shipped, and the child CRV item is the environmental fee attached to that product. Acumatica keeps them associated so that pricing, quantity, and downstream document flow stay synchronized.

Why California Redemption Value Matters for Beverage Distributors

California Redemption Value is a refundable deposit applied to eligible beverage containers under the state's beverage container recycling program. Consumers pay the deposit at purchase and recover it when they return the container for recycling. For distributors and retailers in the supply chain, CRV is not revenue in the ordinary sense; it is a pass-through amount that must be charged, tracked, and reported separately from the product price.

That separation is exactly why CRV cannot simply be built into a product's unit price. It needs to be visible as a distinct line on the sales document so that customers can see what they are paying, and so that the business can account for the deposit correctly. Any ERP handling for CRV therefore has to solve two things at once: automatically adding the fee whenever an eligible product is sold, and keeping that fee identifiable as belonging to a specific product line. The Acumatica configuration described below does both.

The CRV Data Flow at a Glance

Before looking at each screen, here is the full path a CRV line travels through Acumatica:

  • A CRV item is created as a non-stock item representing the environmental fee.
  • On the Stock Items (IN202500) screen, the Price/Cost tab of each eligible beverage product points to its CRV item through the CRV Item field.

  • The CRV Amount field on the General tab of the Stock Items screen determines the fee amount based on the selected unit of measure.
  • The Include in CRV checkbox on the customer's default location determines whether CRV applies to that customer at all.
  • When the parent item is added to a sales order for an eligible customer, Acumatica automatically adds the associated CRV item as a new line with the same quantity and warehouse.
  • Parent Item and Child Item fields on the Sales Orders, Shipments, and Invoices screens keep the product and its CRV line identifiable as a pair throughout the document flow.

Each field below sits at one of those handoffs, and knowing which stage a problem occurred at tells you which screen to open.

Step One: Configure the CRV Item as a Non-Stock Item

The flow begins with the fee itself. Before any product can reference a CRV charge, the CRV item must exist in Acumatica as a non-stock item. This is a prerequisite rather than a preference. The CRV Item field described in the next step expects a non-stock item, and configuring the fee as a stock item will break the association.

Businesses selling containers in more than one size category typically need more than one CRV item, since deposit amounts differ by container size under the state program. Setting these up as separate non-stock items, clearly named so that order entry staff and accounting can tell them apart on a document, is worth the small amount of extra effort at configuration time.

Step Two: Link the CRV Item to Its Parent Product

With the fee item in place, each eligible beverage product must be told which CRV item belongs to it. This association is made on the Stock Items screen and is the single most important link in the whole data flow. To configure it, navigate to the Stock Items screen, select the desired item, open the Price/Cost tab, and in the CRV Item field select the appropriate CRV item.

This field is what makes automatic CRV line creation possible. Without it, Acumatica has no way to know which fee applies to which product, and no child line will be generated when the product is sold. When a CRV charge fails to appear on an order, this field is the first place to check.

Step Three: Set the CRV Amount by Unit of Measure

The amount charged is controlled by the CRV Amount field on the General tab of the Stock Items screen. This field determines the amount for the associated CRV item based on the selected unit of measure, which allows a separate price to be defined for the CRV item independently of the product's own price.

The unit of measure dependency deserves attention during setup. Because deposits are levied per container, a product sold in multiple units of measure, such as individual bottles and cases, needs its CRV amount configured so that the resulting charge reflects the number of containers actually being sold. Reviewing this against a real order for each unit of measure you sell is a worthwhile validation step before going live.

Step Four: Enable Include in CRV on the Customer Location

The final piece of configuration determines which customers are charged. An Include in CRV checkbox has been added to the customer default location, and the status of that checkbox controls whether the CRV item is displayed on the sales order for that customer. Selected, and CRV lines are generated. Cleared, and they are not.

Placing this control at the location level rather than at the customer level is deliberate and useful. A customer with several ship-to locations may be subject to the deposit at some and not others, and the location record is where that distinction naturally lives. It also means CRV behavior can be adjusted for a specific customer relationship without touching item configuration that affects everyone.

How CRV Lines Are Created on the Sales Order

With configuration complete, the runtime behavior is simple and automatic. Navigate to the Sales Orders screen and select a customer whose location has the Include in CRV checkbox selected. When the main parent item is added to the order, the system automatically adds the associated CRV item as a new line.

Two attributes are inherited from the parent line rather than being entered by the user: the child CRV line receives the same quantity and the same warehouse as the parent item. This inheritance is what keeps the fee proportional to what is actually being sold. If ten cases are ordered, the CRV line reflects ten, and if the parent line ships from a particular warehouse, the CRV line is associated with that same warehouse. Order entry staff do not need to calculate, add, or adjust anything.

Parent Item and Child Item: Keeping CRV Lines Linked Downstream

A CRV line is only useful if you can tell which product it belongs to, and that becomes harder as documents multiply. To solve this, Parent Item and Child Item fields have been added to the Sales Orders, Shipments, and Invoices screens, specifically to identify the main item and its associated CRV item.

The significance of those three screens together is that the relationship survives the entire order-to-invoice flow. On the sales order, you can see which CRV line was generated by which product. When the order is shipped, the shipment document carries the same parent and child identification. When the invoice is produced, the association is still visible, so the customer's bill can be reconciled line by line and accounting can attribute every deposit to the product that generated it. This is what separates a properly modeled CRV implementation from one where fees appear as anonymous extra lines that nobody can trace.

Where to Monitor CRV Results in Acumatica

When configuring CRV, training users, or investigating an order where the fee looks wrong, these are the fields and screens that show what the system actually did:

  • The CRV Item field on the Price/Cost tab of the Stock Items screen, which defines the association between a product and its fee item and is the first thing to check when no CRV line appears.
  • The CRV Amount field on the General tab of the Stock Items screen, which sets the fee amount for the selected unit of measure.
  • The Include in CRV checkbox on the customer default location, which determines whether CRV lines are generated for that customer at all.
  • The non-stock status of the CRV item itself, since CRV items must always be non-stock items.
  • The Parent Item and Child Item fields on the Sales Orders screen, which confirm that the generated CRV line is correctly associated with its product.
  • The quantity and warehouse on the generated CRV line, which should match the parent line exactly.
  • The Parent Item and Child Item fields on the Shipments screen, which confirm the association survived shipment creation.
  • The Parent Item and Child Item fields on the Invoices screen, which is where the customer-facing result is verified and where accounting reconciles deposits against products sold.

CRV Processing in Acumatica: Frequently Asked Questions

What is a CRV item in Acumatica?

A CRV item is a non-stock item used in the inventory and sales modules to represent the California Redemption Value environmental fee attached to eligible beverage containers. It is added automatically to sales transactions when you sell beverages covered by California's recycling program, appearing as its own line alongside the product that generated it.

Does a CRV item have to be a non-stock item?

Yes. CRV items are only non-stock items. The fee represents a deposit rather than physical goods, and the CRV Item field on the Price/Cost tab of the Stock Items screen expects a non-stock item. Configuring the CRV item as a stock item will prevent the association from working correctly.

Why is the CRV line not appearing on my sales order?

Check three things in order. First, confirm that the Include in CRV checkbox is selected on the customer's default location, since this controls whether CRV items are displayed on the sales order for that customer. Second, confirm that the parent product has the correct CRV item selected in the CRV Item field on the Price/Cost tab of the Stock Items screen. Third, confirm that the CRV item itself is configured as a non-stock item.

How is the CRV amount determined?

The CRV Amount field on the General tab of the Stock Items screen determines the amount for the associated CRV item based on the selected unit of measure. This allows a separate price to be defined for the CRV item, independent of the product's own price, and lets the charge reflect the number of containers represented by the unit of measure being sold.

How do I tell which CRV line belongs to which product?

Use the Parent Item and Child Item fields, which have been added to the Sales Orders, Shipments, and Invoices screens specifically to identify the main item and its associated CRV item. Because those fields exist on all three screens, the relationship remains visible and traceable from order entry through shipment to the final invoice.

Can CRV be applied to some customers but not others?

Yes. The Include in CRV checkbox sits on the customer default location, so CRV behavior is controlled per location rather than globally. A customer with multiple ship-to locations can have the fee applied at some locations and not at others, without any change to item configuration.

What quantity and warehouse does the CRV line use?

The generated child CRV line inherits both from the parent item automatically. The same quantity and the same warehouse are set on the associated CRV line when the main item is added to the sales order, so the fee stays proportional to what is being sold and no manual adjustment is required during order entry.

Work With the Biz-Tech Services CRV Solution for Acumatica

CRV processing in Acumatica is compact but precise. A non-stock CRV item defines the fee, the CRV Item field on each product creates the association, the CRV Amount field sets the value per unit of measure, the Include in CRV checkbox decides which customers are charged, and the Parent Item and Child Item fields keep the fee traceable to its product across sales orders, shipments, and invoices. Configure those five things correctly and CRV billing takes care of itself on every order that follows.

If your business distributes beverages in California and needs redemption value charges applied automatically and reported accurately, we are glad to help you configure and validate CRV handling in your Acumatica environment. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration.


How Gift Card Processing Works in Acumatica from Sale to Redemption

How Gift Card Processing Works in Acumatica from Sale to Redemption

Gift Card Processing in Acumatica turns a gift card into two things at once: an item you sell and a payment method you later accept. That dual nature is what makes the data flow worth understanding. A gift card item is sold on a sales order, a serial number is generated and stored, a gift card record appears on the Payment Methods screen carrying its own balance, and every later redemption draws that balance down until nothing remains. Knowing where each record is created, which field holds the balance, and where to check the result is what keeps gift card liability accurate.

The Biz-Tech Services Gift Card Processing product, built for Acumatica, allows companies to sell serialized gift cards and then process those sold gift cards as payment. Gift cards grow sales, reinforce brand awareness, and are consistently preferred by customers over paper gift certificates. This article follows a gift card through the entire Acumatica data flow, from the preferences that define how it is numbered to the redemption that finally spends it, and points out the fields worth monitoring at every step.

What Gift Card Processing in Acumatica Does

Gift Card Processing is an Acumatica ERP customization that manages the full lifecycle of serialized gift cards. It lets you sell gift cards as either non-stock or stock inventory items, assigns each card a unique serial number, stores the card's value against the customer and order that created it, and then allows that stored value to be redeemed as a payment method on sales orders, invoices, and payments. Acumatica maintains a running Used Amount and Remaining Amount for every card, so the outstanding gift card balance is always visible and auditable. Cards can also be created directly from an external system through the API.

The Gift Card Data Flow at a Glance

Before looking at individual screens, it helps to see the path a gift card record travels through Acumatica:

  • A gift card payment method is configured on the Payment Methods (CA204000) screen and linked to a dedicated cash account.

  • Gift Card Preferences (BZ102000) defines how card numbers are generated and how external gift cards map to Acumatica items.
  • A gift card item is sold on the Sales Orders (SO301000) screen, either as a non-stock item or as a serialized stock item.

  • A serial number is generated and stored, and a gift card record appears on the Gift Cards tab of the Payment Methods screen with its customer, order, and amount.
  • The card is redeemed as a payment method on a sales order, on Payments and Applications (AR302000), or on an invoice, with the serial number identifying which balance to draw from.
  • Used Amount and Remaining Amount update on both the Payment Methods screen and the Gift Card History (BZ407099) screen after the payment is released.

Every field discussed below sits somewhere on that path. Identifying the stage tells you which screen holds the answer.

Setting the Foundation: The Gift Card Payment Method

The flow starts with a payment method, because a gift card is ultimately money. Payment methods are defined and viewed on the Payment Methods (CA204000) screen, and setting up gift cards begins by creating a new payment method there. Because payment methods are linked to cash accounts, it is strongly recommended to create a new general ledger account dedicated to the gift card item. Keeping gift card liability in its own account is what allows finance to see outstanding gift card value as a distinct number rather than buried in a general cash account.

Once that general ledger account exists, add the gift card cash account under the Allowed Cash Accounts tab of the payment method. One further field saves users time throughout the rest of the flow: the Default Gift Card field on the Payment Methods screen lets you nominate the gift card that will appear automatically in the Gift Card field of the Create Payment popup. With a default set, redemption becomes a matter of entering a serial number rather than selecting a card first.

Gift Card Preferences (BZ102000): Numbering and External Mapping

The Gift Card Preferences screen configures two things that shape every card created afterward: how gift card numbers are generated inside Acumatica, and how external gift cards map to Acumatica gift card items during order import.

Default Gift Card Item identifies the non-stock item treated as the default gift card during the order import process. Use Multiple Gift Cards in Commerce extends this by letting you map an external gift card SKU to its corresponding Acumatica gift card item, which is what makes orders containing several different gift cards import correctly. The fallback behavior is worth remembering: if Use Multiple Gift Cards in Commerce is not selected, the system defaults to the non-stock item named in Default Gift Card Item for every imported external order.

Sequential numbering versus random numbering

Selecting the Gift Card Numbering checkbox makes the Numbering Segments tab available, where you define the numbering structure for non-stock gift cards. Acumatica then generates card numbers according to that configuration. One detail is essential rather than optional: the Auto-Incremental Value must be configured in the Numbering Segments tab for gift card numbers to generate automatically.

Use Random Numbering takes the opposite approach and hides the Numbering Segments tab entirely. In this mode, Acumatica generates random numbers when a gift card item is entered on a sales order and a quantity is specified. The system produces as many random numbers as the entered quantity and displays them in the Gift Card Numbers popup. The security rationale matters: random numbering prevents anyone from guessing valid gift cards by following a predictable sequence. For cards distributed at scale, this is usually the safer choice.

Two Kinds of Gift Card Item: Non-Stock and Stock

Acumatica supports gift cards as either non-stock items or stock items, and the choice determines the shape of the early data flow. A non-stock gift card is the lighter path, suited to digital cards and to cards imported from external commerce systems. A stock gift card is a serialized physical inventory item that must be received before it can be sold, suited to physical cards held in a warehouse. Both converge on the same gift card record and the same redemption process, so the difference is confined to how the card comes into existence.

Selling a Non-Stock Gift Card Item in Acumatica

Non-stock gift card items are sold to customers on the standard Acumatica Sales Orders screen. The card can be sold directly within Acumatica or imported from an external system, after which the order proceeds to fulfillment as normal. The gift card number is generated and displayed in the Gift Card Numbers field on the Details tab of the sales order, and also in the Gift Card Numbers popup during order creation.

For orders created inside Acumatica, the gift card number can either be entered manually or generated according to the numbering setup in Gift Card Preferences. Three behaviors are worth knowing before users encounter them. The Gift Card Numbers popup displays the number belonging to the currently selected item line, so selecting a different line changes what you see. When the gift card quantity is greater than one, all of the generated numbers appear in that popup rather than on the line itself. And the shipping rule for a non-stock gift card automatically becomes Ship Complete on the sales order line.

Creating and Selling a Stock Gift Card Item

A stock gift card item is created from the Stock Items (IN202500) screen. Two configuration points make it function as a gift card. First, you must select the payment method to associate with the item for gift card payments. Second, because that field is enabled only for serialized items, a serial class specifically for the gift card item must be created on the Lot/Serial Classes screen. Serialization is what gives each physical card its own identity and its own balance.

Expiration dates are handled through the Track Expiration Date checkbox, which should be selected if gift cards are to expire. The timing matters: the gift card expiration date is established during the gift card receipt process, not at item creation.

The gift card receipt process

Stock gift cards must be received into inventory before they can be sold. Add the gift card item to the Receipts screen, enter the quantity, and generate the serial numbers together with their respective expiration dates from the Line Details popup window. Expiration dates appear here only when Track Expiration Date is selected on the serial class. At the end of this process, you hold a set of uniquely numbered, dated cards in inventory ready to sell.

Fulfilling a stock gift card order

Stock gift card items are sold on the same Sales Orders (SO301000) screen, but with one important difference: allocation is required for all stock gift card items. The specific card being sold must be chosen by selecting its serial number from the Lot/Serial Nbr field on the Line Details tab, which displays all available gift card serial numbers along with their expiration dates. This is the step that ties a physical card in your warehouse to a specific customer order.

Where the Gift Card Record Lives After the Sale

Once a gift card item is sold, whether stock or non-stock, the customer information, order information, and gift card amount are stored on the Gift Cards tab of the Payment Methods screen. This tab is the master record of every gift card in the system, and it displays Customer ID, Inventory ID, Gift Card Serial Number, Order Number, Gift Card Amount, Used Amount, and Remaining Amount.

Those last two fields are the ones to watch. As a gift card is used, Acumatica updates the Used Amount and Remaining Amount on this tab, so the outstanding balance of any card is always one screen away. Clicking a serial number opens the Gift Card History screen, which shows all transactions related to that card. Together these two views answer the two questions users actually ask: what is left on this card, and what has been done with it.

Redeeming a Gift Card as a Payment Method in Acumatica

Redemption is where a sold gift card becomes tender, and Acumatica supports three routes. All three follow the same underlying pattern: choose the gift card payment method, identify the specific card by serial number, and release the payment.

Redeeming on a sales order

On the Sales Orders (SO301000) screen, select Gift Card Payment as the payment method. This reveals the Gift Card field in the Create Payment popup. If a default gift card has been configured on the payment method, it appears automatically; if not, select it manually. Then enter the serial number of the card being redeemed, which can also be typed manually. Proceed with order fulfillment afterward, and note that the payment for the order must be released for the redemption to take effect.

Redeeming on Payments and Applications

Gift cards can also be processed on the Payments and Applications (AR302000) screen. Navigate to the screen and select the appropriate payment method and cash account, after which the Gift Card field appears. The default card populates automatically if one is configured, otherwise select it manually and enter the serial number. Once all required fields are complete, release the payment.

Redeeming against an invoice

The third route runs through the Invoices (SO303000) screen. Create an invoice by adding either the corresponding sales order or the relevant items. Create a payment from the Applications tab within the invoice, choose the gift card payment method, which displays the Gift Card field in the Create Payment popup, select the card if no default is set, and enter its serial number. Release the invoice and complete the payment process.

After both the invoice and the payment have been released, Acumatica updates the Used Amount and Remaining Amount fields in two places at once: the Gift Card tab of the Payment Methods screen and the Gift Card History screen. Those two screens agreeing is the confirmation that a redemption posted correctly.

The Gift Card Return Process

Returns follow standard Acumatica return-for-credit mechanics. Create a return order of the RC type on the Sales Orders (SO301000) form and add the line or lines from the sales invoice prepared for the original order. Receive the returned items back into inventory on the Shipments (SO302000) form by creating a shipment with the Receipt operation and confirming it. Then create a credit memo to decrease the customer's debt by the amount of the returned items, review its details on the Invoices (SO303000) form, and release it.

For gift card items specifically, the return can also be handled by adding the corresponding gift card items to an RC type return order on the Sales Orders form and selecting the serial number from the Sold Serial Numbers tab of the Line Details. That tab exists precisely so that a returned card can be matched to the exact serial that was sold. Once the return transaction is processed, Acumatica updates the amount information on the Gift Card History screen, which is where you verify that the returned card's balance was corrected.

Gift Card History and Gift Card Summary Screens

The Gift Card History (BZ407099) screen displays all information related to a given gift card and serves as the transaction ledger for that card. It is also a creation point: the Create Gift Card button opens a popup where the required data can be entered and confirmed with OK to create a card directly, without going through a sales order.

Two flags on this screen classify each card and are useful when filtering or troubleshooting. External Gift Card indicates that the card was imported from an external system, and Is Stock Gift Card indicates whether the card is a stock or non-stock item. The separate Gift Card Summary screen displays all related information for a gift card in consolidated form, and it also serves as the outbound channel for sending gift card summary details from Acumatica to an external system.

Creating Gift Cards from an External System via API

Gift card information can be imported into Acumatica from an external system through the API using the Biztech endpoint. The Create Gift Card action within the Gift Card History endpoint is what accepts inbound card data. Once the API request is processed, the gift card details, including customer information, serial number, and amount, appear on the Payment Methods screen under the Gift Card tab, and the same information becomes available on both the Gift

Card Summary and Gift Card History screens.

This matters for the data flow because it means a gift card does not have to originate from an Acumatica sales order. A card sold in an external commerce platform, a point of sale system, or a marketing campaign can enter Acumatica through the API and then behave exactly like any internally sold card, including being redeemed as a payment method and tracked through the same balance fields.

Where to Monitor Gift Card Processing Results in Acumatica

When training users or investigating a gift card that does not behave as expected, these are the fields and screens that show what the system actually did:

  • Gift Card Serial Number on the Gift Cards tab of the Payment Methods screen, which uniquely identifies every card and links to its history.
  • Gift Card Amount, Used Amount, and Remaining Amount, which together give the original value, the consumed value, and the current balance.
  • Customer ID, Inventory ID, and Order Number on the same tab, which tie a card back to who bought it and on which order.
  • The Gift Card History (BZ407099) screen, reached by clicking a serial number, which lists all transactions for that card and reflects return adjustments.
  • The Gift Card Numbers popup on the sales order, remembering that it shows numbers for the selected line and lists every number when the quantity exceeds one.
  • Lot/Serial Nbr on the Line Details tab for stock gift cards, which shows available serial numbers with their expiration dates during allocation.
  • The Sold Serial Numbers tab of Line Details, used to match a returned card to the serial number originally sold.
  • External Gift Card and Is Stock Gift Card flags on the Gift Card History screen, which classify how a card entered the system and what type it is.
  • The dedicated gift card cash account and general ledger account, which is where outstanding gift card liability should be reviewed by finance.

Gift Card Processing in Acumatica: Frequently Asked Questions

What is Gift Card Processing in Acumatica?

Gift Card Processing is an Acumatica ERP customization from Biz-Tech Services that lets companies sell serialized gift cards and then accept those cards as a payment method. Each card carries a unique serial number and its own balance, tracked through Gift Card Amount, Used Amount, and Remaining Amount fields on the Payment Methods screen, with a full transaction history available on the Gift Card History screen.

What is the difference between a stock and a non-stock gift card item?

A non-stock gift card is created and sold without inventory receipt, which suits digital cards and cards imported from external commerce systems. A stock gift card is a serialized inventory item created on the Stock Items (IN202500) screen that must be received through the gift card receipt process before it can be sold, and it requires allocation of a specific serial number at the time of sale. Both card types produce the same gift card record and are redeemed identically.

How are gift card numbers generated in Acumatica?

Gift Card Preferences (BZ102000) controls this. With the Gift Card Numbering checkbox selected, numbers follow the structure defined on the Numbering Segments tab, and the Auto-Incremental Value must be configured for automatic generation. With Use Random Numbering selected instead, the Numbering Segments tab is hidden and Acumatica generates random numbers based on the quantity entered on the sales order, which prevents anyone from predicting valid card numbers. Numbers can also be entered manually for orders created inside Acumatica.

How do you redeem a gift card in Acumatica?

There are three routes. On the Sales Orders (SO301000) screen, select Gift Card Payment as the payment method, then supply the card and its serial number in the Create Payment popup. On Payments and Applications (AR302000), select the payment method and cash account, then the card and serial number. On the Invoices (SO303000) screen, create a payment from the Applications tab and do the same. In every case the payment must be released for the balance to update.

Where do you check a gift card balance in Acumatica?

Open the Gift Cards tab of the Payment Methods screen and locate the card by serial number. The Remaining Amount field shows the current balance, with Gift Card Amount showing the original value and Used Amount showing what has been consumed. Clicking the serial number opens the Gift Card History screen for the full transaction detail behind those figures.

Can gift cards be returned in Acumatica?

Yes. Create a return order of the RC type on the Sales Orders (SO301000) form, add the relevant lines, receive the items on the Shipments (SO302000) form using the Receipt operation, then create and release a credit memo through the Invoices (SO303000) form. For gift card items you can select the specific card from the Sold Serial Numbers tab of the Line Details. Once the return is processed, the amount information updates on the Gift Card History screen.

Can gift cards be created from an external system?

Yes. Gift card information can be imported into Acumatica through the API using the Biztech endpoint, via the Create Gift Card action in the Gift Card History endpoint. After the request is processed, the customer information, serial number, and amount appear on the Gift Card tab of the Payment Methods screen and on both the Gift Card Summary and Gift Card History screens. Cards can also be created manually with the Create Gift Card button on the Gift Card History screen.

Work With the Biz-Tech Services Gift Card Processing Product

Gift Card Processing in Acumatica becomes straightforward once the flow is clear. The payment method and its dedicated cash account establish where gift card value lives, preferences decide how cards are numbered and mapped, the sales order creates the card and its serial number, the Payment Methods screen holds the balance, redemption draws that balance down through any of three screens, and the Gift Card History screen records everything that happened along the way. Teams that know which field governs each handoff can answer any gift card question in seconds.

If your business wants to sell gift cards, accept them as payment, and keep outstanding gift card liability visible and accurate, we are glad to help you scope, configure, and roll out Gift Card Processing in Acumatica. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Biz-Tech Services Gift Card Processing product.

How Gift Card Processing Works in Acumatica from Sale to Redemption

Gift Card Processing in Acumatica turns a gift card into two things at once: an item you sell and a payment method you later accept. That dual nature is what makes the data flow worth understanding. A gift card item is sold on a sales order, a serial number is generated and stored, a gift card record appears on the Payment Methods screen carrying its own balance, and every later redemption draws that balance down until nothing remains. Knowing where each record is created, which field holds the balance, and where to check the result is what keeps gift card liability accurate.

The Biz-Tech Services Gift Card Processing product, built for Acumatica, allows companies to sell serialized gift cards and then process those sold gift cards as payment. Gift cards grow sales, reinforce brand awareness, and are consistently preferred by customers over paper gift certificates. This article follows a gift card through the entire Acumatica data flow, from the preferences that define how it is numbered to the redemption that finally spends it, and points out the fields worth monitoring at every step.

What Gift Card Processing in Acumatica Does

Gift Card Processing is an Acumatica ERP customization that manages the full lifecycle of serialized gift cards. It lets you sell gift cards as either non-stock or stock inventory items, assigns each card a unique serial number, stores the card's value against the customer and order that created it, and then allows that stored value to be redeemed as a payment method on sales orders, invoices, and payments. Acumatica maintains a running Used Amount and Remaining Amount for every card, so the outstanding gift card balance is always visible and auditable. Cards can also be created directly from an external system through the API.

The Gift Card Data Flow at a Glance

Before looking at individual screens, it helps to see the path a gift card record travels through Acumatica:

  • A gift card payment method is configured on the Payment Methods (CA204000) screen and linked to a dedicated cash account.

  • Gift Card Preferences (BZ102000) defines how card numbers are generated and how external gift cards map to Acumatica items.
  • A gift card item is sold on the Sales Orders (SO301000) screen, either as a non-stock item or as a serialized stock item.

  • A serial number is generated and stored, and a gift card record appears on the Gift Cards tab of the Payment Methods screen with its customer, order, and amount.
  • The card is redeemed as a payment method on a sales order, on Payments and Applications (AR302000), or on an invoice, with the serial number identifying which balance to draw from.
  • Used Amount and Remaining Amount update on both the Payment Methods screen and the Gift Card History (BZ407099) screen after the payment is released.

Every field discussed below sits somewhere on that path. Identifying the stage tells you which screen holds the answer.

Setting the Foundation: The Gift Card Payment Method

The flow starts with a payment method, because a gift card is ultimately money. Payment methods are defined and viewed on the Payment Methods (CA204000) screen, and setting up gift cards begins by creating a new payment method there. Because payment methods are linked to cash accounts, it is strongly recommended to create a new general ledger account dedicated to the gift card item. Keeping gift card liability in its own account is what allows finance to see outstanding gift card value as a distinct number rather than buried in a general cash account.

Once that general ledger account exists, add the gift card cash account under the Allowed Cash Accounts tab of the payment method. One further field saves users time throughout the rest of the flow: the Default Gift Card field on the Payment Methods screen lets you nominate the gift card that will appear automatically in the Gift Card field of the Create Payment popup. With a default set, redemption becomes a matter of entering a serial number rather than selecting a card first.

Gift Card Preferences (BZ102000): Numbering and External Mapping

The Gift Card Preferences screen configures two things that shape every card created afterward: how gift card numbers are generated inside Acumatica, and how external gift cards map to Acumatica gift card items during order import.

Default Gift Card Item identifies the non-stock item treated as the default gift card during the order import process. Use Multiple Gift Cards in Commerce extends this by letting you map an external gift card SKU to its corresponding Acumatica gift card item, which is what makes orders containing several different gift cards import correctly. The fallback behavior is worth remembering: if Use Multiple Gift Cards in Commerce is not selected, the system defaults to the non-stock item named in Default Gift Card Item for every imported external order.

Sequential numbering versus random numbering

Selecting the Gift Card Numbering checkbox makes the Numbering Segments tab available, where you define the numbering structure for non-stock gift cards. Acumatica then generates card numbers according to that configuration. One detail is essential rather than optional: the Auto-Incremental Value must be configured in the Numbering Segments tab for gift card numbers to generate automatically.

Use Random Numbering takes the opposite approach and hides the Numbering Segments tab entirely. In this mode, Acumatica generates random numbers when a gift card item is entered on a sales order and a quantity is specified. The system produces as many random numbers as the entered quantity and displays them in the Gift Card Numbers popup. The security rationale matters: random numbering prevents anyone from guessing valid gift cards by following a predictable sequence. For cards distributed at scale, this is usually the safer choice.

Two Kinds of Gift Card Item: Non-Stock and Stock

Acumatica supports gift cards as either non-stock items or stock items, and the choice determines the shape of the early data flow. A non-stock gift card is the lighter path, suited to digital cards and to cards imported from external commerce systems. A stock gift card is a serialized physical inventory item that must be received before it can be sold, suited to physical cards held in a warehouse. Both converge on the same gift card record and the same redemption process, so the difference is confined to how the card comes into existence.

Selling a Non-Stock Gift Card Item in Acumatica

Non-stock gift card items are sold to customers on the standard Acumatica Sales Orders screen. The card can be sold directly within Acumatica or imported from an external system, after which the order proceeds to fulfillment as normal. The gift card number is generated and displayed in the Gift Card Numbers field on the Details tab of the sales order, and also in the Gift Card Numbers popup during order creation.

For orders created inside Acumatica, the gift card number can either be entered manually or generated according to the numbering setup in Gift Card Preferences. Three behaviors are worth knowing before users encounter them. The Gift Card Numbers popup displays the number belonging to the currently selected item line, so selecting a different line changes what you see. When the gift card quantity is greater than one, all of the generated numbers appear in that popup rather than on the line itself. And the shipping rule for a non-stock gift card automatically becomes Ship Complete on the sales order line.

Creating and Selling a Stock Gift Card Item

A stock gift card item is created from the Stock Items (IN202500) screen. Two configuration points make it function as a gift card. First, you must select the payment method to associate with the item for gift card payments. Second, because that field is enabled only for serialized items, a serial class specifically for the gift card item must be created on the Lot/Serial Classes screen. Serialization is what gives each physical card its own identity and its own balance.

Expiration dates are handled through the Track Expiration Date checkbox, which should be selected if gift cards are to expire. The timing matters: the gift card expiration date is established during the gift card receipt process, not at item creation.

The gift card receipt process

Stock gift cards must be received into inventory before they can be sold. Add the gift card item to the Receipts screen, enter the quantity, and generate the serial numbers together with their respective expiration dates from the Line Details popup window. Expiration dates appear here only when Track Expiration Date is selected on the serial class. At the end of this process, you hold a set of uniquely numbered, dated cards in inventory ready to sell.

Fulfilling a stock gift card order

Stock gift card items are sold on the same Sales Orders (SO301000) screen, but with one important difference: allocation is required for all stock gift card items. The specific card being sold must be chosen by selecting its serial number from the Lot/Serial Nbr field on the Line Details tab, which displays all available gift card serial numbers along with their expiration dates. This is the step that ties a physical card in your warehouse to a specific customer order.

Where the Gift Card Record Lives After the Sale

Once a gift card item is sold, whether stock or non-stock, the customer information, order information, and gift card amount are stored on the Gift Cards tab of the Payment Methods screen. This tab is the master record of every gift card in the system, and it displays Customer ID, Inventory ID, Gift Card Serial Number, Order Number, Gift Card Amount, Used Amount, and Remaining Amount.

Those last two fields are the ones to watch. As a gift card is used, Acumatica updates the Used Amount and Remaining Amount on this tab, so the outstanding balance of any card is always one screen away. Clicking a serial number opens the Gift Card History screen, which shows all transactions related to that card. Together these two views answer the two questions users actually ask: what is left on this card, and what has been done with it.

Redeeming a Gift Card as a Payment Method in Acumatica

Redemption is where a sold gift card becomes tender, and Acumatica supports three routes. All three follow the same underlying pattern: choose the gift card payment method, identify the specific card by serial number, and release the payment.

Redeeming on a sales order

On the Sales Orders (SO301000) screen, select Gift Card Payment as the payment method. This reveals the Gift Card field in the Create Payment popup. If a default gift card has been configured on the payment method, it appears automatically; if not, select it manually. Then enter the serial number of the card being redeemed, which can also be typed manually. Proceed with order fulfillment afterward, and note that the payment for the order must be released for the redemption to take effect.

Redeeming on Payments and Applications

Gift cards can also be processed on the Payments and Applications (AR302000) screen. Navigate to the screen and select the appropriate payment method and cash account, after which the Gift Card field appears. The default card populates automatically if one is configured, otherwise select it manually and enter the serial number. Once all required fields are complete, release the payment.

Redeeming against an invoice

The third route runs through the Invoices (SO303000) screen. Create an invoice by adding either the corresponding sales order or the relevant items. Create a payment from the Applications tab within the invoice, choose the gift card payment method, which displays the Gift Card field in the Create Payment popup, select the card if no default is set, and enter its serial number. Release the invoice and complete the payment process.

After both the invoice and the payment have been released, Acumatica updates the Used Amount and Remaining Amount fields in two places at once: the Gift Card tab of the Payment Methods screen and the Gift Card History screen. Those two screens agreeing is the confirmation that a redemption posted correctly.

The Gift Card Return Process

Returns follow standard Acumatica return-for-credit mechanics. Create a return order of the RC type on the Sales Orders (SO301000) form and add the line or lines from the sales invoice prepared for the original order. Receive the returned items back into inventory on the Shipments (SO302000) form by creating a shipment with the Receipt operation and confirming it. Then create a credit memo to decrease the customer's debt by the amount of the returned items, review its details on the Invoices (SO303000) form, and release it.

For gift card items specifically, the return can also be handled by adding the corresponding gift card items to an RC type return order on the Sales Orders form and selecting the serial number from the Sold Serial Numbers tab of the Line Details. That tab exists precisely so that a returned card can be matched to the exact serial that was sold. Once the return transaction is processed, Acumatica updates the amount information on the Gift Card History screen, which is where you verify that the returned card's balance was corrected.

Gift Card History and Gift Card Summary Screens

The Gift Card History (BZ407099) screen displays all information related to a given gift card and serves as the transaction ledger for that card. It is also a creation point: the Create Gift Card button opens a popup where the required data can be entered and confirmed with OK to create a card directly, without going through a sales order.

Two flags on this screen classify each card and are useful when filtering or troubleshooting. External Gift Card indicates that the card was imported from an external system, and Is Stock Gift Card indicates whether the card is a stock or non-stock item. The separate Gift Card Summary screen displays all related information for a gift card in consolidated form, and it also serves as the outbound channel for sending gift card summary details from Acumatica to an external system.

Creating Gift Cards from an External System via API

Gift card information can be imported into Acumatica from an external system through the API using the Biztech endpoint. The Create Gift Card action within the Gift Card History endpoint is what accepts inbound card data. Once the API request is processed, the gift card details, including customer information, serial number, and amount, appear on the Payment Methods screen under the Gift Card tab, and the same information becomes available on both the Gift

Card Summary and Gift Card History screens.

This matters for the data flow because it means a gift card does not have to originate from an Acumatica sales order. A card sold in an external commerce platform, a point of sale system, or a marketing campaign can enter Acumatica through the API and then behave exactly like any internally sold card, including being redeemed as a payment method and tracked through the same balance fields.

Where to Monitor Gift Card Processing Results in Acumatica

When training users or investigating a gift card that does not behave as expected, these are the fields and screens that show what the system actually did:

  • Gift Card Serial Number on the Gift Cards tab of the Payment Methods screen, which uniquely identifies every card and links to its history.
  • Gift Card Amount, Used Amount, and Remaining Amount, which together give the original value, the consumed value, and the current balance.
  • Customer ID, Inventory ID, and Order Number on the same tab, which tie a card back to who bought it and on which order.
  • The Gift Card History (BZ407099) screen, reached by clicking a serial number, which lists all transactions for that card and reflects return adjustments.
  • The Gift Card Numbers popup on the sales order, remembering that it shows numbers for the selected line and lists every number when the quantity exceeds one.
  • Lot/Serial Nbr on the Line Details tab for stock gift cards, which shows available serial numbers with their expiration dates during allocation.
  • The Sold Serial Numbers tab of Line Details, used to match a returned card to the serial number originally sold.
  • External Gift Card and Is Stock Gift Card flags on the Gift Card History screen, which classify how a card entered the system and what type it is.
  • The dedicated gift card cash account and general ledger account, which is where outstanding gift card liability should be reviewed by finance.

Gift Card Processing in Acumatica: Frequently Asked Questions

What is Gift Card Processing in Acumatica?

Gift Card Processing is an Acumatica ERP customization from Biz-Tech Services that lets companies sell serialized gift cards and then accept those cards as a payment method. Each card carries a unique serial number and its own balance, tracked through Gift Card Amount, Used Amount, and Remaining Amount fields on the Payment Methods screen, with a full transaction history available on the Gift Card History screen.

What is the difference between a stock and a non-stock gift card item?

A non-stock gift card is created and sold without inventory receipt, which suits digital cards and cards imported from external commerce systems. A stock gift card is a serialized inventory item created on the Stock Items (IN202500) screen that must be received through the gift card receipt process before it can be sold, and it requires allocation of a specific serial number at the time of sale. Both card types produce the same gift card record and are redeemed identically.

How are gift card numbers generated in Acumatica?

Gift Card Preferences (BZ102000) controls this. With the Gift Card Numbering checkbox selected, numbers follow the structure defined on the Numbering Segments tab, and the Auto-Incremental Value must be configured for automatic generation. With Use Random Numbering selected instead, the Numbering Segments tab is hidden and Acumatica generates random numbers based on the quantity entered on the sales order, which prevents anyone from predicting valid card numbers. Numbers can also be entered manually for orders created inside Acumatica.

How do you redeem a gift card in Acumatica?

There are three routes. On the Sales Orders (SO301000) screen, select Gift Card Payment as the payment method, then supply the card and its serial number in the Create Payment popup. On Payments and Applications (AR302000), select the payment method and cash account, then the card and serial number. On the Invoices (SO303000) screen, create a payment from the Applications tab and do the same. In every case the payment must be released for the balance to update.

Where do you check a gift card balance in Acumatica?

Open the Gift Cards tab of the Payment Methods screen and locate the card by serial number. The Remaining Amount field shows the current balance, with Gift Card Amount showing the original value and Used Amount showing what has been consumed. Clicking the serial number opens the Gift Card History screen for the full transaction detail behind those figures.

Can gift cards be returned in Acumatica?

Yes. Create a return order of the RC type on the Sales Orders (SO301000) form, add the relevant lines, receive the items on the Shipments (SO302000) form using the Receipt operation, then create and release a credit memo through the Invoices (SO303000) form. For gift card items you can select the specific card from the Sold Serial Numbers tab of the Line Details. Once the return is processed, the amount information updates on the Gift Card History screen.

Can gift cards be created from an external system?

Yes. Gift card information can be imported into Acumatica through the API using the Biztech endpoint, via the Create Gift Card action in the Gift Card History endpoint. After the request is processed, the customer information, serial number, and amount appear on the Gift Card tab of the Payment Methods screen and on both the Gift Card Summary and Gift Card History screens. Cards can also be created manually with the Create Gift Card button on the Gift Card History screen.

Work With the Biz-Tech Services Gift Card Processing Product

Gift Card Processing in Acumatica becomes straightforward once the flow is clear. The payment method and its dedicated cash account establish where gift card value lives, preferences decide how cards are numbered and mapped, the sales order creates the card and its serial number, the Payment Methods screen holds the balance, redemption draws that balance down through any of three screens, and the Gift Card History screen records everything that happened along the way. Teams that know which field governs each handoff can answer any gift card question in seconds.

If your business wants to sell gift cards, accept them as payment, and keep outstanding gift card liability visible and accurate, we are glad to help you scope, configure, and roll out Gift Card Processing in Acumatica. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Biz-Tech Services Gift Card Processing product.


How Kit Processing Works in Acumatica from Order Entry to Fulfillment

How Kit Processing Works in Acumatica from Order Entry to Fulfillment

Kit Processing in Acumatica is easiest to understand as a data flow rather than as a screen. A single kit record starts life on the Kit Specifications form, picks up defaults from your preferences screens, becomes a line on a sales order, splits into a placeholder and a set of components, and finally resolves into a shipment, an invoice, and a set of inventory transactions. Every problem a user ever reports with kits traces back to one of those handoffs. Understanding where each record is created, which field controls the next step, and where the result becomes visible is what makes the module predictable.

The Biz-Tech Services Kit Processing product lets users explode kit components directly on the Sales Orders screen, with no need to open a separate maintenance form or print a pick list just to see what a kit contains. Cost calculation for kit items is controlled from the native Sales Order Preferences screen, which gives companies flexibility without forcing maintenance adjustments to inventory items. This article follows a kit through the entire Acumatica data flow, from the specification that defines it to the released invoice that closes it out, and points out the fields worth watching at each stage.

Stage One: The Kit Specification Is the Source of Every Record

Everything downstream inherits from the Kit Specifications form, so this is where the data flow begins. The form is available only when the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form, and you can create a kit specification only for an inventory item that has already been marked as a kit on the General tab of the Stock Items (IN202500) or Non-Stock Items (IN202000) form. That marking is the true origin point of the record. Without it, no specification can exist.

The header fields define the identity of the kit. Kit Inventory ID is the inventory identifier of the kit as assigned on the stock or non-stock item form, and Non-Stock is a read-only checkbox indicating that the kit is a non-stock kit. Revision ID uniquely identifies each revision of the specification, and Description holds a brief summary. Two checkboxes govern whether the record participates in the flow at all: Active marks the specification as usable, and Current Revision indicates which revision the system will actually use when the kit explodes on a sales order. If a kit item already has a current revision and you attempt to change it, the system warns you that saving will uncheck the previous one. Only one revision is current at a time, and that is the revision the rest of the flow will read.

Explode Kit is the field that determines whether the kit will break into its components on the Sales Orders screen. Selecting it activates three further fields that shape the entire downstream flow: Kit Placeholder Item, Explode Option, and Price Calculation. Kit has options adds Option Category and Option Codes tabs, where you define the choices a user will be asked to make during order entry. Marking an option category as Required forces the user to select a code in the Options popup before the kit order can proceed, while Sort Order controls whether categories appear in ascending or descending order in the Sales Orders dropdown. Default Code automatically includes an option code in the order without user input, which matters a great deal for any path where no human is present to choose: API calls, import scenarios, processing screens, and opportunities or sales quotes.

Three further checkboxes extend what users can change later in the flow. Allow Option Rules adds an Option Rule tab, where a source option category and code exclude a target option category and code on the Sales Orders screen. If Size 8x10 is configured to exclude the color Black, a user who selects 8x10 will not be offered Black; selecting a size that is not covered by a rule, such as 8x12, makes Black available again. Allow Component Substitution adds a Substitution tab and a matching column on the Stock Components tab, letting you nominate replacement items for specific components. Allow Component Addition activates the Add Row option in the Component Details dialog on the Sales Orders screen, permitting new components to be added before the kit explodes.

Two structural rules belong here because they cause real problems when missed. First, the Unit of Measure of the Kit Placeholder Item must match the Unit of Measure of the kit item, or the system raises a warning. Second, for nested kits, where a kit item is used as a component or option inside another kit, the main kit is the Parent Kit and the included kit is the Child Kit. If a non-stock kit is used as a component or option, the Explode Option for both the parent and the child must be set to Automatically. The same requirement applies when a non-stock kit contains a stock option item, because only automatic explosion ensures the stock option is allocated during shipment.

Stage Two: Acumatica Preferences Supply the Defaults That Flow Downstream

The second stage of the Acumatica Kit Processing data flow is the Biz-Tech Services Kit Processing Settings section on the Sales Orders Preferences screen, with an equivalent section on the Purchase Orders Preferences screen. Price Calculation for Kits, Kit Placeholder Item, and Explode Option are general settings that apply to every kit. The precedence rule is simple and worth teaching to every user: if those same settings are configured manually for a specific kit on the Kit Specifications screen, the system prioritizes the kit-level setting over the general one. When a kit behaves differently from what preferences suggest, the specification is almost always the reason. If the specific item has already configyration done in Kit Specifications screen, then the setup of individual item would be used

Several preference fields change how quantities and documents behave later in the flow. Not Calculate Component Quantities bases quantity calculation in sales orders on the quantity specified for the kit itself. Invoice After Full Shipment allows partial shipment and holds the placeholder item back until every component has shipped. Use Kit Posting Group places the kit item's account and subaccount values on the placeholder row after explosion, and Apply to the Components extends those same values to the component rows. Allow Kit Assembly Generation enables the assembly branch described later. Unexploded Kit Price Calculation by Components prevents the kit from exploding and calculates only the price of the components toward the order total, which is why selecting it triggers a warning that the Explode Kit checkbox should be unchecked.

Components Qty. Is Required for Kit Item Ship deserves particular attention, because it decides whether a shipment can be created at all. Selecting it reveals a dropdown with three shipping behaviors. Ship Available Qty. sets the kit or placeholder line to back order allowed and lets a shipment be created for the minimum component quantity, without requiring every component to be available. Ship Ordered Qty. requires all components to be available and allocated based on the kit quantity, so nothing ships until everything is ready. The third option allows back order without requiring component quantity to be available for shipping. Finally, Allow Edit Exploded Kit Component gives users control over component quantities after explosion and permits deletion of kit components on the Sales Orders screen, and it has the same effect on the Purchase Orders screen when set in purchase order preferences.

Two settings outside these screens can also stop the flow. Selecting Block Kit Items Explosion on the Customers or Vendors screen prevents kits from exploding for that business account, and the same checkbox in the Biz-Tech Kit Processing Settings on the Order Types screen prevents explosion for that order type. Both override the explode option on the kit itself, so they are the first place to look when a kit refuses to explode for one customer or one order type but works everywhere else.

Stage Three: Sales Order Entry and the Component Details Window

Once a kit item is added to a sales order, the flow moves into the Component Details popup, which is the working surface for everything that happens before explosion. If the kit has options, an Options popup opens automatically when the kit item is entered, prompting the user to select an option code for each option category before pressing OK. Those selections can still be revised without exploding the kit by using the Change Options button in Component Details; all previous option category and option code configurations remain intact unless they are manually changed.

Before explosion, Component Details is where the order line is shaped. Users can add or delete components, and they can exchange a component for an approved substitute by double-clicking the item and choosing the replacement from the search icon that appears beside it. This window is also the point where purchasing can be triggered. Selecting the Mark for PO checkbox for a component and clicking Create PO generates a purchase order, and the resulting purchase order number is displayed under the PO Number field in Component Details. The required quantity must have a value for the purchase order to be created. Purchase orders are created according to the Default Vendor ID of each component, and when several components share the same vendor, a single purchase order covers them all. If that purchase order or its lines are later deleted, the number is removed from Component Details automatically, which keeps the reference trustworthy.

Stage Four: Acumatica Kit Explosion and the Placeholder Item

Explosion is the pivotal transformation in the Biz-Tech Services Acumatica Kit Processing flow, because it is the moment one order line becomes many. A kit explodes in one of two ways: by clicking Load Components in the Component Details dialog, or simply by assigning a quantity to the newly added kit on the sales order. Which of these is even possible depends on the Explode Option chosen earlier. Prompt asks the user whether to explode, Automatically explodes without user intervention, and Do Not Explode prevents explosion entirely.

When the kit explodes, the kit placeholder item and its components appear on the sales order lines with their respective prices, quantities, and costs. The placeholder is a non-stock item that replaces the kit item on the Sales Orders screen after explosion. Its purpose is financial accuracy: a kit item consists of multiple components, and when those components are added to the order as real lines, leaving the original kit item in place would double-count item cost. The placeholder behaves like the kit item in the order but contains no actual items. One field on that placeholder row is worth monitoring closely. Total Cost of Components is calculated as the component's unit cost at the time the sales order was created, which does not change afterward, multiplied by the quantity. It is displayed on the kit placeholder row and carried forward to the invoice, making it the natural checkpoint for verifying kit margin.

Price Calculation determines what the customer is charged, and it offers three methods. Use Kit Default Price applies the kit's own default price, plus any manually added price for its options. Use Component Default Price bases the price on each component's default price and sets the kit item price to zero. Use Combined Default Price adds the kit's default price to the default prices of the components. The choice matters beyond the order total, because it changes how partial shipments are invoiced, as described in the fulfillment stage below.

Editing rules tighten once explosion has occurred, and this catches users out more than any other behavior in the module. After the kit has exploded, components can no longer be added or deleted from the Component Details popup; only Quantity and Warehouse remain editable there. To add or remove components at that point, users must work with the [X] and [+] buttons on the Document Details tab of the sales order. Before explosion, the picture is different again: if Allow Component Addition is off, new components cannot be added, although existing components can still be deleted.

Stage Five: The Acumatica Kit Assembly Branch

Kit Assembly is an optional branch in the Acumatica data flow rather than a mandatory step, and it is available only when the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form. A kit assembly document contains the required stock components with their quantities and costs, calculated according to the kit specification revision you specify. Assemblies can be created directly on the Kit Assembly screen by entering the kit item in the Inventory ID field, selecting the revision, choosing a warehouse, and entering a quantity. Components can be added or removed before the assembly is released.

The more interesting path runs from the sales order, because it lets you assemble without exploding the kit. The user enters the kit on the sales order, optionally adjusts components in the Component Details popup, selects the Mark for Kit Assembly checkbox on the Details tab, and then clicks Generate Kit Assembly from the Actions list followed by Save. The same action is available through the Mark/Unmark for Kit Assembly button in the Component Details dialog. The generated assembly places a link number in the Kit Assembly field on the Details tab of the sales order, and clicking that link opens the Kit Assembly form. The relationship is visible from both ends: the Orders tab of the Kit Assembly screen shows the linked sales order number the assembly came from. Two constraints apply. Kit assemblies generated from sales orders always use the current revision specified on the Kit Specifications screen, and for non-stock kit items the Mark for Assembly button is disabled.

Stage Six: Kit Order Fulfillment in Acumatica

With explosion complete, the order moves into the standard Acumatica fulfillment cycle, and the kit records follow the components rather than the kit. The sequence is four steps. First, click Create Shipment on the toolbar and confirm the Specify Shipment Parameters window with OK. Second, on the Shipments screen to which you are redirected, click Confirm Shipment. Third, on the Invoices screen, click Prepare Invoice. Fourth, release the invoice with the Release button. At that point the inventory and financial impact of the kit is fully posted.

Partial shipments introduce one behavior that finance teams should know before it appears on a customer document. When Use Kit Default Price is the selected price calculation method and the order ships partially, the invoice for the first shipment carries the total kit price, and the invoice price for the remaining items is zero. This is intentional, since the kit is priced once rather than per component, but it looks surprising on a second invoice if nobody was expecting it. Where this is undesirable, Invoice After Full Shipment holds the placeholder back until all components have shipped, so the kit is invoiced only once everything is out the door.

The Purchase Order Side of Kit Processing

Kit Processing in Acumatica is not limited to the sell side. The Purchase Orders Preferences screen carries the same Biz-Tech Kit Processing Settings section, with the same precedence rule that kit-level configuration overrides the general settings, and the same Unexploded Kit Price Calculation by Components and Allow Edit Exploded Kit Component behaviors. Adding a kit item to a purchase order gives access to the same Component Details popup, where components can be added, deleted, or exchanged for substitutes and options can be changed before explosion. The kit is exploded either by clicking Load Components or by assigning a quantity to the kit line, exactly as on the sales order.

The inbound flow then completes in three moves. A purchase order containing the kit items is created and exploded. When the components are received, a purchase receipt for the ordered items is created. On release of that purchase receipt, the system automatically generates an inventory receipt reflecting the items in inventory. That automatic inventory receipt is the point at which purchased kit components become available stock, so it is the record to check when component availability does not look right after a delivery.

Where the Flow Starts Earlier: Opportunities and Sales Quotes

For businesses that quote before they sell, the kit data flow begins one step earlier. A kit item is added on the Details tab of the Opportunities screen and a quote is generated with the Create Quote button. The kit will not explode on the Opportunities screen itself.

Explosion happens on the Sales Quotes screen, either by giving the kit a quantity or by clicking Load Components on the Details tab. After saving, the exploded kit is reflected back in the Details tab of the Opportunities screen, and from then on any change made to the exploded kit updates in both screens. This is also the path where Default Code earns its place, since no user is prompted to pick options during automated or quote-driven creation.

Kit Pricing Summary: Where Pricing Is Reviewed and Applied

Kit Pricing Summary is the analysis point of the Acumatica Kit Processing flow, and it uses the same explosion logic as the order screens. For a kit to appear here, its specification must have the Active checkbox selected and the Revision field filled in. Selecting the kit in the Kit Inventory ID field loads the kit together with its components, stock components first and non-stock components after. Each component line displays Quantity, Unit Price, Min Markup %, Markup %, Extended Price, and Surcharge, and the calculated totals of Extended Price and Surcharge appear on the last line.

Two formulas govern the numbers. Surcharge is calculated as quantity multiplied by unit price multiplied by minimum markup, divided by one hundred. Total with Surcharge is the sum of the extended price and surcharge amounts across the component lines. Clicking Apply Price takes the total surcharge from the last line and applies it to the kit item's default price, which is how component-level markup becomes a kit-level price. The screen works for nested kits as well: after the parent kit is exploded, the components of both kits load together and the totals line sums their extended prices and surcharges. The whole summary can be exported to Excel, which makes it a practical review artifact for a pricing meeting.

Where to Monitor Kit Processing Results in Acumatica

If you are training users or troubleshooting a kit order in Acumatica, these are the fields and screens that tell you what the system actually did:

  • Current Revision on Kit Specifications, which determines the revision every downstream document reads.
  • Explode Option and Explode Kit, which decide whether the order line ever becomes components.
  • Block Kit Items Explosion on the Customers, Vendors, and Order Types screens, which silently overrides the kit's own explode setting.
  • Total Cost of Components on the kit placeholder row, which carries the frozen unit cost forward to the invoice.
  • PO Number in the Component Details popup, which confirms whether a component was purchased and stays accurate if the purchase order is deleted.
  • Kit Assembly on the sales order Details tab, which links to the generated assembly, and the Orders tab of the Kit Assembly screen, which links back.
  • The Component Availability section of Component Details, which can display Qty. Available, Qty. Avail. for Shipping, and Qty. on Hand.
  • Next receive information in the same window, including next receive type and reference number, with Inc. In Receipt, Inc. In Transfer, Inc. PO, Inc. PO Receipt, and Inc. PO Transfer controlling which documents are considered when calculating the next receive date and quantity.
  • The totals line on Kit Pricing Summary, where extended price and surcharge are reviewed before Apply Price changes the kit's default price.

One note on availability display: if any kit component has a quantity of zero and the kit item is not set to back order allowed, an error message appears when the availability checkbox is selected. That message is a genuine signal about allocation, not a display fault.

Loading Kits in Bulk with Acumatica Import Scenarios

Kit items do not have to be built by hand. Acumatica import scenarios support structured, automated entry of kit data from external sources, and the product ships with a set of scenarios that map to the stages described above. BZ-Import Is a Kit Check Box in Non-Stock and BZ-Import Is a Kit Check Box in Stock enable the Is a Kit checkbox on the respective item forms, which is the prerequisite for everything else. BZ-Import Kit Header configures the header section of the Kit Specifications screen. BZ-Import Kit Stock Components and BZ-Import Kit Non-Stock Components add components to the kit. BZ-Import Kit Option Category adds option categories, option codes, and the stock and non-stock components associated with each code, and BZ-Import Kit Substitution adds substitute items for the relevant components. Before running any of them, confirm that data mapping between the external source and the corresponding Acumatica fields is correct, and remember that Default Code matters here because an import has no user to answer an options prompt.

Kit Processing in Acumatica: Frequently Asked Questions

What is the kit placeholder item and why does Acumatica use one?

The kit placeholder item is a non-stock item that replaces the kit item on the Sales Orders screen after explosion. Because the components are added to the order as their own lines, keeping the original kit item would double-count item cost. The placeholder behaves like the kit item in the order but contains no actual items. Its unit of measure must match the unit of measure of the kit item, or the system raises a warning.

Why will my kit not explode on the sales order?

Check four things in order. The kit specification must have Explode Kit selected and a current revision marked. The Explode Option must not be set to Do Not Explode. The Block Kit Items Explosion checkbox may be selected on the Customers or Vendors screen, or in the Biz-Tech Kit Processing Settings on the Order Types screen, either of which prevents explosion. Finally, Unexploded Kit Price Calculation by Components deliberately prevents explosion and prices the kit by its components instead.

Can components be changed after a kit has exploded?

Only partially. Once the kit has exploded, components can no longer be added or deleted from the Component Details popup, where just Quantity and Warehouse remain editable. To add or remove components after explosion, use the [X] and [+] buttons on the Document Details tab of the sales order. Editing component quantities and deleting components on the order screen also requires Allow Edit Exploded Kit Component to be enabled in preferences.

How does Acumatica price a kit that ships partially?

When Use Kit Default Price is the selected price calculation method, the invoice for the first shipment carries the total kit price and the invoice price for the remaining items is zero, because the kit is priced once rather than per component. If you would rather invoice only when the order is complete, enable Invoice After Full Shipment, which permits partial shipment but holds the placeholder item back until every component has shipped.

Can a kit contain another kit?

Yes. Kit items can be configured as nested components or options inside both stock and non-stock kit specifications, with the outer kit acting as the Parent Kit and the included kit as the Child Kit. If a non-stock kit is used as a component or option, the Explode Option for both the parent and the child must be set to Automatically. The Copy Kit function and the Kit Pricing Summary screen both support nested kits.

How do I create a purchase order for a single kit component?

Add the kit to the sales order and, without exploding it, open the Component Details popup. Select the Mark for PO checkbox for the component you need and click Create PO. The required quantity must have a value. The purchase order is created against the component's Default Vendor ID, several components sharing a vendor are combined into one purchase order, and the resulting number appears in the PO Number field of the popup.

Work With the Biz-Tech Services Kit Processing Product

Kit Processing in Acumatica rewards teams who understand the flow rather than memorizing screens. The specification defines the kit, preferences supply the defaults, order entry shapes the line, explosion turns one line into a placeholder plus components, and fulfillment converts those components into shipments, invoices, and inventory transactions. Once users know which field governs each handoff and where to look when a result is unexpected, kit orders stop being a special case and become routine.

If your business sells or purchases configured products and wants kit components visible and controllable right on the order, we are glad to help you scope, configure, and roll out Kit Processing. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Biz-Tech Services Kit Processing product.

How Kit Processing Works in Acumatica from Order Entry to Fulfillment

Kit Processing in Acumatica is easiest to understand as a data flow rather than as a screen. A single kit record starts life on the Kit Specifications form, picks up defaults from your preferences screens, becomes a line on a sales order, splits into a placeholder and a set of components, and finally resolves into a shipment, an invoice, and a set of inventory transactions. Every problem a user ever reports with kits traces back to one of those handoffs. Understanding where each record is created, which field controls the next step, and where the result becomes visible is what makes the module predictable.

The Biz-Tech Services Kit Processing product lets users explode kit components directly on the Sales Orders screen, with no need to open a separate maintenance form or print a pick list just to see what a kit contains. Cost calculation for kit items is controlled from the native Sales Order Preferences screen, which gives companies flexibility without forcing maintenance adjustments to inventory items. This article follows a kit through the entire Acumatica data flow, from the specification that defines it to the released invoice that closes it out, and points out the fields worth watching at each stage.

Stage One: The Kit Specification Is the Source of Every Record

Everything downstream inherits from the Kit Specifications form, so this is where the data flow begins. The form is available only when the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form, and you can create a kit specification only for an inventory item that has already been marked as a kit on the General tab of the Stock Items (IN202500) or Non-Stock Items (IN202000) form. That marking is the true origin point of the record. Without it, no specification can exist.

The header fields define the identity of the kit. Kit Inventory ID is the inventory identifier of the kit as assigned on the stock or non-stock item form, and Non-Stock is a read-only checkbox indicating that the kit is a non-stock kit. Revision ID uniquely identifies each revision of the specification, and Description holds a brief summary. Two checkboxes govern whether the record participates in the flow at all: Active marks the specification as usable, and Current Revision indicates which revision the system will actually use when the kit explodes on a sales order. If a kit item already has a current revision and you attempt to change it, the system warns you that saving will uncheck the previous one. Only one revision is current at a time, and that is the revision the rest of the flow will read.

Explode Kit is the field that determines whether the kit will break into its components on the Sales Orders screen. Selecting it activates three further fields that shape the entire downstream flow: Kit Placeholder Item, Explode Option, and Price Calculation. Kit has options adds Option Category and Option Codes tabs, where you define the choices a user will be asked to make during order entry. Marking an option category as Required forces the user to select a code in the Options popup before the kit order can proceed, while Sort Order controls whether categories appear in ascending or descending order in the Sales Orders dropdown. Default Code automatically includes an option code in the order without user input, which matters a great deal for any path where no human is present to choose: API calls, import scenarios, processing screens, and opportunities or sales quotes.

Three further checkboxes extend what users can change later in the flow. Allow Option Rules adds an Option Rule tab, where a source option category and code exclude a target option category and code on the Sales Orders screen. If Size 8x10 is configured to exclude the color Black, a user who selects 8x10 will not be offered Black; selecting a size that is not covered by a rule, such as 8x12, makes Black available again. Allow Component Substitution adds a Substitution tab and a matching column on the Stock Components tab, letting you nominate replacement items for specific components. Allow Component Addition activates the Add Row option in the Component Details dialog on the Sales Orders screen, permitting new components to be added before the kit explodes.

Two structural rules belong here because they cause real problems when missed. First, the Unit of Measure of the Kit Placeholder Item must match the Unit of Measure of the kit item, or the system raises a warning. Second, for nested kits, where a kit item is used as a component or option inside another kit, the main kit is the Parent Kit and the included kit is the Child Kit. If a non-stock kit is used as a component or option, the Explode Option for both the parent and the child must be set to Automatically. The same requirement applies when a non-stock kit contains a stock option item, because only automatic explosion ensures the stock option is allocated during shipment.

Stage Two: Acumatica Preferences Supply the Defaults That Flow Downstream

The second stage of the Acumatica Kit Processing data flow is the Biz-Tech Services Kit Processing Settings section on the Sales Orders Preferences screen, with an equivalent section on the Purchase Orders Preferences screen. Price Calculation for Kits, Kit Placeholder Item, and Explode Option are general settings that apply to every kit. The precedence rule is simple and worth teaching to every user: if those same settings are configured manually for a specific kit on the Kit Specifications screen, the system prioritizes the kit-level setting over the general one. When a kit behaves differently from what preferences suggest, the specification is almost always the reason. If the specific item has already configyration done in Kit Specifications screen, then the setup of individual item would be used

Several preference fields change how quantities and documents behave later in the flow. Not Calculate Component Quantities bases quantity calculation in sales orders on the quantity specified for the kit itself. Invoice After Full Shipment allows partial shipment and holds the placeholder item back until every component has shipped. Use Kit Posting Group places the kit item's account and subaccount values on the placeholder row after explosion, and Apply to the Components extends those same values to the component rows. Allow Kit Assembly Generation enables the assembly branch described later. Unexploded Kit Price Calculation by Components prevents the kit from exploding and calculates only the price of the components toward the order total, which is why selecting it triggers a warning that the Explode Kit checkbox should be unchecked.

Components Qty. Is Required for Kit Item Ship deserves particular attention, because it decides whether a shipment can be created at all. Selecting it reveals a dropdown with three shipping behaviors. Ship Available Qty. sets the kit or placeholder line to back order allowed and lets a shipment be created for the minimum component quantity, without requiring every component to be available. Ship Ordered Qty. requires all components to be available and allocated based on the kit quantity, so nothing ships until everything is ready. The third option allows back order without requiring component quantity to be available for shipping. Finally, Allow Edit Exploded Kit Component gives users control over component quantities after explosion and permits deletion of kit components on the Sales Orders screen, and it has the same effect on the Purchase Orders screen when set in purchase order preferences.

Two settings outside these screens can also stop the flow. Selecting Block Kit Items Explosion on the Customers or Vendors screen prevents kits from exploding for that business account, and the same checkbox in the Biz-Tech Kit Processing Settings on the Order Types screen prevents explosion for that order type. Both override the explode option on the kit itself, so they are the first place to look when a kit refuses to explode for one customer or one order type but works everywhere else.

Stage Three: Sales Order Entry and the Component Details Window

Once a kit item is added to a sales order, the flow moves into the Component Details popup, which is the working surface for everything that happens before explosion. If the kit has options, an Options popup opens automatically when the kit item is entered, prompting the user to select an option code for each option category before pressing OK. Those selections can still be revised without exploding the kit by using the Change Options button in Component Details; all previous option category and option code configurations remain intact unless they are manually changed.

Before explosion, Component Details is where the order line is shaped. Users can add or delete components, and they can exchange a component for an approved substitute by double-clicking the item and choosing the replacement from the search icon that appears beside it. This window is also the point where purchasing can be triggered. Selecting the Mark for PO checkbox for a component and clicking Create PO generates a purchase order, and the resulting purchase order number is displayed under the PO Number field in Component Details. The required quantity must have a value for the purchase order to be created. Purchase orders are created according to the Default Vendor ID of each component, and when several components share the same vendor, a single purchase order covers them all. If that purchase order or its lines are later deleted, the number is removed from Component Details automatically, which keeps the reference trustworthy.

Stage Four: Acumatica Kit Explosion and the Placeholder Item

Explosion is the pivotal transformation in the Biz-Tech Services Acumatica Kit Processing flow, because it is the moment one order line becomes many. A kit explodes in one of two ways: by clicking Load Components in the Component Details dialog, or simply by assigning a quantity to the newly added kit on the sales order. Which of these is even possible depends on the Explode Option chosen earlier. Prompt asks the user whether to explode, Automatically explodes without user intervention, and Do Not Explode prevents explosion entirely.

When the kit explodes, the kit placeholder item and its components appear on the sales order lines with their respective prices, quantities, and costs. The placeholder is a non-stock item that replaces the kit item on the Sales Orders screen after explosion. Its purpose is financial accuracy: a kit item consists of multiple components, and when those components are added to the order as real lines, leaving the original kit item in place would double-count item cost. The placeholder behaves like the kit item in the order but contains no actual items. One field on that placeholder row is worth monitoring closely. Total Cost of Components is calculated as the component's unit cost at the time the sales order was created, which does not change afterward, multiplied by the quantity. It is displayed on the kit placeholder row and carried forward to the invoice, making it the natural checkpoint for verifying kit margin.

Price Calculation determines what the customer is charged, and it offers three methods. Use Kit Default Price applies the kit's own default price, plus any manually added price for its options. Use Component Default Price bases the price on each component's default price and sets the kit item price to zero. Use Combined Default Price adds the kit's default price to the default prices of the components. The choice matters beyond the order total, because it changes how partial shipments are invoiced, as described in the fulfillment stage below.

Editing rules tighten once explosion has occurred, and this catches users out more than any other behavior in the module. After the kit has exploded, components can no longer be added or deleted from the Component Details popup; only Quantity and Warehouse remain editable there. To add or remove components at that point, users must work with the [X] and [+] buttons on the Document Details tab of the sales order. Before explosion, the picture is different again: if Allow Component Addition is off, new components cannot be added, although existing components can still be deleted.

Stage Five: The Acumatica Kit Assembly Branch

Kit Assembly is an optional branch in the Acumatica data flow rather than a mandatory step, and it is available only when the Kit Assembly feature is enabled on the Enable/Disable Features (CS100000) form. A kit assembly document contains the required stock components with their quantities and costs, calculated according to the kit specification revision you specify. Assemblies can be created directly on the Kit Assembly screen by entering the kit item in the Inventory ID field, selecting the revision, choosing a warehouse, and entering a quantity. Components can be added or removed before the assembly is released.

The more interesting path runs from the sales order, because it lets you assemble without exploding the kit. The user enters the kit on the sales order, optionally adjusts components in the Component Details popup, selects the Mark for Kit Assembly checkbox on the Details tab, and then clicks Generate Kit Assembly from the Actions list followed by Save. The same action is available through the Mark/Unmark for Kit Assembly button in the Component Details dialog. The generated assembly places a link number in the Kit Assembly field on the Details tab of the sales order, and clicking that link opens the Kit Assembly form. The relationship is visible from both ends: the Orders tab of the Kit Assembly screen shows the linked sales order number the assembly came from. Two constraints apply. Kit assemblies generated from sales orders always use the current revision specified on the Kit Specifications screen, and for non-stock kit items the Mark for Assembly button is disabled.

Stage Six: Kit Order Fulfillment in Acumatica

With explosion complete, the order moves into the standard Acumatica fulfillment cycle, and the kit records follow the components rather than the kit. The sequence is four steps. First, click Create Shipment on the toolbar and confirm the Specify Shipment Parameters window with OK. Second, on the Shipments screen to which you are redirected, click Confirm Shipment. Third, on the Invoices screen, click Prepare Invoice. Fourth, release the invoice with the Release button. At that point the inventory and financial impact of the kit is fully posted.

Partial shipments introduce one behavior that finance teams should know before it appears on a customer document. When Use Kit Default Price is the selected price calculation method and the order ships partially, the invoice for the first shipment carries the total kit price, and the invoice price for the remaining items is zero. This is intentional, since the kit is priced once rather than per component, but it looks surprising on a second invoice if nobody was expecting it. Where this is undesirable, Invoice After Full Shipment holds the placeholder back until all components have shipped, so the kit is invoiced only once everything is out the door.

The Purchase Order Side of Kit Processing

Kit Processing in Acumatica is not limited to the sell side. The Purchase Orders Preferences screen carries the same Biz-Tech Kit Processing Settings section, with the same precedence rule that kit-level configuration overrides the general settings, and the same Unexploded Kit Price Calculation by Components and Allow Edit Exploded Kit Component behaviors. Adding a kit item to a purchase order gives access to the same Component Details popup, where components can be added, deleted, or exchanged for substitutes and options can be changed before explosion. The kit is exploded either by clicking Load Components or by assigning a quantity to the kit line, exactly as on the sales order.

The inbound flow then completes in three moves. A purchase order containing the kit items is created and exploded. When the components are received, a purchase receipt for the ordered items is created. On release of that purchase receipt, the system automatically generates an inventory receipt reflecting the items in inventory. That automatic inventory receipt is the point at which purchased kit components become available stock, so it is the record to check when component availability does not look right after a delivery.

Where the Flow Starts Earlier: Opportunities and Sales Quotes

For businesses that quote before they sell, the kit data flow begins one step earlier. A kit item is added on the Details tab of the Opportunities screen and a quote is generated with the Create Quote button. The kit will not explode on the Opportunities screen itself.

Explosion happens on the Sales Quotes screen, either by giving the kit a quantity or by clicking Load Components on the Details tab. After saving, the exploded kit is reflected back in the Details tab of the Opportunities screen, and from then on any change made to the exploded kit updates in both screens. This is also the path where Default Code earns its place, since no user is prompted to pick options during automated or quote-driven creation.

Kit Pricing Summary: Where Pricing Is Reviewed and Applied

Kit Pricing Summary is the analysis point of the Acumatica Kit Processing flow, and it uses the same explosion logic as the order screens. For a kit to appear here, its specification must have the Active checkbox selected and the Revision field filled in. Selecting the kit in the Kit Inventory ID field loads the kit together with its components, stock components first and non-stock components after. Each component line displays Quantity, Unit Price, Min Markup %, Markup %, Extended Price, and Surcharge, and the calculated totals of Extended Price and Surcharge appear on the last line.

Two formulas govern the numbers. Surcharge is calculated as quantity multiplied by unit price multiplied by minimum markup, divided by one hundred. Total with Surcharge is the sum of the extended price and surcharge amounts across the component lines. Clicking Apply Price takes the total surcharge from the last line and applies it to the kit item's default price, which is how component-level markup becomes a kit-level price. The screen works for nested kits as well: after the parent kit is exploded, the components of both kits load together and the totals line sums their extended prices and surcharges. The whole summary can be exported to Excel, which makes it a practical review artifact for a pricing meeting.

Where to Monitor Kit Processing Results in Acumatica

If you are training users or troubleshooting a kit order in Acumatica, these are the fields and screens that tell you what the system actually did:

  • Current Revision on Kit Specifications, which determines the revision every downstream document reads.
  • Explode Option and Explode Kit, which decide whether the order line ever becomes components.
  • Block Kit Items Explosion on the Customers, Vendors, and Order Types screens, which silently overrides the kit's own explode setting.
  • Total Cost of Components on the kit placeholder row, which carries the frozen unit cost forward to the invoice.
  • PO Number in the Component Details popup, which confirms whether a component was purchased and stays accurate if the purchase order is deleted.
  • Kit Assembly on the sales order Details tab, which links to the generated assembly, and the Orders tab of the Kit Assembly screen, which links back.
  • The Component Availability section of Component Details, which can display Qty. Available, Qty. Avail. for Shipping, and Qty. on Hand.
  • Next receive information in the same window, including next receive type and reference number, with Inc. In Receipt, Inc. In Transfer, Inc. PO, Inc. PO Receipt, and Inc. PO Transfer controlling which documents are considered when calculating the next receive date and quantity.
  • The totals line on Kit Pricing Summary, where extended price and surcharge are reviewed before Apply Price changes the kit's default price.

One note on availability display: if any kit component has a quantity of zero and the kit item is not set to back order allowed, an error message appears when the availability checkbox is selected. That message is a genuine signal about allocation, not a display fault.

Loading Kits in Bulk with Acumatica Import Scenarios

Kit items do not have to be built by hand. Acumatica import scenarios support structured, automated entry of kit data from external sources, and the product ships with a set of scenarios that map to the stages described above. BZ-Import Is a Kit Check Box in Non-Stock and BZ-Import Is a Kit Check Box in Stock enable the Is a Kit checkbox on the respective item forms, which is the prerequisite for everything else. BZ-Import Kit Header configures the header section of the Kit Specifications screen. BZ-Import Kit Stock Components and BZ-Import Kit Non-Stock Components add components to the kit. BZ-Import Kit Option Category adds option categories, option codes, and the stock and non-stock components associated with each code, and BZ-Import Kit Substitution adds substitute items for the relevant components. Before running any of them, confirm that data mapping between the external source and the corresponding Acumatica fields is correct, and remember that Default Code matters here because an import has no user to answer an options prompt.

Kit Processing in Acumatica: Frequently Asked Questions

What is the kit placeholder item and why does Acumatica use one?

The kit placeholder item is a non-stock item that replaces the kit item on the Sales Orders screen after explosion. Because the components are added to the order as their own lines, keeping the original kit item would double-count item cost. The placeholder behaves like the kit item in the order but contains no actual items. Its unit of measure must match the unit of measure of the kit item, or the system raises a warning.

Why will my kit not explode on the sales order?

Check four things in order. The kit specification must have Explode Kit selected and a current revision marked. The Explode Option must not be set to Do Not Explode. The Block Kit Items Explosion checkbox may be selected on the Customers or Vendors screen, or in the Biz-Tech Kit Processing Settings on the Order Types screen, either of which prevents explosion. Finally, Unexploded Kit Price Calculation by Components deliberately prevents explosion and prices the kit by its components instead.

Can components be changed after a kit has exploded?

Only partially. Once the kit has exploded, components can no longer be added or deleted from the Component Details popup, where just Quantity and Warehouse remain editable. To add or remove components after explosion, use the [X] and [+] buttons on the Document Details tab of the sales order. Editing component quantities and deleting components on the order screen also requires Allow Edit Exploded Kit Component to be enabled in preferences.

How does Acumatica price a kit that ships partially?

When Use Kit Default Price is the selected price calculation method, the invoice for the first shipment carries the total kit price and the invoice price for the remaining items is zero, because the kit is priced once rather than per component. If you would rather invoice only when the order is complete, enable Invoice After Full Shipment, which permits partial shipment but holds the placeholder item back until every component has shipped.

Can a kit contain another kit?

Yes. Kit items can be configured as nested components or options inside both stock and non-stock kit specifications, with the outer kit acting as the Parent Kit and the included kit as the Child Kit. If a non-stock kit is used as a component or option, the Explode Option for both the parent and the child must be set to Automatically. The Copy Kit function and the Kit Pricing Summary screen both support nested kits.

How do I create a purchase order for a single kit component?

Add the kit to the sales order and, without exploding it, open the Component Details popup. Select the Mark for PO checkbox for the component you need and click Create PO. The required quantity must have a value. The purchase order is created against the component's Default Vendor ID, several components sharing a vendor are combined into one purchase order, and the resulting number appears in the PO Number field of the popup.

Work With the Biz-Tech Services Kit Processing Product

Kit Processing in Acumatica rewards teams who understand the flow rather than memorizing screens. The specification defines the kit, preferences supply the defaults, order entry shapes the line, explosion turns one line into a placeholder plus components, and fulfillment converts those components into shipments, invoices, and inventory transactions. Once users know which field governs each handoff and where to look when a result is unexpected, kit orders stop being a special case and become routine.

If your business sells or purchases configured products and wants kit components visible and controllable right on the order, we are glad to help you scope, configure, and roll out Kit Processing. Visit https://biz-techservices.com to learn more about our Acumatica expertise or to schedule a personalized demonstration of the Biz-Tech Services Kit Processing product.


ServiceTitan Acumatica Integration Configuration Checklist

ServiceTitan Acumatica Integration Configuration Checklist

A successful ServiceTitan Acumatica integration is decided long before the first invoice ever crosses between the two systems. It is decided during configuration. Field service companies live in two platforms at once: dispatchers, technicians, and sales staff work inside ServiceTitan every hour of the day capturing jobs, invoices, purchase orders, and payments in the field, while the controller and accounting team depend on Acumatica to manage inventory, branches, vendors, and the general ledger. When those two systems are not connected, the result is predictable. The same invoice gets keyed twice, purchase receipts pile up waiting to be reconciled, and nobody can say with confidence what a job actually cost.

The Biz-Tech Services ServiceTitan Connector closes that gap so the work recorded in the field lands in your Enterprise Resource Planning, or ERP, system exactly once and exactly right. A connector, however, is only as reliable as the configuration behind it, and the most common cause of a rough go-live is not the software but a mapping that was never completed or a date filter that was never set. This ServiceTitan Acumatica integrator configuration checklist walks through every required setting, the data you need to prepare in advance, the points where you should stop and validate, the user access to confirm, and the tests to run before you switch on automatic synchronization.

Step One: Configure the ServiceTitan Store in Acumatica

Every ServiceTitan Acumatica integration begins with the ServiceTitan Store. This is the single most important step in the entire setup process and it belongs on the first line of your checklist. The Store is the foundation on which every other setting depends, because it controls your invoice import rules, your customer creation rules, your inventory and item handling, your warehouse and branch mapping, your vendor and business unit mapping, your transaction processing logic, and the way purchase orders, receipts, and bills flow into Acumatica. If the ServiceTitan Store is not configured correctly, the system will not work and no data can be imported at all.

Start by assigning a Store Code, the lookup value that identifies the corresponding ServiceTitan store, and give it a clear Description so your team can recognize it later. If you select the Default Store checkbox, will tell the system to set and display that store code automatically on every processing screen, removing a small but repetitive step from your users' daily routine. Companies operating several stores should decide up front which one carries the default flag.

With the Store record in place, move to the General Settings tab and enter the credentials generated on the ServiceTitan side to authorize the connection. Once those values are saved, use the Test Credentials action before going any further. This validation step confirms that Acumatica can reach your ServiceTitan store through the Application Programming Interface, or API, and it is the earliest safe point to catch a mistyped key or an authorization that was never granted. Do not begin any mapping work until this test succeeds.

Step Two: Set Invoice, Tax, and Payment Import Options

The next item on the ServiceTitan integration checklist is the Import Options tab, where your business decides what actually comes across. Selecting the Activate Invoice checkbox opens the invoice section and lets you import invoices along with their taxes, payment methods, customer data, and general ledger accounts. You will need to specify the Invoice Type, which determines what kind of document ServiceTitan invoices become in Acumatica, and choose whether to import invoices with one preferred status or with all statuses at once.

Date filtering deserves particular attention during preparation, because it governs how much history you pull in on day one. The Begin Invoice Date defines the point from which the first import should reach back, and the Last Invoice Date records when the most recent import ran, which subsequent import processes then use as their starting point. Choose your beginning date deliberately. Setting it too far back can pull years of closed transactions into a fresh system, while setting it too late can leave open invoices stranded in ServiceTitan.

Tax handling is a simple checkbox that enables importing invoices with their taxes included, but confirm with your accounting team that the resulting tax treatment matches how they expect revenue to post. For payments, selecting the Activate Payment checkbox allows invoices to arrive with their payment information attached. Two decisions follow. First, the Payment Type determines whether payments imported from ServiceTitan are created in Acumatica as payments or as prepayments. Second, Release Payment After Import controls whether those payments are released automatically or left for your team to review. Many businesses leave automatic release turned off during the first few weeks and enable it once they trust the results.

Step Three: Prepare Customer, Country, Term, and GL Account Data

How your business handles customer records is the next preparation point, and it has real consequences for the cleanliness of your Acumatica database. If the Import Customer checkbox is left unselected, every invoice arrives assigned to a single default customer. If it is selected, the connector creates the customer in Acumatica whenever that customer is missing, using the default customer class you nominate. Decide which model fits your operation before go-live, and if you choose automatic creation, make sure the default customer class is configured with the correct general ledger accounts, terms, and statement settings, because every new customer will inherit them.

Address handling is controlled separately. The Override Bill Address Information from Invoice and Override Ship Address Information from Invoice checkboxes allow the customer's billing and shipping addresses to be imported into Acumatica from the invoice itself. Enable these when the field-captured address should be treated as authoritative. Alongside addresses, review the Country Options, since country names are passed to Acumatica in International Organization for Standardization, or ISO, country code format. Note that when the Activate Payment checkbox is selected, the Country options become hidden, so plan your review of this section accordingly.

Two mapping tables round out this stage of the ServiceTitan Acumatica setup. Term Options aligns ServiceTitan term values with the corresponding Acumatica terms, and Account Options maps ServiceTitan general ledger accounts to your Acumatica chart of accounts. Complete both with your controller in the room. An unmapped term or GL account is the kind of gap that does not surface until the first import run, and by then it is already producing exceptions.

Step Four: Configure Inventory Items and Transaction Settings

Inventory preparation is where most of the pre-launch data work lives. When the Import Item checkbox is selected, the Generate Item from ServiceTitan option becomes available, and the connector will create non-stock and stock items in Acumatica based on the Stock Item Class, Non-Stock Item Class, and Unit of Measure values you designate. Those three values are prerequisites, so confirm they exist and are correctly configured before enabling generation. Your business can also skip automatic creation entirely and map ServiceTitan items to existing Acumatica items by hand, which is often the better path for companies with a mature, curated item master.

Use the Load Materials, Load Equipment, Load Services action to retrieve the corresponding ServiceTitan items and display them on the Inventory tab, and understand the rule the system applies: Materials and Equipment become stock items, while Services become non-stock items. Reviewing that list before go-live is one of the highest-value validation steps on this checklist, because it is your last comfortable opportunity to spot duplicates, retired parts, or items that should never have been synchronized.

On the Transactions tab, configure each transaction type your business actually uses. Receipts, Transfers, Adjustments, and Returns each have their own setup options, along with a corresponding Release Receipt After Import, Release Transfer After Import, Release Adjustment After Import, and Release Return After Import checkbox. Selecting a release checkbox means those documents are imported into Acumatica and released in the same pass. The Activate Bill checkbox on this tab allows bills to be imported together with their receipts. As with payments, we generally recommend leaving automatic release unselected for the first cycle so your team can inspect the documents in a balanced state before they post.

Step Five: Map Business Units, Warehouses, PO Types, and Vendors

The Biz-Tech Services Service Titan Acumatica connector needs to know how your ServiceTitan structure corresponds to your Acumatica structure, and these mappings are mandatory. Begin with Business Units, where ServiceTitan Business Unit identifiers are mapped to Acumatica branches. Pressing Load Business Units retrieves the available ServiceTitan values so your team can pair them manually with the correct branch. Get this right and every imported document lands in the correct branch for reporting. Get it wrong and your branch profitability numbers will be wrong from day one.

Warehouses follow the same pattern. The Warehouses tab maps Acumatica warehouses to ServiceTitan Warehouse and Truck identifiers, and the Load Warehouses action retrieves those values for manual pairing. Because trucks are treated as inventory locations, this mapping is what makes technician van stock visible and accurate in your ERP, so give it real attention rather than treating it as a formality.

Finally, complete the purchasing mappings. The PO Types tab maps ServiceTitan purchase receipt order type names to Acumatica purchase order types, and Load PO Types retrieves the available values. Return Types maps ServiceTitan return types to the corresponding Acumatica purchase order types. On the Vendors tab, selecting the Import Vendor checkbox lets the connector create ServiceTitan vendors in Acumatica, while Load Vendors retrieves the full vendor list from ServiceTitan so your team can map existing vendors manually instead. For most established businesses, manual mapping of your top vendors combined with automatic creation for the long tail strikes the right balance.

Step Six: Import ServiceTitan Purchase Orders, Receipts, and Bills in Order

This section of the checklist is less about a setting and more about a rule your team must understand, because it is the single most common source of go-live confusion in a ServiceTitan Acumatica integration. The Purchase Order module workflow requires that ServiceTitan purchase receipts and bills cannot be imported into Acumatica unless the related ServiceTitan purchase order has already been imported. Sequence matters, and it is not negotiable.

Purchase orders are brought in through the Import ServiceTitan Purchase Orders screen and are created in Acumatica as purchase orders, retrieved based on their updated date. If a ServiceTitan purchase receipt or bill already exists at the moment the purchase order is imported, it comes across in the same process. If the receipt or bill does not yet exist in ServiceTitan, it is simply not imported, and it can be brought over later through its own screen once it has been created. Before importing purchase orders at all, confirm that the required preferences have been configured on the ServiceTitan Stores screen, since the import depends on them.

The Import Receipts screen retrieves purchase order receipts based on the date and status defined in your Receipt Options, and it can be run manually or automatically through the scheduler. If a receipt is imported before its purchase order exists in Acumatica, the system stops and returns a message such as POOrder document for Receipt 433272225 has not been created yet. That message is not a defect. It is the sequencing rule protecting your data. When the purchase order is already present, the connector locates it and attaches the receipt document to the PO History tab of the Purchase Orders screen. The receipt arrives with a Released status if the release checkbox is selected in the store setup, and with a balanced status if it is not. Where a receipt includes a bill, that bill is imported in the same pass and attached to the same PO History tab.

Bills follow identical logic on the Import ServiceTitan Bills screen, retrieved by their updated date. A bill cannot be imported on its own without its corresponding purchase order, and attempting to do so produces an error. If you import a purchase order while its related bill is sitting on the processing screen, the bill is imported alongside it and disappears from that screen. If the purchase order was imported earlier, importing the bill later automatically locates the parent document and attaches it. One additional field belongs on your configuration checklist here: the Branch For Bills field, which applies specifically when bills are imported and Bills and Adjustments documents are created in Acumatica.

Step Seven: Validate ServiceTitan Invoice and Payment Import

Before you declare go-live readiness, run a controlled test of the invoice and payment path, because there are three distinct scenarios and your team should recognize all of them. Invoices are retrieved on the Import SO Invoices screen based on their updated date and the statuses you selected. In the first scenario, an invoice that already carries a payment at the moment it is retrieved is imported together with that payment. The invoice is created on the Invoices and Memos screen, the payment is created and applied under the Applications tab of that invoice, and the corresponding payment identifier disappears from the Import Invoice Payments screen because it has already been processed.

In the second scenario, the invoice has already been imported but the payment is still waiting on the processing screen. Here the connector locates the matching invoice during the payment import and applies the payment automatically. The third scenario is the reverse: the payment was taken first and the invoice is imported afterward, in which case the system matches the two on its own. The Import Invoice Payments screen retrieves all payments from ServiceTitan and shows the associated Invoice ID, and payments can be imported separately, either as a deposit or after the invoice already exists. In every case the outcome is the same, which is that the payment ends up matched to the correct invoice in Acumatica. Test all three paths with real data in a sandbox tenant before go-live and your finance team will know exactly what they are looking at on launch day.

Step Eight: Journal Entries, Scheduling, and User Access

If your business intends to bring journal entries across rather than invoices, activate the Journal Entry checkbox on the Import Options tab while the Activate Invoice checkbox is disabled. Pay close attention to one detail that catches teams out: the Begin Journal Entry Date is not set automatically the first time, so a user must enter it manually. The Last Journal Entry Date then records the most recent import, and you should also define which statuses qualify for import. Put this on the checklist explicitly, because an unset beginning date is a silent failure rather than a visible error.

Turning to operations, decide how synchronization will run. Every processing screen can be executed manually or automatically through the Acumatica scheduler, and documents are retrieved based on their updated date. We recommend running manually for the first several cycles so your team sees each batch before it posts, then moving to a scheduled cadence once the results are consistently clean. Confirm at the same time that user access is correct. The staff responsible for each processing screen need the appropriate Acumatica roles, and the ServiceTitan credentials used by the connector should belong to a dedicated integration account rather than an individual employee whose access might be revoked.

ServiceTitan Acumatica Integration Checklist: Quick Reference

Before you launch, walk through this final go-live readiness checklist with your project team:

  • The ServiceTitan Store is created, the Default Store flag is set, and Test Credentials returns a successful result.
  • Invoice type, import statuses, and the Begin Invoice Date are configured to match your intended cutover point.
  • Customer creation, default customer class, and address override behavior reflect an agreed policy.
  • Term and general ledger account mappings are complete and reviewed by your controller.
  • Item classes and unit of measure values exist, and the loaded ServiceTitan item list has been inspected.
  • Business units, warehouses and trucks, purchase order types, return types, and vendors are all mapped.
  • The Branch For Bills field is set if your business imports bills.
  • Your team understands that purchase orders must be imported before receipts and bills.
  • All three invoice and payment scenarios have been tested in a sandbox environment.
  • Release-after-import options are set deliberately, and the scheduler plan is agreed.
  • Acumatica roles are assigned, and the connector uses a dedicated ServiceTitan integration account.

ServiceTitan Acumatica Integration FAQ

What is the first step in setting up a ServiceTitan Acumatica integration?

Configuring the ServiceTitan Store is always the first step. The Store controls invoice import rules, customer creation, inventory handling, warehouse and branch mapping, vendor and business unit mapping, and the purchase order workflow. Until the Store is set up and Test Credentials returns a successful result, no data can be imported into Acumatica.

Can ServiceTitan receipts and bills be imported without the purchase order?

No. ServiceTitan purchase receipts and bills cannot be imported into Acumatica unless the related purchase order has already been imported. Attempting to import a receipt first produces an error message identifying the missing purchase order document. Import purchase orders first, and any receipt or bill that already exists in ServiceTitan will come across in the same process.

Does the connector create customers and vendors in Acumatica automatically?

It can. Selecting the Import Customer checkbox creates a customer in Acumatica whenever one is missing, using your default customer class. Selecting the Import Vendor checkbox does the same for vendors. If you prefer tighter control, leave these unselected and use a default customer, or map ServiceTitan vendors to existing Acumatica vendors manually with the Load Vendors action.

How are ServiceTitan items created in Acumatica?

When Import Item is selected, the Generate Item from ServiceTitan option creates items using your Stock Item Class, Non-Stock Item Class, and Unit of Measure values. Materials and Equipment become stock items, while Services become non-stock items. You can also map ServiceTitan items to existing Acumatica items manually instead of generating them.

How are ServiceTitan payments matched to Acumatica invoices?

Three scenarios are handled automatically. If the invoice carries a payment when it is retrieved, both import together and the payment is applied under the Applications tab. If the invoice was imported earlier, the payment import locates it and applies the payment. If the payment was taken first, the system matches it when the invoice arrives. In all three cases the payment ends up applied to the correct invoice.

Can the ServiceTitan Acumatica integration run automatically?

Yes. Every processing screen can run manually or on a schedule through the Acumatica scheduler, with documents retrieved by their updated date. We recommend running manually for the first several cycles so your team can review each batch, then switching to a scheduled cadence once results are consistently clean.

Get Started With the ServiceTitan Acumatica Connector

The Biz-Tech Services ServiceTitan Acumatica Connector is built for field service businesses that need their operational reality and their financial records to agree without anyone retyping a thing. Purchase orders, receipts, bills, invoices, payments, inventory transactions, and journal entries all flow into Acumatica along a defined path, and the quality of that flow is determined by the configuration work you complete before you begin. Working through this ServiceTitan Acumatica integration checklist methodically is what separates a launch that quietly succeeds from one that consumes weeks of cleanup.

If your business is preparing to connect ServiceTitan to Acumatica, we are glad to help at every stage, from initial scoping through configuration, validation, and go-live support. Visit https://biz-techservices.com to learn more about our integration expertise or to schedule a personalized demonstration of the Biz-Tech Services ServiceTitan Acumatica Connector.

SEO Metadata (for the publisher, remove before posting)

Focus keyword: ServiceTitan Acumatica integration

Secondary keywords: ServiceTitan Acumatica connector; ServiceTitan integration checklist; ServiceTitan Acumatica setup; import ServiceTitan invoices into Acumatica; ServiceTitan purchase order import; field service ERP integration; ServiceTitan Stores configuration

SEO title (58 characters): ServiceTitan Acumatica Integration Configuration Checklist

Meta description (154 characters): Complete pre-launch configuration checklist for the ServiceTitan Acumatica integration: store setup, mappings, imports, validation, and go-live readiness.

URL slug: servicetitan-acumatica-integration-configuration-checklist

Suggested internal links: ServiceTitan Connector product page; Acumatica integrations overview; Salesforce Acumatica Integration Configuration Checklist

Schema markup: Article plus FAQPage. The FAQ section is written for FAQ rich results.

Image alt text: Set on all seven images inside this document; carries over on paste into a CMS.

ServiceTitan Acumatica Integration Configuration Checklist

A successful ServiceTitan Acumatica integration is decided long before the first invoice ever crosses between the two systems. It is decided during configuration. Field service companies live in two platforms at once: dispatchers, technicians, and sales staff work inside ServiceTitan every hour of the day capturing jobs, invoices, purchase orders, and payments in the field, while the controller and accounting team depend on Acumatica to manage inventory, branches, vendors, and the general ledger. When those two systems are not connected, the result is predictable. The same invoice gets keyed twice, purchase receipts pile up waiting to be reconciled, and nobody can say with confidence what a job actually cost.

The Biz-Tech Services ServiceTitan Connector closes that gap so the work recorded in the field lands in your Enterprise Resource Planning, or ERP, system exactly once and exactly right. A connector, however, is only as reliable as the configuration behind it, and the most common cause of a rough go-live is not the software but a mapping that was never completed or a date filter that was never set. This ServiceTitan Acumatica integrator configuration checklist walks through every required setting, the data you need to prepare in advance, the points where you should stop and validate, the user access to confirm, and the tests to run before you switch on automatic synchronization.

Step One: Configure the ServiceTitan Store in Acumatica

Every ServiceTitan Acumatica integration begins with the ServiceTitan Store. This is the single most important step in the entire setup process and it belongs on the first line of your checklist. The Store is the foundation on which every other setting depends, because it controls your invoice import rules, your customer creation rules, your inventory and item handling, your warehouse and branch mapping, your vendor and business unit mapping, your transaction processing logic, and the way purchase orders, receipts, and bills flow into Acumatica. If the ServiceTitan Store is not configured correctly, the system will not work and no data can be imported at all.

Start by assigning a Store Code, the lookup value that identifies the corresponding ServiceTitan store, and give it a clear Description so your team can recognize it later. If you select the Default Store checkbox, will tell the system to set and display that store code automatically on every processing screen, removing a small but repetitive step from your users' daily routine. Companies operating several stores should decide up front which one carries the default flag.

With the Store record in place, move to the General Settings tab and enter the credentials generated on the ServiceTitan side to authorize the connection. Once those values are saved, use the Test Credentials action before going any further. This validation step confirms that Acumatica can reach your ServiceTitan store through the Application Programming Interface, or API, and it is the earliest safe point to catch a mistyped key or an authorization that was never granted. Do not begin any mapping work until this test succeeds.

Step Two: Set Invoice, Tax, and Payment Import Options

The next item on the ServiceTitan integration checklist is the Import Options tab, where your business decides what actually comes across. Selecting the Activate Invoice checkbox opens the invoice section and lets you import invoices along with their taxes, payment methods, customer data, and general ledger accounts. You will need to specify the Invoice Type, which determines what kind of document ServiceTitan invoices become in Acumatica, and choose whether to import invoices with one preferred status or with all statuses at once.

Date filtering deserves particular attention during preparation, because it governs how much history you pull in on day one. The Begin Invoice Date defines the point from which the first import should reach back, and the Last Invoice Date records when the most recent import ran, which subsequent import processes then use as their starting point. Choose your beginning date deliberately. Setting it too far back can pull years of closed transactions into a fresh system, while setting it too late can leave open invoices stranded in ServiceTitan.

Tax handling is a simple checkbox that enables importing invoices with their taxes included, but confirm with your accounting team that the resulting tax treatment matches how they expect revenue to post. For payments, selecting the Activate Payment checkbox allows invoices to arrive with their payment information attached. Two decisions follow. First, the Payment Type determines whether payments imported from ServiceTitan are created in Acumatica as payments or as prepayments. Second, Release Payment After Import controls whether those payments are released automatically or left for your team to review. Many businesses leave automatic release turned off during the first few weeks and enable it once they trust the results.

Step Three: Prepare Customer, Country, Term, and GL Account Data

How your business handles customer records is the next preparation point, and it has real consequences for the cleanliness of your Acumatica database. If the Import Customer checkbox is left unselected, every invoice arrives assigned to a single default customer. If it is selected, the connector creates the customer in Acumatica whenever that customer is missing, using the default customer class you nominate. Decide which model fits your operation before go-live, and if you choose automatic creation, make sure the default customer class is configured with the correct general ledger accounts, terms, and statement settings, because every new customer will inherit them.

Address handling is controlled separately. The Override Bill Address Information from Invoice and Override Ship Address Information from Invoice checkboxes allow the customer's billing and shipping addresses to be imported into Acumatica from the invoice itself. Enable these when the field-captured address should be treated as authoritative. Alongside addresses, review the Country Options, since country names are passed to Acumatica in International Organization for Standardization, or ISO, country code format. Note that when the Activate Payment checkbox is selected, the Country options become hidden, so plan your review of this section accordingly.

Two mapping tables round out this stage of the ServiceTitan Acumatica setup. Term Options aligns ServiceTitan term values with the corresponding Acumatica terms, and Account Options maps ServiceTitan general ledger accounts to your Acumatica chart of accounts. Complete both with your controller in the room. An unmapped term or GL account is the kind of gap that does not surface until the first import run, and by then it is already producing exceptions.

Step Four: Configure Inventory Items and Transaction Settings

Inventory preparation is where most of the pre-launch data work lives. When the Import Item checkbox is selected, the Generate Item from ServiceTitan option becomes available, and the connector will create non-stock and stock items in Acumatica based on the Stock Item Class, Non-Stock Item Class, and Unit of Measure values you designate. Those three values are prerequisites, so confirm they exist and are correctly configured before enabling generation. Your business can also skip automatic creation entirely and map ServiceTitan items to existing Acumatica items by hand, which is often the better path for companies with a mature, curated item master.

Use the Load Materials, Load Equipment, Load Services action to retrieve the corresponding ServiceTitan items and display them on the Inventory tab, and understand the rule the system applies: Materials and Equipment become stock items, while Services become non-stock items. Reviewing that list before go-live is one of the highest-value validation steps on this checklist, because it is your last comfortable opportunity to spot duplicates, retired parts, or items that should never have been synchronized.

On the Transactions tab, configure each transaction type your business actually uses. Receipts, Transfers, Adjustments, and Returns each have their own setup options, along with a corresponding Release Receipt After Import, Release Transfer After Import, Release Adjustment After Import, and Release Return After Import checkbox. Selecting a release checkbox means those documents are imported into Acumatica and released in the same pass. The Activate Bill checkbox on this tab allows bills to be imported together with their receipts. As with payments, we generally recommend leaving automatic release unselected for the first cycle so your team can inspect the documents in a balanced state before they post.

Step Five: Map Business Units, Warehouses, PO Types, and Vendors

The Biz-Tech Services Service Titan Acumatica connector needs to know how your ServiceTitan structure corresponds to your Acumatica structure, and these mappings are mandatory. Begin with Business Units, where ServiceTitan Business Unit identifiers are mapped to Acumatica branches. Pressing Load Business Units retrieves the available ServiceTitan values so your team can pair them manually with the correct branch. Get this right and every imported document lands in the correct branch for reporting. Get it wrong and your branch profitability numbers will be wrong from day one.

Warehouses follow the same pattern. The Warehouses tab maps Acumatica warehouses to ServiceTitan Warehouse and Truck identifiers, and the Load Warehouses action retrieves those values for manual pairing. Because trucks are treated as inventory locations, this mapping is what makes technician van stock visible and accurate in your ERP, so give it real attention rather than treating it as a formality.

Finally, complete the purchasing mappings. The PO Types tab maps ServiceTitan purchase receipt order type names to Acumatica purchase order types, and Load PO Types retrieves the available values. Return Types maps ServiceTitan return types to the corresponding Acumatica purchase order types. On the Vendors tab, selecting the Import Vendor checkbox lets the connector create ServiceTitan vendors in Acumatica, while Load Vendors retrieves the full vendor list from ServiceTitan so your team can map existing vendors manually instead. For most established businesses, manual mapping of your top vendors combined with automatic creation for the long tail strikes the right balance.

Step Six: Import ServiceTitan Purchase Orders, Receipts, and Bills in Order

This section of the checklist is less about a setting and more about a rule your team must understand, because it is the single most common source of go-live confusion in a ServiceTitan Acumatica integration. The Purchase Order module workflow requires that ServiceTitan purchase receipts and bills cannot be imported into Acumatica unless the related ServiceTitan purchase order has already been imported. Sequence matters, and it is not negotiable.

Purchase orders are brought in through the Import ServiceTitan Purchase Orders screen and are created in Acumatica as purchase orders, retrieved based on their updated date. If a ServiceTitan purchase receipt or bill already exists at the moment the purchase order is imported, it comes across in the same process. If the receipt or bill does not yet exist in ServiceTitan, it is simply not imported, and it can be brought over later through its own screen once it has been created. Before importing purchase orders at all, confirm that the required preferences have been configured on the ServiceTitan Stores screen, since the import depends on them.

The Import Receipts screen retrieves purchase order receipts based on the date and status defined in your Receipt Options, and it can be run manually or automatically through the scheduler. If a receipt is imported before its purchase order exists in Acumatica, the system stops and returns a message such as POOrder document for Receipt 433272225 has not been created yet. That message is not a defect. It is the sequencing rule protecting your data. When the purchase order is already present, the connector locates it and attaches the receipt document to the PO History tab of the Purchase Orders screen. The receipt arrives with a Released status if the release checkbox is selected in the store setup, and with a balanced status if it is not. Where a receipt includes a bill, that bill is imported in the same pass and attached to the same PO History tab.

Bills follow identical logic on the Import ServiceTitan Bills screen, retrieved by their updated date. A bill cannot be imported on its own without its corresponding purchase order, and attempting to do so produces an error. If you import a purchase order while its related bill is sitting on the processing screen, the bill is imported alongside it and disappears from that screen. If the purchase order was imported earlier, importing the bill later automatically locates the parent document and attaches it. One additional field belongs on your configuration checklist here: the Branch For Bills field, which applies specifically when bills are imported and Bills and Adjustments documents are created in Acumatica.

Step Seven: Validate ServiceTitan Invoice and Payment Import

Before you declare go-live readiness, run a controlled test of the invoice and payment path, because there are three distinct scenarios and your team should recognize all of them. Invoices are retrieved on the Import SO Invoices screen based on their updated date and the statuses you selected. In the first scenario, an invoice that already carries a payment at the moment it is retrieved is imported together with that payment. The invoice is created on the Invoices and Memos screen, the payment is created and applied under the Applications tab of that invoice, and the corresponding payment identifier disappears from the Import Invoice Payments screen because it has already been processed.

In the second scenario, the invoice has already been imported but the payment is still waiting on the processing screen. Here the connector locates the matching invoice during the payment import and applies the payment automatically. The third scenario is the reverse: the payment was taken first and the invoice is imported afterward, in which case the system matches the two on its own. The Import Invoice Payments screen retrieves all payments from ServiceTitan and shows the associated Invoice ID, and payments can be imported separately, either as a deposit or after the invoice already exists. In every case the outcome is the same, which is that the payment ends up matched to the correct invoice in Acumatica. Test all three paths with real data in a sandbox tenant before go-live and your finance team will know exactly what they are looking at on launch day.

Step Eight: Journal Entries, Scheduling, and User Access

If your business intends to bring journal entries across rather than invoices, activate the Journal Entry checkbox on the Import Options tab while the Activate Invoice checkbox is disabled. Pay close attention to one detail that catches teams out: the Begin Journal Entry Date is not set automatically the first time, so a user must enter it manually. The Last Journal Entry Date then records the most recent import, and you should also define which statuses qualify for import. Put this on the checklist explicitly, because an unset beginning date is a silent failure rather than a visible error.

Turning to operations, decide how synchronization will run. Every processing screen can be executed manually or automatically through the Acumatica scheduler, and documents are retrieved based on their updated date. We recommend running manually for the first several cycles so your team sees each batch before it posts, then moving to a scheduled cadence once the results are consistently clean. Confirm at the same time that user access is correct. The staff responsible for each processing screen need the appropriate Acumatica roles, and the ServiceTitan credentials used by the connector should belong to a dedicated integration account rather than an individual employee whose access might be revoked.

ServiceTitan Acumatica Integration Checklist: Quick Reference

Before you launch, walk through this final go-live readiness checklist with your project team:

  • The ServiceTitan Store is created, the Default Store flag is set, and Test Credentials returns a successful result.
  • Invoice type, import statuses, and the Begin Invoice Date are configured to match your intended cutover point.
  • Customer creation, default customer class, and address override behavior reflect an agreed policy.
  • Term and general ledger account mappings are complete and reviewed by your controller.
  • Item classes and unit of measure values exist, and the loaded ServiceTitan item list has been inspected.
  • Business units, warehouses and trucks, purchase order types, return types, and vendors are all mapped.
  • The Branch For Bills field is set if your business imports bills.
  • Your team understands that purchase orders must be imported before receipts and bills.
  • All three invoice and payment scenarios have been tested in a sandbox environment.
  • Release-after-import options are set deliberately, and the scheduler plan is agreed.
  • Acumatica roles are assigned, and the connector uses a dedicated ServiceTitan integration account.

ServiceTitan Acumatica Integration FAQ

What is the first step in setting up a ServiceTitan Acumatica integration?

Configuring the ServiceTitan Store is always the first step. The Store controls invoice import rules, customer creation, inventory handling, warehouse and branch mapping, vendor and business unit mapping, and the purchase order workflow. Until the Store is set up and Test Credentials returns a successful result, no data can be imported into Acumatica.

Can ServiceTitan receipts and bills be imported without the purchase order?

No. ServiceTitan purchase receipts and bills cannot be imported into Acumatica unless the related purchase order has already been imported. Attempting to import a receipt first produces an error message identifying the missing purchase order document. Import purchase orders first, and any receipt or bill that already exists in ServiceTitan will come across in the same process.

Does the connector create customers and vendors in Acumatica automatically?

It can. Selecting the Import Customer checkbox creates a customer in Acumatica whenever one is missing, using your default customer class. Selecting the Import Vendor checkbox does the same for vendors. If you prefer tighter control, leave these unselected and use a default customer, or map ServiceTitan vendors to existing Acumatica vendors manually with the Load Vendors action.

How are ServiceTitan items created in Acumatica?

When Import Item is selected, the Generate Item from ServiceTitan option creates items using your Stock Item Class, Non-Stock Item Class, and Unit of Measure values. Materials and Equipment become stock items, while Services become non-stock items. You can also map ServiceTitan items to existing Acumatica items manually instead of generating them.

How are ServiceTitan payments matched to Acumatica invoices?

Three scenarios are handled automatically. If the invoice carries a payment when it is retrieved, both import together and the payment is applied under the Applications tab. If the invoice was imported earlier, the payment import locates it and applies the payment. If the payment was taken first, the system matches it when the invoice arrives. In all three cases the payment ends up applied to the correct invoice.

Can the ServiceTitan Acumatica integration run automatically?

Yes. Every processing screen can run manually or on a schedule through the Acumatica scheduler, with documents retrieved by their updated date. We recommend running manually for the first several cycles so your team can review each batch, then switching to a scheduled cadence once results are consistently clean.

Get Started With the ServiceTitan Acumatica Connector

The Biz-Tech Services ServiceTitan Acumatica Connector is built for field service businesses that need their operational reality and their financial records to agree without anyone retyping a thing. Purchase orders, receipts, bills, invoices, payments, inventory transactions, and journal entries all flow into Acumatica along a defined path, and the quality of that flow is determined by the configuration work you complete before you begin. Working through this ServiceTitan Acumatica integration checklist methodically is what separates a launch that quietly succeeds from one that consumes weeks of cleanup.

If your business is preparing to connect ServiceTitan to Acumatica, we are glad to help at every stage, from initial scoping through configuration, validation, and go-live support. Visit https://biz-techservices.com to learn more about our integration expertise or to schedule a personalized demonstration of the Biz-Tech Services ServiceTitan Acumatica Connector.

SEO Metadata (for the publisher, remove before posting)

Focus keyword: ServiceTitan Acumatica integration

Secondary keywords: ServiceTitan Acumatica connector; ServiceTitan integration checklist; ServiceTitan Acumatica setup; import ServiceTitan invoices into Acumatica; ServiceTitan purchase order import; field service ERP integration; ServiceTitan Stores configuration

SEO title (58 characters): ServiceTitan Acumatica Integration Configuration Checklist

Meta description (154 characters): Complete pre-launch configuration checklist for the ServiceTitan Acumatica integration: store setup, mappings, imports, validation, and go-live readiness.

URL slug: servicetitan-acumatica-integration-configuration-checklist

Suggested internal links: ServiceTitan Connector product page; Acumatica integrations overview; Salesforce Acumatica Integration Configuration Checklist

Schema markup: Article plus FAQPage. The FAQ section is written for FAQ rich results.

Image alt text: Set on all seven images inside this document; carries over on paste into a CMS.


Salesforce Acumatica Integration Configuration Checklist

Salesforce Acumatica Integration Configuration Checklist

In many fast-growing companies, an invisible wall often exists between the sales team and the finance department. Your sales representatives live and breathe in their Customer Relationship Management, or CRM, platform to close deals, while your accounting and operations teams rely on their Enterprise Resource Planning, or ERP, system to manage inventory and billing. When these two worlds do not talk to each other, your business suffers from manual data entry, duplicate records, and a lack of real-time visibility into customer health. We at Biz-Tech Services know that bridging the gap between Salesforce and Acumatica is not just a technical task, but a strategic move to streamline your entire order-to-cash cycle.

The Biz-Tech Services Salesforce Acumatica Connector is a robust integrator designed to ensure data flows smoothly between these two powerful platforms. It provides a comprehensive solution for synchronizing customer data, automating complex workflows, and maintaining accurate financial reporting. To help your business prepare for a successful integration, we have developed a practical configuration checklist that covers everything from technical foundations to go-live readiness.

The Essential Technical Foundation

The first step in your configuration journey is ensuring your system meets the basic requirements for the Biz-Tech Services SalesForce Acumatica integration. Before we begin the setup, your business must have the correct license installed on your Acumatica system, such as a Software as a Service, or SAAS, or a Perpetual license. Once the license is in place, the primary technical task is establishing a secure link through the Application Programming Interface.

You will need to gather several key pieces of information from your Salesforce instance to facilitate this connection. First, you must identify your specific instance URL and the Username and Password for the integrator account. Second, you will need a Client ID and a Client Secret, which act as the digital keys for the Biz-Tech Services SalesForce Acumatica integrator. After entering these credentials into the general information area, we use the actions feature to Test Credentials. This validation step confirms the correctness of the login details and ensures the two systems can communicate before any data begins to move.

Defining Your Order and Customer Logic

Once the technical bridge is built, your business must decide how information should be organized as it enters your ERP. The first item on this part of the checklist is defining your Default Import Options. You must select a specific order type to indicate which document category the Salesforce orders should land in, and assign a default warehouse identification number to ensure your inventory is tracked correctly. We also recommend setting a beginning date for your first import to ensure the system only retrieves the records you are ready to process.

The second consideration is how the system should handle Customer records. You have the option to enable an import customer feature that automatically creates new customer records in Acumatica during the order import process. This automated creation includes the customer's email, contact information, and assigned customer class. If you choose not to enable this, the system can be configured to use a default customer record for every imported order instead. Additionally, you must decide if the Biz-Tech Services SalesForce Acumatica integration should override existing billing and shipping address information with the data provided in the Salesforce order, ensuring your shipments always reach the correct destination.

Mapping Data with Cross-References and Items

For the Biz-Tech Services SalesForce Acumatica integration to be truly seamless, the two systems must speak the same language regarding shipping and payments. This is where cross-reference options become critical. First, you must create mappings for common fields like payment methods, countries, and Ship Via services. For example, if a salesperson selects a specific shipping carrier in Salesforce, the cross-reference ensures the correct internal shipping code is applied in Acumatica.

Second, your business must prepare its inventory data. You can enable a feature on Ityem Settings tab that creates new items in your ERP based on information from Salesforce. If this is not enabled, the system will search for an existing inventory identification by using the Salesforce product Stock Keeping Unit, or SKU.

If the product does not already exist in your ERP, the system will display an error message to prevent data discrepancies. Here we have already performed Sync All From SalesFore process and got Stock Items created

Third, we look at tax options. You can choose to use your internal tax categories or enable an External Tax calculation service, such as Avalara, to handle complex tax requirements automatically.

Managing Prices, Discounts, and Payments

A vital part of your go-live readiness is ensuring your pricing and promotions are synchronized. The Biz-Tech Services SalesForce Acumatica connector allows your business to manage price books directly. You can retrieve all existing items from a Salesforce price book and display them within your ERP, allowing you to manually define or update list prices as needed. It is important to remember that items must be included in your standard price book before they can be added to any specialized price books.

Furthermore, the checklist should include your promotional strategies. When you configure discount codes in your ERP, they can be exported to Salesforce for use during the order creation process. These discounts can be applied at either the individual line level or the overall document level. Finally, you must define your default payment options. You can choose to release payments automatically during the import process or skip the payment step if you prefer to handle billing as a separate financial task.

Validation and Real-Time Synchronization

As you move toward your launch date, testing the Sync Orders to Salesforce feature is essential. This capability allows your team to update imported order data within Acumatica — such as changing a shipping address or adding a new line item — and then process those changes back to Salesforce. This ensures that your sales team always sees the most current information regarding an order's total, tax, and freight amounts. The system even retrieves internal notes from Salesforce and displays them in the sales order notes area of your ERP, though these are kept uneditable to maintain the integrity of the original sales record.

This Biz-Tech Services SalesForce Acumatica integrator is built for modern enterprises that need to eliminate the data gap between their front-office sales activities and their back-office financial functions. By following this structured configuration checklist, we ensure that your teams can make informed decisions based on up-to-date, synchronized information.

If you are ready to streamline your order processing and improve visibility across your entire organization, we are here to help you every step of the way. We invite you to visit https://biz-techservices.com to learn more about our integration expertise or to schedule a personalized demo of the Biz-Tech Services Salesforce Acumatica Connector.


Privacy Preference Center