C
CW
We have an order processing mdb that I developed and which is handling
everything fine, but we have to do our billing separately within the
accounting system.
I want this to be done within my mdb (all the data is there and I can easily
create the necessary mergefields etc).
The resulting invoices would need to be exported as a csv to the Sage sales
ledger (there is a well-estalished import routine within that package so no
problem there).
Question is, once the invoices are generated and residing within an Invoices
table, how do I select those that I need to export? Obviously they should
only be exported once, so there needs to be some sort of flag on them once
they have been exported to prevent them being selected within any subsequent
batch.
I'm sure I'm hardly the first to be doing this, so can somebody please help
with this or point me to a sample mdb that includes a similar process?
Thanks a lot
CW
everything fine, but we have to do our billing separately within the
accounting system.
I want this to be done within my mdb (all the data is there and I can easily
create the necessary mergefields etc).
The resulting invoices would need to be exported as a csv to the Sage sales
ledger (there is a well-estalished import routine within that package so no
problem there).
Question is, once the invoices are generated and residing within an Invoices
table, how do I select those that I need to export? Obviously they should
only be exported once, so there needs to be some sort of flag on them once
they have been exported to prevent them being selected within any subsequent
batch.
I'm sure I'm hardly the first to be doing this, so can somebody please help
with this or point me to a sample mdb that includes a similar process?
Thanks a lot
CW