[development-axapta] Updating inventtrans field

2004-01-02 Thread James Flavell
I wish to add a new field to every inventtrans record and update this field depending other inventrans field values when a record is created. Can anyone tell me the class/method or where I should put such code. I was thinking of on the inventtrans table insert method but dont think this is such a

RE: [development-axapta] RTF format used in email feature

2004-01-02 Thread James Flavell
From my expereience the logo is there but the MS Word box that it is contained in is too small or underneath another box. Try selecting everything in the doc (Ctrl-A) and then goto format (have to go to the menu point not right click!) and set properties to 'transparent' (not sure exactly what

RE: [development-axapta] Line discount % modification

2004-01-02 Thread James Flavell
- the parrentheses do not matter in this context. (Check for yourself - (2*3)*4 == 2*(3*4)) Best regards Thomas Turn Jensen - Original Message - From: James Flavell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 27, 2003 3:55 PM Subject: [development-axapta] Line discount % modification Hi

RE: [development-axapta] correction :custPackingSlipTrans and salesLine

2004-01-10 Thread James Flavell
on the custpackingsliptrans table there should be a method something like initFromSalesLine. easiest is to add a new field to the table and initilise it in this method then you have a permenatent record on the record regardless of what happens to the salesline. -Original Message-

[development-axapta] Purchase amount as 100% tax

2004-02-13 Thread James Flavell
Hi I would like to have a purchase line that is basically just 100% tax. I tried setting tax so that is 100% but this will end up calculating 100% on top of the purchase line whereas I would like the purchase line net amount to be the tax. Is there any possible way to have this so that

RE: [development-axapta] Purchase amount as 100% tax

2004-02-16 Thread James Flavell
Thanks everyone, it seems there is no easy way to get net amount as tax on purchase line. A few things to note: You CAN do tax adjustment on PO and SO and not just general ledger (use the SETUP button on the order screens) An idea might be to create a tax group/code such that the

[development-axapta] Pallet transports for SO issues

2004-02-17 Thread James Flavell
Can someone help me with creating pallet transports for Sales orders. I am trying to use the std demo data with Ax30SP2 plus all hotfixes. I can get pallet transports generated on incoming but can only get picking routes generated for sales orders. From the shipmentI select activate

RE: [development-axapta] Re: Pallet transports for SO issues

2004-02-17 Thread James Flavell
is that for complete pallet quantites (defined in inventory - Tab Page Settings) you'll get a pallet transport and for incomplete ones you'll get a picking route. Hope this helps you Greets Michael -- In [EMAIL PROTECTED], James Flavell [EMAIL PROTECTED] wrote: Can someone help me with creating pallet

RE: [development-axapta] Inventory dimensions

2004-02-20 Thread James Flavell
Not come across this but somethign linked to using batch (or any dimension) only as info, not sure you are aware of this or whether this is likely to be an issue for you but incase: Please use the following link to update your incident:

RE: [development-axapta] Inventory dimensions

2004-02-21 Thread James Flavell
and the outflows will not have the same dimid and hence not being matched when closing. If you change the dimensions you have to write a script that sets the dimid for already existing transacions - and then afterwards run the close - that should do the trick. Regards, Anders --- James Flavell [EMAIL

[development-axapta] 2.1 APPL ith 3.0 KERNEL???

2004-03-01 Thread James Flavell
In XAL it was possible to mix appl and kernel versions, is this possible in anyway with Axapta? Is it possible to mix a 2.1 APPL with a 3.0 KERNEL? If so how should it be done? Thanks James Yahoo! Groups Sponsor ADVERTISEMENT Click Here Yahoo! Groups Links To

RE: [development-axapta] Re: Inventory dimensions

2004-03-04 Thread James Flavell
Hi, I am not sure if you have exactly the same issue, my 'hanging' inventsum is both qty and value and so your final attempt would not work as the cost might be zero but the qty will still be open on my inventsum records. I am interested in how the consistency check is able to set the

RE: [development-axapta] Re: Inventory dimensions

2004-03-04 Thread James Flavell
. That's the exact situation I'm in.. Regards, min2sia --- In [EMAIL PROTECTED], James Flavell [EMAIL PROTECTED] wrote: Hi, I am not sure if you have exactly the same issue, my 'hanging' inventsum is both qty and value and so your final attempt would not work as the cost might be zero but the qty

[development-axapta] change of email test

2004-03-31 Thread James Flavell
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 to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. attachment: winmail.dat

RE: [development-axapta] Importing General Ledger / General Journal

2004-04-19 Thread James Flavell
There is a 'load lines' (or load something but cant remember off hand and no Ax with me right now) in the functions button in general ledger right? Not sure the format it uses or how it addresses voucher number etc... -Original Message-From: Steve Wright [mailto:[EMAIL

RE: [development-axapta] Quarantine warehouse

2004-04-20 Thread James Flavell
If you only need to register the financial amount (I take it meaning ledger only)without affecting inventory why do you not use Invoice Register and tehn Invoice Approval? -Original Message-From: Charles [mailto:[EMAIL PROTECTED]Sent: Wednesday, April 21, 2004 12:14 PMTo:

RE: [development-axapta] Quarantine warehouse

2004-04-20 Thread James Flavell
: [development-axapta] Quarantine warehouse Hi James, Thanks for the quick reply. Where can I find more information on how to go about doing the Invoice Register and invoice Approval. Regards, Charles -Original Message-From: James Flavell [mailto:[EMAIL

[development-axapta] Ax2.5 SP3 and Win2k server SP3

2004-04-23 Thread James Flavell
Does anyone have or know whether Ax2.5 SP3 has any problems when run from a Windows 2000 Server with SP3 or higher installed? I was told that should not use Win2k server SP3 long ago but was never given the reason and now due to some AD replication problems we have been recommendedto

RE: [development-axapta] Ax2.5 SP3 and Win2k server SP3

2004-04-23 Thread James Flavell
Malcolm Burtt Global IT Group -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: 23 April 2004 06:10 To: [EMAIL PROTECTED] Subject: [development-axapta] Ax2.5 SP3 and Win2k server SP3 Does anyone have or know whether Ax2.5 SP3 has any problems when run from a Windows 2000

RE: [development-axapta] Excel Import

2004-05-05 Thread James Flavell
After copying in your data go to the vendor code and put ' in the front as part of the code, does it show or disappear? If it disappears try doing an import. Excel has some strange behaviour on so called string fields (to you it looks like a striong field but not to excel, not until you put

RE: [development-axapta] Excel Import

2004-05-05 Thread James Flavell
dont understand why its only for vendor code , not for other mandatory fields. Regards Akash --- James Flavell [EMAIL PROTECTED] wrote: After copying in your data go to the vendor code and put ' in the front as part of the code, does it show or disappear? If it disappears try doing an import

RE: [development-axapta] Ageing report

2004-04-29 Thread James Flavell
I dont think that is the problem because the report "customer balance list with credit report" should still refelect the settlement date being the invoice date right and hence the total balance of both the aging and this report should match? Grish, just to double check: Your 'As of'

[development-axapta] Black triangle

2004-04-30 Thread James Flavell
I think you mean the symbol that appears if not all the fields ont he form/tabpage can be shown (i.e. there are some fields you cannot see) As far as I know there is nothing you can do except resize or hide existing fields so that the hidden ones have sapce to appear... -Original

RE: [development-axapta] Ageing report

2004-04-30 Thread James Flavell
you should be able to keep dragging the form size and end up with a scroll bar in the main Axapta window but I think I recall some forms it impossible to get right at that resolution :( -Original Message-From: Tony Chan [mailto:[EMAIL PROTECTED]Sent: Friday, April 30, 2004

RE: [development-axapta] Ageing report

2004-04-30 Thread James Flavell
transactions displayed in the "customer transactions" report were missing, for both the reports the date rangewere selected the same. Did anyone observe this difference earlier? cheers, Girish -Original Message-From: James Flavell [mailto:[EMAIL PROTECTE

RE: [development-axapta] Re : Report In PDF Format Problem

2004-04-30 Thread James Flavell
the axapta pdf writing classes are limited to which fonts, sizes... I recall if you use double line or soemthing like that it appears. In the end my customer went with a freeware PDF print driver rather than the axapta PDF option. -Original Message- From: sinn3653 [mailto:[EMAIL

RE: [development-axapta] Re : Report In PDF Format Problem

2004-04-30 Thread James Flavell
Sorry I think they had an inhouse one available in the end. On customer uses Adobe PDF writer printer driver (v8 I think, they no longer provide stand alone printer driver)., this of course not free. Others are the main freeware out there...cutepdf I think is one of the more popular ones but

RE: [development-axapta] Ageing report

2004-04-30 Thread James Flavell
ansactions, for the selected period. And onwhich settlement screen is the "date principal" button available. i will write down the trans date example and email back. thanks again. cheers, Girish -Original Message-From: James Flavell [mailto:[EMAIL PROTECTED]Sent: 3

RE: [development-axapta] what is OCR Line ?

2004-04-28 Thread James Flavell
. regards, Girish -Original Message-From: James Flavell [mailto:[EMAIL PROTECTED]Sent: 28 April 2004 09:43To: [EMAIL PROTECTED]Subject: RE: [development-axapta] what is OCR Line ?Following on abit from Mai-Britt's replyThis field I BELIEVE (but I have

[development-axapta] Technet gone?

2004-05-21 Thread James Flavell
I see technet has been merged into Partnersource etc so much so I cant find the database compatibility sheet for Axapta. Can anyone give me the URL or send me the latest as I want to know for Oracle 8.01 and Axapta 3.0 Thanks James [Non-text portions of this message have been removed]

[development-axapta] Oracle to MS SQL white paper?

2004-06-08 Thread James Flavell
Maybe I am mistaken but I thought there was a white paper about converting Oracle Axapta database to MS SQL? Can anyone confirm this and point me in the right direction where I can find it or give any feedback on any problems as I seem to be having problems with duplicate recids being reported

RE: [development-axapta] Axapta web application

2004-06-09 Thread James Flavell
Do you know about the axapta module' record level security' and/or 'domains'? Your multiple companies is axapta companies or you mean different end clients of yours who all inquire into the same axapta company? -Original Message- From: Girish Bhatkal [mailto:[EMAIL PROTECTED] Sent:

[development-axapta] Payment Advice report for non cheque payments

2004-06-14 Thread James Flavell
Hi, I want to be able to get the Payment Advice report that is produced for Cheque AP payments when i make non cheque payments. From what I understand I must first on the Method of payment (e.g. 'Cash') set a EXPORT File format and then in the payment journal use the Functions/Generate

[development-axapta] SQL VIEWS missing and cannot be synced

2004-06-17 Thread James Flavell
Has anyone had the problem that views such as LEDBALANCESDIM does not exist in SQL server and when sync in AOT nothing is created? I have checked and find that some of the views can sync but others cannot!!! I have checked the MASTER db and the views in that have INFORMATION_SCHEMA as the

RE: [development-axapta] SQL VIEWS missing and cannot be synced

2004-06-17 Thread James Flavell
AS SYSTEMGENERATEDULTIMO,A.DATAAREAID AS DATAAREAID,1010 AS RECID FROM LEDGERBALANCESDIMTRANS A(NOLOCK) GROUP BY A.ACCOUNTNUM,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.TRANSDATE,A.PERIODCOD E,A.SYSTEMGENERATEDULTIMO,A.DATAAREAID GO setuser GO --- Good luck. Regards, Pascal James Flavell [EMAIL

RE: [development-axapta] Decimals in Axapta

2004-06-29 Thread James Flavell
Have you set the number of decimals to round to on the currency code? (I think you want 0.0001 and not the default 0.0100) as I guess this is applied inside the priceDisc.price() -Original Message- From: Jens Strandberg [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 30, 2004

[development-axapta] TS versus Citrix

2004-07-01 Thread James Flavell
Can someone just put me on the right path as to the main differences with just a Terminal Server client and a Cytrix client... I have been told TS requires higher bandwidth per client but have not found anywhere that explains when TS is enough and when Citrix should be used etc... Thanks

RE: [development-axapta] (urgent) how to delete log file from SQL server 2000

2004-07-01 Thread James Flavell
I take this is MS SQL database. check the propertieis of the db and you will probably find the 'Restore' is set as FULL change it to SIMPLE and then backup the database. You should then find the log has been deleted/truncated I believe (read up the SQL help on this setting should explain

RE: [development-axapta] Deliver remainder != 0 even if all qty are invoiced

2004-07-01 Thread James Flavell
There was a known bug in ax3.0 sp1 (I think there was a hotfix issued and also guess it should be fixed in SP2) that deliver remaining qty went AWOL in certain situations... -Original Message- From: Steeve Gilbert [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 4:32 AM To:

RE: RE : [development-axapta] Deliver remainder != 0 even if all qty are invoiced

2004-07-01 Thread James Flavell
it can be fixed once it's messed up? Steeve... -Message d'origine- De : James Flavell [mailto:[EMAIL PROTECTED] Envoyé : 30 juin 2004 18:24 À : [EMAIL PROTECTED] Objet : RE: [development-axapta] Deliver remainder != 0 even if all qty are invoiced There was a known bug in ax3.0 sp1 (I think

RE: [development-axapta] identify Inventory model group

2004-07-23 Thread James Flavell
this one I got around with using GST group (as this can affect posting) but it was not a geat clean solution but is a possible way without doing any mods...if you link posting to warehouse etc then i would be very very interested to know how you did. Thanks james -Original Message-

RE: [development-axapta] Deleting a line from an open Profit/Loss Journal

2004-07-29 Thread James Flavell
well its because you dont allow negative stock for the item I guess so the easiest is to change that and oyu can delete but then supposedly you have negative stock status for the item so this is probably not a good enough answerso read on... :). I think maybe some other issue trans has

RE: RE : [development-axapta] Deleting a line from an open Profit/Loss Journal

2004-07-30 Thread James Flavell
, someWMSLocation) and it can't because of the negative quantity posted earlier. If you have some other idea, feel free to send. Otherwise I'll phone our consultant and see what he can do about it and hopefully I'll know what to do next time. Steeve... -Message d'origine- De : James Flavell [mailto

RE: RE : RE : [development-axapta] Deleting a line from an open Profit/Loss Journal

2004-08-01 Thread James Flavell
sense. Anyway, that's another story that I'll investigate some other time. Don't worry, if I get stuck you'll hear from me soon enough. :) Thanks for your help. Steeve... -Message d'origine- De : James Flavell [mailto:[EMAIL PROTECTED] Envoyé : 30 juillet 2004 09:18 À : [EMAIL

[development-axapta] Form sort used for what?

2004-08-01 Thread James Flavell
Does anyone out there use the 'form sort' setup? What is it used for the 'Form sort' ? I thought maybe it was if I do a batch update of several sales orders say into invoices then I can control which order gets processed first and hence which one gets the first invoice number etc.but

RE: [development-axapta] Form sort used for what?

2004-08-04 Thread James Flavell
Does noone at all know what the 'Form sort' is for in Axapta?!!! Anyone want to make any guesses? Thanks James -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 9:20 AM To: [EMAIL PROTECTED] Subject: [development-axapta] Form sort used

RE: [development-axapta] Form sort used for what?

2004-08-08 Thread James Flavell
Thanks very much Harry, Your example situation is a very good one and one that had not really crossed my mind :) my situation is very similar in that I want to make sure the warehouse pick priority customer stock first and therefore want the picking instructions to appear in customer

RE: [development-axapta] Picking List report

2004-08-10 Thread James Flavell
In AR/Setup/Forms setup you can sepcify on the pick list tab page which dimensions appear on the report I believe only problem is the std format can end up wasting a lot of paper as each dimension is printed on a new line rather than as part of the item lineso you still might end up doing

RE: [development-axapta] Axapta Update

2004-08-25 Thread James Flavell
James Flavell International Business Consultant Email: [EMAIL PROTECTED] / [EMAIL PROTECTED] Tel : +65 97582281(SG) PT Columbus IT Indonesia Jakarta Stock Exchange Tower II, 17th Floor Suite 1701 Jl. Jend Surdiman Kav. 52-53 Jakarta 12190 Indonesia Tel: +62 21 515 7684 Fax: +62 21 515 7799

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

2004-08-26 Thread James Flavell
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] Strange records in table CustInvoiceJour

2004-08-26 Thread James Flavell
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

RE: [development-axapta] Tax Codes

2004-08-26 Thread James Flavell
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] table views

2004-08-26 Thread James Flavell
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

2004-08-27 Thread James Flavell
. then you can go to that posting account (from inventory postings form). now go to chart of account , select the account and then go to the dimension tab and select the mandatory dimension/ To be filled in -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: 26 August

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

2004-08-27 Thread James Flavell
: [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

RE: [development-axapta] Re: DAT company

2004-10-22 Thread James Flavell
can I ask why you thinkit is not a good idea to use DAT? just wondering what the reasoning might be because after all Axapta companies are in the same SQL database -Original Message- From: m5sanchez [mailto:[EMAIL PROTECTED] Sent: 22 October 2004 18:19 To: [EMAIL PROTECTED]

RE: [development-axapta] Re: DAT company

2004-10-22 Thread James Flavell
cant delete the DAT company from Axapta. The DAT company is Axapta is special, it holds all of the non-company things like Logins etc. Ever considered what would happen if you click on the Duplicate button on the Company Accounts form? Steve _ From: James Flavell [mailto:[EMAIL

RE: [development-axapta] Re: DAT company

2004-10-22 Thread James Flavell
happen if you click on the Duplicate button on the Company Accounts form? Steve _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Friday, 22 October 2004 4:38 PM To: [EMAIL PROTECTED] Subject: RE: [development-axapta] Re: DAT company can I ask why you thinkit is not a good

RE: [development-axapta] Question regarding settlements and closing date

2004-10-29 Thread James Flavell
Axapta 3.0 SP2. Regards, Matt Benic Axapta Developer UTi Sun Couriers Division The universal aptitude for ineptitude makes any human accomplishment an incredible miracle. - Col. John P. Stapp -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: 28 October 2004 03

RE: [development-axapta] Report problem.

2004-11-01 Thread James Flavell
set you realtionship in the join as 1:1 otherwise oyu will notice the lines that supposedly show okay are actually showing the wrong PO name for the line!!! (they are showing the PO name of the line above...the first line is blank becasue it has no line before it...) -Original

RE: [development-axapta] Payment distribution

2004-11-04 Thread James Flavell
Also you have 'Allocation' which allows you to set predefined amounts or % splits when something is posted into a ledger accountbut I cant remember if Allocation works on automatic system posting or only on journal postings -Original Message- From: Karina Normann Jakobsen

RE: [development-axapta] CRITICAL! General Journal Line duplicated

2004-11-05 Thread James Flavell
Look in the List button on the number sequence. Delete all the records here (maybe copy and paste them all to excel first as a historical record) Hope that fixes it -Original Message- From: Matt Benic [mailto:[EMAIL PROTECTED] Sent: 05 November 2004 21:11 To: Axapta Dev Subject:

[development-axapta] Assigning invent dims from Sales to Purchase

2004-11-11 Thread James Flavell
Hi, I have a situation such that a purchase is basically a blanket contract (100,000 qty) with a fixed price per unit. Now the contract is only purchased when it is sold to the customer (so it is partial invoices per contract) and when this happens there are additional charges the supplier

RE: [development-axapta] Joining two customers into one

2004-11-17 Thread James Flavell
How about using the same concept that is in the 'Rename' because I believe this uses the EDT to find every table and record in the database, just in your code delete the customer table record, the rest should be pretty much the same I would think. Never tried it but its an idea for you

RE: [development-axapta] Joining two customers into one

2004-11-18 Thread James Flavell
... :-( /Jens -Oprindelig meddelelse- Fra: James Flavell [mailto:[EMAIL PROTECTED] Sendt: 18. november 2004 02:23 Til: [EMAIL PROTECTED] Emne: RE: [development-axapta] Joining two customers into one How about using the same concept that is in the 'Rename' because I believe this uses

[development-axapta] Langauge field

2005-01-06 Thread James Flavell
To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Ageing report Hi James, I have selected a few vouchers in the table browser and the screen dump of the same is mentioned in the attachment with examples. thanks, Girish -Original Message- From: James Flavell

RE: [development-axapta] Use of InventSumLogTTS table

2005-01-12 Thread James Flavell
I have just found for a customer that InventSumLogTTS is the biggest table in the database (1/6th of the total). Based on what Helmut posted back in March last year I realised I have the case where the customer has master planning license in Ax3.0 SP1 but does not use it. Can I just delete

[development-axapta] Document handling button

2005-02-03 Thread James Flavell
Can anyone point me to the place which is the 'highest' point where I could add common code that is executed for EVERY record that is selected by the user in a form . I guess it is somewhere like where the document handling icon is made active or greyed out. I read in so old posts (see

[development-axapta] Dynamic form changes possible?

2005-02-14 Thread James Flavell
Hi everybody, I hope somebody can help me to know is it possible to control what is displayed on a form (e.g. disable a button) based on the value in a record's field? I would like to be able to make a general solution whereby I can setup that on a given form certain controls (such as

RE: [development-axapta] Dynamic form changes possible?

2005-02-15 Thread James Flavell
(0) Thanks for all the help I am not a programmer but need to check out whether my 'dream' is realistically doable so sorry if my questions are a little basic for developers Thanks James -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: 15 February 2005 09:16

RE: [development-axapta] Dynamic form changes possible?

2005-02-15 Thread James Flavell
Subject: SV: [development-axapta] Dynamic form changes possible? Take a look at the class SysSetupFormRun This class is used to e.g. retrieve a user defined design for a form... Regards Carsten F. Frandsen Fra: James Flavell [mailto:[EMAIL PROTECTED] Sendt: ti 15

RE: [development-axapta] Dynamic form changes possible?

2005-02-20 Thread James Flavell
(); formRun.run(); formRun.wait(); } HTH Best regards Carsten F. Frandsen Fra: James Flavell [mailto:[EMAIL PROTECTED] Sendt: ti 15-02-2005 14:42 Til: development-axapta@yahoogroups.com Emne: RE: [development-axapta] Dynamic form changes possible? Thanks Carsten

RE: [development-axapta] Dynamic form changes possible?

2005-02-27 Thread James Flavell
860) { if (FormRun.design().controlName(btHide)) { FormRun.design().controlName(btHide).visible(false); } } else { if (FormRun.design().controlName(btHide)) { FormRun.design().controlName(btHide).visible(True); } } standard code deleted } -Original Message- From: James Flavell [mailto:[EM

[development-axapta] Product builder, how to execute user entered X++

2005-02-27 Thread James Flavell
ign().controlName(btHide).visible(false); } } else { if (FormRun.design().controlName(btHide)) { FormRun.design().controlName(btHide).visible(True); } } standard code deleted } -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Saturday, 19 February 2005 12:51

[development-axapta] Where does recor dlevel security get checked?

2005-02-27 Thread James Flavell
ide)) { FormRun.design().controlName(btHide).visible(True); } } standard code deleted } -Original Message- From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Saturday, 19 February 2005 12:51 PM To: development-axapta@yahoogroups.com Subject: RE: [development-axapta] Dynamic form changes possi

RE: [development-axapta] Product builder, how to execute user entered X++

2005-02-28 Thread James Flavell
it you will not find the configuration. I think this is a known bug not yet addressed. Regards, HK James Flavell [EMAIL PROTECTED] wrote: Hi I am not a true X++ programmer and need some guideance to see how user entered X++ logic can be executed (like what can be done in the product builder

RE: [development-axapta] Re: Product builder, how to execute user entered X++

2005-03-03 Thread James Flavell
Thanks Onno that really helps me :)) Is this the way the product builder does it? Thanks James -Original Message- From: onnobid [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 17:30 To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: Product builder, how to

RE: [development-axapta] Printing Sales invoice

2005-03-08 Thread James Flavell
I think its in the Form' sort (AR/Setup) -Original Message- From: anettemalmberg [mailto:[EMAIL PROTECTED] Sent: 07 March 2005 23:00 To: development-axapta@yahoogroups.com Subject: [development-axapta] Printing Sales invoice Hi Multiprinting of Sales invoice is sorting by

RE: [development-axapta] Printing Sales invoice

2005-03-09 Thread James Flavell
lue will have to be set to after. Another option which you may want to look at will be to change the order in which picking list are processed. Hope this helps Regards harry _ From: James Flavell [mailto:[EMAIL PROTECTED] Sent: Saturday, 7 August 2004 11:28 a.m. To: developm

[development-axapta] Adding new field to inventrans and getting it populated

2005-03-09 Thread James Flavell
Hi I would like to know what I need to do to add a new field to the inventrans and to get this field populated. I have a customer PO number that ends up being many Axapta sales orders and this PO number is very importnat for the my client to review inventory movements. I could use the

[development-axapta] OLAP cubes for cost of sales

2005-04-14 Thread James Flavell
Hi everyone, Has anyone done any OLAP cubes for cost of sales analysis/reports? I am considering doing this for a customer and am just wondering if there is any potential dangers/risks? >From what I can see there is an 'OLAPCostValue' on the custinvoicelines table. Can I use this field

[development-axapta] APAR aging by currency

2005-04-14 Thread James Flavell
Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether there is any risks (i.e. why is such reports not already in std Axapta?) Thanks James [Non-text portions

RE: [development-axapta] OLAP cubes for cost of sales

2005-04-14 Thread James Flavell
' in the cube (s. \Classes\OLAPCreateAmount\fieldMethodName). Michael From: James Flavell [EMAIL PROTECTED] Reply-To: development-axapta@yahoogroups.com To: development-axapta@yahoogroups.com Subject: [development-axapta] OLAP cubes for cost of sales Date: Thu, 14 Apr 2005 08:46:26 +0900 Hi everyone

RE: [development-axapta] APAR aging by currency

2005-04-18 Thread James Flavell
in Axapta. Exactly which AR aeging report are you taking about? regards harry James Flavell [EMAIL PROTECTED] wrote: Hi all, Has anyone created the AR and AP aging reports in original transaction currencies? I have a requirement for this but am not sure how long it might take to do or whether

RE: [development-axapta] APAR aging by currency

2005-04-19 Thread James Flavell
want to achive. You will have to back-track this method (or method PlaceTransInColumns) to the ageing report. (i.e. method tmpAccountSum). regards harry James Flavell [EMAIL PROTECTED] wrote: hi Harry, Sorry I am only having up to Sp2 right now and from what I can see the balance aging reports

RE: [development-axapta] APAR aging by currency

2005-04-21 Thread James Flavell
Subject: RE: [development-axapta] APAR aging by currency hi V3Sp2 Standard system I posted two transactions in different currencies and printed customer - external account statement, the aging was printed for multiple currencies. regards harry James Flavell [EMAIL PROTECTED] wrote: Thanks

RE: [development-axapta] Deny user log on concurrently

2005-05-13 Thread James Flavell
Sorry Kenneth I would like to add maybe another question in the same area: If I have two companies within one system is there any place I can control to make sure the total user licenses are allocated correctly to each company? E.g. Comapny A - paid for 10 users Company B - paid for 25 users

RE: [development-axapta] Change InvoiceId on an invoice generated

2005-05-27 Thread James Flavell
@yahoogroups.com [mailto:[EMAIL PROTECTED] nombre de James Flavell Enviado el: jueves, 26 de mayo de 2005 11:02 Para: development-axapta@yahoogroups.com Asunto: RE: [development-axapta] Change InvoiceId on an invoice generated Right click on the invoice id field and do 'Rename' and enter the value you

[development-axapta] Print all Axapta companies data in a report

2005-05-31 Thread James Flavell
Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use the changeCompany function because I want a select (or query) to be able to run through all the records to consolidate records with same values and so I would like to use

RE: [development-axapta] Inventory amount adjustment some warehouse not shown ???

2005-06-08 Thread James Flavell
I think on hand adjustment is only based on the on hand at last inventory closing so probably do an invnetory closing up to the current date and you should see the same warehouses...I think, let us know if this is the case cheers -Original Message- From:

RE: [development-axapta] Print all Axapta companies data in a report

2005-06-09 Thread James Flavell
] On Behalf Of James Flavell Sent: Monday, May 30, 2005 7:52 PM To: development-axapta@yahoogroups.com Subject: [development-axapta] Print all Axapta companies data in a report Hi I am thinking of writing a report that prints information from several Axapta companies but do not want to have to use

RE: [development-axapta] Range criteria on InventTrans

2005-07-07 Thread James Flavell
you should realise any trans can only ahve status in either issue or receipt but you are basically telling the report to find trans that has value in both (i.e. criteri are AND together) basically you will need to run the report 2 times I think -Original Message- From:

[development-axapta] SQL sync error

2005-07-19 Thread James Flavell
Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets stuck but where shoul dthis view be? In the Ax DB or the master DB or where? I hope someone can

RE: [development-axapta] SQL sync error

2005-07-20 Thread James Flavell
this master db and restore the other master db.. Good luck :-) James Flavell [EMAIL PROTECTED] wrote: Can anyone tell me anything about INFORMATION_SCHEMA.VIEWS in SQL ...I get teh following error messages when I try to sync Axapta. I guess I am missing this view or table and so the system gets

RE: [development-axapta] External Axapta Training Resources

2005-07-27 Thread James Flavell
manufacturing tools ...) If you wish to considered our services please contact me on the email [EMAIL PROTECTED] Thanks James James Flavell International Business Consultant Email: [EMAIL PROTECTED] / [EMAIL PROTECTED] Tel : +65 97582281(SG) PT Columbus IT Indonesia Graha Surya Internusa, Lantai 8

RE: [development-axapta] From Axapta 2.5 to 4.0

2005-08-24 Thread James Flavell
mmm I am confused what is SP2.5???!! Anyway if you are going from version 2.5 to version 3.0 from what I can recall you need to install the last 2.5 SP and then upgrade to v3.0 SP0 after which you can then install the latest v.30 SP (i.e SP4) because service pack are accumualtive (i.e. SP4

[development-axapta] table cache 'Entire table'

2005-08-25 Thread James Flavell
Hi Can anyone tell me the table protperty for 'CacheLookup' if set to EntireTable will this load all Axapta companies records or only the company I am in when I access that table? Also if I set it up in user options the 'PreLoad' for a table deos it also load all Axapta companies or just

RE: [development-axapta] Print group totals in auto reports

2005-10-19 Thread James Flavell
Instead of autoreport use the report wizard (can do auto report and then 'modify') In one of the steps (about the 3rd of 4th NExt button) there is which fields you want to subtotal on :) James -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED]

RE: [development-axapta] URGENT Decimal Length

2005-12-25 Thread James Flavell
Which part needs to be 3 decimals? And why? Qty? Price? Sales or Purchase? Base Amounts? -Original Message- From: development-axapta@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mohib B. Reda Sent: 24 December 2005 16:31 To: Axapta_Documentation@yahoogroups.com;

RE: [development-axapta] Digest Number 1706

2006-03-16 Thread James Flavell
Hi Jim, Can you confirm you can go from 2.5 to 3.0SP4 directly (i.e. just run the Sp4 installation etc). I was always under the impression we had to upgrade to 3.0SP0 first. Just want to check as I am doing such an upgrade in the near future Thanks James -Original Message-

  1   2   >