Hi All,

I was asked to build a report that will show the Open Items (for each supplier) that is very similar to the original report that comes out from tfacp2421m000 session.

Basically what I need is to go over all the open Items per suppliers and sum them up (in all avaible currencies). So for each supplier, I will have all his open items, and the total.

Can any one guide to the tables and logic? I prefer to write my own report since they will ask me to put many other customized information in.

Thanks,

- D7

Hi David,

If you're totally new to Baan reports then it maybe advisable to get hold of some sort of documentation that gives you a decent overview. To put totals on reports generally you use after.field section in the layouts and then make the field a total field within the layout.

In respect of the session tfacp2421m000 our system has a standard report with a total by supplier.

Hope this helps.
Cheers Neal

Thank you Neal,

I am not new to Baan Reports. The request here will include a dozen of field that will not fit to the Baan IV's editor. That's why I need to write the whole report from scratch.

I will be writing it in a regular script, with regular SQL and writing the output to a text file.

That's why I need to understand the logic of this specific report, which tables are involved and how to calculate it.

Can you help me in this?

Thanks in advance,

- D7

Hi David,

No I'm sorry I don't know the report that deeply i'm afraid in respect of the SQL etc. I was intrigued by this part of the comment

"request here will include a dozen of field that will not fit to the Baan IV's editor. "

Do you mean that you are being asked to print several fields that exceed the maximum number of lines per layout ?

You could print several layouts ie. detail.1, detail.2 etc. Or are you doing this already ?

If you have too many fields have you tried using arrays ?

Apologies if you've been through this route already but I've always managed to find a way with the Baan standard reports in these situations. However maybe my users are just easily pleased.

Good luck with it.

Cheers Neal

No I mean I want to have 50 columns! One next to the other! The Baan reprot has a limit of 255 Character, and I have more than that in each row.

This report, should be read in another system. So I bounded to its template. I can not change the looks, add lines or columns other than what they want.

Thanks for your reply.

Does anyone know how does this report work? What tables are involved?

- D7

Hi David,

It never ocuured to me you were going across. If it helps it looks as if most of the data comes from tfacp200.

Cheers Neal

Yes, it sounds like tfacp200.. but I have been told that there are a lot of logic invloved, and not just summing up the numbers..

Can someone explain the logic?

Can someone explain the logic of how this report works please?

If you are on LN then mayby your lucky and the source of the session is present on your system in the U_stnd layer. just check it. Then you are able to read the logic.

Can someone explain the logic of how this report works please?

Hi David,

I'm on ERP LN, however I think there should not be a big difference in tables in BaaN IVc4 as well.

For Open Invoices, not paid fully : The main table should be tfacp200, can write logic for all the invoices with value 0 in balance field (tfacp200.balh). then in the report sort the report with supplier code, currency, invoice no. And Like Neil said, for totals, use "Total" function on after.field section

For 255 chars issue, may be you can try creating a file.

Hope it helps.

Regards,
Saroj K Thakur

Thank you for your reply.

So, is that all? if tfacp200.balh = 0 then I should type it? Can you elaborate more on this field? Are there any exceptions?

I heard there is a special treatment for anticipated and other types.

I can see that in some cases the tfacp200.balh & tfacp200.balc = 0 but the item is still opened. I can see it is still opened fromt he Baan print session, and also if I some the "tfacp200.amti" it does not add up to zero, it will have the same result as the Baan report.

Why aren't the tfacp200.balh & tfacp200.balc updated? I got only 2 cases out of 1000!

Any ideas?

Could you share your report format(layout)? It would be helpful to suggest.

Raj

I can see that in some cases the tfacp200.balh & tfacp200.balc = 0 but the item is still opened. I can see it is still opened fromt he Baan print session, and also if I some the "tfacp200.amti" it does not add up to zero, it will have the same result as the Baan report.

Why aren't the tfacp200.balh & tfacp200.balc updated? I got only 2 cases out of 1000!

Any ideas?

There may be some currency differences which may need to be written off.

Also Balc /balh are updated in header records only and not in child records.

Could you share your report format(layout)? It would be helpful to suggest.

Raj

I am writing the report from scratch. So there is no "layout". What I need is all the open suppliers with their balance in 3 currencies.

There may be some currency differences which may need to be written off.

Also Balc /balh are updated in header records only and not in child records.

Hi Hitech,

Thanks for your reply.

How can I know what to cut off and what not to?

For those specific suppliers, balc/balh was zero in all record although it is still open and it appears in the native Baan reports. Do you know why?

1. run tfacp2245m000 to correct balances
2. The program tfacp2421m000 may be run with fully paid or may be with backdated to invoice receipt dates .
3. When balance in FC is 0 and there is balance in hc , u can run write off currency differences .

1. run tfacp2245m000 to correct balances
2. The program tfacp2421m000 may be run with fully paid or may be with backdated to invoice receipt dates .
3. When balance in FC is 0 and there is balance in hc , u can run write off currency differences .

Thanks again for your help. I really appreciated it.
1) I do not have this session in my Baan IV! Is there an alternative?
2) I should exclude "fully payed invoices". How can I recognize those who where fully paid from this table (tfacp200)?
3) Thanks. I will add will try to add this logic.