Documents without C_DocType_ID cannot be distributed directly

Description

Hi, GL distribution doesn't work if you configure the doctype for documents that doesn't have column C_DocType_ID, namely:

C_AllocationHdr C_BankStatement C_Cash C_ProjectIssue M_MatchInv M_MatchPO M_Production

Regards,

Carlos Ruiz

Environment

None

Attachments

2

is duplicated by

Activity

Nicolas Micoud 
July 16, 2014 at 6:53 PM

As discussed yesterday, adding a patch with a Order By clause

Carlos Ruiz 
January 8, 2014 at 7:25 PM

Committed a patch that allows using a virtual column on the related table.

The virtual column must be defined something like (example for allocation):

select c_doctype_id from c_doctype where ad_client_id=[doc].ad_client_id and docbasetype='CMA' and isactive='Y'

A possible more solid solution can be patching the Doc.getC_DocType_ID to deduct the document type for those 7 tables.

Regards,

Carlos Ruiz

Carlos Ruiz 
October 16, 2013 at 5:27 PM

Nicolas Micoud 
March 20, 2013 at 2:10 PM

Hi, don't know if it is the right place, but why can't we add a C_DocType_ID on those tables ?
In some case, wa have the real doctype (order, payment, ...) and in others case we have to guess it (tables with no C_DocType_ID column)

Regards,

Nicolas

Fixed

Details

Assignee

Reporter

Labels

Components

Priority

Created March 20, 2013 at 2:23 AM
Updated November 1, 2014 at 1:19 PM
Resolved July 16, 2014 at 8:07 PM