DataDefs

Bart De Cattelle

Dear all,

We have created a select grid where the customer can see all invoices for a certain month.
From this grid the customer can select all the invoices that he wants to print.
This is working fine, but we are not able to use the same layout as we use for printing one invoice because on the layout definition i can not choose "Document" under UseData.
This is because the formtype is our own created form.
Is there a way we can use the queries of Document without having to link them one by one it the layout definition?

Philipp Knecht

Hi Bart

Just use an additional Column named "FormType" in your Select grid.
Example:
Select '133' As FormType, DocEntry, ....

Then you need to define this Parameter (FormType).

After that coresuite designer will just use the invoice as printed from this formtype

hth

Bart De Cattelle

Dear Philipp,

Thank you very much, I have changed my query so the '133' as FormType is now added as a column.

But where do i need to define this Parameter?
Is is under SWA_LD_FormType or under SWA_LD_Param or under the LayoutDefinition or somewhere else?

Kind regards
Bart

Philipp Knecht

Hi Bart

Just define it as regular Parameter in the SWA_LD_Param Form.

In the documentation there is a section about "SelectGrid". You also may look at the Parameters which have "grdSelect" in the matrixId Column in the Parameterform as an example

hth

Bart De Cattelle

Dear Philipp,

Thank you again,

I have created the Parameter 'FormType' looking at the Parameters which have grdSelect in the MatrixId Column, but when i select an invoice from my selectgrid and click on print preview i receive two times the following messagebox : "Invalid object name 'O@@RDR'.
Any idea what i am doing wrong?

Kind regards
Bart

Philipp Knecht

Hi Bart

When you select the invoice and then click on the design button. Does the correct prtintdefinition appear? (the same as you would receive when clicking the design button from the invoice form)

hth

Bart De Cattelle

Dear Philipp,

yes, the print definition is the same as if you click the design button from the invoice form.

kind regards
Bart

Philipp Knecht

Hi Bart

Now i have to guess but do you have an UseData set in the SelectGrid Definition itself?
If yes remove it.

hth

Bart De Cattelle

Dear Philipp,

I solved it with your help.
I have created a new printdefinition for the invoice formtype and after i added a printer for the FormType of our selectgrid at the printer tab on layout definition level, everything was solved.
Thank you very much for your help.

Can we somewhere find some more information about free text (beside standard documentation) ?

Kind regards
Bart

Philipp Knecht

Hi Bart

It should use the printersettings from the default invoice layout. This is a bug which is resolved but not available yet.

hth

Bart De Cattelle

Dear Philipp,

Do you have any idea when it will be available?

Kind regards
Bart

Philipp Knecht

Hi Bart

If everything works out we will deploy a new Beta next week.

hth

Bart De Cattelle

Dear Philipp,

When we print the invoices from the select grid, the status of the document does not get adjusted, (the set print flag when printing in the config section is set to true).
So when we print an invoice from the invoice form, the stauts of the invoice changes from open to open-printed, but when we print invoices from our select grid, the status of the printed invoices remains open.
So we can not check if a document has been printed or not.

Is this normal?

Kind regards
Bart

Philipp Knecht

Hi Bart

Thanks for reporting this bug. It's fixed in current version (alpha)
We need some components from the layouter supplier thats why the new beta is late.

hth

Bart De Cattelle

No problem Philipp, do you know when the new version will be available for our customers?
One week, one month, ... ?

Kind regards
Bart

Philipp Knecht

Hi Bart

As soon as the new version from our supplier passes all our testcases we will deploy it.
We hope this will be the case next week.

hth