You are not logged in. [Log In] Adagio Home Page » Forums » General Discussion » Technical Support » Good resource for GridView?
Register User    Forum List        Calendar     Active Topics     Search     FAQ
Page 3 of 3 < 1 2 3
Topic Options
#7569 - 10/10/06 03:35 PM Re: Good resource for GridView?
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
For more infrmation about how to use GridView, make sure you sign up for one of this month's Adagio User Group web seminars. Warren will be showing how to create inquiries using filters and calculated columns. He'll also preview some of the improvements coming in the next release. If you have a specific feature you'd like demonstrated, don't forget to ask about it when you register for the session.
_________________________
Andrew Bates

Top
#40274 - 02/20/14 07:39 AM Re: Good resource for GridView? [Re: Retired_Guy]
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Originally Posted By: Andrew Bates
To have the View "ask you" for a range of item numbers, use this fiter:

Code:
AND(
  UPPER(TRIM({Item #}))&gt;=UPPER(TRIM(QUERYSTRING("Starting item?", ""))),
  UPPER(TRIM({Item #}))&lt;=UPPER(TRIM(QUERYSTRING("Ending item?", "zzzzzzzzzzzzzzzz")))
  )

For date ranges use "=QUERYDATE()".

I asked the same question about the transaction codes in IC history the other day. Here are the values:
Code:
 Trx Trx
 Src Type Description
 1   1    Receipt
 1   2    Receipt adjustment
 1   3    Receipt return
 2   1    Shipment
 2   2    Shipment return
 3   1    Adjustment credit 
 3   2    Adjustment debit
 4   1    Stock transfer from
 4   2    Stock transfer to
 5   1    Component item assembly
 5   2    Master item assembly


Hope that helps.


Could I find out what these code are:

Trx Trx
Src Type Description

3 3 Adjustment ????
3 4 Adjustment ????
3 5 Adjustment ????
3 6 Adjustment ????


Thanks
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#40280 - 02/20/14 09:14 AM Re: Good resource for GridView? [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11448
Loc: Vancouver, BC Canada
Hi Mike,

There are 6 different kinds of adjustments you can make. You can change just the quantity, just the cost or both, and either an increase or a decrease. That makes 6 combinations of these choices:

1: Qty increase
2: Qty decrease
3: Cost increase
4: Cost decrease
5: Both increase
6: Both decrease
_________________________
Regards,
Softrak Tech Support

Top
Page 3 of 3 < 1 2 3


Moderator:  Christa_Meissner 
Who's Online
1 registered (Bruce Gardner), 54 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1862 Members
5 Forums
14384 Topics
70345 Posts

Max Online: 432 @ 01/20/25 10:17 PM
January
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Privacy statement · Board Rules · Mark all read
Contact Us · Adagio Home Page · Top