How to enter the amount foreseen in operations on Articles

Navigation
-3

I need to enter the expected quantity in the respective column, as shown in the figure.

ImadeatraceusingtheSQLServerProfiler,howeverIgetittoselectthedatabaseandpassitasanid.

IcopiedthesameselectandpastedintothedatabaseanddidnotgetthisbecausethisIDdoesnotevenexistinthetableinthatcolumn.Ireturnedtodothesameselectwithoutfilter,(select*fromGPR_OrdemFabricoComponentesorderbyIDOrdemFabricoComponentdesc)andIevennoticedthatthereisnosuchID;

I would like to know which parameter is used there in select by spring and where it is searched or otherwise would like to know how to put values there in the expected amount through a query, insert, etc, as long as it is not by the button Suggest available in the Stocks window. In the background I want to know what the Suggest button does.

    
asked by anonymous 05.07.2018 / 11:52

1 answer

1

For the document concerned (Output for Production Order), the Suggest button loads the articles (components) that are consumed by a particular manufacturing order, for each of the existing operations in that order. manufacturing.

The amount of the expected quantity indicates the quantity that is expected to be consumed from a particular component. At this point this value is obtained from the manufacturing order but its origin (at the time of creation of the manufacturing order) is the technical file of the article. This value is updated as stock movements are made for the manufacturing order. The stock movement is based on the Quantities column value.

    
05.07.2018 / 15:28
Banco do Brasil, second booty ticket: can not send POST to https://www63.bb.com.br/portalbb/boleto/boletos/hc21e,802,3322,10343.bbx [closed] Simple Problem (Java Calculator - Switch) [closed]