business view

[ekben]

dear all,
i have the problem. i want to check the total contract sum against the total receipt sum. if fully settled then will not b shown on the report.
i use the contract sum table breakdown by milestone F5202 to check against receipt table F03B14.
my question is I want to group and sort by contract in business view level. i searched thru the standard BV but none has summary total contract sum by contract and also total receipt also. in short only single record to show total contract sum for each of the contract for BV. or if have single record to show total receipt?
may i know how to create BV by summary and not do it in report?
i find its very restricted in creating BV. I cannot set condition/logic for BV.

rgds
ekben

 

[peterbruce]

ekben,

I hope I understand your requirements. I have a suggestion, and I hope it will help you.

First using the contract BV section (hidden or suppress section write), loop through it and accumulate the appropriate amounts. On contract break, using the receipts BV section (hidden or suppress section write), loop through it accumulating appropriate amounts. On receipt/contract break check to see if contract is paid ou. If it isn't call a condition section to print the single line, identifying the contract, its total/accumulated amounts and its total/accumulated receipts and a balance outstanding. The only section to write is the conditional section. Plus any required report headers or page headers.

Hope this gives some assistance.

 

[ekben]

hi peter
i dun understand this statement :
On contract break, using the receipts BV section (hidden or suppress section write), loop through it accumulating appropriate amounts. On receipt/contract break check to see if contract is paid
1)on contract break(V5202B) how to use receipts section(V03B14A)?
2)receipt/contract break - both are different break?
3)can refer to my attachment?
4)at BV level(during create BV) can do summary?

 

[peterbruce]

ekben,

Sorry for the confusion. I left some important information out.

The receipts BV section is a conditional section. In the initialise section ER set user selection to the contract/business unit or other information to identify the contracts receipts for the contract value just completed in the contract BV section. If I remember correctly it is executed once for each call when defined as conditional.

Basically, it should work like this:

*Contract BV Section - Non conditional, non printing section
Do Section ER: Loop through contract BV accumulating totals. Save contract identifying information to be used to get receipts. On change of contract value, call Receipts BV Section.

*Receipts BV Section - Conditional, non printing section
Initialize Section ER: Set user selection to contract identifying information saved in Contract BV Section.
Do Section ER: Loop through receipts BV section accumulating totals.
End Section ER: Call printing section.

*Printing Section - Conditional, printing section - no BV
Do Section ER: Print 1 line: Contract, Contract Total, Receipt Total, Balance Outstanding etc.

When the printing section is complete the Contract BV Section will continue with the next contract.

 

[ekben]

Re: business view - thanks

dear peter, thanks for yr help. i've done the logic and it's just nice. u can see the attachment.
certain thing to confirm with u.
1)when u sau on change of means sort and level break by that particular column in data sequencing, rite?
2)printing section just another normal section only as what i did, rite?
3)when u say call certain section means do custom section as what i did, rite?
4)another thing, cannot do in end section but end break section.
5)may i know why my output always got 2 lines before the next order number?
6)infact my report with 3 kind of information. from milestone, billing to receipt. so i need to use F5201,F5202,F5216,F03B11,F03B14 in order to accomplish this. any idea of what standard BV to use or if need to create how many BV to create and the combination. i plan to have 2 group. 1 is F5201,F5202 and F5216 whereas another group is F03B11,F03B14 and F5201.
what do u think?

thanks again.

rgds
ekben

 

[Zoltan_Gyimesi]

Re: business view - thanks

Hi ekben (again),

>> "may i know why my output always got 2 lines before the next order number?"

Have you ever debugged your report to figure out it?

Application Debugger a great tool sometimes to find bugs.
Try it!
You will be able to solve or to identify more specific your problem.

Good luck,

Zoltán

 

[ekben]

Re: business view - thanks

application debugger? in jde.ini?

 

[Zoltan_Gyimesi]

Re: business view - thanks

Hi ekben,

Not in jde.ini.

This is a tool, to debug APPL and UBE type of objects.
Currently I haven't access to any system, but you can reach through the menu. I try to describe it for you from my memory:

Start from main menu (G)
> Foundation
> Tools
> Development Tools
> Cross Application Development tools
> Menu Selection: Debug Application

I hope, you will be able to locate it.

By the way, the Development Tools manual describe, how to access the Debugger tool and how to use it (though, it is obvious).

You can select APPL/UBE to debug, place break point on event rules, execute ER step-by-step, examine all "data holder items" at break point (eg. ER variables, RV, PV, BC, PO, RI, FI, PC, PV, SV, FC, GC, GB, and so on...) and you can changes their value at run-time (at least most of them).

I hope, you will explore this tools soon!

Regards,

Zoltán

 

[peterbruce]

Re: business view - thanks

ekben,

I'm glad my suggestion has worked for you. In answer to your questions:

1) Q: when u sau on change of means sort and level
break by that particular column in data sequencing,
rite?

A: Yes, or it can be done "manually" by coding it in ER.

2) Q: printing section just another normal section only
as what i did, rite?

A: A group section, yes.

3) Q: when u say call certain section means do custom
section as what i did, rite?

A: Yes.

4) Q: another thing, cannot do in end section but end
break section.

A: Whatever works.

5) Q: may i know why my output always got 2 lines before
the next order number?

A: Impossible for me to tell remotely. Zoltán's suggstion
of using a debugger would help you.

6) Q: infact my report with 3 kind of information. from
milestone, billing to receipt. so i need to use
F5201,F5202,F5216,F03B11,F03B14 in order to
accomplish this. any idea of what standard BV to
use or if need to create how many BV to create and
the combination. i plan to have 2 group. 1 is F5201,
F5202 and F5216 whereas another group is F03B11,F03B14
and F5201. what do u think?

A: I'm not that familiar with the details, so I can't
advise. Trust your own abilities to find or produce the
needed BV's.