T24: Customer accounts Grand total enquiry

[NrK]

Hello everyone,

plz help me, i want to create an enquiry which will show the grand
total (total of all accounts of the customer) of all the accounts of
any customer. Kindly guide me how can i do this?

I am waiting for reply from your guys.

Thanks!

[raphael olapade]

hi,

can u be specific on ur request?

is total no of accts of a particular customer? or grand total of
accounts of customers in an account table?

pls clarify!!!!!!!!!

rafael

2008/9/8 NrK <naum...@gmail.com>:

--
Rafael

[Santosh]

You need to do it through NOFILE enquiry. Select the file CUSTOMER.ACCOUNT file. CUSTOMER.ACCOUNT id is customer hence you can read all the accounts for each customer and do the calculation and populate the nofile array and parse it in the enquiry.

--
Mobile: 973-39406098

[John Watson]

No need for a nofile - you can base a normal EMQUIRY on the ACCOUNT
table and use the CUSTOMER.MNEMONIC as the selection field for the
required customer number.

This will instantly return all accounts for the given customer (via
the CUSTOMER.ACCOUNT table)

Then use the TOTAL function in the enquiry to give totals.

Should all be in the basic training for ENQUIRY.