Crear desde Factura en Selección de Pago da error de "Falta completar los campos INV_IsSOTrx"

[niclopup]

Bug report

Encontré otro error: el SB de "Crear Desde Factura" en ventana Selección de Pagos da error de "Falta completar los campos INV_IsSOTrx"

Screenshot or Gif（截图或动态图）

[EdwinBetanc0urt]

Existe un error en la definición de la vista asociada a la consulta inteligente.

El campo que trata de obtener el valor INV_IsSOTrx del contexto es Payment Rule (BP_PaymentRule).

Sin embargo el único campo relacionado a ese nombre de contexto es Sales Transaction cuyo nombre de columna es IsSOTrx.

Quizás deba cambiarse el nombre de la columna a INV_IsSOTrx para que pueda coincidir con el contexto. Ademas que no comienza con el prefijo INV_ como la mayoría de las columnas (exceptuando PS_C_Currency_ID)

[EdwinBetanc0urt]

Aca el contexto del zk donde se demuestra que no existe INV_IsSOTrx, el zk/swing a diferencia de vue no valida si falta un valor de contexto en la consulta para ejecutarla, por lo que puede considerarse que quizás la columna BP_PaymentRule con columna sql

CASE WHEN '@INV_IsSOTrx@' = 'Y' THEN bp.PaymentRule ELSE bp.PaymentRulePO END

siempre toma el valor del bp.PaymentRulePO al no cumplirse la primera condición.

0|currWindowNo == 10
10|0|BP_C_BP_Group_ID == 0
10|0|INV_C_BPartner_ID == 0
10|0|INV_C_BankAccount_ID == 0
10|0|INV_C_Currency_ID == 0
10|0|INV_C_DocType_ID == 0
10|0|INV_C_Invoice_ID == 0
10|0|INV_C_Order_ID == 0
10|0|INV_C_PaymentTerm_ID == 0
10|0|INV_CurrentBalance == 0
10|0|INV_DateInvoiced == 
10|0|INV_DateInvoiced_To == 
10|0|INV_DaysDue == -9999999
10|0|INV_DaysDue_To == 9999999
10|0|INV_DueDate == 
10|0|INV_DueDate_To == 
10|0|INV_IsInDispute == 
10|0|INV_MatchRequirement == N
10|0|INV_OnlyDiscount == 
10|0|INV_OnlyDue == 
10|0|INV_PaymentRule == 
10|0|PS_C_Currency_ID == 100
10|0|Table_BP_PaymentRule == 
10|0|Table_BP_SOCreditStatus == 
10|0|Table_BP_TotalOpenBalance == -50909.000
10|0|Table_INV_AmtSource == 1050.00
10|0|Table_INV_C_BPartner_ID == 0
10|0|Table_INV_C_ConversionType_ID == 0
10|0|Table_INV_C_Currency_ID == 0
10|0|Table_INV_C_DocType_ID == 0
10|0|Table_INV_C_InvoicePaySchedule_ID == 0
10|0|Table_INV_C_Invoice_ID == 0
10|0|Table_INV_C_PaymentTerm_ID == 0
10|0|Table_INV_ConvertedAmt == 19854.0
10|0|Table_INV_DateInvoiced == 
10|0|Table_INV_DaysDue == 5145
10|0|Table_INV_Description == 
10|0|Table_INV_DiscountAmt == 0.00
10|0|Table_INV_DocumentNo ==  Σ 
10|0|Table_INV_DueDate == 
10|0|Table_INV_GrandTotal == 19854.0
10|0|Table_INV_IsInDispute == 
10|0|Table_INV_OpenAmt == 19854.00
10|0|Table_INV_PayAmt == 19854.00
10|0|Table_INV_PaymentNumber == 
10|0|Table_INV_PaymentRule == 
10|0|Table_IsSOTrx == 
10|0|Table_PS_C_Currency_ID == 0
10|AD_Client_ID == 11
10|AD_Org_ID == 50001
10|AutoCommit == Y
10|AutoNew == Y
10|BaseTable_ID == 426
10|C_BankAccount_ID == 1000000
10|C_Currency_ID == 100
10|C_DocType_ID == 1000000
10|C_PaySelection_ID == 1000008
10|Created == 2023-08-04 12:34:09
10|CreatedBy == 101
10|DateDoc == 2023-08-04 00:00:00
10|DocAction == CO
10|DocStatus == DR
10|DocumentNo == 1000008
10|INV_CurrentBalance == 0
10|INV_DaysDue == -9999999
10|INV_DaysDue_To == 9999999
10|INV_MatchRequirement == N
10|IsActive == Y
10|IsApproved == N
10|IsSOTrx == N
10|PS_C_Currency_ID == 100
10|PayDate == 2023-08-04 00:00:00
10|Processed == N
10|Processing == N
10|Table_BP_TotalOpenBalance == -50909.000
10|Table_INV_AmtSource == 1050.00
10|Table_INV_ConvertedAmt == 19854.0
10|Table_INV_DaysDue == 5145
10|Table_INV_DiscountAmt == 0.00
10|Table_INV_DocumentNo ==  Σ 
10|Table_INV_GrandTotal == 19854.0
10|Table_INV_OpenAmt == 19854.00
10|Table_INV_PayAmt == 19854.00
10|TotalAmt == 0
10|Updated == 2023-08-04 12:34:09
10|UpdatedBy == 101
10|WindowName == Selección de Pago

4|0|BP_C_BP_Group_ID == 0
4|0|INV_C_BPartner_ID == 0
4|0|INV_C_BankAccount_ID == 0
4|0|INV_C_Currency_ID == 0
4|0|INV_C_DocType_ID == 0
4|0|INV_C_Invoice_ID == 0
4|0|INV_C_Order_ID == 0
4|0|INV_C_PaymentTerm_ID == 0
4|0|INV_CurrentBalance == 0
4|0|INV_DateInvoiced == 
4|0|INV_DateInvoiced_To == 
4|0|INV_DaysDue == -9999999
4|0|INV_DaysDue_To == 9999999
4|0|INV_DueDate == 
4|0|INV_DueDate_To == 
4|0|INV_IsInDispute == 
4|0|INV_MatchRequirement == N
4|0|INV_OnlyDiscount == 
4|0|INV_OnlyDue == 
4|0|INV_PaymentRule == 
4|0|PS_C_Currency_ID == 100
4|0|Table_BP_PaymentRule == 
4|0|Table_BP_SOCreditStatus == 
4|0|Table_BP_TotalOpenBalance == -50909.000
4|0|Table_INV_AmtSource == 1050.00
4|0|Table_INV_C_BPartner_ID == 0
4|0|Table_INV_C_ConversionType_ID == 0
4|0|Table_INV_C_Currency_ID == 0
4|0|Table_INV_C_DocType_ID == 0
4|0|Table_INV_C_InvoicePaySchedule_ID == 0
4|0|Table_INV_C_Invoice_ID == 0
4|0|Table_INV_C_PaymentTerm_ID == 0
4|0|Table_INV_ConvertedAmt == 19854.0
4|0|Table_INV_DateInvoiced == 
4|0|Table_INV_DaysDue == 5145
4|0|Table_INV_Description == 
4|0|Table_INV_DiscountAmt == 0.00
4|0|Table_INV_DocumentNo ==  Σ 
4|0|Table_INV_DueDate == 
4|0|Table_INV_GrandTotal == 19854.0
4|0|Table_INV_IsInDispute == 
4|0|Table_INV_OpenAmt == 19854.00
4|0|Table_INV_PayAmt == 19854.00
4|0|Table_INV_PaymentNumber == 
4|0|Table_INV_PaymentRule == 
4|0|Table_IsSOTrx == 
4|0|Table_PS_C_Currency_ID == 0
4|AD_Client_ID == 11
4|AD_Org_ID == 50001
4|AutoCommit == Y
4|AutoNew == Y
4|BaseTable_ID == 426
4|C_BankAccount_ID == 1000000
4|C_Currency_ID == 100
4|C_DocType_ID == 1000000
4|C_PaySelection_ID == 1000008
4|Created == 2023-08-04 12:34:09
4|CreatedBy == 101
4|DateDoc == 2023-08-04 00:00:00
4|DocAction == CO
4|DocStatus == DR
4|DocumentNo == 1000008
4|INV_CurrentBalance == 0
4|INV_DaysDue == -9999999
4|INV_DaysDue_To == 9999999
4|INV_MatchRequirement == N
4|IsActive == Y
4|IsApproved == N
4|IsSOTrx == N
4|PS_C_Currency_ID == 100
4|PayDate == 2023-08-04 00:00:00
4|Processed == N
4|Processing == N
4|Table_BP_TotalOpenBalance == -50909.000
4|Table_INV_AmtSource == 1050.00
4|Table_INV_ConvertedAmt == 19854.0
4|Table_INV_DaysDue == 5145
4|Table_INV_DiscountAmt == 0.00
4|Table_INV_DocumentNo ==  Σ 
4|Table_INV_GrandTotal == 19854.0
4|Table_INV_OpenAmt == 19854.00
4|Table_INV_PayAmt == 19854.00
4|TotalAmt == 0
4|Updated == 2023-08-04 12:34:09
4|UpdatedBy == 101
4|WindowName == Selección de Pago
7|0|BP_C_BP_Group_ID == 0
7|0|INV_C_BPartner_ID == 0
7|0|INV_C_BankAccount_ID == 0
7|0|INV_C_Currency_ID == 0
7|0|INV_C_DocType_ID == 0
7|0|INV_C_Invoice_ID == 0
7|0|INV_C_Order_ID == 0
7|0|INV_C_PaymentTerm_ID == 0
7|0|INV_CurrentBalance == 0
7|0|INV_DateInvoiced == 
7|0|INV_DateInvoiced_To == 
7|0|INV_DaysDue == -9999999
7|0|INV_DaysDue_To == 9999999
7|0|INV_DueDate == 
7|0|INV_DueDate_To == 
7|0|INV_IsInDispute == 
7|0|INV_MatchRequirement == N
7|0|INV_OnlyDiscount == 
7|0|INV_OnlyDue == 
7|0|INV_PaymentRule == 
7|0|PS_C_Currency_ID == 100
7|AD_Client_ID == 11
7|AD_Org_ID == 50001
7|AutoCommit == Y
7|AutoNew == Y
7|BaseTable_ID == 426
7|C_BankAccount_ID == 1000000
7|C_Currency_ID == 100
7|C_DocType_ID == 1000000
7|C_PaySelection_ID == 1000008
7|Created == 2023-08-04 12:34:09
7|CreatedBy == 101
7|DateDoc == 2023-08-04 00:00:00
7|DocAction == CO
7|DocStatus == DR
7|DocumentNo == 1000008
7|INV_CurrentBalance == 0
7|INV_DaysDue == -9999999
7|INV_DaysDue_To == 9999999
7|INV_MatchRequirement == N
7|IsActive == Y
7|IsApproved == N
7|IsSOTrx == N
7|PS_C_Currency_ID == 100
7|PayDate == 2023-08-04 00:00:00
7|Processed == N
7|Processing == N
7|TotalAmt == 0
7|Updated == 2023-08-04 12:34:09
7|UpdatedBy == 101
7|WindowName == Selección de Pago

[EdwinBetanc0urt]

En el zk/swing al hacer la búsqueda del smart browse si el valor no existe en el contexto, lo omite, se quito la validación en vue para tener un comportamiento similar.