PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – 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"

This content is restricted to site members. If you are an existing user, please log in. New users may register below.

Register now for unlimited access to

Existing Users Log In
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: or call +6221-5806336 or wa +6287786555055

, , , , , ,