Options

same transaction no display to all brnches in general ledge

ahmedbaahmedba Member Posts: 424
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

Comments

  • Options
    ahmedbaahmedba Member Posts: 424
    to achieve this task i changed transaction no to document no
    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
  • Options
    ahmedbaahmedba Member Posts: 424
    can any one help me in this

    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
  • Options
    ahmedbaahmedba Member Posts: 424
    Suppose i want to tell
    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 .
Sign In or Register to comment.