xTuple.com xTupleU Blog & News Customer Support

Where is the table in the Check Details

The following query in the Check report where is the checkDetailFormatted coming from. I checked in the database including the api schema and it is not there. I want to modify the checkdata_checknumber, to not include "Invoice#" string


SELECT checkdata_page,
  FROM checkDetailFormatted(<? value("checkhead_id") ?>, 12);

It is a function

It is a function, public.checkdetailformatted(). If you want to change this I suggest copying it to a new name (in its own schema, so like custom.checkdetailcustom() or something), and then modify the check report definition to use your custom function. 

Got it! I see that function. Will create a new schema and modify. Thanks for the help