-
Manual COM - Excel
Hello, i am new in this community and the first thing is a question. I am working with Axapta 3.4, and trying to export a report to a Excel file . Does anyone know about a manual of COM for Axapta? Where can i find it? The problem appears when i try to write a value to the sheet, in a sentence like this: cell =…
-
Prevent filter from beeing removed
Hi After posting a sales order, every filter I have set in the sales order form is removed. Could this be prevented in some way?
-
Insert record at a position from code
Hi When I manually add a record in a table it get positioned where the cursor is located, but when I add it from code (with custTable.insert()) it is added at the end of the table. Is it possible to force Axapta to insert a record at a position from code? Thanks in advance!
-
Viewing Marked Transactions for a Customer
I have a very basic requirement. I have a customer who has paid some money. Once I mark the invoices against which the money is received, I post the payment journal. Now later on I wish to report / view the list of marked invoices for any given payment entry. How can I see that? What is the table that stores this…
-
Getting value out of treenode
Hi I created a treeview in X++. I used a formtreedatasource like this: SerComTree = new FormTreeDatasource(this,element.control (control::mytree), fieldnum(MCS_ServiceComponents,SerComID), fieldnum(MCS_ServiceComponents,SerComParentID), fieldnum(MCS_ServiceComponents,name) ); The treeview gets populated just fine. Next I…
-
Good litterature?
Hi! I'm getting lost trying to find some good litterature covering most parts of axapta 3.0. Is there any out there? :shock: Thankfull for all the help i can get! Alveus
-
Where to input the BOM ?
Dear every one, I can't find the BOM input menual in the Axapta 3.0 screen, who can tell me why? :oops:
-
Purchase Order status
Hi, Can some one please tell me how to mark the item that it has been received for a particular purchase order. Thanks in advance. Ps: I i can see the option Receiptlist when clicked on the Post button. i did try it but the status still remain as open Order.
-
Document handling
Hi, Is there a way to change the document handling icon from Axapta toolbar? Thanks.
-
table.setTmpData(Common)......?
Hi All, Can you pls tell me what does mean by the following statement? 1. table.setTmpData(Common) and 2. How to execute Form methods on server side? Can I use server qualifier infront of the form method?
-
Id gets created by?
Hi All, How an Id gets created for a table and its fields?
-
Fixed Asset Transfer from one location to another
Hi, I want to transfer one Fixed Asset from one location to another within the same company. I am not able to locate the transaction anywhere. Can someone help me out please ? I have already seen the Lending Transaction but that does not suffice my requirement. Regards, Kanchan Chatterjee
-
could you tell me what these code mean??thanks.
#macrolib.AviFiles #if.never #define.CurrentVersion(1) #define.version1(1) #localmacro.CurrentList accountID, chequeNum, transDate #endmacro #endif
-
Permissions Building
Were running Axapta 3.0 Im trying to backward engineer user permissions, basically I want to be able to sa: "my table is InventTable, now... which users have access to this table" Im trying to work out permisisons wise, where they are stored. Ive got users and which groups they are in from the tables: SysUserInfo,…
-
Report Wizard permissions
Can anybody give me some advice on setting the permissions for access to the Tools>Development tools >Wizards >Report Wizard functionality. Thanks in advance.
-
Reverse Payment Journal with No Check Numbers
Hello. I have only been using Axapta for a few months as an accountant, not a programmer/developer. Can anyone tell me the best way to completely reverse all transactions in a payment journal that has the payment status of None, no check numbers assigned, but has been posted? :-k
-
Change Join Source at runtime
Hi all Can anyone tell me how can i change the JoinSource property of a form's data source at run time. I want to change the Join Source at a particular event on the form. Thanx in advance Rashi
-
How to checka position on report, during printing
Hi everyone :) I have a problem with a SalesInvoice report :cry: The problem occur when I set up an old model of printer, with tractor beem (a neverending piece of paper). At the begining I write that i checked a size of paper and this case is set up correctly. So the problem is, that I'm printing a list of transaction on…
-
Fixed Assets Tax Depreciation calculation
Dear All, Can anyone explain me how to post depreciation only on Tax layer in Axapta 3.0 without posting it to LedgerTrans table.
-
Import data from one Axapta DB to another
Hi I need to import data to one axapta DB from another axapta DB without importing data in 2-3 tables.. Both databases have the same schema. Any ideas how to do this? Thanks in advance Rashi
-
Error when i try to open Axapta 3.0 with SQL 2005
Hi I am trying to run Axapta 3.0 SQL Server 2005. I created a new Database and changed its compatibility level to SQL 2000. Now when i try to open axapta it closes by giving an error "One or more SQL server variables are unknown" If i change the DB the application runs fine. Can anyone figure out what the problem is? Thanx…
-
few doubts in Axapta..
1. Does Axapta supports replication? 2. Can we debug on server in 3- tier architecture? 3. Can we change object id while importing? 4. What should we do after importing a class object? Is it recompile or synchronize?
-
Excel Import of Chart of Accounts into Axapta
I am trying to import a Chart of Accounts into MBS Axapta using the Data Import Template and Defintion Group. However, I am faced with a typical problem. My Account Codes are like 1000.10 , 11000.20 etc. In Excel even if I format this column as Text column, while importing the data it does not import the data and gives me…
-
Quarantine warehouse
HI experts, I have defined a quaratine warehouse to a main warehouse. Thw main warehosue is configured to have a location while the quarantine warehosue is configured to NO location. when I do PO there is an error stating that there must be an exactly the same location in the Quarantine warehosue as to the main warehouse.…
-
wrong number format
Hi all, I am getting a wrong number format in reports with the 3-tier client since the update to 3.0. When I run the report in a 2-tier client on the object server I get the right format. I already have deleted the AOC files and restarted the server without success. When I change the country settings to US I get the us…
-
Object import
Hi, can somebody please help me and tell me how can I programmaticaly import an object without displaying the oweride dialog? Thanks
-
AOT image
Hi, does somebody know how to change the image of AOT tree node, or how is possible progrmmaticaly lock a node? Thanks
-
new to Axapta, need ur help
hi, Actually I need some info. .... I am totally new to Axapta.... so i want to know about the tech. backround I need to have for it ( do i need to have knowledge about .NET or anything else ) how u find Axapta development ?? please give some feedback to me.... Anuradha.
-
Stock Transfers in MBS Axapta 3.0 - India Localisation
Hi, I need some help in Stock Transfers relavent to Indian Localisation. When a Stock Transfer is made from one warehouse to another, can I transfer the materials at Cost , At Price? In case of stock transfer at cost what are the accounting the entries and in case of Price, what are the accounting entries. Please help me…
-
LocalMacro.CurrentList Question
There is a variable in LedgerBalanceSheetPrint called columnDataList that is getting set to a list of 134 but I can't find where the 134 is coming from. Where can I find where or how this is getting set? Also, can it be expanded? Axapta 3.0 sp3 SQL2000 Thanks, Rick