From B1UP 2018.10 (out start October 2018) B1 Print and Delivery will support SAP 9.3 Document types 'Return Request' and 'Goods Return Request'.
Besides the support in the Add-on, Boyum's out-of-the-box Crystal Reports will also support the new layouts. We can't, however, change any existing layouts you might have running with customers so this article will describe what steps you need to take to support the new document types in your existing layouts (given that they are based on the Boyum template)
Shared needed steps (Regardless if you run MSSQL or HANA)
- Open the Documents.rpt file
- Locate ObjectId@ Parameter field and double-click it to edit
- Add the two new document types to the Valid Values List and Press OK
- Add new formulas 'X_Is_AP_GoodsReturnRequest' and 'X_Is_AR_ReturnRequest'
-
- And have the be like this:
- (for copy/paste)
- {?ObjectId@}=234000032
- {?ObjectId@}=234000031
- Locate the Formula called 'Title' and add the following section:
- (for copy/paste - Add extra languages as you see fit)
- {?ObjectId@} = 234000031,
switch(
{@X_Language} = 'DK', 'Returneringsanmodning',
True, 'Return Request' //Default English
),
{?ObjectId@} = 234000032,
switch(
{@X_Language} = 'DK', 'Varereturneringsanmodning',
True, 'Good Return Request' //Default English
),
- {?ObjectId@} = 234000031,
- Locate the Formula called 'Title_Number' and add the following section
- (for copy/paste - Add extra languages as you see fit)
- {?ObjectId@} = 234000031,
switch(
{@X_Language} = 'DK', 'Anmodnings nr.',
True, 'Request No' //Default English
),
{?ObjectId@} = 234000032,
switch(
{@X_Language} = 'DK', 'Anmodnings nr.',
True, 'Request No' //Default English
),
- {?ObjectId@} = 234000031,
- Locate Formula 'Title_SalesEmployee' and replace it's content with below
-
switch(
{?ObjectId@} = 23 OR {?ObjectId@} = 17 OR {?ObjectId@} = 15 OR {?ObjectId@} = 16 OR {?ObjectId@} = 203 OR {?ObjectId@} = 13 OR {?ObjectId@} = 14 OR {?ObjectId@} = 234000031,
switch(
{@X_Language} = 'DK', 'Salgsmedarbejder',
{@X_Language} = 'NO', 'Selger',
{@X_Language} = 'DE', 'Verkaufsmitarbeiter',
{@X_Language} = 'ES', 'Vendedor',
{@X_Language} = 'FI', 'Myyjä',
{@X_Language} = 'NL', 'Verkoper',
{@X_Language} = 'FR', 'Vendeur',
True, 'Salesemployee' //Default English
),{?ObjectId@} = 22 OR {?ObjectId@} = 20 OR {?ObjectId@} = 21 OR {?ObjectId@} = 204 OR {?ObjectId@} = 18 OR {?ObjectId@} = 19 OR {?ObjectId@} = 540000006 OR {?ObjectId@} = 234000032,
switch(
{@X_Language} = 'DK', 'Indkøber',
{@X_Language} = 'NO', 'Innkjøper',
{@X_Language} = 'DE', 'Einkäufer',
{@X_Language} = 'ES', 'Comprador',
{@X_Language} = 'FI', 'Ostaja',
{@X_Language} = 'NL', 'Afnemer',
{@X_Language} = 'FR', 'Acheteur',
True, 'Buyer' //Default English
),
TRUE, 'NOT SUPPORTED DOCUMENT TYPE'
)
-
- Locate Formula 'Title_DueDate' and add the following section
- (for copy/paste - Add extra languages as you see fit)
- {@X_Is_AP_GoodsReturnRequest} OR {@X_Is_AR_ReturnRequest},
switch(
{@X_Language} = 'DK', 'Returdato',
True, 'Return Date'
),
- {@X_Is_AP_GoodsReturnRequest} OR {@X_Is_AR_ReturnRequest},
Extra steps you need to take if you run MSSQL (There are no extra steps to take on HANA)
- Go to the Database Expert and edit the Header Command
- Add the following section highlighted in red and press OK
- DECLARE @table AS VARCHAR(20)
SELECT @table = CASE @objectId WHEN '23' THEN 'OQUT' WHEN '17' THEN 'ORDR' WHEN '16' THEN 'ORDN' WHEN '15' THEN 'ODLN' WHEN '13' THEN 'OINV' WHEN '14' THEN 'ORIN' WHEN '203' THEN 'ODPI' WHEN '22' THEN 'OPOR' WHEN '21' THEN 'ORPD' WHEN '20' THEN 'OPDN' WHEN '18' THEN 'OPCH' WHEN '19' THEN 'ORPC' WHEN '204' THEN 'ODPO' WHEN '540000006' THEN 'OPQT' WHEN '1470000113' THEN 'OPRQ'
WHEN '234000031' THEN 'ORRR' WHEN '234000032' THEN 'OPRR' END
/* DECLARATIONS - END */
- DECLARE @table AS VARCHAR(20)
- Now edit the Lines command
- Add the following sections highlighted in red and press OK
- DECLARE @tableHeader AS NVARCHAR(20)
DECLARE @tableLines AS NVARCHAR(20)
DECLARE @tableSpecialLines AS NVARCHAR(20)
SELECT @tableHeader = CASE @objectId WHEN '23' THEN 'OQUT' WHEN '17' THEN 'ORDR' WHEN '16' THEN 'ORDN' WHEN '15' THEN 'ODLN' WHEN '13' THEN 'OINV' WHEN '14' THEN 'ORIN' WHEN '203' THEN 'ODPI' WHEN '22' THEN 'OPOR' WHEN '21' THEN 'ORPD' WHEN '20' THEN 'OPDN' WHEN '18' THEN 'OPCH' WHEN '19' THEN 'ORPC' WHEN '204' THEN 'ODPO' WHEN '540000006' THEN 'OPQT' WHEN '1470000113' THEN 'OPRQ' WHEN '234000031' THEN 'ORRR' WHEN '234000032' THEN 'OPRR' END
SELECT @tableLines = CASE @objectId WHEN '23' THEN 'QUT1' WHEN '17' THEN 'RDR1' WHEN '16' THEN 'RDN1' WHEN '15' THEN 'DLN1' WHEN '13' THEN 'INV1' WHEN '14' THEN 'RIN1' WHEN '203' THEN 'DPI1' WHEN '22' THEN 'POR1' WHEN '21' THEN 'RPD1' WHEN '20' THEN 'PDN1' WHEN '18' THEN 'PCH1' WHEN '19' THEN 'RPC1' WHEN '204' THEN 'DPO1' WHEN '540000006' THEN 'PQT1' WHEN '1470000113' THEN 'PRQ1' WHEN '234000031' THEN 'RRR1' WHEN '234000032' THEN 'PRR1' END
SELECT @tableSpecialLines = CASE @objectId WHEN '23' THEN 'QUT10' WHEN '17' THEN 'RDR10' WHEN '16' THEN 'RDN10' WHEN '15' THEN 'DLN10' WHEN '13' THEN 'INV10' WHEN '14' THEN 'RIN10' WHEN '203' THEN 'DPI10' WHEN '22' THEN 'POR10' WHEN '21' THEN 'RPD10' WHEN '20' THEN 'PDN10' WHEN '18' THEN 'PCH10' WHEN '19' THEN 'RPC10' WHEN '204' THEN 'DPO10' WHEN '540000006' THEN 'PQT10' WHEN '1470000113' THEN 'PRQ10' WHEN '234000031' THEN 'RRR10' WHEN '234000032' THEN 'PRR10' END
/* DECLARATIONS - END */
- DECLARE @tableHeader AS NVARCHAR(20)
You now have a modified Crystal Report that supports the new document types.
Comments
0 comments
Please sign in to leave a comment.