Dear brother,
i am running a small furniture store.
i want to know if it is possible to auto entry data to other workbooks?
for example:
when i have made an invoice, it will automatically increase the customer account's receivable balance and decrease the inventory account; after i issue a payment receipt: it will automatically decrease customer account and increase my bank or cash account.
please note that there are multiple customers and each customer has individual file(workbook).
how do i do that?
please let me know the simplest way to do this.
i will be very grateful if you could manage some time to work on my requirement.
i am sorry for my bad english.
thank you in advance.
i am running a small furniture store.
i want to know if it is possible to auto entry data to other workbooks?
for example:
when i have made an invoice, it will automatically increase the customer account's receivable balance and decrease the inventory account; after i issue a payment receipt: it will automatically decrease customer account and increase my bank or cash account.
please note that there are multiple customers and each customer has individual file(workbook).
how do i do that?
please let me know the simplest way to do this.
i will be very grateful if you could manage some time to work on my requirement.
i am sorry for my bad english.
thank you in advance.