Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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

Labels in this area