Comments by Member 12654313

Member 12654313 27-Feb-20 7:18am View

issue resolved
i fix it by doing changes in below code

select top 1 dated,openingbalance
from ledgerbalance
where dated=({?dateb}) and accounttitle='{?tran}'
order by ledgeridnew desc

date must be ({?dateb}) in this format instead of {?dateb} and tran has to be '{?tran}'

Member 12654313 27-Feb-20 5:31am View

alright i will check it

Member 12654313 27-Feb-20 5:00am View

really sorry to ask again . do i have to use it in parameter's format part?like right click the parameter and in formula? or in vb.net

Member 12654313 27-Feb-20 4:38am View

ok so can i write query like below in crystal reports?

select Top 1 openingbalance,dated
FROM ledgerbalance
where accounttitle='{?tran} and dated={?dateb}
order by ledgeridnew asc, dated desc;

DateTime dateb = new DateTime(2020, 2, 1);
myReport.SetParameterValue("dateb", dateb.ToString("yyyy-MM-dd"));

Member 12654313 27-Feb-20 4:12am View

hi maciej.
how r u
thank you for your reply. actually i tried with {?tran} and it working fine but when i tried with date, it give error. in database date format is 2020-02-01 and in crystal reports its 01-02-2020 ... how can i fix it ?

Member 12654313 27-Feb-20 2:21am View

i remove it and tried but still same issue

Member 12654313 25-Feb-20 8:49am View

actually tran and dateb im using to get data from ledger database ...tran is transection id and date is entry date. now if i use only
where accounttitle='{tran}' then it working fine but if i use
where accounttitle='{tran}' and dated='{dateb}'
then it give error

Member 12654313 25-Feb-20 8:34am View

parameters are correct
one is tran and other is dateb

Member 12654313 22-Feb-20 5:32am View

Hi Gerry

Thank you for your comment and i will follow your instruction but i have a question

i tried one thing. i made one ledger table in sql.

now in this table what i am doing is im saving the closing balance after day close and im doing it manually and same closing balance im saving closing balance as opening for next day. is it possible i do it by coding in vb.net after every entry ?

now see in 1st picture . im saving the balance of cash manually after day close or u can say after every entry in cash payment module. is it possible that i can do it from vb.net ?and in 2nd picture the balance is opening and after entries closing came and that will be the opening of next day .

link for picture

https://i.stack.imgur.com/fI6lO.png
https://i.stack.imgur.com/dQi6P.png

Member 12654313 10-Jul-19 3:38am View

my friend i can understand this but trust me i tried many things but fail thats why i thought to ask here any logic or any help let me explain more

my friend i have 5 accounting modules

cash payments

cash receipts

bank payments and receipts

journal entries

now all these modules are based on chart of accounts . in cash payment mostly cash in hand i credit and the account to whom we pay is debit .

now in chart of accounts cash in hand type or nature remains DR but other account to whom we pay cash is credit and if we pay him and his account type is DR in chart of account, then his account must show CR after we do entry in cash payment. and same like if we do entry in cash receipt, then his account will be DR if in chart of account its CR, becz we are receiving payment from him.

now i am not able to change the type of status from DR to CR or CR to DR after every transactions .

Member 12654313 12-Jun-19 7:47am View

not working :(

Member 12654313 12-Jun-19 7:17am View

suppose my column of TYPE is 7 and OPENING BALANCE is 6 so how can i do it with your code ?

Member 12654313 12-Jun-19 4:13am View

thank you for your code i was looking for vb.net code . i change your code to .net
Dim cell = Me.COADataGridView(e.ColumnIndex, e.RowIndex)
Dim n As Single

If Single.TryParse(cell.Value.ToString(), n) Then

If n < 0 Then
cell.Value += " CR"
Else
cell.Value += " DB"
End If
End If

your code worked ok but i have a separate column name type , under that column i need , whenever balance goes to -tive, the sign of DR in type column change to CR for that particular account , also i need that code to work on form load event . i need it to run while user open chart of accounts

Member 12654313 9-Apr-19 5:37am View

Thank you for link but i need vb.net sir

Member 12654313 9-Apr-19 3:38am View

dear nirav i need any guide or idea to do it.

Member 12654313 1-Jan-19 0:25am View

nope i am not a student i am IT engineer in uae. i have idea to do this but i thought maybe if i write any additional line or code in my code then maybe it work the way i want.

Member 12654313 31-Dec-18 8:47am View

ok i understand your point but can you write any code for me please that can help me in autocomplete and fetch the description ..... that will be great help for me ...happy new year

Comments by Member 12654313 (Top 17 by date)