By using this website, you agree to our Terms of Use (click here)
My First Post to ARC 🙂
We currently have a distribution client in implementation with approx 3000 products. As part of their implementation we are designing a 'Proposal' report based on a QT Order, our client would like to include an image of the product. We have achieved this in the report design using the product image.
Does anyone have any suggestions on how we might go about bulk loading the product images? Currently they are in a local folder labeled {ProductCode}.jpg
Thanks in Advance!
Nicholas Wood
Momentum Software
Hi Nic,
I was able to bulk load attachments into the Bills and Adjustments screen using REST APIs and Microsoft Flow for a scenario where a customer wanted to scan invoices to a folder and have them automatically get created as AP Bills. Your scenario would be even easier because the Stock Items screen is part of the DEFAULT endpoint so you save yourself a step by not having to create it.
We should be able to do the same thing here.
Basically, you could name all of the files with the Inventory ID that each one needs to get attached to. Then you would drag them into a folder (I used OneDrive, but DropBox would work to). Microsoft Flow would see that they were created, then automatically attach them into appropriate Stock Item in Acumatica.
Does that method sound like it would work for you?
O ya, and thanks for becoming a member of ARC!
Thanks Tim!
That sounds like a great solution, I'll brush up on MS Flow and see what I can put togeather
Nic
I'd like to write a blog post on the topic. Would you prefer to use DropBox or OneDrive to accomplish this?
Thanks Tim,
A blog post on the topic would be very interesting. I tend to use Dropbox but would be happy to see the process set up with either.
Nic
Hey Tim,
Cool example. I'd like to see blog post using OneDrive with Flow.
I'll add it to my list of post ideas. The scenario that I used it for was automatically creating an AP Bill when a scanned invoice is dragged into a OneDrive folder. I think it's more useful with FTP because most scanner/copier machines can scan directly to FTP, but I didn't have access to an FTP server when I built it.