Hi All,
When we use Vendtrans and Vendtransopen table for uploading balances for vendors I could not import data into both the tables. Data is not imported properly; my doubt is what to give in the reference field in the Vendtransopen and Vendtrans sheets before importing data. Could anybody help me in this regard, it will be grateful. Thanks and Regards, Barath _____ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tarek Saleh Sent: Wednesday, August 01, 2007 1:29 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] uploading balances for Customers & vendors Thanks a lot for your support. AX CONS <[EMAIL PROTECTED] <mailto:axcons%40gmail.com> com> wrote: Hello, That is up what your customer wants to see. First of all update the CustTrans, CustTransOpen, Vendor and VendorTransOpen. These transactions will update your Vendor and Customer balance. After that update the LedgerTrans, LedgerBalancesTrans and LedgerBalancesDimTrans. The best way you can use for reference is just copy the company without any Transactions and create sample Vendor transactions and Customer Transactions. After thet check the tables? Which tables have the data and how importance for you. This method is for updating Vendor and Customer as posted. So, your Reconciliation reports will show these are not correct and also, correction functions will not work. Maybe, the another disadvantages The another, you could import the transaction as Open Order. So you could use some Journals for that, check the table names and import the data. That could be more effective and usefull method for you. I mean that is up to your customer needs. Let me know if you have question, email me directly. Thank you Gokhan Kestek gokhankestek@ <mailto:gokhankestek%40whatisaxapta.com> whatisaxapta.com On 7/31/07, faiqa <faiqa.khushi@ <mailto:faiqa.khushi%40m-consultants.com> m-consultants.com> wrote: > > > > Just use LedgerJournalTrans table , here you can enter transactions for > vendor/customer/ledger account using account type. > > From: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED]<Axapta-Knowledge-Village%40yahoogroups.com> > [mailto:Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED]<Axapta-Knowledge-Village%40yahoogroups.com>] > On Behalf Of Tarek Saleh > Sent: Tuesday, July 31, 2007 11:27 AM > To: Axapta-Knowledge- <mailto:Axapta-Knowledge-Village%40yahoogroups.com> [EMAIL PROTECTED]<Axapta-Knowledge-Village%40yahoogroups.com> > Subject: [Axapta-Knowledge-Village] uploading balances for Customers & > vendors > > Dear All, > > currently i need to upload the customer as well as the vendor balances, so > what is the proper table i should export: > "vendtrans & cust trans" > or "ledger trans and then vendtrans & custtrans" or someother tables. > > Thanks for your support, > > Tarek > > --------------------------------- > Pinpoint customers who are looking for what you sell. > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] --------------------------------- Need a vacation? Get great deals to amazing places on Yahoo! Travel. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
