On Thu, 3 Jan 2008 09:41:58 -0800
"Chris Travers" <[EMAIL PROTECTED]> 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? 

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

Reply via email to