PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice

using one crystal report layout for ar dp request and ar dp invoice

In SAP Business One, standard marketing documents such as A/R Down Payment Request and A/R Down Payment Invoice are using the same table (ODPI and DPI1).

When you create a custom layout using Crystal Report Designer for those marketing documents, you can use only one layout with the additional query below to determine layout title in preview mode:

SELECT
     T0."DocNum",  
     T0."DocDate",
     T0."CardCode",
     T0."CardName",
     T0."Comments",
     T0."DocTotal",
     T1."ItemCode",
     T1."Dscription",
     T1."Quantity",
     T1."Price",
     T1."DiscPrcnt",
     T1."LineTotal",
     CASE T0."CreateTran" WHEN 'N' THEN 'A/R DOWN PAYMENT REQUEST' ELSE 'A/R DOWN PAYMENT INVOICE' END AS "LayoutTitle"
FROM {?Schema@}."ODPI" T0 JOIN {?Schema@}."DPI1" T1 ON T0."DocEntry"=T1."DocEntry" WHERE T0."DocEntry"={?DocKey@}
SAP Business One Tips - Using One Crystal Report Layout for A/R DP Request And A/R DP Invoice

SAP Business One Tips – How to Print Login User Name in SAP Business One Crystal Report

SAP Business One Tips – Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice

Now you can use this “LayoutTitle” field at the title section in your Crystal Report Layout for A/R DP Request and A/R DP Invoice simultaneously. SAP Business One Tips - Using One Crystal Report Layout for A/R DP Request And A/R DP Invoice

SAP Business One Tips – Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice

Example preview A/R DP Request And A/R DP Invoice only use one Crystal Report Layout with the additional query

SAP Business One Tips - Using One Crystal Report Layout for A/R DP Request And A/R DP Invoice

SAP Business One Tips – Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, , , , , ,