Mark Alexander

Calculation Query

I'm trying to write a query that will list all make items with their corresponding direct material costs and labour costs, as per the data in the calculation section of the Item Master. I don't kno...

• Mark Alexander
• November 04, 2022 17:52
• 1 follower
• 0 comments
• 0 votes

Hi Martin, I found it now. I was querying on the wrong attribute (DocNum instead of DocEntry), and it was returning nothing for the view. Now I'm getting all the rows, with the planned time. Thanks...

• View comment
• December 04, 2020 14:02
• 0 votes

Hi Martin, If I query the view (BEASV_WORKORDER_ROUTING), I get nothing for the work order in question (33780). If I query table BEAS_FTAPL I get the 3 rows for each operation, but none of the valu...

• View comment
• December 04, 2020 13:47
• 0 votes

Hi Martin, Thanks for replying. I see planned time and reserved time, which are taken from BEAS_FTAPL and BEAS_RESOURCEN respectively. I can't find the planned time in BEAS_FTAPL and the BEAS_RESOU...

• View comment
• December 03, 2020 21:51
• 0 votes

Booked time for operations/routers

I am trying to write a query that will display the booked time for an operation/router and the actual time that was logged against it. I don't have a problem getting the time logged for each scan, ...

• Mark Alexander
• November 30, 2020 21:11
• 2 followers
• 5 comments
• 0 votes
• Answered

Hi Daniel, Thanks for the response, I put the missing text into the query and it worked great. I didn't put them in originally as I thought they were comments (Similar to C++ code), and didn't real...

• View comment
• January 23, 2018 13:17
• 0 votes

Hi Daniel, thanks for the response. I did as you suggested but I still get an error. Here's my new SQL statement below: DECLARE @ItemCode NVARCHAR(100)SET @ItemCode = '[%0]' SELECT t1.ItemCode, t2....

• View comment
• January 19, 2018 15:48
• 0 votes