Hi All

I posted here Draft Document Report (Pending for Approval); it will helpful for new comers in SAP Business One.

SELECT T0.DocEntry as ‘Draft Number’, 

CASE T0.ObjType

WHEN 13 THEN ‘A/R Invoice’

WHEN 14 THEN ‘A/R Credit Memo’     

WHEN 15 THEN ‘Delivery’     

WHEN 16 THEN ‘Return’

WHEN 17 THEN ‘Sales Order’    

WHEN 18 THEN ‘A/P Invoice’     

WHEN 19 THEN ‘A/P Credit Memo’     

WHEN 20 THEN ‘Goods Receipt PO’     

WHEN 21 THEN ‘Goods Return’     

WHEN 24 THEN ‘Incoming Payment’     

WHEN 25 THEN ‘Deposit’     

WHEN 46 THEN ‘Outgoing Payment’     

WHEN 59 THEN ‘Goods Receipt’     

WHEN 60 THEN ‘Goods Issue’     

WHEN 67 THEN ‘Inventory Transfer’     

WHEN 204 THEN ‘A/P Down Payment Invoice’         

WHEN 22 THEN ‘Purchase Order’         

END ‘Document’,     

T0.CreateDate, T0.[DocDate], T0.[CardCode], T0.[CardName], T0.[NumAtCard], T0.[DocTotal]  

FROM ODRF T0  WHERE T0.[DocStatus] = ‘O’

Regards

SP Samy

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply