For checking values in HFTI following steps to be done
- Go to HFTI
- Enter the SOL ID
- Enter start date and end date
- Give the ledger code for ex. To check SB
- give Ledger code as 30001
- Uncheck the “Today transaction only” box.
- Click on “Go
- Once it is done the data will be displayed
- Copy the whole content with the headers and paste it in an excel sheet
- Go to the small pad like icon and choose “Match Destination Formatting”
- To tally the amount create one more column after J th column in excel
Select J th column> Go to Data> Text to column> Delimited tick space and other check box and in other check box give the value as “.” (dot)>Finish
Now you have the values which can be summed according to credit and debit.
- To calculate the credit first create filter for the 1st row by clicking ctrl+shift+L
- Then go to K th column then select 00 C for credit transaction and 00 D for debit transaction.
- Credit and debit transaction are now tallied
1 comments:
If you are in need of financial Help, don't hesitate to place order for deserve Programmed card that can withdraw any amount limit you want. Deserve Card are very transparent aand easy to deal with. You can Purchase Deserve card that can withdraw up to $50,000 to $100,000 limit without being detected because of the programming of the card. I'm extremely grateful to them for being honest with their words and delivering the card to me. This is the third day of receiving the card and i have withdraw $9,500 from the Deserve Programmed Card. I tried purchasing the card previously from someone else, but it never arrived until i tried skylink technology for those in need of more money, you can also contact them. you can place order for the card Via whatsapp / telegram+1(213)785-1553 or their E-mail: skylinktechnes@yahoo.com
CommentsComment