Hi guys I attach data from more branches in same database .then after few days i make wrong post to banks account then
i go to function -reverse from general ledger enteries then i see all transaction with same no from all branches show when i make to reverse this transaction no from chart of account-net balance-general ledger entries.how i show only transactions that related to entry i need to reverse
example
Entry no transaction no document no
12223 1238 MA-CR-12-12-00036
when i select this entry then make function reverse this result show
transaction no document no
1238 MA-CR-12-12-00036
1238 RA-C-12-12-00197 another branch
1238 PRL-13-03-022 another branch
why it show all branches as above how it must show only
this entry
1238 MA-CR-12-12-00036
i asked now can i do that
How I control in properties of transaction no to prevent this from display or show
OR
Make filter to show only document no related how
I don't know
thanks
0
Comments
FIND('-');
ReversalEntry := Rec;
IF "Reversal Type" = "Reversal Type"::Transaction THEN BEGIN
CurrForm.CAPTION := Text000;
ReversalEntry.SetReverseFilter("Transaction No.","Reversal Type");
END ELSE BEGIN
CurrForm.CAPTION := Text001;
ReversalEntry.SetReverseFilter("G/L Register No.","Reversal Type");
END;
but it give me error integer:=code you cannot make conversion
how to solve
ReversalEntry.SetReverseFilter("Transaction No.","Reversal Type");
in the line above i want to put document No in place of transaction no
but it give me error
" you cannot make conversion integer :=code"
can any one tell me how i solve this error and replace integer with code data type of document no
Entry no transaction no document no
12223 1238 MA-CR-12-12-00036
when i select this entry then make function reverse this result show
transaction no document no
1238 MA-CR-12-12-00036
1238 RA-C-12-12-00197 another branch
1238 PRL-13-03-022 another branch
I need only MA-CR-12-12-00036 .
I want to do one thing this what i want t o do
1- when i select record of g/l entry (general ledger entries) then make reverse function store the value of document No in variable suppose variable name Doc as code data type
2-in open form trigger of form reverse entry
set filter by this value of Doc
Can i do that of code please .