-
line number creation
hi all, Actually i am trying to insert the records into the customised Table. which is in the form of Header and line Format. while i am inserting a New record in the Line Table It is Taking Negetive line Numbers. but Line No is an extended Datatype and we set the Property of AllowNegetive to No. Let me know how to…
-
Importing excel file data into Axapta tables
Hi experts, Can someone have a code that can import excel data to a specific table with specific field. I would greatly appreciate it if you can share it with me. Thanks in advance.. Mike
-
Exporting to excel
Hi experts, Is there a functionality in AXAPTA 3.0 that you can export directly the data from the tables in excel. And can you select some fields in the table and not all fields. Tnx Mike
-
Help Pls.. AXAPTA Programming books and manuals
Hi guys, We will implement AXAPTA 3.0 for the first time here in the Philippines and according to Microsoft we are the first ever client here to be using AXAPTA ERP system. In line with this I am looking for a good manual and training materials for development. Can anyone Pls share the Manuals for Axapta Development…
-
Syntax of Edit method
Hi All I want to access a field from a table on my form. The table is not in the form's data source. Can anyone tell me how can i write an Edit method to display and edit that field on my form. Thanx in advance Rashi
-
Code missing??
Does anyone have an idea why the code from the method : blockRemoveofApproval() (which is used in two classes BOMRouteApprove and BOMRouteVersionApprove ) is missing by default from Axapta and it has no return in it when it is expected to return Yes, No. Please help cause it issuing a terrible error. That's its code NoYes…
-
Warning 163 + Event Viewer
Hi, In the event viewer of my AOS server there is a warning 163, The content are as follows : "Object Server prod : SQL Diagnoses : Detected protocol SQL 's' was not recommended for a multisession use of Microsoft Business Solution-Axapta." I think it's for this reason I have a problem on my AOS Server. He can't start…
-
two master plan strategy
I'm so confuse about this principle. #-o How does it work in real situation? And what's it different from dynamic plan with regeneration mode for first plan and net change mode for updating any change? Regards, Rongrit
-
Changing the Cloud picture in the Main Menu
Hi guys, Can anyone know how to change the logo in the main menu of the axapta. I have tried the other post in which I just copy a "CompanyLogo.bmp" in the ...\share\include folder but it does not work for me.
-
Report count quantity
Hi, I have create a report, and I would like count a quantity of item. Is necessary it to create a execute section and use a "while select count..." ? Thanks for your help.
-
Company Logo
Hi, I'm trying to add the company logo to the Main Menu in axapta. I followed the instructions given in the Developer's guide but still could not succeed. I tried it in two-tier. This is the following instructions given in guide. //Add company logo to the Main menu When the Main menu opens, it displays the name of the…
-
Anyone knows how to use Axapta Business Conector with JAVA?
Hi, Have anyone tried to use the Axapta functionality exposed throught Bussiness Connector using JAVA? This means using COM objects from Java. I have already used these COM objects from .NET (it's easy) but from Java is another history... There is any who can help me? Anyway I will try it and if any if interested I will be…
-
How to copy Price Group Trade Agreements
Hi, I want to be able to copy the Trade Agreement from Price Group A to Price Group B, in much the same way as you can copy "normal" trade agreements (ie. those without price groups attached). The only "Group" copying I can see is for Customer Group which is no use to me. Is this possible ?
-
How to get the number of the selected records in a grid
Hi there does any body know how to get the number of selected records in a grid. For example CustTransOpen_ds.mark() does not return it. Please help. I would like to check if the number is > 1 so that i can throw error
-
Checkbox issue
Hi there i have in a form with 2 datagrids one with invoices and underneath a grid showing the lines to each invoice. There is a checkbox infront of every line and i would like when an invoice is checked, the corresponding lines that are displayes below, to have their checkboxes automatically checked when the check box of…
-
String function help
Hi there, does anybody know a functions in X++ like the ones in VB and ASP : Left, Right...i looked at the documentation and i found onli Trim and some converting functions. Thanks in advance :)
-
Page footer problem
Hi there i have a page footer with executeSection method showing it only on the last page of the SalesInvoice report. The problem is that though it is not printing it on every page(it is only on the last page) it keeps empty space on the bottom of every page. Thanks in Advance :)
-
How can I open a document from Axapta?
Hi I am developing a Web based Content Management System and I want to integrate it with Axapta. When I insert a new document I have in a Axapta table the path of the new file inserted on our server. So How can I open a Word, PDF, ... document from Axapta using X++? There is some way to launch a windows command from Axapta…
-
SalesInvoice Report design problem
Hi there i spent hours in looking for a property that makes the body in the SalesInvoice report so long(i mean even if i have one line there are 50 empty and i would like to keep the footer right beneath the last line of body section), Does anybody know which property i how i should set it so that i fix that problem.…
-
Excel format
Hi! I'm quite new with Axapta but already familar with Excel export by code. But there is one probleme for which i can't find any solution - format cells (eg. Font, Size, Style[Bold,Italic,...]....) please provide me any sample code if possible...I already searched the whole Internet without getting any answers on my…
-
Free text invoice problem
Hi there, i added a new field to the CustInvoiceLine table and then i palced it on the CustFreeInvoice form which is under Accounts Recievable->Free Text Invoive. I would like to print on the invoice its content but i'm finding it difficult to understand where and how CustFreeInvoice form passes parameters to the…
-
Language drop down
Hi there i added a new tab on CustInvoiceJour form where i would like to show the field LanguageId from CustInvoiceJOur table and be able to change it from there. I created a group called Setup and drag and dropped the field from the CustInvoiceJOur table to the that Group. The problem is that the field on the form is now…
-
Passing Parameters to Menu Item
How can i pass parameters(possible values from BaseEnumType) to MenuItems so that later according to the value to activate different Report....Please help
-
Relation Between CustTable and SalesTable tables
Hi there, i created new field in the CustTable and a user can fill it in the CustTable form. Well when creating new sales order the user is prompt wheter he wants to transfer the customer details to the order. SInce i would like my new field to be also copied to the SalesTable table, could you please tell me which is the…
-
How can I delete a dataSource previously added?
Hi, when I press a button in the Asset Table form, I execute this code in order to show only the assets with a value of "0" in a table related with the Asset table. I need to add a DataSource to the main DataSource of the form in order that I can filter the assets that have a value of "0" in the field…
-
How adjust an InventTrans programatically?
Hi, I want to adjust the physical transaction produced by a invoiced purch line so can I add an adjustment to the Financial Cost Amount. I can do this in: Invent, Periodic, Closing and adjustment. But can I do this programmatically? and How? Thanks!
-
license
Hi, I'm very new to Axapta and would like to take a look at it's development enviroment. I have it installed and submitted a request on partnersource re:some kind of evaluation license. However, it's been over a week and I'm still waiting for it. Does anyone know of a better channel to take to obtain such a license?
-
Auto-updating AddrRecId while importing flat files (.DAT)
Hi ! , i am currentlu programming a software that generate .dat files which are imported into axapta. At this moment i am working on the importation of the Address Table. So my software generate a correct .DAT files with the corrects AddrRecId which containts the recID's of the customer the adress is belonged. But when i…
-
Fixed lenght field Text file import
Hi everybody! I'd like to create a method to import a text file into a table. The fields in this file has different types of data (int, real, string) and are fixed lenght, with no separators char between the fields. It doesn't seem possible using the read method of an IO class (AsciiIO or BinaryIO, and so on..). Am I…
-
Error in aod file
I copy the axcus.aod file in my application. start Axapta Start Reindex Axapta Ocurred this error: error in the file axcus.aod in the register=20520620 code error=38 the end of the file has been reached How can I solve this error? Thanks