erp

Hi guys, I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and...

Years ago I did a project that I used VBA for. We were pulling data directly into excel from an ERP. I am now working on another project where I want the data from our ERP (NetSuite) to be automatically populated in Excel and cannot remember for the life of me the code/process for connecting...

Hello, beautiful minds! I have an Excel file that connects to a Cube on a SQL database. I created that connection with Get Data > From Database > From Analysis Services. The cube I ma connecting to is updated every few hours and while that process is happening, I cannot work on my file. Is...

Hello fellow excel enthusiasts, This is my first post as I am a new joiner - although i am now wondering what took me so long...! I have been playing around with excel for the last 20 odd years and self taught myself whatever I needed to make it work. I have developed and implemented a pretty...

Hello everyone, I have a QTD measure that is almost working, It calculates the current QTD value exactly as I would see it in our ERP, but I would like it to respond to the month selection, based on a <= calculation. My current measure is, =CALCULATE(SUM('Income...

I am identifying component items which will be Made-to-Stock (MTS) for parent items which are Assemble-to-Order (ATO) for manufacturing purposes. What I would like to do is: In column A, list all of my items which are ATO In column B, compare the first 6 characters of column A to a list of...