We are using baan for ordering but at the warehouse end, both baan is running along with the system of the third party running our warehouse. The result is that currently we have to do the donkey work of taking the entries from baan and from the other company's software and then compare them manually.

Is there a more elegant/humane/intelligent way of doing this ?

I mean can we automate this process somehow ?

Or is there support in baan for this already e.g. cycle count etc.

Ideally we would need to see the same transaction in baan and in the 3rd party's system and these transactions can be compared. However, there is no mapping of transactions as such e.g. we can automate the system to check transactions but there is no direct mapping for the dispatch data.

I think it is not difficult to compare the result of the Baan system and the external system.
But if any discrepancies occur, you still not human to find out the reason.

I think a better way, if possible, is to avoid the entries of transactions on the two system separately. I will suggest to import the inventory transactions from the external warehous system in Baan.

Hi,

You can create a table in Baan to import the data from the warehouse system by scheduled job etc. and then run a report to get the desired output.

Regards,

create a custom script to compare and report. baan do have a cycle count program where the data are held in a cycle count table. there you can analyze and make changes as necessary. in our case we have the data in excel and upload to the cycle count table. once you're satisfied with the number you can process the cycle count so the inventory goes into the Item data by Warehouse.