I need an open purchase order report at the end of each month..
a report that list the items that have not been recieved...
Seems like this should be there already...am I missing it..
Help???

Dear Linda,

Even in BaanERP 5.0c, such report, unfortunately, are not readily available built in. You'd have to perform customisation to get one

Rgds,
Paul

What about session tdpur4403m000? A similar session should be available in Baan ERP as well I guess :)
Regards,

Martin

Hello All,

There is no Outstanding PO Report in Standard Baan.

Please see this link for more information, and a sample report that I wrote.


Outstanding POs (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=9422)

John

Well, we are using tdpur4403m000 with a modified report layout and it works fine.. or is there some functionalitity you are missing here?

Regards,

Martin

my company is using customize Open PO in Baan. However, becareful before you start for to customize the session for print this report. Think about what you are require, such as by buyer or by PO or .... Because my company have 2 session ( by buyer and by supplier) for print this report. Unfortunately, not useful for user because they looking for by order number.

End up, we are using Oracle report writer to write for it. Why don't you use report writer? Better format option. Example, table format (no repeating header) is easier for export in excel file or Crosstab format with XY view.

I am modifing 4403, but have found it doesn't pick up the backorders..but I can us that report plus 4403...again thanks for the help..

I leave a.m. for Alaska for ten days it took me all day to pull things together..so I'm kinda-of tired...

Hi lindar,

backorders should be included in 4403 - with the backorder quantity of course. That's the main reason why it's worth customizing this particular report: all necessary features are included (and standard Baan :cool: ) and need not to be reinvented.

Good luck!

Martin

Hi

I think a simple query on tdinv150 Planned Inventory Transactions should solve your problem

I don't believe that tdinv150 will give you Cost Items. So if the requirement is for an overall open PO report, not just inventory items, you will still have to work through the PUR tables.

Scott

I think Scott's advice is good.

As a general principle: if you want purchase details then the purchase tables are the best use. Similarly inventory/ilc tables for inventory; sales tables for sales; etc etc...

In many situations it may also be necessary/useful to also use additional tables from other modules to get the complete story.

One of the great vitues of baan is its underlying data structure.

Terry