Skip to Content
0

cancelled invoices entry hide from Crystal General Ledger Report

Nov 23, 2016 at 06:43 AM

41

avatar image

Dear Experts,

I am making A General Ledger report based on OJDT,JDT1, where Cancelled Invoices also showing in Report, I want to remove those cancelled entries from report. Upon cancelling any Invoice, a new invoice with reverse amount is added in system, I cant find any differences between base and target document in OJDT,JDT1 tables except for negetive amount.

Need your expert advise to acheive this.

Regards,

Ravi.

10 |10000 characters needed characters left characters exceeded

To make sure I understood, you have something like:

Invoice Amount

1001 $100

1002 $500

1003 -$500

1004 $300

and you want to eliminate Invoices 1002 and 1003. Correct?

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi Jha Nov 30, 2016 at 05:29 AM
0

Hi Vitaly,

Sorry for the late reply.

Yes correct.

Regards,

Ravi.

Share
10 |10000 characters needed characters left characters exceeded