João Antonio
- Actividad total 87
- Última actividad
- Miembro desde
- Siguiendo 0 usuarios
- Lo siguen 0 usuarios
- Votos 8
- Suscripciones 35
Publicaciones
Actividad reciente de João Antonio-
Adjust query when creating a position in the bill of material of the production order
Hi,When adding a material to the work order, the system is making some queries and the process takes a while.Analyzing the query we can see that there is a conversion in the data in where.Monitorin...
-
Slow Query - Timestamp
Hi Martin, We are having a great slowdown when making the time recording through the terminal.Monitoring the database I found a query that reads all batches in the system and adds up the amount of ...
-
Query when adding a work order.
Hi Martin. Every time you add a work order or system, look up below.select "BELNR_ID", "BELPOS_ID", "POS_ID", "NUMMER" from "BEAS_FTSTL" where coalesce ("NUMMER", 0) = 0 ordered by "BELNR_ID", "BEL...
-
Beas Common
HI Martin We have industry 4.0 a to make the integration of the timestamp we use the common beas and with its priority of appointment.As we have several records in the common beas queue, we can do ...
-
When creating a sql result screen
Hi, The screen created based on the query, as shown in the example, the screen is displayed normally, but I can't change its name to develop the Beas script. The default name is sqlanzeige1 tools=i...
-
Work Order change log
Hi A small suggestion that can be useful for several customers, in the system there is the log and reason for changing the master data as the route and structure, we need the same functionality to ...
-
Filter in MRP
HiI need more fields to perform some filters on the MRP screen before performing the calculation.In the image where I need to filter the data contained in the work order as an example the project, ...
-
MRP filter
Dear friends In the MRP I need to make a filter in order of work as the image below the system allows only one order. How can I filter multiple orders. Example: 12028,12100,12820,12844,14400 As our...
-
Add field
RespondidaHello, I need your help, on the inventory inventory screen, I need to put information that contains the item's registration in a field on this screen.Attached is an image where I have to put this i...
-
serial number
RespondidaNeed help!I need to set up a serial number for production order, in the serial configuration I need to run a procudure and display an error.Image one where proc is.The second image is the field siz...