Hi there guys,
I'm new here and hope to gain some valuable info from some of the more clevererer lot and share my experiences with others running into similar problems.
In short: We have a manufacturing / retail / design business where we deal with a large amount of separate components (from stock) that needs to be combined into a single (unique) order. We do this by creating a unique spreadsheet quote for each job which gets transformed into a "pick slip" for the factory.
To improve accuracy of the Picking slip, I need to query stock levels in Pastel from within Excel (this is required to generate a sensible "pick slip" for the warehouse and not include items which is out of stock, or replace it with something else that is in stock).
I'm sure many businesses need the same functionality to optimize the workflow.
What I've done so far:
1) Created an ODBC connection to our Pastel database from Excel
2) Managed to figure out that the table called "MultistoreTrn" in Pastel Partner is the one storing inventory levels (adding / subtracting some columns together gets me to the actual "on hand" number as reflected from within Pastel).
My concern (and question):
1) We have about 1200 inventory items and every time I refresh the query, takes Excel about 10 sec - I can see it pulls quite a lot of resources and it sometimes "bombs-out" saying the memory on my local machine is full / or corrupt etc.
Is it possible to "ask" the server only to send the inventory levels of the specified inventory item? in stead of loading the entire inventory list to the local excel spreadsheet where it gets filtered?
2) The way I intend to use this query may result in two or more workstations running the same macro (which includes refreshing this query) from different machines. I therefor need it to be snappy and low on network resources.
Any ideas / advice appreciated!
(I'm by no means an IT expert. I'm probably more useful with a torque wrench and a hammer; so please correct me if I'm at any point missing a much more obvious way to get to the same answer)
thank you!![]()
Did you like this article? Share it with your favourite social network.