vyp_007
13th December 2006, 14:42
Hi,

I am working on BaaN4 C4.

I want to display only authorised and released POs in the report which I am developing. How to find whether the PO is released or authorised...?

Regards,

VYP

jp.aalders
13th December 2006, 16:47
How do you indicate whether your PO is authorized of released? Is this based on the order procedure you defined.

If this is the case you can surpress detaillines on your report based on the status, the current status of the lines you can find in table tdpur045 ( spur ).
If you report is showing just the PO and no positions this means you need to check al the posistions on the order.

To surpress a detail on your report you can simply use an expression on the specific detailline line, for example "tdpur045.spur <> 2"

If you need more info, just let me know

Regards,

JP

Paul P
14th December 2006, 08:09
Hi VYP,
In BaanERP (ie version 5), there is indeed separate step in PO processing to release the PO or have extra step to have it authorised by the big wigs. However, there's no built in feature like those in BaanIV. The next best thing would be to find whether a PO has been printed or not. If you're feeling really adventurous you can customise BaanIV to include those feature from BaanERP :)
Paul

skennedy
14th December 2006, 20:36
Hi VYP,

Or if you’re not “adventurous” enough you could purchase a solution such as ours which can add approval chains to 4c, we store the date and time stamp of each of the signers which you could easily access.

sukesh75
19th December 2006, 08:01
hi vyp,
The main issue here is to flag of a certain field and use it to show the order as authorized or approved. The only two step before Maintain receipt that could help are Print Purchase Order and Print Goods Received Notes. Once you decide which of these to use, you could utilize the field pmsk(Procedure Mask) in tdpur045 table to pick up authorized or approved orders.

sk