cancel
Showing results for 
Search instead for 
Did you mean: 

Sales Ledger Control

Former Member
0 Kudos

Does anyone know how, in one report, I can get the follwing info from the sales A/R ledger:

1. Opening debtor balance

2. Net sales + VAT

3. total receipts

4. Therfore the closing debtor balance

Any help would be appretiated.

Accepted Solutions (0)

Answers (2)

Answers (2)

JesperB1
Advisor
Advisor
0 Kudos

HI Martin,

In version 2007 try with user query on jdt1.

Jesper

Former Member
0 Kudos

Do you know the syntax for the query. I'm not sure what JD1 is?

Former Member
0 Kudos

I am afraid you have to create your own report by a query or Crystal Report.

Thank,

Gordon

Former Member
0 Kudos

Would you have any idea what the syntax for the query is so I can copy and paste it?