Hide Duplicates in DAP

[Steve]

I have made a DAP showing invoices and stuff. However, I get duplicates of
the second level group, probably becase there are two entroes. Is there a way
to hid the duplicate group??

Thank you in advance Steve

 

[Vincent Johns]

I have made a DAP showing invoices and stuff. However, I get duplicates of
the second level group, probably becase there are two entroes. Is there a way
to hid the duplicate group??

Thank you in advance Steve

Could you show an example of what you're doing, and the specific results
you get that you don't like? You can probably do that by listing 2 or 3
sample records, and indicating what you'd like to see as a result.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[Steve]

I am in contractin, Government to be specific. I am the one that makes sure
tax payers get what they pay fore. Anyway a Gov contract say has 1 Million
dollars on it. Well the 1 mil get devided up into categories e.g. Labor,
Travel, Unique Automation items, et cetra. We assign these categories numbers
called Clins, under these Clins are sub-categories called Sclins, because
there may be differents funds used on the same contract. Well we attach a
"AA, AB etcetrat to the Sclins to keep them seperate.

So the contractor Company "X" bills the Fed for services in a invoice, e.g.
the invoice will bill $10 to travel Sclin 5121AA, and $20 to Unique
Automation 5124AA et cetra. My job is to sign the invoice but first I verify
that the work has been done pursuit to the contract and funds have been
allocated in accordance with the contract, once done I sign the invoice
verifying that it is correct and honest then I send it to DFAS (Defense
Finance and Accounting), and they pay Contractor X. My DAP shows a subgroup
for every invoice entry, what I want it to do is show the Sclin as a group
and list all invoice entries below, the page does this as desired, however,
it keeps repeating the subgroup. So i have entered two invoices againts the
sam Sclin and it shows both as a Sclin group??

This would be much easier if I could send you a screen shot of the problems.

Steve

 

[TC]

IMHO, you should not be writing software to handle million dollar
contracts, unless you are suitably qualified & experienced in software
development.

Don't you have an IT department to help you with this, or do it for
you?

Is your software audited by the GAO (for example)?

HTH,
TC

 

[Vincent Johns]

I think I see what you're saying, that you might have 2
sub-contract-line-item-numbers (SCLINs) for one item, maybe because the
funds come from more than one account. But to give you a more specific
answer, I'd like to see a specific example. (But please be sure to
sanitize the stuff -- I don't want to see any sensitive information that
might affect some procurement process!!!)

Instead of a screen shot, could you display the relevant results in
Datasheet View, select the displayed records, copy the contents to the
Clipboard, and paste them into your message? That would be easier for
me (and, I expect, others) to use in constructing an answer than a
screen shot would be.

If it's a Report that you're describing, perhaps you could run the
underlying Select Query for the Report, and also describe what the
Sorting & Grouping criteria are on that Report. (Tools --> Analyze -->
Documenter can do that, but it produces way more information than is
usually necessary.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.