Configure custom inquiry endpoint for Amazon - Acumatica integration app to sync inventory

Contents

• Step 1: Create a custom generic inquiry in Acumatica
• Tables tab
• Relations tab
• Parameters tab
• Conditions tab
• Grouping tab
• Sort Order tab
• Results Grid tab
• Step 2: Extend the web service endpoint to the custom generic inquiry
• Step 3: Enter the object name in the Integration App settings

It is required to sync item inventory and summed up inventory against multiple warehouses from the last flow run time whenever there is an inventory update. The Acumatica native API doesn't get delta inventory across multiple warehouses for an item. To get the delta inventory, create a custom generic inquiry in Acumatica. The generic inquiry helps to compare data across multiple warehouses by getting the last modified date of inventory at each warehouse and comparing the recent one with the last flow run time.

Note: The custom generic inquiry is only applicable for the Acumatica inventory to Amazon inventory (add/update) flow.

Limitation: By default, Celigo provides a generic inquiry (CeligoInventoryInquiry) in the Acumatica account when you import the Customization Project. In this custom project, the Integration App supports filters for 10 warehouses. If you support more warehouses or want to add further conditions or customizations, you can create a custom generic inquiry in your Acumatica account.

Step 1: Create a custom generic inquiry in Acumatica

1. Log in to the Acumatica account with the appropriate credentials.
2. In the search bar, enter generic inquiry.
3. From the search results, below the Profiles section, click Generic Inquiry.
4. On the Generic Inquiry page, in the Inquiry Title field, enter a valid unique name.
5. Check the Make Visible on the UI box.
6. In the Select Top field, enter the value as 100.
7. Click Save.
   
   

Tables tab

1. Go to the Tables tab.
2. In the Tables tab, click + to add the following tables an alias.
   

   Table Name*	Alias*
   PX.Objects.IN.CeligoINSiteStatusProjection	CeligoINSiteStatusProjection
   PX.Objects.IN.INSiteStatus	INSiteStatus
   PX.Objects.IN.InventoryItem	InventoryItem

3. Click Save.
   
   

Relations tab

1. Go to the Relations tab.
2. Click + to add the following relations:
   

   Parent Table	Join Type	Child Table
   INSiteStatus	Left	InventoryItem
   INSiteStatus	Left	CeligoINSiteStatusProjection

   

   In the Data Field Links for Active Relation section, add the following:

   As per the above table, click on the first row to add the following active relation:

   Parent Field	Condition	Child Field	Brackets	Operator
   INSiteStatus.InventoryID	Equals	InventoryItem.InventoryID		And

   Click on the second row to add the following active relation:
   

   Parent Field	Condition	Child Field	Brackets	Operator
   INSiteStatus.InventoryID	Equals	CeligoINSiteStatusProjection.InventoryID		And

   
3. Click Save.

Parameters tab

1. Go to the Parameters tab.
2. Click + to add the following parameters.
   

   Name	Schema Field	Display Name
   InventoryNbr	InventoryItem.InventoryID	Inventory no.
   LastModifiedDateTime	CeligoINSiteStatusProjection.InventoryID	Last Modified Date Time
   CeligoAccount	InventoryItem.UsrCeligoAccounts	Celigo Account

   
3. Click Save.

Conditions tab

1. Go to the Conditions tab.
2. Click + to add the following conditions:
   

   Brackets	Data Field	Condition	Value 1	Value 2	Brackets	Operator
   (	InventoryItem.InventoryID	Is Greater Than		[InventoryNbr]		Or
   	[InventoryNbr]	Is Empty			)	And
   (	CeligoINSiteStatusProjection.LastModifiedDateTime	Is Greater Than or Equal		[LastModifiedDateTime]		Or
   	[LastModifiedDateTime]	Is Empty			)	And
   (	InventoryItem.UsrCeligoAccounts	Contains		[CeligoAccount]		Or
   	[CeligoAccount]	Is Empty			)	And

   
3. Click Save.

Grouping tab

1. Go to the Grouping tab.
2. Click + to add a new entry.
3. In the Data Field column, select INSiteStatus.inventoryID from the drop-down menu.
   
   
4. Click Save.

Sort Order tab

1. Go to the Sort Order tab
2. Click + to add a new entry.
3. In the Data Field column, select InventoryItem.InventoryID from the drop-down menu.
4. In the Sort Order column, be sure the value is Ascending.
   
   
5. Click Save.

Results Grid tab

1. Go to the Results Grid tab
2. Click + to add the following results grid.
   

   Object	Date Field	Schema Field	Caption	Aggregate Function
   INSiteStatus	InventoryID		Inventory ID
   CeligoINSiteStatusProjection	LastModifiedDateTime		Last modified date time	MAX
   INSiteStatus	QtyOnHand		Qty on hand	SUM
   InventoryItem	UsrCeligoAccounts		Celigo account
   InventoryItem	InventoryID	InventoryItem.InventoryID	Inventory no.

   
3. Click Save.

Step 2: Extend the web service endpoint to the custom generic inquiry

1. In the global search, enter the web service endpoint.
2. From the search results, below the Preferences section, click Web Service Endpoints.
3. On the Web Service Endpoints page, click CeligoAcumaticaIA.
   
   Note: It is mandatory to select the web service endpoint as CeligoAcumaticaIA.
4. On the Web Service Endpoints page, click Insert.
5. In the Object Name field, enter an object name.
   
   
6. Click Search to select the screen name created in Step 1.
   
7. After you select the appropriate search, the value in the Screen ID field is populated automatically.
8. Click OK.
   

Step 3: Enter the object name in the integration app settings

1. Log in to your integrator.io account
2. Click Amazon - Acumatica Integration App tile.
3. Go to Settings > Inventory section.
4. Check the Use Acumatica custom inquiry endpoint box.
5. In the Acumatica custom inquiry endpoint name field, it is mandatory to provide the object name entered in Step 2.