Currently, we have a field which is exposed to the API and calculates inventory based on the warehouse. This field is based on “INStatus.LastModifiedDateTime”. However, the question with Celigo is the aggregation of inventory items based on various locations. So, it should either be aggregated on the Celigo side or we can have a generic Inquiry which feeds this information to Celigo. For this reason, we have a GI in this case. Please find attached for your reference.After importing the GI, you can perform a GET request:{sitename}/OData/StorageSummary?$filter=SiteLastModifiedDate gt datetime'2021-04-22T00:00:00.000'
@Igor.Leybe - their premade templates have the following OData filter which references the LastModified on the stock item: /StockItem?$filter=LastModified ge datetimeoffset'{{encodeURI lastExportDateTime}}' &$top=100 This only recognizes a change to the item listing itself, not to changes in inventory. We tested this by applying an inventory adjustment, running the flow, getting nothing, then changing the item description, running the flow, and getting a result. When we asked Celigo about it they suggested we contact Acumatica. We even attended their office hours and got the same answer. Hi @ctechaplus We have proposed a solution to Celigo for this scenario and waiting for their reply. It includes retrieving the inventory records using a Generic Inquiry.Please allow us some time to confirm the findings with Celigo and get back to you on this.
@ruchikasharma23 - Could you please check with Celigo why they can’t do it and if there are any possible workarounds. Sure, working on it.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.