NE_JohnC Red Ribbon

we are trying to build a report that tracks out of stocks by day and location over time

Thanks for the suggestion, I would use this to generate the inventory snapshot, but I am looking for a solution to store the daily snapshots for historical reporting / trending of inventory at an item level

ok, thanks for your help, at least you confirmed I was doing it correct

it is showing 3 and $20.97

here is the transaction

Thanks again for your help Here is the results of the search, for the first item it is showing Sales of 3 units for $20.97 between Sept 8-14, then the second image shows the transactions for the item with only 1 sold between Sept 8-14 (on the 12th) for $6.99

Thanks for your help I have attached:

thanks, I am trying to build our job applicant form on our SCA site

Thanks, I have an existing form that the captcha was working. I am beginning to think is a permissions issue

Thanks, this will work

thank you

Thanks for the links, they seem to be able to show the one price for one vendor for an item, vs prices from all vendors for an item (in one row)

Thank you for your help, that solved the issue.

Here is my search and the Formula text - i get an error when i run the search with the formula, the bottom are the results I am getting that i am trying to remove the comma from both the sales Qty and Sales Amt Thanks for looking at this

Thanks, I have tried that, but it seems to have an issue with formula (text) - Group -has an issue with the formula for Sum ( {amount})

Thank you, i have built a "temporary" solution running the report daily with Wednesday as the date, and using the plus 1-3 days from now as well as the yesterday and 2 days ago

thanks, are there any scripts to convert the third-party response to a useable format?

Thanks, however when I do that my response looks like: I am hoping to get a list of the transactions

Thank you, this is what I needed

Thanks, I am looking to find a Po that has the same item several times

ok, thanks - we do not have the advanced inventory module, however I am going to look at having our EDI ASN transaction create an Inbound Shipment document which looks like it may meet our needs. Thanks

is it possible the Suite App has been removed or is it the Inbound Shipment Feature?

Thanks, typically it is a supplier shipping directly to one of our retail outlets, so we want them to have visibility to the ASN when the supplier sends the product, but we do not want the product to be "On Hand" until it arrives at our loading dock. I am working through testing the Inbound ASN Automation in our sandbox to…

yes, It is the first time trying to clean up / inactivate items with no sales. But this will work. Thanks again

thanks, it seems to be working, but it keeps timing out, so i have scheduled it to run overnight

Thanks, I will track down where to vote for the enhancement

We require our suppliers to provide their price changes 7-30 days in advance. Is there a way to load these so that future Purchase Orders reflect the correct price? Thanks

Thanks, we are going to try this solution

I am waiting to hear back from our finance team