×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

GREAT PLAINS DYAMICS & CRYSTAL REPORTS

GREAT PLAINS DYAMICS & CRYSTAL REPORTS

GREAT PLAINS DYAMICS & CRYSTAL REPORTS

(OP)
My question is in regards to Great Plain Dynamics & use of CR for A/R aged TB reporting.

I have certain items that we invoice that I do not want included in the O/S totals of each invoice that is displayed in the report.

i.e. Total for invoice may be $3,000 but I have 2 of 15 items for $1,250 that I do not want their amounts included for the purpose of this report. I only want to display the remaining $1,750

Currently:
Customer X Inv#888 Amount $3000

Like to see:
Customer X Inv#888 Amount $1750

Any help would be appreciated,
Nathan

can also contact me directly at angelozzi-enterprises@home.com

RE: GREAT PLAINS DYAMICS & CRYSTAL REPORTS

Nathan,

That's a bit skimpy to start on, but we can try. Do the amounts that you wish to exclude have any commonality?

For instance, do the items have a fixed price that you can reference, or perhaps a particular stock code, or unit measure?

If so, you can select by excluding, e.g.
(
{database.field}<>'some criteria'
or
{database.field}<>'some other criteria'
)

Or, is there some data commonality or a date range that can be used?

Also, are you excluding the same things from every invoice, or just selected [different] items from different invoices?

Try fleshing out your request a bit more.

Make a good day . . .
. . . barn

RE: GREAT PLAINS DYAMICS & CRYSTAL REPORTS

(OP)
For instance, do the items have a fixed price that you can reference, or perhaps a particular stock code, or unit measure?

>>>Yes they do, I use the item description {SOP30200.ITMDESC} as the filter for another report where I reprint invoice information that splits all the other invoiced items from this particular group.

>>>I can't seem to get the same ideas to work for the Aged A/R Trial Balance though I continue to mix & match tables to come up with the correct one.

Also, are you excluding the same things from every invoice, or just selected [different] items from different invoices?

>>>This report would be used to include or exclude the same items each time. My next project after this second one will be to bring out only the invoices paid during a month that have a particular group of products in the invoice too. Should be interesting.

Thanks for your time.
Nathan

Try fleshing out your request a bit more.

Make a good day . . .
. . . barn

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close