Thanks Ian!
I tried joining data on my table however my problem is the OCRD and CRD1 (details of customer or vendor).
Every time I tried to insert the content the zero values were gone though it was connected in left outer join.
How can In change my result column into a formula? Any...
When I generate the report based on my parameter those purchased transaction with zero amount in details for example is
Item 1 = 1,000
Item 2 = 0.00
Item 3 = 0.00
The Item 2 & 3 is not displaying in my details. im having a hard time now.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.