Skip to Content

How to design CR layout of draft document in SAP B1 9.2?.

Hi all,

I have a problem in CR layout of sales order draft document.

Actually I know how I can use query in creation of new CR layout and then set parameter DocKey@ to any document of SAP B1, but now I have a case of draft document where I have UDT called @MMS which has some information I want it to be displayed to my layout, so I created a simple query

SELECT T0.DocEntry, T0.[CardCode], T0.[CardName], T1.[U_dependstommiNo], T1.[U_depFname], T1.[U_depLname], T2.[Dscription] FROM [dbo].[ODRF]  T0 inner join [dbo].[@MMS]  T1 on T0.[CardCode]=T1.[Code] INNER JOIN DRF1 T2 ON T0.[DocEntry] = T2.[DocEntry]

The above query uses tables one for draft header ODRF and another for draft rows DRF1,

after doing design of layout I set parameter like this

{Command.DocEntry} = {?DocKey@}

if I finish my layout and then try to print preview it brings empty page.

What I have seen is if document is still draft it is not saved in ORDR.

My query works fine and print preview in crystal report works, the problem is in SAP client.

What can I do in order to display my new CR layout of sales order draft document?

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Mar 10, 2017 at 12:34 AM

    Hi Rurangwa,

    If you want to support draft documents, you can not use Query as the base of your data source.
    Use the base tables instead, if this draft is for Order then add the table ORDR into the CR.
    On printing, SBO will automatically detect you are printing a DRAFT and on runtime will change all the DOCUMENT tables (ORDR, RDR1, RDR2, etc) to Draft tables.

    + SBO will add a watermark 'DRAFT' on your report.

    There isn't a need to create a specific layout for draft documents.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi Edy,

      I am having same issue while View Draft Delivery, sometimes it works layout brings up info and sometimes it shows blank.

      Please suggest me what should i do as my derlivery document have all it's tables. so should i add ODRF and DRF1 in it and how do i link these tables with ODLN/DLN1 ?

      I would appreciate your guidance. Thanks