Invoicing +accounting vouchers

[mhakim]

Hi dears

I have form for invoicing or bills
For example logistics or transportation bill

I need to make automatic accounting vouchers after saving the bill

I have every thing ready like the item linked to accounting number and vendor linked to accounting number but need idea

 

[pbaldy]

That's a little cryptic for me, so it may help to see your database structure, or a sample db. Generally speaking I'd say identify the steps you'd take manually once a bill is saved, and automate them in the same event/process that saves the bills.

 

[Pat Hartman]

In general, you link a detail item to its parent by using a combo and picking the parent's Name (PK) out of the list. But, as Paul said, you haven't provided enough information for an accurate solution.

 

[mhakim]

i will explain but first of all to understand what i am going to say you should be accountant or ERP CONSULTANT .
all of bills or sales invoices forms should create an Accounting voucher
for example
if you receive bill from vendor as you received a logistic or transportation service
you will record bill data in form like date bill ref and quantity and price every thing then save
after saving it should also create Accounting voucher like this
debit logistics expenses
credit vendor
in other way i am trying to save data in many tables

 

[pbaldy]

I'm a reformed accountant.

Presuming the structure requires it, creating debit/credit entries in a general ledger type table would be fairly simple. You could use a recordset or execute SQL. It's possible the entries could simply be derived from the transactional data entered as well.

 

[mhakim]

would you send it to me if you have small eample

like 1 form
record vendor service bills currently i am saving two tables first bill header table second bill details
i want to make voucher or save in another two tables
accounting entries vouchers header table + vouchers details

 

[pbaldy]

I do not have a sample db.