send items with quantities to another database

  • 5 July 2023
  • 1 reply

Userlevel 3
Badge +1


i need to make integration between two databases to send the items and the quantities from database to another database automatically 

which tables should i make the integration with ?

thanks in advance


Best answer by davidnavasardyan09 17 July 2023, 20:49

View original

1 reply

Userlevel 5
Badge +1

Hello @abdallaahmed61 

In order to achieve an integration between two databases to automatically transmit item and quantity information, you would typically be interfacing with tables that contain item master data and inventory quantity data.

In most systems, this data is commonly stored in the following types of tables:

  1. Item Master Table: This table contains the master data for all items/products in the system. The table name can vary widely depending on the system, but common names could be "Items", "Products", "InventoryItems", "MaterialMaster" and so forth.

  2. Inventory/Stock Level Table: This table usually holds the quantity of each item available in the inventory. Again, the exact table name can differ based on the system, but could be something like "Inventory", "Stock", "InventoryLevels", "MaterialStock", etc.

For an ERP system like SAP, these tables would be MARA (Material Master) and MARD (Material Stock).

In Acumatica ERP, the corresponding tables would be InventoryItem (for item master data) and INItemSite (for stock quantities at each site).

However, I must caution you that directly interfacing with the database tables can be risky, as it bypasses any business rules enforced by the application layer of the ERP system. Also, if the database schema changes with a system upgrade, your integration could break.

A safer and more robust approach would be to use APIs provided by the system, such as web services (like SOAP or REST), or even file-based interfaces if the system provides them. For Acumatica, there are robust REST and SOAP web services that you could use for this purpose, which will ensure that all business rules are adhered to when updating the data.

In addition to the above, an integration like this could have other complexities. For example, if there are differences in the item coding/naming schemes between the two systems, or if the UOM (Units of Measure) are not the same, you may need to develop a mechanism to map these values between the two systems.


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved