[development-axapta] Tax Codes

Hello I have a very big problem, I think. In our company we are just starting to work with AXAPTA and we have a doubt. We have 18 branch offices and each office can buy items. This means we have a vendor for 1 or many branch offices. How do we create a sales tax group for this vendor if

[development-axapta] Strange records in table CustInvoiceJour

Hello there, I have come across some strange records in table CustInvoiceJour. These are without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not checked. Also, Refnum is set to Customer. I am only able to track these records ind Table Browser; not elsewhere (probably my skills

[development-axapta] select and query

Hi all; I have a sql statement like Select inventtable where inventtable.itemid==123645 join .. I have a query and i want select statement to fill query, but sql statement is dynamic that, each time i get select, it works on different tables. Note : Select statement is in Axapta

[development-axapta] is there any where to check that a dimension value on inventorytrans

I hope someone can help me, Whenever an inventtrans is created/updated etc I want to check that one of the dimensions is set. This is because I have created an inventory movement report that assumes the dimension is always set but I dont want to have to go round every place in the system and

RE: [development-axapta] Web Service/XML

Try this code, that work for me... and look at the end of the Web Address. real ObtenerTipoCambio(date fecha) { str sfecha; real ntipocambio = -1; WebService ws; ; try { sfecha = date2str(fecha, 321, 2, 3, 2, 3, 4); ws = new

[development-axapta] Looking for eGraph module for Axapta

Hi All, eGraph is a MBS Partner module by MPS Graphics for Axapta that provides an administrative environment for the graphical print industry. I am looking for anyone that has deployed, enhanced, or used the eGraph modules. Please contact me at; c.hoffmann @ cqu.edu.au Chris.

RE: [development-axapta] Strange records in table CustInvoiceJour

I am not sure but are those not updated Free text invoice records??? -Original Message- From: Jens Strandberg [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 15:47 To: [EMAIL PROTECTED] Com (E-mail) Subject: [development-axapta] Strange records in table CustInvoiceJour Hello

[development-axapta] Refresh Form

Hi, I need to refresh a form after an operation. How can I do this? Thanks Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ To unsubscribe from this group, send an email

RE: [development-axapta] Strange records in table CustInvoiceJour

Perhaps from free text journal. // Lars -Original Message- From: Jens Strandberg [mailto:[EMAIL PROTECTED] Sent: 26. august 2004 08:47 To: [EMAIL PROTECTED] Com (E-mail) Subject: [development-axapta] Strange records in table CustInvoiceJour Hello there, I have come across

RE: [development-axapta] Tax Codes

Is the vendor havnig a branch/.office in each city, if so why not create avendor for each and invocie accoutn can all point to one vendor. If vendor only ahs one office but delviers to all the cities etc then you can look at the address table, you can setup axapta to have a tax code for each

[development-axapta] Query with join in X++ code

Hi, I have headdata (Table head) and linedata (table line). Instead of showing all headdata and selecting linedata, I want to show all linedata and select the corresponding headdata. This works fine, I have joined headdatasource to linedata. My problem concerns the filter on my headdata. To

Re: [development-axapta] Create Word document from code

Hi, you could have a look at Tools-Development tools-Wizards-COM Class Wrapper Wizard, check out how things are done in the SysExcel*, SysMicrosoftAgent or SysOutlook* classes, or create your own class in the lines of: (Note: All error and version checking has been left out.) class

[development-axapta] Import Error

hi all, Can anybody tell me how to clear out this error. I got this error when I tried to import some data to production related tables. Actually I have selected all the tables selected on my def group. The error is :- Table reference when importing to table 'Calculation' not specified,

[development-axapta] table views

Can anyone tell me what kind of processing over head there is in using table views? I understand that ax basically creates SQL views in the database but I was wondering if say I join inventrans and inventdim in a view and want to filter by warehouse and a specific item number, will the view

Re: [development-axapta] is there any where to check that a dimension value on inventorytrans

Have a look on inventory dimension group on item card. you can set which dimension you want to be mandatory over there in all over the system. Ta --- James Flavell [EMAIL PROTECTED] wrote: I hope someone can help me, Whenever an inventtrans is created/updated etc I want to check that one

RE: [development-axapta] Refresh Form

suppose the you are on purchTable form and the changes are done in purchTable then you should write purchTable_ds.reread(); purchTable_ds.refresh(); -Original Message- From: Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 09:59 To: 'Development-Axapta

[development-axapta] how to filter data on forms (date and time fields)...

Hi! I'm in need of advice. I have a form and i want to filter data by specifying time limit... for example: show rows that are newer than 25.08.2004 12:00:00. But how can i do that when Axapta holds date and time separated (different types). Ok... i can make a query of my own and filter data

RE : [development-axapta] Refresh Form

Try element.redraw() or refresh the dataSource with ATable_ds.executeQuery(); ATable_ds.refresh(); Steeve... -Message d'origine- De : Alfonso Collados Arroyo [mailto:[EMAIL PROTECTED] Envoyé : 26 août 2004 04:59 À : 'Development-Axapta (E-mail) Objet : [development-axapta]

[development-axapta] Cheque printing

Hi All, We print company cheques using an Epson FX 890 dot matrix printer. We have been having problems with the printer skipping cheques. I have been trawling through the printer settings on wondoze, and have had no luck with the problem so far. Would there be anything in Axapta that could

RE: [development-axapta] How to show container content in the grid

Hi Baran, you can find a sample Classes/SysTableBrowser/showAllFields() this is the class of tableBrowser of Axapta.. This is a part of code, when the field is container : formBuildControl = formBuildGridControl.addControl(FormControlType::STRING,'TableBrowserCon tainer');

RE: [development-axapta] Strange records in table CustInvoiceJour

Thanks Steve - and others, You are correct, those are indeed from a Free Text Invoice. However, I find it very strange that: CustTrans holds 1 record, USD 1,480 (which is correct) CustInvoiceJour holds 1 record, USD 1,480 (which is also correct) BUT CustInvoiceJour also holds 3 records,

RE : [development-axapta] How to show container content in the grid

I don't have much experience with containers but I think you'll have to extract the data yourself to be able to show it on you grid. Have a look at Forms/SysDatabaseLog. Steeve... -Message d'origine- De : Baran Sasmaz [mailto:[EMAIL PROTECTED] Envoyé : 26 août 2004 05:00 À :

Re: [development-axapta] Refresh Form

Try : dataSourceName_ds.executeQuery(); Alfonso Collados Arroyo [EMAIL PROTECTED] wrote: Hi, I need to refresh a form after an operation. How can I do this? Thanks Yahoo! Groups SponsorADVERTISEMENT - Yahoo! Groups Links To visit your group on the

[development-axapta] Exporting/Importing SP1 - SP2

Hi I have a customer with a Axapta 3.0 SP1 application. In this application they have multiple companies, eight, I think. They also have a bunch a Axapta 3.0 SP2 with empty databases. They want to export the different companies (From SP1) to the different Axapta's (SP2). The export is

Re: [development-axapta] table views

Hello James Flavell, , 26 2004 ., you wrote: JF I know this is might be a bit of a black box question given that the DBMS JF can do what it likes but I would like to get any insight (esp for MS SQL maybe QueryAnalyzer can help you? -- Best regards, Max

[development-axapta] Re: Axapta Update

James, Thanks for your help. I'll talk to my partner about that. Lucas! --- In [EMAIL PROTECTED], James Flavell [EMAIL PROTECTED] wrote: Hi Lucas, Depends on how much modifcations you have done and whether you expect you might want to use new features that might come along (of

RE : [development-axapta] how to filter data on forms (date and time fields)...

Check this article on TechNet : http://technet.navision.com/default.asp?MenuFunctionName=EISNewsArticleMenuFunctionType=OutputNEWSID=351 You can do that : Str _expression_ = strfmt%1 == %2) (%3 = %4)) || (%5 %6)), fieldStr(YourTable, DateField), 25\08\2004, fieldStr(YourTable,

[development-axapta] integration axapta 3.0 whith lotus notes

hi, has anybody informations about an easy way to integrate lotus notes and axapta? my intension is, lotus notes has a role of a mobile client to collect orders and printing invoices. the communication between lotus and axapta should realized by the replicate function from lotus notes.

RE: [development-axapta] Cheque printing

Ive also had endless problems with the Epson printers ,my solution which works perfectly was just to use the generic text only driver Regards Jason Crook Exordia From: Matt Benic [mailto:[EMAIL PROTECTED] Sent: 26 August 2004 13:57 To: Axapta Dev

Re: [development-axapta] Create Word document from code (2)

There are also some code in the DocuActionCOM_Word class that could be useful. Amund Wed, 25 Aug 2004 17:02:34 +0200 skrev Harry Nilsen [EMAIL PROTECTED]: Hi! I have to create a Word document based on a Word template with bookmarks from code using data from a table in Axapta. Does