If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Exchaning a field with data from another
Here's my problem, I am an accountant, that is part of the problem I know.
I have a client who has data that comes out his software that has names associated with the General Ledger Items, example Cost of Goods Sold, Auto, Telephone and Meals. My software uses Numbers. I have a table that matches up their Name with my number... Examples QuickBooks PeachTree Cost of Goods Sold 50500 Auto 61000 Telephone 84000 Meals 73500 The data from his check register is like this: Check Date Amount Payee Distribution 7001 02/16/07 $159.95 Olive Garden Meals I need to exhance the Meals for 73500 then I can import the data into my software to generate financial reports. Can anyone offer some guidience and suggestions. When you do you your taxes make sure you take the one time credit of the Telephone excise tax, it worth atleast $30 and as much as $60 depending on your filing status and number of dependants Thanks, Jess Just Jess |
#2
|
|||
|
|||
Exchaning a field with data from another
Create a table with 2 fields one for the costcentre and one for the
description. Then create a query that links your clients data table to your table and select the required fileds from both tables. the only thing you will need to watch is if the description is ever wrong (i.e. a typo) as this would leave the costcentre field blank. The join should be a left join (i.e. show all data from your clients table and only records from the new table that matches! Hth Stu "Jess" wrote: Here's my problem, I am an accountant, that is part of the problem I know. I have a client who has data that comes out his software that has names associated with the General Ledger Items, example Cost of Goods Sold, Auto, Telephone and Meals. My software uses Numbers. I have a table that matches up their Name with my number... Examples QuickBooks PeachTree Cost of Goods Sold 50500 Auto 61000 Telephone 84000 Meals 73500 The data from his check register is like this: Check Date Amount Payee Distribution 7001 02/16/07 $159.95 Olive Garden Meals I need to exhance the Meals for 73500 then I can import the data into my software to generate financial reports. Can anyone offer some guidience and suggestions. When you do you your taxes make sure you take the one time credit of the Telephone excise tax, it worth atleast $30 and as much as $60 depending on your filing status and number of dependants Thanks, Jess Just Jess |
Thread Tools | |
Display Modes | |
|
|