Dear all,


Is Baan 5C provide a report to get an information about how many order that we have got for certain period, for certain customer, for certain item?

Is anybody need the same report like this? Can you pls share with me?

Thanks & Regards,
Agoes

We, like many Baan users have found that the standard Baan reports do not always include what we want in the formats we want, so we mostly use reports we have written ourselves, using a separate report writer – we have used both crystal and cyber query with great success. But – if you must have a Baan report:

GO TO tdsls5501m000 – Created Sales Order History by B P and Item
Menu Path
General Menu
Order Management
Sales Control
Sales Order History
Session – Created Sales Order History by BP and Item
When in the session go to the menu bar and select:
File:
Print:
Print Sales Order Line History by Sold-to BP and Item

This brings up a dialog box where you can enter your desired ranges (or single value ranges) for BP; Date Range; Item or Item Range or any of the other selection options.

Print Planned Inventory Transactions by item would help you? whinp1400m000

Print Planned Inventory Transactions by item would help you? whinp1400m000

Nope. The session that you gave is for planned transactions.

jcorwine has gave me the session that I want. But as jcorwine said that reporting in Baan is not good enough, we have to modified it to make us ease.

Anyway, thanks for your help.

Regards,
Agoes

You may also try one more report: tdsls4412m000 which is attached in the session sales order lines.
I am not sure about your scenario but if you opt for customized reprt, designing a report from sales order lines (all lines with sequence number = 0) would be easier and better than history tables. because creating, deleting and modification etc., will all be logged in it (along with the deliveries).
However, this is just my idea.

Hi,

Just another idea : you could also use the session tdsls4409m000 (Print Sales Order Lines), where you can select sold-to BP, item, sales order, ... Start this session from the sales order lines session tdsls4501m000 by clicking the printer icon. You can choose several reports (by item, order, ...) and at the end, there's a total line.
I have attached some screenshots.

Maybe this will save you some customization.

All excellent suggestions about using standard baan reports and possible customizations.

But - in my humble opinion I would avoid customization of the Baan reports and the consequent problems with all customizations - are they going to continue to function as desired with the implementation of the next service pack?

My experience says that you are much better off investing in a good report writer (have used both Crystal and Cyber Query with great success). You can train many users to do some of their own ad hoc report writing and can get the specific information and formatting as you want much easier than via customization of the Baan report scripts.