I am trying to copy an export function that an access database currently does to a pc based accounting pacakge. The export file type is usual csv.
The user sets a time frame (say june 1st to june 30th). Any new customers who have placed an order in that date are exported as a csv fiel that contains a few details abou the customer - (name, cust number phone etc). (Can do this part!)
It then exports a file that lists the invoices for those customers. The first record called Header, will contain fields such as date, account number, customer code etc. then the detail records will show 3 records each containing different lines from the such as tax type, total , subtotal. cost code and others...
This is quite difficult to understand but belive this type eof export is quite common with database to account packages so I am hoping someone may recognise what I am trying to explain! I have pasted an exampe piece from the export from access csv file - it is for one new customer who placed an order.
So In fm 12 adv, how do i do it?
I know how to export I just am unsure of how to export the headers and details parts.
Here is the template from the accounts package: obviously I dont use all the fields...