Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error al Acercar Referencia #23

Open
elsiosanchez opened this issue Jun 13, 2022 · 0 comments
Open

Error al Acercar Referencia #23

elsiosanchez opened this issue Jun 13, 2022 · 0 comments
Labels

Comments

@elsiosanchez
Copy link

elsiosanchez commented Jun 13, 2022

En la ventana Órdenes de Venta ir al menu de accciones y abra la referencia a la ventana Cálculo de Morosidad que posee 4 registro

image

Gif Error

error-sql-zoom

Petición

http://localhost:8085/api/adempiere/user-interface/window/entities?window_uuid=a5215810-fb40-11e8-a479-7a0060f0aa01&tab_uuid=a4a293c2-fb40-11e8-a479-7a0060f0aa01&search_value=&filters[]=%7B%22column_name%22:%22C_Order_ID%22,%22value%22:108%7D&page_size=15&token=dc059d9f-fc75-42bb-ba5b-a813b098d2ac&language=es

Error

org.postgresql.util.PSQLException: ERROR: column c_dunningrun.c_order_id does not exist\n  Position: 58, SQL=SELECT COUNT(*)  FROM C_DunningRun AS C_DunningRun WHERE (C_DunningRun.C_Order_ID=?) AND C_DunningRun.AD_Client_ID IN(0,11) AND C_DunningRun.AD_Org_ID IN(0,11,12,50000,50002,50001,50004,50006,50005,50007) AND (C_DunningRun.C_DunningRun_ID IS NULL OR C_DunningRun.C_DunningRun_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 526 AND AD_User_ID <> 100 AND IsActive = 'Y' ))\norg.postgresql.util.PSQLException: ERROR: column c_dunningrun.c_order_id does not exist\n  Position: 58, SQL=SELECT COUNT(*)  FROM C_DunningRun AS C_DunningRun WHERE (C_DunningRun.C_Order_ID=?) AND C_DunningRun.AD_Client_ID IN(0,11) AND C_DunningRun.AD_Org_ID IN(0,11,12,50000,50002,50001,50004,50006,50005,50007) AND (C_DunningRun.C_DunningRun_ID IS NULL OR C_DunningRun.C_DunningRun_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 526 AND AD_User_ID <> 100 AND IsActive = 'Y' ))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants