PT Sterling Tulus Cemerlang
www.sterling-team.com

Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

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 – 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

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

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

, , , , , ,