[Axapta-Knowledge-Village] Handheld devices for AX
Hi , Which are the best handheld devices to be used with AX and is there any specific requirements to configure PDA with AX? Any document on it will be highly appreciated. Regards, Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How to unsettle the journal ?
Use Closed Transaction Editing window. Accounts PayableVendorFunction button(Closed Transaction Editing Window), select specific transaction and press Reverse button. Regards, faiQa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Thursday, July 05, 2007 9:45 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] How to unsettle the journal ? Hi everyone, I want to know, is there any way to unsettle the journal who has been posted ? I need unsettle this journal because the invoice who has settled, i want to use in another journal. - setiaji - [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How to unsettle the journal ?
Please tell me the exact steps you have performed to settle the invoice against which journal? If you have settled the invoice in payment journal and did payment against that invoice and posted , then you can view the settled invoice from closed editing transaction . But you can just reverse the settlement and then that invoice will again get available for settlement against other payment journal . For the wrong payment you will have to enter reversal transaction through journal. Sorry, If I could not get your query correctly. Regards, faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Thursday, July 05, 2007 11:08 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] How to unsettle the journal ? Thanks Faiqa for your quick answer, still i have problem, sorry to telling you. The voucher or invoice number is not there. I m sorry maybe its too simple question, is there any other way to unsettle ? - setiaji - Faiqa Khushi wrote: Use Closed Transaction Editing window. Accounts PayableVendorFunction button(Closed Transaction Editing Window), select specific transaction and press Reverse button. Regards, faiQa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] How to unsettle the journal ?
No problem setiajiJ Anyways, If you can see that invoice in open transaction editing window then its mean , its available for settlement . In short you either have not yet settled it against any payment journal or settled but not posted. If you could see Red hand icon against that invoice then its mean you have settled it in some journal but have not yet posted that journal. Hence you will have to search for the journal against which this transaction has been settled to unsettle it. There is no need to peek inside the tables , there are many inquiry windows from where you can drill down to the transaction origin. Regards, faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Friday, July 06, 2007 12:06 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] How to unsettle the journal ? Thanks again Faiqa for your amazing quick anwer. Its not me who did the posting with settlement. I only have an order to unsettle that journal. So i began check the voucher and invoice number to get the journal number from open transaction editing. Next i search in ledgerjournaltrans table to get the journal number. Right now, i already have journal number,voucher,invoice and recid. Then i follow your instruction.But the voucher or invoice is not there. Is there something happened with posting journal proses? Its really great help for me Faiqa - setiaji - Faiqa Khushi wrote: Please tell me the exact steps you have performed to settle the invoice against which journal? If you have settled the invoice in payment journal and did payment against that invoice and posted , then you can view the settled invoice from closed editing transaction . But you can just reverse the settlement and then that invoice will again get available for settlement against other payment journal . For the wrong payment you will have to enter reversal transaction through journal. Sorry, If I could not get your query correctly. Regards, faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] AOS is not working
Ya I think there is some security problem because of which I am getting this issue, but I have checked all the options related to security but could not figure out . Can you please guide me to the possibilities .! Its working fine if I bring AOS and File server on same machines. But if both are on separate machines, AOS service gives the same error. Regards faiQa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faisal Hussain Sent: Monday, July 02, 2007 5:53 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] AOS is not working Code 80: is usually permission error, you have to check users permission required to start AOS Faisal - Original Message From: Faiqa Khushi [EMAIL PROTECTED] mailto:faiqa.khushi%40m-consultants.com To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Sunday, July 1, 2007 9:37:44 AM Subject: [Axapta-Knowledge-Village] AOS is not working I am getting following error when I try to run AOS windows could not start the Dynamics server $01-company on local computer for more information view the system event log . if this is non-Microsoft service contact the service vendor and refer to service specific error code 80 Installation structure is like , we have three server machines and I have installed these three application separately on each machine. . Database Server . File Server . Application Object Server ,Client and .Net Business connectors But when I tried to run Dynamic services on AOS machine it gives me the above error. Even I could not see SQL services in its dependencies tab which means my AOS could not communicate with SQL server . I searched over Knowledge base and got some solution but problem is still there. Please suggest some solution to resolve this issue. Operating system : windows 2003 server SP2 AX: Axapta 4.0 with SP1 Regards, FaiQa [Non-text portions of this message have been removed] __ Don't get soaked. Take a quick peak at the forecast with the Yahoo! Search weather shortcut. http://tools.search.yahoo.com/shortcuts/#loc_weather [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] AOS is not working
I am getting following error when I try to run AOS windows could not start the Dynamics server $01-company on local computer for more information view the system event log . if this is non-Microsoft service contact the service vendor and refer to service specific error code 80 Installation structure is like , we have three server machines and I have installed these three application separately on each machine. . Database Server . File Server . Application Object Server ,Client and .Net Business connectors But when I tried to run Dynamic services on AOS machine it gives me the above error. Even I could not see SQL services in its dependencies tab which means my AOS could not communicate with SQL server . I searched over Knowledge base and got some solution but problem is still there. Please suggest some solution to resolve this issue. Operating system : windows 2003 server SP2 AX: Axapta 4.0 with SP1 Regards, FaiQa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Cost Price
I think you have not marked inventoryItem Setup tab(Latest Cost Price check box) or using dimension cost prices. Also check inventDimCombination table. AX keeps the record in different tables , I could not figure out on which form you are exactly looking for the item cost. Anyhow you can get the relevant table by right click the form SetupQuery Tab. Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Friday, June 08, 2007 8:33 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Cost Price I have check InventTableModule table for Purchase,Sales, and Cost Price. But there is only empty value. I have check Item who have Sales Order and Production Order. I see via Transaction, and On Hand. In On Hand, i see value Cost Price, but there is nothing in InventTableModule for that item. Is there a class, handling cost price that i can use for count cost price? - setiaji - Faiqa Khushi wrote: You can get purchase, sales and cost price from InventTableModule table. Regards, Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Cost Price
You can get purchase, sales and cost price from InventTableModule table. Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of setiaji Sent: Thursday, June 07, 2007 1:15 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Cost Price Hi everyone, Is there any table which keep record for 'cost price' for Item in InventTable ? For example, for every month, Item in InventTable who had transaction SO or PO, always make changes in 'cost price'. So I want to take 'cost price for that item Is there any ? Or I should count again everytime i need 'cost price' ? Thanks before for the answer - setiaji - [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] AX-FRX: Dimension Wizard
Hi everyone, We have an account structure of -, when I run Axapta Dimension Wizard for FRx it gives me Compliance Error: - is invalid character . History: I had imported COA from xls in AX, its giving this error on only imported records but if I manually enter the account with same structure code it works fine with that account. Please suggest some solution if anyone had faced the same problem. Waiting for prompt reply. Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Misc. charges and PO in different currencies
Hi , Does AX support multi-currency handling in misc. charges process? I want to create PO and invoice in US$ but the misc. charges should be calculated in different currency on invoice amount . When I create PO in US $ it does not allocate auto misc. charges on that PO but if both PO and misc. charges are of the same currency then it process correctly. Please let me know if I am missing some step. Secondly is there any proper report available of Misc. Charges? Because I could not found any. Regards, Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Uploading Opening Balances
Hi everyone, I had imported the openings without using any 3rd party tool. AX provides the facility to import and export excel sheet from the system. We can get the tables by right click (setup) on any form and then can import or export those tables .(Administration PeriodicData export /import Excel Spreadsheets) For GL and vendor balances use following tables: LedgerJournaltable LedgerJournalTrans For customer balances : CustinvoiceLine Custinvoicetable Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of vivek sharma Sent: Thursday, May 24, 2007 9:39 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, It is better to talk abt Atlas why dont we do it only only in Axapta withoutAtlas can u let me know how we can do it??? I am also new pls help me out... Regards Vivek Steve Wright [EMAIL PROTECTED] mailto:steve%40globesoftware.com.au wrote: Hi Subbu Sorry to hear about your support issues. Atlas was developed for AX 2.1 and supports 2.5, 3.0 and 4.0. Next Innovation have requested support for your permission issue from us yesterday. Your import definition can have a user group or ax user id assigned to it, only users in this group (or specific userid) can then use the import. Security needs to be placed in AX at a table level and not a menu level. The thing to remember about Atlas and AX security...all access to AX is controlled by AX security keys, the product itself does no database access itself. If your ax permissions do not allow it (updating, reading) then you will see the normal insufficient access rights error. I will correspond with Next Innovation more on this. Re:loading external item descriptions getting confused about zip codes...forward screen pictures to Next Innovation or our support desk [EMAIL PROTECTED] mailto:support%40atlasxl.com.au Regards Steve. Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Subrahmanyam,Mamidi Sent: Thursday, 24 May 2007 11:59 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Uploading Opening Balances Hi Steve, AtlasXl is really a pain as I have been having. FIrst one is, no good support from next innovation. Second thing is: it does not work properly with Ax4.0. I tried to load Item external description, it just looks/points to zipcode. One and foremost thing is, it does not use Axapta security groups and permissions. For example, I have given limited permission to a user. The user is still able to insert/update all the listed main tables via atlas xl Login This disappointed me a lot.. Or just data export wise, yes its good..but for just data import , if the std import does not support my requirements, I rather prefer to write scripts using X++... All I wanted to say is VERY BAD support... I thought of sharing my exp...for atlasxl with Ax4.0. I hope my comments can be taken in a friendly manner! thanks, subbu Steve Wright [EMAIL PROTECTED] mailto:steve%40globesoftware.com.au mailto:steve%40globesoftware.com.au wrote: Use General Ledger general journal or all opening balances. Step 1. For GL, bring in balances per period per account (so you can use AX for prior period comparisions). Step 2. For customers, one line in the journal per open invoice (the offset account is your customer control account in the GL). The control account is used as the offset so the net effect on it (the control account) is zero. It needs to be zero as step one (above) has the correct balance in it already. Step 3. For vendors, one line in the journal per open invoice, the offset account is your vendor control account) Try using www.atlasxl.com.au It allows you to import AX journals from Excel. Get your data from the old system into Excel and then use Atlas xl to create and import the AX journals. Atlas xl handles number sequences and validation for you. Regards Steve From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Hardees Buff Sent: Wednesday, 23 May 2007 8:16 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Uploading Opening Balances Hi, I am into my first implementation of AX. I need to upload GL opening balances, Customer Balances and Vendor Balances to be transfered into the system for the first time. Can anyone help me on how to do
RE: [Axapta-Knowledge-Village] AXAPTA Implementation
You can download Axapta test company from partner source . Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Naeem Sarwar Sent: Thursday, May 03, 2007 1:29 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] AXAPTA Implementation hi guyz, i need little help of you ppls that I've downloaded AXAPTA 4.0 from somewhere. and I've installed it as well. now i don't find any test or training company in AXAPTA? how would be that possible... 2nd as we have outsourced this project to vendor so what would be the best approach to get it implemented within budgets and time lines. I've another problem but i will speak about it later. thanks and waiting for your help Naeem Sarwar Saudi Arabia [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Invoice arrived before PO received
We cannot link an invoice to the PO , if we book invoice before receiving . But I think you can achieve this through work around like: Step1: Record invoice though Invoice Journal , where you can Cr Payable Dr- Invoice items not received Step 2: When you will post Packing Slip it will Purchase Un-invoicedDr Purchase Un-Invoice OffsetCr Step 3: Then you will Post it to Invoice and it will Purchase Un-invoicedCr Purchase Un-Invoice OffsetDr PayableCr InventoryDr Now you can reverse your Step 1 transaction : Go to Vendor Form , press Transaction button and select Step 1 transaction and press Reverse Transaction button . Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Le Quyet Thang Sent: Wednesday, May 02, 2007 12:14 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Invoice arrived before PO received Hi Khue, Thank you for your reply. I know this way, but if I use Invoice journal or Invoice Register, I cannot see the connection between Invoice and Packing slip. If I use the normal way, I can see in Inquery both Packing and Invoice posting, but if I use your way, how can I check the posting and connection. Please show me how to check. Thanks. kbi kbi [EMAIL PROTECTED] mailto:hsvkbi%40yahoo.com wrote: Hi Thang, You receive invoice but not yet paid, correct? Because you may want to check your goods before paying money to the customer. Then: 1. When received Invoice 1st May: Dr Account Payable -- Cr Unvoucher Invoiced Can you use AP/Payment/Invoice Journal or Invoice Register 2. When PO goods received 4th May: Dr Unvoucher invoiced -- Cr Inventory Received You can post your PO to packing slip Hope this help. Khue - Original Message From: Le Quyet Thang [EMAIL PROTECTED] mailto:lethang293%40yahoo.com To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Wednesday, May 2, 2007 11:59:54 AM Subject: [Axapta-Knowledge-Village] Invoice arrived before PO received Hi all, If my company received Invoice before goods received, how can we solved because accountant want to record: 1. When received Invoice 1st May: Dr Account Payable -- Cr Unvoucher Invoiced 2. When PO goods received 4th May: Dr Unvoucher invoiced -- Cr Inventory Received Similar when we deliver SO Invoice before shipping goods. Please help me how to resolved it in Axapta. My previous system has seperated screens recording for each step: PO Received, Invoice and Payment and we can matching each step later depend on which step arrives first . Thanks in advance, Thang zeno zoe dynamics0309@ yahoo.co. uk wrote: Print an Performa invoice, Untick the posting button while posting which would not create a Financial entry. - Original Message From: Khurram Zaki [EMAIL PROTECTED] com To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Sent: Sunday, 15 April, 2007 12:43:43 PM Subject: [Axapta-Knowledge- Village] Reciept/Invoice for Customer Prepayment Hello Guys, My client recieves advance payments against their SO sometimes even before the SO is created in the system. They wish to issue a reciept or invoice for that amount. I could not figure out how to print that either from Payment Journal or SO. Can anyone help me out in that. Cheers! Khurram [Non-text portions of this message have been removed] _ _ _ _ _ _ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers. yahoo.com/ [Non-text portions of this message have been removed] - - --- Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Serial numbers as Bar code
Hi everyone, We want to use serial numbers as a Bar code . If anyone can share his/her experience in this regard. Do we need customization to achieve this task? Because on master level we can assign multiple bar codes with each item but at the time of sale / purchase how can we pick ten bar codes against 10 quantity ? Regards, Faiqa [Non-text portions of this message have been removed]
RE: Re: [Axapta-Knowledge-Village] Inventory OBs
Thanks Hemant and Khue. Now its working perfectly . Actually I didn’t know that it picks dimension number from number sequence setup. I was not giving it proper dimension id because of which it was generating various errors . Ya Hemant, I know that we shall be careful while entering inventory OBs as we also import GL OBs because of which it can double the inventory balance. This was also a reason of using Movement journal , where we can give an “Inventory Clearing offset account” . Regards, faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Hemant Kumthekar Sent: Tuesday, February 27, 2007 12:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: Re: [Axapta-Knowledge-Village] Inventory OBs Hi, If you are importing the Opening Balance using P/L journal, then you just need to load the proper InventDimId. Make sure that you have the InventDimId created / loaded in AX. Do you have Config/Size/Color and Storage Dim combinations like Warehouse/Location/Batch/Serial you need to give that information to help you out or guide you properly. I have been using P/L journals to load Opening Balance for last 5 years, and I had done with all dimension combinations of Config/Size/Color/Warehouse/Location. But also you need to understand that you should not have a double dip when you are importing your GL balances and your Inventory Balance will be one of your GL entries to be imported also. So take care that you don't have Inventory G/L account affected becuase of P/L journal load and then you also have G/L import which may have a Inventory G/L balance as a part of import. Hemant K - Original Message From: 江华 [EMAIL PROTECTED] mailto:jhuaweier%40163.com To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Monday, February 26, 2007 12:54:13 AM Subject: Re:Re: [Axapta-Knowledge-Village] Inventory OBs Agree with Khue Trinh's comments. John ÔÚ2007-02-23£¬kbi kbi [EMAIL PROTECTED] mailto:hsvkbi%40yahoo.com дµÀ£º Hi Faiqa, I always use PL for import the opening balance not sure that you use Movement journal to have integration with GL on your OB import. INVENTDIMID problem: I think can you import data into InventJournalTable, InventJournalTrans... Then you can write a small job to read through the inventJournalTrans. For each transactions, you can check if there is a linked record in InventDim table by using the method: InventDim::findOrCreate(...) The reason I don't put full sample code here because I don't know how many inventory/item dimension you have (size, color, configuration, warehouse, location...) for your inventory transaction. This will help you to create record in InventDim table. then you can postyour inventory journal to get opening balance. Hope this help Thanks Khue Trinh - Original Message From: Faiqa Khushi [EMAIL PROTECTED] mailto:faiqa.khushi%40m-consultants.com To:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Sent: Wednesday, February 21, 2007 8:00:26 PM Subject: RE: [Axapta-Knowledge-Village] Inventory OBs Thanks David, but in Trade and logistics manual (Chapter 6) its written that in movement journal we can select offset ledger account and this journal is used to change prices and to bring opening inventory balances during system setup. So I think Movement Journal is the proper way to enter Inventory OBs. Secondly even if I move from PL journal , I think I will still face this issue because InventDim table also get involve in that journal. PLEASE GUYS , IF ANYONE CAN SUGGEST SOMETHING TO RESOLVE THIS PROBLEM. Regards, Faiqa From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com] On Behalf Of Bonk, David Sent: Wednesday, February 21, 2007 5:38 PM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com Subject: RE: [Axapta-Knowledge- Village] Inventory OBs Faiqa; This does not answer your specific question but when we imported inventory OBs we brought it in through the Profit and loss journal and had none of the problems that you mention. You obviously will have other issues to consider such as the PL journal creates GL entries however from the inventory perspective; it worked well. David _ _ __ From: Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com [mailto:Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com ] On Behalf Of Faiqa Khushi Sent: Tuesday, February 20, 2007 6:31 AM To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com mailto:Axapta- Knowledge- Village%40yahoog roups.com Subject: [Axapta-Knowledge- Village] Inventory OBs Importance: High Hi everyone, I am facing an issue while importing inventory OBs in Movement Journal. I am importing records in InventJournalTable, InventJournalTrans and InvenDim. It imports
[Axapta-Knowledge-Village] Inventory OBs
Hi everyone, I am facing an issue while importing inventory OBs in Movement Journal. I am importing records in InventJournalTable, InventJournalTrans and InvenDim. It imports the records successfully in inventjournaltable and inventjournaltrans , but in invendim it generate errors against many records that the record already exist. When I check that record in invendim table using query analyzer , there wasn't that record against which it generate that error . Can anyone explain that how it generate InvenDimID for each record and can we make our own invendimid or there is some logic behind generating this id ? It would be great if someone can write the steps of importing inventory OBs into the system. Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] getting error in Daily journal
Hi everyone, I am importing transaction in Daily journal of GL. After importing transactions I got same error against all transaction. I have attached the screen shot for your reference . Please suggest something to resolve it. Regards, Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Inventory OBs
Thanks David, but in Trade and logistics manual (Chapter 6) its written that in movement journal we can select offset ledger account and this journal is used to change prices and to bring opening inventory balances during system setup. So I think Movement Journal is the proper way to enter Inventory OBs. Secondly even if I move from PL journal , I think I will still face this issue because InventDim table also get involve in that journal. PLEASE GUYS , IF ANYONE CAN SUGGEST SOMETHING TO RESOLVE THIS PROBLEM. Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Bonk, David Sent: Wednesday, February 21, 2007 5:38 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Inventory OBs Faiqa; This does not answer your specific question but when we imported inventory OBs we brought it in through the Profit and loss journal and had none of the problems that you mention. You obviously will have other issues to consider such as the PL journal creates GL entries however from the inventory perspective; it worked well. David From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Faiqa Khushi Sent: Tuesday, February 20, 2007 6:31 AM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory OBs Importance: High Hi everyone, I am facing an issue while importing inventory OBs in Movement Journal. I am importing records in InventJournalTable, InventJournalTrans and InvenDim. It imports the records successfully in inventjournaltable and inventjournaltrans , but in invendim it generate errors against many records that the record already exist. When I check that record in invendim table using query analyzer , there wasn't that record against which it generate that error . Can anyone explain that how it generate InvenDimID for each record and can we make our own invendimid or there is some logic behind generating this id ? It would be great if someone can write the steps of importing inventory OBs into the system. Regards, Faiqa [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]
[Axapta-Knowledge-Village] Importing Free Text Invoice
Hi everyone, I am facing issue in free text invoice import. Its not importing Address field against customer accounts. In CustInvoiceTable, in Customer Account field I entered customer account and didn't add anything in address field because it should bring the address detail from customer master. But it not working in that way. Can anyone guide me if I had missed something? Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Target Customers
Is there any way to setup customer contract information in AX? We want to give incentives to our customer after meeting their targets on the base of : . On Set Item Qty/ Periodic . On Item Groups Qty/ Periodic . On Only Value/ Periodic . On Only Qty/Periodic Regards, faiqa f [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Misc. Charges as Landed Cost
I studied in Logistics 1 that we can use misc. charges setup for landed cost as it increase the item cost. I follow the steps written in the manual. During setup of misc. charges code it asks for posting setup in which I pick item in debit and a ledger account in credit. But its not changing item cost with this scenario but it work well if I select item in Debit and vendor/customer in Credit. But in that case it credits the purchasing vendor which we don't want as we need to credit third vendor e.g. insurance vendor. Kindly also pass on some knowledge about Posting dropdown option available in account payablesetupmisc. ChargesMisc. Charges Code . Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Item physical dimensions
In item master window ,what unit of measure it use to save item height , width and depth and in pallets setup with pallet type? Regards. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM
Its working now J Thanks David. Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Probst Sent: Wednesday, January 24, 2007 2:33 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM Have you tried running the synchronization job in periodic/update/Synchronize customer and vendors to relation? The synchronization in the checklist is just the database synchronization. Best regards David Probst Program Manager From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Faiqa Khushi Sent: 23. januar 2007 08:36 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM Thanks david n Arijit for your replies. Actually , initially I imported customer and vendors into RM/PM but it didn't show me those customers and vendors in CRM. So I thought I will have to come from CRM if needs to have them in CRM. If we enter customer and vendor manually through customer /vendor forms it automatically synchronize these tables with Business Relation form but its not doing this with excel import. Can anyone explain if I need to run any synchronize process after importing into vendor/customer tables? Because I have already tried Synchronize function available in checklist but its not showing those customers in Business Relation formL Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com] On Behalf Of David Probst Sent: Monday, January 22, 2007 8:32 PM To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM Yes you add them as a relation type and you can convert them into Customer or vendor types. In 4.0 dependent on whether you have enabled it in the CRM parameters You cannot import them into CRM directly as customers or vendors, you could import them as relation types and then convert them, however it have to be done manually for each one, so it may make more sense to import directly into the customer/vendor tables. They should then be synchronized automatically into the business relation table. Best regards David Probst Program Manager This posting is provided AS IS with no warranties, and confers no rights. From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Arijit Basu Sent: 22. januar 2007 13:59 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Customers and Vendors in CRM You can add Customers n Vendors directly in the AP/AR Modules. Then you can sync ur Business Relations Table which will show these Customers n Vendors. On 1/22/07, Faiqa Khushi [EMAIL PROTECTED] mailto:faiqa.khushi%40m-consultants.com mailto:faiqa.khushi%40m-consultants.com mailto:faiqa.khushi%40m-consultants.com mailto:faiqa.khushi%40m-consultants.com wrote: I want to add customers and vendors through CRM . Do I have to add them as prospect initially and then convert to vendor / customer using Functionconvert to vendor buttons? Please guide me if there is any other way out for this. Can I add customer and vendors directly through excel sheet in CRM? If yes, then how will it synchronize it with RM/PM tables? Regards, Faiqa [Non-text portions of this message have been removed] -- Arijit Basu [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] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM
Thanks david n Arijit for your replies. Actually , initially I imported customer and vendors into RM/PM but it didn't show me those customers and vendors in CRM. So I thought I will have to come from CRM if needs to have them in CRM. If we enter customer and vendor manually through customer /vendor forms it automatically synchronize these tables with Business Relation form but its not doing this with excel import. Can anyone explain if I need to run any synchronize process after importing into vendor/customer tables? Because I have already tried Synchronize function available in checklist but its not showing those customers in Business Relation formL Regards, Faiqa From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David Probst Sent: Monday, January 22, 2007 8:32 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Customers and Vendors in CRM Yes you add them as a relation type and you can convert them into Customer or vendor types. In 4.0 dependent on whether you have enabled it in the CRM parameters You cannot import them into CRM directly as customers or vendors, you could import them as relation types and then convert them, however it have to be done manually for each one, so it may make more sense to import directly into the customer/vendor tables. They should then be synchronized automatically into the business relation table. Best regards David Probst Program Manager This posting is provided AS IS with no warranties, and confers no rights. From: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com ] On Behalf Of Arijit Basu Sent: 22. januar 2007 13:59 To: Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Customers and Vendors in CRM You can add Customers n Vendors directly in the AP/AR Modules. Then you can sync ur Business Relations Table which will show these Customers n Vendors. On 1/22/07, Faiqa Khushi [EMAIL PROTECTED] mailto:faiqa.khushi%40m-consultants.com mailto:faiqa.khushi%40m-consultants.com wrote: I want to add customers and vendors through CRM . Do I have to add them as prospect initially and then convert to vendor / customer using Functionconvert to vendor buttons? Please guide me if there is any other way out for this. Can I add customer and vendors directly through excel sheet in CRM? If yes, then how will it synchronize it with RM/PM tables? Regards, Faiqa [Non-text portions of this message have been removed] -- Arijit Basu [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]
[Axapta-Knowledge-Village] Customers and Vendors in CRM
I want to add customers and vendors through CRM . Do I have to add them as prospect initially and then convert to vendor / customer using Functionconvert to vendor buttons? Please guide me if there is any other way out for this. Can I add customer and vendors directly through excel sheet in CRM? If yes, then how will it synchronize it with RM/PM tables? Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Inventory Dimensions
We are in a process of data collection and basic AX setup. Currently we don't know which inventory dimensions we should make active for few items. So we plan to activate all dimensions and will change it afterwards if desire. Can we do this? Because I have seen if once we assigned a dimensions to an item and made any transaction against those items then we cannot edit or change the dimension groups with that item. Please also explain Edit Dimension function available with item master. Regards, Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Import Addresses in AX
How do we import data into the Lookups from Excel sheet? I am facing an issue while importing addresses in AX. I have define Address Format in Basic module and assigned this format to my country. It imports the data successfully but don't show address according to defined attached format. But when I select the country using lookup it format my address properly . Please reply me urgently if anyone else had faced this issue and can guide me to resolve it. Regards, Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Inventory Journal Number Sequence
Yes , you can have different number sequence for different journals. Go to Inventory managementsetupJournalsJournal Names, Inventory and assign different number sequence to different Journals. You can define unlimited number sequences in BasicsetupNumber Sequence and can use in different scenarios. I hope, I answered your question correctly :S Regards. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of viju27_kumar Sent: Thursday, January 18, 2007 5:31 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Inventory Journal Number Sequence Hi All, We have a journal number sequence for an inventory (Ex:IJ-07) which has been set in the basic- setup- Number Sequence- reference. can i have a different number sequence for different journals like mov,counting,transfer.. Regards, Vijay [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Virtual Company
Thank you Faisal. It workedJ Regards. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Faisal Hussain Sent: Thursday, January 18, 2007 12:14 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Virtual Company Step 1. Create new Company Account from Administration - Company Accounts Step 2. Create Table Collection in AOT and drag-n-drop the required shared tables. Step 3. Create Virtual company account from Administration - Setup - Virtual company accounts, in the company account tab select the newly created company, in the table collection tab select the required table collection you have created. Faisal Hussain --- In Axapta-Knowledge-Village@yahoogroups.com mailto:Axapta-Knowledge-Village%40yahoogroups.com , Faiqa Khushi [EMAIL PROTECTED] wrote: How do we setup Virtual Company in Axapta? Please write the exact steps . I read somewhere, it helps us to share data between different companies . Can anyone please explain it with some example? Regards [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Virtual Company
How do we setup Virtual Company in Axapta? Please write the exact steps . I read somewhere, it helps us to share data between different companies . Can anyone please explain it with some example? Regards [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Customer Card
We want to use customer coding like a credit card number of 16 digits because we want to give a card (like a credit card)to our customers. If we cannot get this from Customer Id then is there any other way to save the credit card detail of a customer in Customer Master. Regards [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] How to use Dimension Wizard
Hi, How can we add new dimension in GL . Dimension Wizard is available with Dynamics Axapta but I want to know the prerequisites and exact steps we shall follow to create a new dimension. I tried it by using wizard but got different errors. If someone has already done this then please list the exact steps require to establish new dimension. Regards. [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] The different between accounts in inventory posting and item group
Hi andreas , If you have assigned accounts with item groups in Inventory Posting window , then it will also be visible in item group window. If you have assigned accounts with All or Table options in posting window then you can also assign different accounts to item groups from item group window. During transaction it will initially pick the accounts assigned with item groups and if not found then will move for other option. I hope I answered your question: S I am new in Axapta hence don't keep it as final commentsJ wait for experts. Regards rom: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of andreas gunawan Sent: Thursday, December 14, 2006 6:21 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] The different between accounts in inventory posting and item group Dear All, I can't find out the different between accounts in inventory posting and item group window. The inventory posting can be found in the customers, customers group, vendors, and vendor groups' forms. Meanwhile in item group window, there are sales order, purchase order, ., and set up. Could you pls tell me ? I appreciate your answer so much. TIA Rgds, - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Creating new company accounts
Go to AdministrationCompany Account and add new line (Ctrl+N)and add new company. After creating new account go to fileOpenCompany and open your require company . it will be with empty database. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of viju27_kumar Sent: Wednesday, December 13, 2006 9:20 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Creating new company accounts I am going to have one more company..I want to create one more company account in axapta with the same application but empty database.Can any one help me in this regard. [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Not getting Line Items detail on different documents
Hi, I am not getting the line items detail while taking a print of PO, Invoice, SO, Packing/Picking Slips. Can anyone help me about this immediately? Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Landed Cost in Axapta
How Axapta deals with landed cost? Is there any feature available through which we can add landed cost amount in item cost? Faiqa [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Difference between Sales Order and Sales Journal
What's the difference between Sales Order and Sales Journal? Because, it opens the same windows for both activities. Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Re: Trade Logistics Training Material
Khurram, Please send me those Docs and PDFs / Training Material on [EMAIL PROTECTED] Regards, Faiqa -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Khurram Zaki Sent: Wednesday, December 06, 2006 12:13 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Re: Trade Logistics Training Material Hello guys, I got this breakup of TL paper when I was preparing for certification (and yes I cleared :) ) Maybe this is of some help to someone. If anyone needs the training material, I have some DOCs and PDFs as well, drop me a line. In my view, exam tests more for practical knowledge as compared to book knowledge, so its better to keep your practice up to date as well. Cheers! Khurram *Sales and purchase orders 25%* Set up and use of reservations and registration; Details and use of the different sales order types; Demonstrate understanding of various purchase order functionality (miscellaneous charges); Advanced sales order features (returned items, over /under, credit limits, integration with the accounts receivables, order status and types); Advanced purchase order features (returned items, creation from a sales order, updates and status); Sales order subscriptions and sales order parameters; Understand features of the sales order form; Configuration and differences between manual and automatic reservations; Customer and vendor set up used by inventory management; Backorder lines in sales orders; Set up of calculation of commissions *Trade Agreements 13%* Forecast future sales and purchase expectations; Know the different types of trade agreements and how to set up and activate trade agreements; Set up discounts and know how they are calculated and applied; Set up of multi line discounts, how they are calculated and posted; Implement the use of supplementary items *Bills of Material 15%* Set up and consequences of the BOM components' line type field; Understand the benefits and differences of working with the BOM designer; Product configurator, item configuration; Understand how the BOM price calculation is performed, the profit settings used, and how to transfer the price to the sales order line; Creation of BOMs, BOM versions and BOM lines *Inventory 47%* Set up and use of item groups; Setup and integration of inventory management with ledger accounts to track the financial aspects of inventory; Understand the purpose and process of adjusting and closing Inventory and the available reports; Setup of items, item coverage and item coverage groups used with master planning; Use of advanced item settings to control order quantity, automatic price updates, etc; Understand the issue and receipt status values assigned to inventory transactions, distinguishing between physical and financial inventory; Know how the total available on-hand inventory is calculated; Use of number sequences in the TL module (serial numbers, batch numbers, order numbers); Calculation of cost prices, item consumption, inventory values and recalculation based on the inventory model group settings; Setup inventory dimension groups and their impact on how items are stored and how they control items are managed in inventory; Use of the unit conversion form to establish conversions; Understand the purpose and mechanics to use the inventory journals (profit and loss, transfer, BOM, movement); Create the setups and parameters for managing quarantine items; Understand and use serial and batch in inventory - On 12/5/06, TAHIR AZIZ [EMAIL PROTECTED] wrote: I will apreciate if somebody will send me some examination preparation and sample questions. Thanks Tahir faiQa [EMAIL PROTECTED] faiqa.khushi%40m-consultants.com wrote: Hi Rasika, can you please mail me the Material on TL. Thanks faQ -- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogro ups.com, maneesh_jain [EMAIL PROTECTED] wrote: Hi, I have E-academy courses for Trade Essentials 3.0 and Logistics Essentials 3.0. Are they any good for the TL exam preparation? Thanks, Maneesh --- In Axapta-Knowledge-Village@yahoogroups.comAxapta-Knowledge-Village%40yahoogro ups.com, lars_kjaersgaard lk@ wrote: Hi Rasika, I am very much interested in TL exam materials. I would be very grateful If you would mail me the material. Maybe I have som materials you are interested in? We can talk about it. Best regards Lars Hi, I am Rasika from Sri Lanka. I did TL exam resently and got through. If you still searching for the materials I can send it. Pl. write to me if you want it. wbr, Rasika - -
RE: [Axapta-Knowledge-Village] Re: Some Questions about Axapta Dynamics
Excellent Christoph, thanks a lot for your reply. Now can you please tell me that does Axapta support National Accounts as we can have a separate module of National Accounts in GP? Regards, Faiqa _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of cdlmalherbe01 Sent: Tuesday, December 05, 2006 9:23 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Some Questions about Axapta Dynamics Hi, 1. Max length of account number --- Out the box, the max account length in 4.0 is 20 characters. You can increase/decrease this. 2. Account segments without Dimensions -- Dimensions play the same role as segments in GP, but with a lot less overhead. Even though you CAN segment the ledger account string to appear like GP does, don't. As an e-GP consultant I can assure you that if you try to recreate a GP-like COA, YOU AND YOUR CLIENT will regret it once you realise the power unlocked by using Dimensions. 3. Renaming Dimensions -- You can rename dimensions and add additional dimensions, if you are licenced to do so. 4. Migrating data - Migrating data is slightly more cumbersome in AX that GP(no Integration Manager). Start by playing with Excel imports. Regards, Christoph Malherbe --- In Axapta-Knowledge- mailto:Axapta-Knowledge-Village%40yahoogroups.com [EMAIL PROTECTED], faiQa [EMAIL PROTECTED] wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? how can we enter Opening Balances of GL, Customer, Vendor and Inventory in Axapta Dynamics? Regards, faQ [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Account Length
Thank you all for your coordination and help. Yes I know we can use Adjust Global to define Account Length but I want to know what maximum length Axapta support for defining Ledger Accounts. As Agu said it could be 8000 characters. Apart from customization, I just want to know that how much flexibility Axapta gives us while defining our ledger accounts. Regards, Faiqa _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Arijit Basu Sent: Monday, December 04, 2006 9:31 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Account Length Hi, In case u wanna change the AccountNum Length, Please use the Adjust Global Types option from the Installation checklist. Its better that way. As for Segregation of Accountnum in GP, can u please elaborate a bit. I dunno GP :( Cheers On 12/4/06, Agus Riyadi [EMAIL PROTECTED] mailto:agusacil%40gmail.com com wrote: Hi Faiqa, You can enlarge the string width of Ledger Account through AccountNum Extended Data Type ( I don't know whether Gread Plains use the same concept of EDT or not - never use it). It is converted into varchar data type in the physical database which means you can set it to maxium of 8000 characters width as documented in SQL server ( CMMIW). I have no insight of your second query. Regards, Agus On 12/1/06, Faiqa Khushi faiqa.khushi@ mailto:faiqa.khushi%40m-consultants.com m-consultants.comfaiqa.khushi%40m-consultants.com wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? Regards, Faq [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] -- Arijit Basu [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] Grouping Customers
Does Axapta Dynamics support National Accounts (i.e. grouping customers in parent child relation)? Faiqa [Non-text portions of this message have been removed]
RE: [Axapta-Knowledge-Village] Account Length
Thanks Subbu for your help. It was really good to know in detail. In Adjust Global, Axapta pick 20 as default length but we can give more in that field. What is the maximum length we can define in that field and Axapta can support without moving to customization. I am not financial person but will try to explain: S.in GP, we define our accounts using segments (e.g. 10-10-00-1020 , 20-10-00-1020 )and can get reporting on the Segments basis. While looking in the test company of Axapta Dynamics I haven't seen such kind of things , there it is taking number sequence while defining accounts. I hope I answered your confusion: S Regards, Faiqa _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam,Mamidi Sent: Monday, December 04, 2006 8:24 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] Account Length Hi Faiqa, 1. if you want to change the account lenght for all companies, you can change the EDT of accoutNum ( highest parent ) properties in the AOT 2. if you want to change per company, you can admnistration - setup-adjust global variables etc etc...you can set the length over there...I guess 20 is the length We extended.for accoun and projeID...but you can always map back to the char variable in SQL( 1000 chars?) Caution: Axapta suggests you that you cange the lengths with proper justification before you load the data into tables or it will lead to data inconsistancy or values will not be fetched in queries.for more info, you can browse the forum for previous posts. Yes. you can rename the default dimensions ( financial??) by changing the lable in the EDT or ENUMs..we renamed configID too... And what is the Seggeration query in GP you are talking about? what does in do in reporting? any insight will be helpful to see if that feature available in axapta. I guess it should since GP is also a baby from Microsoft as Axapta good luck, take care, Subbu Agus Riyadi [EMAIL PROTECTED] mailto:agusacil%40gmail.com com wrote: Hi Faiqa, You can enlarge the string width of Ledger Account through AccountNum Extended Data Type ( I don't know whether Gread Plains use the same concept of EDT or not - never use it). It is converted into varchar data type in the physical database which means you can set it to maxium of 8000 characters width as documented in SQL server ( CMMIW). I have no insight of your second query. Regards, Agus On 12/1/06, Faiqa Khushi faiqa.khushi@ mailto:faiqa.khushi%40m-consultants.com m-consultants.com wrote: Hi , I am new to Axapta Dynamics, previously I worked over Great Plains Dynamics. Please help me about few queries: How much maximum Ledger Account length we can define in Axapta? Can we segregate our account in parts while generating reports from Axapta as we can do in GP using Segment features? Please reply me apart from using Dimensions. Can we rename the default Dimensions? Regards, Faq [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] - Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
[Axapta-Knowledge-Village] National Account feature in Axapta
Does Axapta Dynamics support National Account feature? If yes, please explain? Regards, Faq [Non-text portions of this message have been removed]