[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Non real-time synchronization



On Thu, 3 Jan 2008 09:41:58 -0800
"Chris Travers" <..hidden..> wrote:


> ar:  This represents the transaction where the customer is charged.
> customer_id links to customer.id in 1.2.x.
> acc_trans:  this represents the line items in the accounting transaction.
> You will need 2 entries here for a charge, and another 2 for a payment.
> chart_id links to chart.id, trans_id links (in this case) to ar.id.  Do you
> need help determining these records and what accounts they need to hit?

Would it be possible for someone to write a trigger for me that would,
if an ar transaction is entered which is has a specific employee_id,
credit and debit the same two accounts in acc_trans every time
with the details from the ar table? If triggers work in this way, it
seems like this might be a way to get my external transactions into
Ledgersmb.

If this could work, would it also work in the same manner for
payments and credits?