Thanks so much for your @kandybeatty49, but unfortunately I couldn’t get it to workI was able to create the new template, but I don’t know how to make it the default template for the ‘create’ email action.
Hi @kandybeatty49, thanks for the reply!I should’ve mentioned in the original post, but I already checked and couldn’t find a template associated with CR306015:At the moment we are doing exactly as you suggested (changing the template manually for each email), but I’m hoping to eliminate this step. We use a single template for most of our case emails
@Chris Hackett, @TimRodman, the problem has mysteriously returned!As you suggested @TimRodman, I opened the odata feed directly in my browser. The data in the “raw” feed contains the exact same errors as the Excel import. It doesn’t appear that Excel isn’t causing the problem. And the GI continues to run flawlessly when run within Acumatica. I’ll raise a support case, but please let me know if you have any other suggestions. I appreciate all your kind help so far!
@TimRodman great idea to check the feed in the browser. I never thought to do that! There are some PQ transformations in the Excel file.If the problem was related to the ARSalesPrice.InventoryID querying to get InventoryID, would I also see the problem in both the GI and in the OData feed? I’ve never had an problem with the data when I ran the GI within Acumatica
@TimRodman. I used ARSalesPrice.InventoryID.ARSalesPrice was the only table in the GI. I’ve pasted a copy of the results fields below:
@Chris Hackett, it seems to have resolved itself without any intervention!The OData feed has been refreshing without errors for the past few weeks. No changes were made to the GI or to the Excel file. I really have no idea what was wrong, or why it is suddenly working again.I will update this thread if I see the problem again.
@vkumar confirming that the issue is still ongoing. Is this a known issue? And does Acumatica have any suggestions for a fix or work around?
@vkumar Done. The data is correct for the first ~785 lines and then it begins to skip some Inventory IDs and randomly repeat others.
Hi @vkumar Version is 2021 R2. Build is 21.200.0145.The number of the lines in the data always seems to be correct. But the data within those lines has errors. This issue only seems to affects once column, INVENTORY ID. The other columns, CUSTOMER PRICE CLASS, EFFECTIVE DATE, and PRICE all match the Acumatica Excel export exactly.
Thanks @vkumar but that didn’t work.I opened the Excel file and the Odata feed refreshed automatically. The data loaded without errors.I then cleared the cache and refreshed the data manually. Now the data has errors!Is this a known issue? And is it likely affecting all my OData feeds?
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.