same transaction no display to all brnches in general ledge

ahmedba
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
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
-
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 solve0 -
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 no0 -
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 .0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions