Newest Content

Making LD (doc00008) group by Project

Thu, 17 May 2012 05:35:40 +0000

Hello,

Im trying to group item rows in a A/R Invoce bij project. someware i have to insert a advanced groupband to do the trick or can i also adjust the group settings for theRrowGroupAdvancedGroupBand.

There must be someone who already altert this doc!

please Help!

Lieferant in Stückliste

Wed, 16 May 2012 17:19:42 +0000

Hallo zusammen,

ich wollt eheute mal kurz einige Felder der Stücklisten Printdefinition (PRD07004) hinzufügen ...
Mit den UDFs der Artikelstammdaten haut das auch wunderbar hin.

Nun wollte ich noch den bevorzugten Lieferanten andrucken was aber nicht wirklich funktioniert.

Wenn ich eine Query einbaue (dingenskirchen = LD.querydata(SQL)) kommt bei mir "Name 'LD' is not declared".

Hat jemand einen Tip für mich

Grüße

Spaxa

LayoutDefinition: Printer: Num. of Copies parameter

Tue, 15 May 2012 13:27:46 +0000

Deal all,
in my customer installation, I found a possible bug.

I need to configure drawers for a specific printer.
First page on drawer 2 and other pages on drawer 1.

But if I set 1 in the "number of copies" column in the layoutdefinition, all the pages are printed from drawer 1.
Settings are not considered.

If I left this field empty, then the settings are followed correctly.

I also see that if the num. of copies parameter is set, all the pages are printed bad (all the text is shifted of some millimeters).

Do you know this kind of issue?

Best regards

Emanuele

Automatische Mail mit Excel-Anhang

Tue, 15 May 2012 09:23:33 +0000

Hallo,
einfache Aufgabe - schwierige Lösung?
Aufgabenstellung: Es gibt eine Abfrage, die wöchentlich per Mail als Excel automatisch versendet werden soll.

Lösung? Alarm / Batchprint? Nur wie bringe ich dem Batchprint eine Excel-Ausgabe bei?

Vielen Dank für jeden Tipp!
Andreas

Seitenumbruch beim letzten Datensatz

Tue, 15 May 2012 09:20:22 +0000

Hallo Zusammen,

ich habe eine Abrage erstellt für die ich jetzt im Coresuite Designer ein Layout erstelle. Ich habe folgendes Problem: Ich möchte gerne das, wenn der Letzte Datensatz aus der Abfrage erreicht ist, ein Seitenumbruch statt findet. Leider habe ich keine ID-Spalte welche ich hochzählen könnte. Kennt jemand eine Methode?

Vielen Dank.

Info - SAP B1 und Coresuite sind auf dem neusten Stand.

Textzeilen

Mon, 14 May 2012 19:06:52 +0000

Hallo Zusammen,

ich bräuchte wieder einmal ein bischen Hilfe

Ich habe in meiner SAP-RE Textzeilen als Überschrift für die kommenden Positionen.

Das sieht dann ungefähr so aus:

Abrechungszeitraum1/12 bis 2/12
Pos 1 Artikel 1 ....
Pos 2 Artikel 2 ....

Abrechungszeitraum 3/12 bis 4/12
Pos 1 Artikel 1 ....
Pos 2 Artikel 2 ....

Jetzt habe ich im Corsuite Designer das Problem. Das ich entweder DocumentRowSubTotal.LineText habe, dann bringt er mir aber ja immer nachfolgenden den Positionen die neue Überschrift. Sprich Überschrift 1 würde fehlen.

Dann habe ich es mit FirstTextDetails.LineText probiert, da kommt bei mir für jede Position der 1. Text.

Ich habe schon die Suche benutzt Und tatsächlich bin ich auf fündig geworden. Allerdings ging es immer darum das DataBand zu verschieben. Aber bei mir sollte es richtig sein. Bzw. egal wo ich es hinschiebe, bzw. auch wo ich den Text hinschiebe irgendwie verändert sich nichts an der Situation

Hat jemand eine Idee was ich falsch mache?!

Danke Melanie

Übernahme der Bankdaten aus dem Shop ins SAP

Mon, 14 May 2012 13:59:10 +0000

Hallo,

habt Ihr bei einem Kunden schon mal die Bankdaten mit übernommen ins SAP ??

Gruß

Tomas

Printing dunnings after running the wizard

Fri, 11 May 2012 12:42:55 +0000

Dear all,

Since we have updated our database we have a problem with the dunning wizard.

during the update we had the sap warning 1645439. After running the query included in the sap call we got the message that the table "@SWA_LD_PARAM" Field : u_key value "SWA_LD_Select" was to big corresponding the table info in sap.

we have created a test db and there we did the update but the result is that when we run the dunning wizard and we select option 4 'print and close' the wizard jumps to option 3 closes and doesn't print anything.

does somebody knows how to solve this problem ?

kind regards,

Kurt

PDF Export - Formate

Fri, 11 May 2012 10:48:16 +0000

Hallo Liebe Coresuite Gemeinde,

ich habe folgenden Anwendungsfall bei einem Kunden:

Export von Ausgangsrechnungen als PDF in ein Verzeichnis. Diese PDF Dateien aus dem Verzeichnis werden dann von einem Signierungsdienst abgehohlt und mit einer digitalen Signatur versehen.

Der Signierungsdienst "Prilos - PriSign V2.3.1" kann nur PDF/A Dokumente lesen und verarbeiten.

Die PDF-Dokumente die von Coresuite erzeugt werden sind in der neuesten Designer-Version 3.40.xxx PDF - V1.6 Dokumente.

Meine Frage: Gibt es die Möglichkeit über Coresuite PDF/A Dokumente zu erzeugen?

Viele Grüße

Ronald Sagschevski

Performance problem after 8.81 migration

Fri, 11 May 2012 07:48:09 +0000

Hi ,

we migrate a customer from B1 2007 to B1 8.81 . And now , all doc print are very slow ( about 1 minute for a order with one line ) .
this customer have a lot of serial numbers in this database

we investigate and saw that the following query run in 1s in B1 2007 and 30s in B1 8.81 :

 
	/* If AddMode (Draft) and ODSR use new Feature else  */
	IF ('N'='Y' AND EXISTS
	(SELECT name FROM dbo.sysobjects WHERE name = 'ODSR' AND xtype = 'U'))
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM ODSR T0 INNER JOIN ODRF T1 ON T0.BaseEntry = T1.DocEntry
	INNER JOIN DRF1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	ELSE
	BEGIN
	/* Get Serialnumbers for Purchase Documents depending on ObjectId */
	IF ('17'='20')
	/* Goods Receipt PO */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OPDN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN PDN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='18')
	/* AP Invoice */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OPCH T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN PCH1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry = 10394
	UNION ALL SELECT T2.DocEntry,T4.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OPDN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN PDN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN PCH1 T4 ON T2.DocEntry = T4.BaseEntry AND T2.LineNum = T4.BaseLine AND T4.BaseType = 20
	/*T2 ON T0.BaseLinNum = T2.BaseLine AND T0.BaseEntry=T2.BaseEntry*/
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T4.DocEntry = 10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='21')
	/* Goods Return */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORPD T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RPD1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry = 10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='19')
	/* AP CREDIT NOTE */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORPC T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RPC1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry = 10394
	UNION ALL SELECT T2.DocEntry,T4.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORPD T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RPD1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN RPC1 T4 ON T2.DocEntry = T4.BaseEntry AND T2.LineNum = T4.BaseLine AND T4.BaseType = 21
	/*T2 ON T0.BaseLinNum = T2.BaseLine AND T0.BaseEntry=T2.BaseEntry*/
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T4.DocEntry = 10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	/* Get Serialnumbers for Sales Documents depending on ObjectId */
	IF ('17'='15')
	/* Delivery */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ODLN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN DLN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='13')
	/* AR INVOICE */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OINV T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN INV1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	UNION ALL SELECT T2.DocEntry,T4.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ODLN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN DLN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN INV1 T4 ON T2.DocEntry = T4.BaseEntry AND T2.LineNum = T4.BaseLine AND T4.BaseType = 15
	/*T2 ON T0.BaseLinNum = T2.BaseLine AND T0.BaseEntry=T2.BaseEntry*/
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T4.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='16')
	/* Return */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORDN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RDN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='14')
	/* AR CREDIT NOTE */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORIN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RIN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	UNION ALL SELECT T2.DocEntry,T4.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ORDN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN RDN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN RIN1 T4 ON T2.DocEntry = T4.BaseEntry AND T2.LineNum = T4.BaseLine AND T4.BaseType = 16
	/*T2 ON T0.BaseLinNum = T2.BaseLine AND T0.BaseEntry=T2.BaseEntry*/
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T4.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='67')
	/* Stock Transaction */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OWTR T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN WTR1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='59')
	/* GoodsEntry */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OIGN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN IGN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	IF ('17'='60')
	/* Goods Exit */
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN OIGE T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN IGE1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=10394
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END
	END
	/* We need at least 1 empty Row */
	IF ( '17' NOT IN ('20','18','21','19','15','13','16','14','67','59','60') )
	BEGIN
	SELECT T2.DocEntry,T2.LineNum,T0.Direction,T0.WhsCode,T3.*
	FROM SRI1 T0 INNER JOIN ODLN T1 ON T0.BaseEntry = T1.DocEntry AND T0.BaseType=T1.ObjType
	INNER JOIN DLN1 T2 ON T0.BaseLinNum = T2.LineNum AND T0.BaseEntry=T2.DocEntry
	INNER JOIN OSRI T3 ON T0.ItemCode = T3.ItemCode AND T0.SysSerial = T3.SysSerial AND T0.WhsCode = T3.WhsCode
	WHERE T1.DocEntry=0
	ORDER BY T3.SuppSerial, T3.IntrSerial, T3.SysSerial
	END

the difference beetwen B1 2007 and B1 8.81 is SRI1 is now a view , and not a table .
it seems that SQLServer run the query , even there is a IF a the beginning of the query .

Does this problem came from a setup problem of our database ?

thanks for your help

regards

laurent