Export G/L Transactions (1 reply)
Bertus, yes you can do this.
To export transaction you use a DB Reader (as opposed to the Sage300 Connector).
There are a couple of samples in the homework section of our documentation site, demonstrating how to do this.
How you handle which transactions to export will be another issue...
Since the GLPOST table doesn't have any field(s) where you could flag the transactions exported you need to record something external to the record.
- We would probably recommend using a Lookup table in IMan to record the last date/time or the last Posting Sequence exported. This would be updated via a DB Writer.
- You would then use a cross database join on the query on the DB Reader to extract only the latest records.
If you need something a bit more concrete we could create a sample integration, so please let us know.
Whave a situation where a customer would like us to export Sage 300 GL transactions to another system.
The file layout is very flat so no need for headers or details. One way I was hoping of doing it was to be able to export from the GLPOST table, however I can find any mention of this in the user guides. Is this possible with iMan?