How to provide access to our inventory for our customers using webservices?

p0wertube

Good Morning Guys,

we are a footwear producer and want to give our customers access to read our stock.
I'm a NAV - Noob, so I'm pretty sure that there are enough options to do it, but I'm looking for an easy and also inexpensive.

generally, Could this be done with a NAV webservice?

Juhl

And don’t give them access to NAV web service. Make an intermediate web service outside NAV that they call and let that service call NAV.
You could even update and external db and serve that if it becomes busy and performance is getting hit on NAV.

KTA8

Yes, it could be achieve. It's something quite normal, all your warehouse movements are registered en table 32

p0wertube

Hey KT8, thanks for your response.

We're using items with variants, so I've found table 5401, which shows a flowfield (stock) which is calculated from tbl 32.
I think this could be a way to go.

KTA8

p0wertube wrote: »

Hey KT8, thanks for your response.

We're using items with variants, so I've found table 5401, which shows a flowfield (stock) which is calculated from tbl 32.
I think this could be a way to go.

In table 32 you've item variant also (5402), the ones are already in warehouse are the one with open (29) = true

Juhl

And don’t give them access to NAV web service. Make an intermediate web service outside NAV that they call and let that service call NAV.
You could even update and external db and serve that if it becomes busy and performance is getting hit on NAV.