Hello,

I need to urgently create a list with all the purchase orders which are received but not yet invoiced.

I know that there are sessions available in Baan (tfacp1235, tfacp1535, tfacp1237, tfacp1435 etc), however, people at our company have tried in the past to get that system working, without success. Currently it is for me not an option to contact Baan support about it, because our version is way behind, (SP9!!) and the first thing they will tell me is to install the latest solution.

I am right now starting a migration to the latest service pack, but for now, I need to get this list out somehow without putting too much time in it.

So my question: how do I get this list together? Which tables/table-field values are to be considered in order to determine the purchase order lines received, but not yet invoiced. Or, can I retrieve it maybe from an already existing report in Baan...?

Looking forward to any help.


Kind regards,

En.

table tdpur401 (Purchase Order Lines) if you check the Delivered Qty > 0 and Invoice = 0. Hope this helps.

u can compare tables tdpur045 & tdpur046 and make a report.
or else in report tfacp1430m000 make an additinal report output with invoice quantity as zero.

regards,
p ravindra

Hello!

Maybe... you can try with tfacp240 in Vrc V.

In Vrc. IV, tfacp200


Regards.

Hi all, thanks for your suggestions.

I made it based on tfacp1430 and adjusted the selections according to my needs.

Kind regards,

En.

Hi,
We have created a custom session that monitors the Received not invoiced every day We have this account in control after we implemented this. I can provide with the logic and the output that we produce Email me at apatil@bogen.com, in case you want to see the result.

Arvind Patil

Hi!

We are also in SP9 but have been using GRINYA reconcilation and this has given very good results. We have not encountered any major problem with same.

Advised is try again with standard functionality.

Himanshu,

I have been told that a couple of years ago there have been several attempts at our company to get GRNYI working, without success. This was however before I was in the picture here, so I have not tried it myself.

Since however, we are right now upgrading to the latest version (SP16 if released on time), I am not putting any effort/energy in the old version.

Since I needed to get this list sorted out urgently, I just needed a quick resolution for this issue.

I will gladly receive the WATERPROOF logic from Arvind for retrieving the correct balances of the GRNYI ledger account.


Kind regards,

En.

en@frrom - What was it you did to the already existing session tfacp1430? I also went this route and I just put in the print condition of the detail layout of the report to only display if tdpur045.iamt was 0. I don't believe this is correct though because said purchase order could be already invoiced on another record in that table. I'm just not showing it. I know this is an old posting and you may not recall but I wanted to give it a try.

Thanks! NikkiZ

Nikki,

The main thing I added is a form selection to select only rows where quantity received <> quantity invoiced, and adjusted all the reports accordingly. I don't know if you have access to the sources...?

Regards,
Eli Nager

I do not have access to the source. I just made a copy of the report - I have the report source, I could put that in there before.layout. what fields are you comparing?