Hi,

I am newbie in BaaN.

I need to export all the unique suppliers(number, name) and all the unique materials(number, name) into CSV file or into Excel file.

The suppliers and materials should be unique (no repeat)

Could you help me?
Thank you

Moved this to the tools forum since AFS code is probably not what you want. The first thing I can think of is to write you own session to give you what you want into a csv file. The other thing I can think of is using exchange schemes. Lots of material on exchange schemes in this forum so please search. Good Luck!

Hi Mark,

Thanks for the quick answer.

This forum is very helpful. I found a lot of materials, which will help me.
I just need help about the table names and field names which I should use. For suppliers I found that I should use table - ttccom020, but for materials I cannot find the table. Should I use the BOM - table ttibom010 or there is another table? And which field I should extract from those tables.
Could you help me, please?
Thank you

tiitm001 - items

you can identify the table from the sessions,
you just click on the help button and select the inputfiled of the particular session.another way is,
goto maitaintain session ttadv2100m000-you can identify from their form's fields.