[Axapta-Knowledge-Village] change page size to A4

2005-06-30 Thread Chaminda Kothalawala
Hi all I have one question in report printing. I want to set the paper size to A4 by using code. Any suggestion would be a great help for me. Thanks chaminda Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-

RE: [Axapta-Knowledge-Village] !00% Acccount function works?

2005-06-30 Thread James Flavell
Hi, Strange it seems to work in another SP1 application I have tried...I will need to go back to the other application (SP2 & SP3) and check again Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sun Fen Chen Sent: 24 J

[Axapta-Knowledge-Village] Journal print out does not have tax!!

2005-06-30 Thread James Flavell
Title: Message I have just realised the general journal report does not have any info if there is tax for a transaction!!!   Can anyone suggest a report or modificaiton as my customer wants a journal printout to use for approving purposes and hence it should show the total affect of the j

[Axapta-Knowledge-Village] Installation & Configuration I and II documents

2005-06-30 Thread David
Hi all, does anyone have Axapta Installation & Configuration I and II documents ?? Can you send it to me ? Thanks, David Send instant messages to your online friends http://asia.messenger.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web,

RE: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-06-30 Thread James Flavell
Title: Message hi harry,   I dont think this is the case as basically I type zero into the update field on the posting form and like I mention it works correct for Q and Confirmation (but I will try to check - problem is I am not sure which table I should check somethign like SalesParmUpd

RE: [Axapta-Knowledge-Village] SQL7 to SQL2000 upgrade

2005-06-30 Thread James Flavell
Title: Message Thanks David,   I think I might try an upgrade and see how that goes as the first appraoch Thanks for your reply James   -Original Message-From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of David CasasSent: 01 July 200

RE: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-06-30 Thread James Flavell
Sorry Girish, I forgot to mention I had several lines to update and I just set one of them as zero qty. Can you try that instead and see whether the zero line appears on the print out with zero qty. Thanks James -Original Message- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Harry \(Harshawardhan Deshpande
hi   interesting   on the same lines...   once a sales order is created insert the sales id in a new table.   create a batch job that will check say after 10 mins if the sales order is still in the database, if yes then send it to the web-database.   Use opposite logic for deleted sales ord

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Harry \(Harshawardhan Deshpande
hi   ValidateWrite may not be the correct way to go for since this method will be called only if the update is being called from the form. This is why a lot tables have validations written on the update method.   regards   harryBrandon George <[EMAIL PROTECTED]> wrote: Well this is great conve

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Jesper Kehlet
What database is your web site based on?  A Microsoft SQL 2000 database?   Anyway, here is my 2 cents:  Modify Application.ttsNotifyCommit() to do the synchronization -- that way you can ensure that transactions have been committed before you synchronize.  Do it like this:       1.  Create

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Brandon George
Well this is great conversation! Thanks for your input, and I believe that I found the Solution:    Override the ValidateWrite and ValidateDelete methods. Adding code that would transfer the information from the SalesLine to our Web Database at this point seems to work every time.   @ harr

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Harry \(Harshawardhan Deshpande
hi Brandon   this email is just for the sakes of complete discussion.   it is not necessary tha the update and insert methods on a table will be executed. The logic may go for doInsert and doUpdate. though I cant think of a scenario where doInsert/Update methods are called for sales table it ma

Re: [Axapta-Knowledge-Village] SQL7 to SQL2000 upgrade

2005-06-30 Thread David Casas
 Hi   I tested the upgrade of SQLServer 7.0 to SQLServer2000 and works well.   If I am in your situation, I do the following:   -  Install in the new machine SQLServer 7.0. -  Restore de database -  Upgrade to SQLServer 2000.   Another idea is with DTS of the tables, pass all of the datab

Re: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-06-30 Thread Harry \(Harshawardhan Deshpande
hi   Very unusual, standard axapta should not allow this to happen.   My guess is this has got something to do with the number of decimal places on the unit. Go into the sql server and check if the quantity that appears as zero on the screen is actually zero and not something like .001234   rega

[Axapta-Knowledge-Village] Product builder table variable based on another variable

2005-06-30 Thread Axapta Consultant
Hello All   Is there a way to limit table variable display based on another variable similar to pre-field exclusions on enumerated text type variables?   I have a variable Customer pointing to CustTable (AccountNum field) and another variable Ship to pointing to address table (ZipCode field). I

RE: [Axapta-Knowledge-Village] SysLastValue Table - RunBase Framework

2005-06-30 Thread Jesper Kehlet
It will default back to the RunBase.saveLast, which in turn is doing a xSysLastValue::saveLast(), which populates the SysLastValue table. From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Danny GaethofsSent: Thursday, June 30, 2005 11:29 AMTo: Axapta-

[Axapta-Knowledge-Village] SysLastValue Table - RunBase Framework

2005-06-30 Thread Danny Gaethofs
Dear all, I noticed the developer's guide says to use the RunBase framework for designing job style tasks. When using the RunBase framework one has to implement the pack() and unpack() methods. I have been looking at some classes that extends RunBase. I found that these have implemented the

Re: [Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-06-30 Thread Girish Bhatkal
Hi James, i am not sure why its happening at ur end. I just now created a SO then when posting the delivery note i changed the Update qty to zero . The order did not get posted and i got a msg that "No lines for posting or quantity = 0". earlier when there was a requirement of posting the invoic

[Axapta-Knowledge-Village] create button on forms (at runtime)

2005-06-30 Thread Girish Bhatkal
Hi, you can enable to get the questionnaire button on many forms for ex: SalesTable (setting can be done from the questionaire setup) . But when i see the salesTable form design i cannot see this button , how is this button included at run time. This button is enabled in many other forms too. Ca

Re: [Axapta-Knowledge-Village] Group and print Multiple Deliver Orders into one Sales Invoice

2005-06-30 Thread Koh Meng Chiat
Hi John, Thanks a lot. Really appreciate your advice. :D Best Regards, Jack --- John Studevant <[EMAIL PROTECTED]> wrote: > Hi Jack, > > As I understand it, depending on how you set the a/r > parameters summary update tab, multiple packing > slips will be invoiced on the same invoice. Plea

Re: [Axapta-Knowledge-Village] Should we allow Negative Financial Inventory??

2005-06-30 Thread John Studevant
Jack,   In most cases, I would allow negative financial inventory.  I say this because not allowing it would hold up the issue of items that for example had been packing slip updated on a purchase order but not invoiced.  If production or sales needed to issue the items they could not until a/p

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Brandon George
Ok,    So say I want to replicate based on the SalesLine Table.   Would I do it on the 'Update method' or on the 'Insert Method'. Is the Update method always called? That's the trick, does anyone know for sure if the update method is always called when a Line in the SalesLine table is crea

RE: [Axapta-Knowledge-Village] GAAP IAS

2005-06-30 Thread Игорь Ильяшенко
Thanks!   ---   Igor "Ingar" Ilyashenko From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Jesper KehletSent: Wednesday, June 29, 2005 8:06 PMTo: Axapta-Knowledge-Village@yahoogroups.comSubject: RE: [Axapta-Knowl

RE: [Axapta-Knowledge-Village] Sales Order - Question

2005-06-30 Thread Andrae, Tobias
Hi Brandon, there are some methods on the table object SalesTable which are fired each time a record is created. Maybe you want to overwrite the insert() method and do your export here after the super() call. To do so, you coulod use a ODBCConnection (see help in System documentation). hth,

RE: [Axapta-Knowledge-Village] SQL7 to SQL2000 upgrade

2005-06-30 Thread Andrae, Tobias
As I remember, the upgrade of SQL-Server 7 to SQL 2000 did not work so well. So I would install SQL 2000 on the new machine, backup the old DB on SQL 7 and restore it on the new one. Of course you must set the owner for the restored DB. hth Tobias -Original Message- Fro

[Axapta-Knowledge-Village] SP2 line with zero qty in Update is still shown in printout of delivery and invoice

2005-06-30 Thread James Flavell
Title: Message Hi   I just noticed for sales order  quotation and confirmation that if I select Qty 'All' and then cahnge the update qty to zero then these zero lines do not get printed BUT when I do the same during delivery or invoice printing the zero lines still get printed!!!   In ord

[Axapta-Knowledge-Village] How Recalculate inventSum

2005-06-30 Thread Cenk Ince
Hi all; Is it possible to recalculate Qty fields on inventTrans? How to calculate it? Is there a standard function for this? Thanks. Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*>