× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MAPICS-L
  3. March 2004

RE: Question on Subsets

Robert:

Thanks for your suggestion.  This solved the problem!  I was able to
create the new object and create the logical expression to convert the
amounts to an actual negative/positive number.  Now the totals are
correct on the queries.  Thanks again!  

-----Original Message-----
From: Robert Russell [mailto:Robert.Russell@xxxxxxxxxx] 
Sent: Tuesday, March 09, 2004 4:47 PM
To: MAPICS ERP System Discussion
Subject: RE: Question on Subsets

This may work... Instead of creating a trigger program to update a user
field you may try creating a new object.  The new object would contain 3
fields, Acct type, Credit/Debit flag, Multiplier (1/-1).  Create a many
to one relationship to the new object via the Acct type and Credit/Debit
flag.  This will make the Multiplier available in the base object's
query scope which in turn should make it available in the logical
expression.

Robert Russell
Paragon SI

-----Original Message-----
From: Sutton, Gary [mailto:Gary.Sutton@xxxxxxxxxxxxxx]
Sent: Tuesday, March 09, 2004 4:01 PM
To: 'MAPICS ERP System Discussion'
Subject: RE: Question on Subsets


Why don't you use Integrator and create a secondary file.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Buckingham, Ed
Sent: Tuesday, March 09, 2004 2:30 PM
To: MAPICS ERP System Discussion
Subject: RE: Question on Subsets


That is another thought that was suggested.  I don't have any extra
fields in the file, so I would have to create a tag along file and
create a trigger to keep it in sync.  I was hoping that I could use an
Alias for the debit/credit field as a C = -1 and D = 1 and create a
logical expression that would simply multiply the amount field by the
alias value to give me the desired result.  This did not work so I am
left only with the extra file and trigger.  Seems like there should be
an easier way to solve this.

-----Original Message-----
From: lisa.thomas@xxxxxxxxxxx [mailto:lisa.thomas@xxxxxxxxxxx] 
Sent: Tuesday, March 09, 2004 3:03 PM
To: mapics-l@xxxxxxxxxxxx
Subject: RE: Question on Subsets

Do you have another field available in the file, perhaps a user field,
that
you can load with -1 with a trigger program depending on the account
type?
Then this field could be used in the logical expression.

-----Original Message-----
From: WRamos@xxxxxxxxxxxx [mailto:WRamos@xxxxxxxxxxxx]
Sent: Monday, March 08, 2004 4:20 PM
To: MAPICS ERP System Discussion
Subject: RE: Question on Subsets







That code field is called Account Type.
  AS-Asset
  IC- Income
  EX-Expense
  LI-Liability



 

                      "Ann Neal"

                      <aneal@letourneau-        To:       "MAPICS ERP
System
Discussion" <mapics-l@xxxxxxxxxxxx>                                     
                      inc.com>                  cc:

                      Sent by:                  Subject:  RE: Question
on
Subsets

                      mapics-l-bounces@m

                      idrange.com

 

 

                      03/08/2004 12:46

                      PM

                      Please respond to

                      MAPICS ERP System

                      Discussion

 





I think the GL records have a code as to whether it was an Asset or
LIability account and we wrote queries to get reports.  Pulled all the
asset
accounts multiplying the credits with a -1, then all the liabilites,
etc.
We have IFM, or I would look at it with our Browser.  If you can
identify
that code field, you could subset by type of account?

Ann

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
Behalf Of Buckingham, Ed
Sent: Monday, March 08, 2004 12:21 PM
To: mapics-l@xxxxxxxxxxxx
Subject: Question on Subsets


Hi, I am new to this list.  We are currently running MAPICS XA6.  I have
a browser question.  Currently some of the subsets in the General Ledger
are setup with a view that contains totals on the Amount column.  Since
these totals are represented by positive numbers, the totals are not
correct.  My questions is there any way to convert the amount field to a
positive or negative value based on the Debit/Credit column.  I have
tried to experiment with Aliases and logical expressions, but this did
not work.  Has any one run into this problem?  See below for an example:

Subset Before:


Company number     Account number       Journal reference number
Description            Amount D/C            Year    Month Day

      --------------    ---------------         ------------------------
---------------         ---------------         ---         ----
-----       ---

             1                  10001   CR1051700002
00673700-479314          3,297.48   Debit      0           0
0

             1                   10001   CR1051700004
02036100-478870             504.63   Debit      0           0
0

             1                   10001   CR1051700006
02042000-481109             347.29   Credit    0           0
0

             1                   10001   CR1051700008
05018800-479099             281.88   Debit      0           0
0


Total          4431.28



Subset After:




Company number     Account number      Journal reference number
Description                        Amount D/C            Year    Month
Day

      --------------    ---------------         ------------------------
---------------         ---------------         ---         ----
-----       ---

             1                   10001   CR1051700002
00673700-479314          3,297.48   Debit      0           0
0

             1                   10001   CR1051700004
02036100-478870             504.63   Debit      0           0
0

             1                   10001   CR1051700006
02042000-481109            -347.29   Credit    0           0
0

             1                   10001   CR1051700008
05018800-479099             281.88   Debit      0           0
0


Total          3736.70








Would like to show negative signs in the Amount column so that the total
columns are correct.  Any help or suggestions would be appreciated.



Thanks!





Ed Buckingham

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.