[Axapta-Knowledge-Village] Problem with Line Above and Line Below in a Report

2004-11-15 Thread Alfonso Collados Arroyo
Hi all: When I choose lines belows and lines Above in a Page Footer, my report take a big width dimensions, and when I choose again none and none my report keeps that dimensions, How can I return to my first state of the report? Regards, Alfonso Sharing the knowledge on

Re: [Axapta-Knowledge-Village] Re: Axapta and OpenOffice

2004-11-15 Thread Max Belugin
Hello jandalfas, ïîíåäåëüíèê, 15 íîÿáðÿ 2004 ã., you wrote: http://www.oooforum.org/forum/viewtopic.php?t=9815 http://www.oooforum.org/forum/viewtopic.php?p=52562 http://www.google.com/search?q=openoffice+progid j I have such type of error: j Could not create Word.Application class COM

[Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Padmaja Iyingar
Hi, I need your help again. Axapta has the approval CheckBox on the posted invoice that is default to "Checked". i.e, Axapta wants me to post an invoice even if it not approved. its kind of strange for me. I didn't hear this type of functionality in any ERP. Is there any way, I can do some

[Axapta-Knowledge-Village] retrieve data via sql statement

2004-11-15 Thread affekatz
Ive got a sql statement which looks like this: S.executeQuery( select statement ); can anyone give me a short example that shows how to retrieve the data into a string Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo!

Re: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread vaibhav pednekar
hi padmaja, i am sorry can please tell me where is this check box on which form. From where do you post the invoice? If your are posting the invoice directly from the purchase order then it is understood that an authorized person is doing it and mostly he will check it before posting. If you

Re: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Padmaja Iyingar
Hi Vaibhav, Thank you for your idea. Actually, the approve check box is on the PO-post-invoice-Setup. we would like to post it directly from Purchase order. But, the client's internal team people are sometimes forgetiing to check/uncheck as its manula process . In steadd, they argued that its

[Axapta-Knowledge-Village] Re: Sales Invoice Layout

2004-11-15 Thread Danny Gaethofs
Dear Aji, All, I have figured it out. The methods initFromSalesTable and initFromSalesLine which can be found respectively on the table CustInvoiceJour and CustInvoiceTrans handle the initialization of the fields in these two tables. These methods are called by the method insertProForma(),

Re: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread vaibhav pednekar
hello padmaja, ok, if the client whats the system to tell them to approve then u can add a validation method here, and on the form init method you can set the approval button to be unchecked. so that whenever the users post the invoice and if he hasnt checked the approval checkbox then axapta

Re: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Padmaja Iyingar
Thank you Vaibhav. The parameters I am thinking as of now are "Invoice amount - Goods Received" 1 and the Invoiceed Qty = Goods received Qty. Still have to sit with them and gather the specs. I am think of overiding validate methods on the form. And let you guys know about it. Thanking you

RE: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Malcolm Burtt
Hi Some time back we implemented an approval mechanism for purchases. Approval limits were stored at the user group level. If a user is in multiple groups then they get the highest approval limit from their group memberships. We added "Approved by", "Approved date", "Approved amount" to

[Axapta-Knowledge-Village] Re: Round Off error.

2004-11-15 Thread jaxxnrhyno
Roberto, Have you tried to set the General round-off parameter to 0.01? Can you provide more info? Are you converting from USD or to USD? And what is the other currency? Also, what is the Maximum penny- rounding in secondary currency parameter set to (navigate General ledger Setup

[Axapta-Knowledge-Village] Round Off error.

2004-11-15 Thread roberto pineda
Hi Jacqy. I have set that parameter to 0.01, when i do that, there appear more errors like the first one. The primary currency is 'Pesos Argentinos (ARS)' and the secondary is USD. The journal is in USD. And the 'Maximun penny difference' and 'maximun penny-rounding ' in secondary currency'

RE: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Jim Jo
Hi Padmaja, Whycant you do this by security groups settings? You can allow only certain groups to post invoice. This is one way of doing this. Second method .. Needs a one min customizations effort. Change the default value of the check box to ::NO anddisable for editing (Through a

RE: [Axapta-Knowledge-Village] Urgent : Axapta Std functionality for Approving Invoices

2004-11-15 Thread Jim Jo
Hi Padmaja, Whycant you do this by security groups settings? You can allow only certain groups to post invoice. This is one way of doing this. Second method .. Needs a one min customizations effort. Change the default value of the check box to ::NO anddisable for editing (Through a