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.

Sign up for GitHub

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

Jump to bottom

Cannot invoice disposal's invoice candidates #582

Closed
teosarca opened this issue Sep 12, 2017 · 2 comments
Closed

Cannot invoice disposal's invoice candidates #582

teosarca opened this issue Sep 12, 2017 · 2 comments
Labels
branch:master branch:release priority:high type:bug

Comments

@teosarca
Copy link
Member

teosarca commented Sep 12, 2017 •
edited
Loading

Is this a bug or feature request?

bug

What is the current behavior?

Which are the steps to reproduce?

  • browse internal use inventory documents: https://w101.metasfresh.com:8443/window/341
  • pick a disposal
  • zoom to related invoice candidates
  • select them and call "generate invoices"
  • instead of enqueuing those invoice candidates you will get an error like:
Error: org.postgresql.util.PSQLException: ERROR: missing FROM-clause...
Server error
org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "master" Position: 453 SQL: INSERT INTO T_SELECTION(AD_PINSTANCE_ID, T_SELECTION_ID) SELECT 18754126, C_Invoice_Candidate_ID FROM C_Invoice_Candidate WHERE ((((/ MQuery-f8f58acc-4101-4b5a-940f-eb0aa7957efc /(( exists ( select 1 from M_Inventory i join M_InventoryLine il on i.M_Inventory_ID = il.M_Inventory_ID join C_Invoice_Candidate ic on ic.AD_Table_ID = get_table_ID('M_InventoryLine') and ic.Record_ID = il.M_InventoryLine_ID where ic.C_Invoice_Candidate_ID = master.C_Invoice_Candidate_ID and i.M_Inventory_ID = 1000099 )))) AND (exists (select 1 from T_WEBUI_ViewSelection sel where UUID='540092-d93f548066f0415f89a44d18da6e5634' and sel.Record_ID=C_Invoice_Candidate.C_Invoice_Candidate_ID) AND C_Invoice_Candidate.C_Invoice_Candidate_ID IN (4763425,4763424))) AND (AD_Client_ID=1000000) AND (1=1)) AND (IsActive=?) AND (AD_Client_ID=?)) AND / security-client / C_Invoice_Candidate.AD_Client_ID IN (0,1000000) / security-record / AND C_Invoice_Candidate.C_Invoice_Candidate_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 540270 AND AD_User_ID <> 2188223 AND IsActive = 'Y' ) SQL params: [true, 1000000]

What is the expected or desired behavior?

shall work ;)
@teosarca teosarca changed the title Cannot invoice disposal Cannot invoice disposal's invoice candidates Sep 12, 2017
@teosarca teosarca self-assigned this Sep 12, 2017
teosarca added a commit that referenced this issue Sep 12, 2017
@teosarca
introduce SqlOptions: UseTableAlias
14e9570 
#582
teosarca added a commit that referenced this issue Sep 12, 2017
@teosarca
fix AD_PInstance.WhereClause
10c0e4a 
it shall be built using fully qualified table name instead of table
alias

#582
metas-ts pushed a commit that referenced this issue Sep 12, 2017
@teosarca @metas-ts
introduce SqlOptions: UseTableAlias
9ce9ca7 
#582
(cherry picked from commit 14e9570)
metas-ts pushed a commit that referenced this issue Sep 12, 2017
@teosarca @metas-ts
fix AD_PInstance.WhereClause
5a7d019 
it shall be built using fully qualified table name instead of table
alias

#582
(cherry picked from commit 10c0e4a)
@metas-ts
Copy link
Member

cherry-picked to 2017-09-12

@metas-lc metas-lc self-assigned this Sep 12, 2017
@metas-lc
Copy link

IT

  1. created disposal with 1 line (bestellung - receipt - disposal), -> reference docus invoice candidates -> create invoice => invoice was created ok, no errors
  2. repeated the same case with disposal with multiple lines => invoice was created ok, no errors

metas-ts added a commit to metasfresh/metasfresh that referenced this issue Sep 15, 2017
@metas-ts
Update ReleaseNotes.md
88b86e3 
[#2218](#2218) User would
like to import default values for contact and address
[#2245](#2445) Support
quantity in flatrate term import
[#2361](#2361) Invoice
Candidates Action Approval for Invoicing
[#2387](#2387)
Autocomplete for zip / postal code and city
[#2298](#2298) Introduce
source-HU to fine-Picking
[#2247](#2474) Extend
Partner Import with ad_language
[#585](metasfresh/metasfresh-webui-api-legacy#585)
Lookup validation rule shall support @CtxName/Default@ annotation
[#2459](#2459) shipto and
billto contact / user
[#2436](#2436) Use
default values for IsShipTo and isBillTo when importing bpartner
[#2457](#2457) Duplicate
locations on partner import when multiple contacts
[#2463](#2463) Extend
Partner Import to support contact flags
[#142](metasfresh/metasfresh-webui-api-legacy#142)
Provide v11 / CAMT 54 File Import
[#2429](#2429) hide qty
TU when HU name is empty
[#2423](#2423) fix
jaspers for vendor return with quality issue
[#2430](#2430) Invoice
candidate close is retrieving the invoice candidates out of transaction
[#547](metasfresh/metasfresh-webui-api-legacy#547)
Provide mass export of Data to Excel
[#570](metasfresh/metasfresh-webui-api-legacy#570)
clicking print on non-document window shows error page
[#2431](#2431) Product
Filter in Handling Unit Editor
[#2413](#2413) Make
request status a search field in request window
[metasfresh/metasfresh-parent-legacy#14](metasfresh/metasfresh-parent-legacy#14)
Look for a way of not having the "placeholder" on local builds
[#178](metasfresh/metasfresh-webui-api-legacy#178)
Have Letter Feature in Sales Order Window
[#2401](#2401) vendor
return with quality discount
[#2434](#2434) Make field
ad_user_incharge_id from C_Flatrate_Term optional
[#2397](#2397) Import and
Store Contract meta-data e.g. startdate on flatrate
[#2412](#2412)
OrderCheckout Jaspers display empty C_BPartner_Product.ProductName
[#582](metasfresh/metasfresh-webui-api-legacy#582)
Cannot invoice disposal's invoice candidates
[#1060](metasfresh/metasfresh-webui-frontend-legacy#1060)
Locale viewing and editing in User Interface
[#583](metasfresh/metasfresh-webui-api-legacy#583)
Provide the document's standard actions
[#581](metasfresh/metasfresh-webui-api-legacy#581)
API to provide user session's locale

me-45
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
branch:master branch:release priority:high type:bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@teosarca @metas-ts @metas-lc