[Axapta-Knowledge-Village] Re: Sales Invoice posting Error in Ax 4.0......Very Urgent
Nitin Things to check: 1. If the invoice is in different currency than company currency: - check rounding in ALL currencies involved (in exchange rate table). - check penny difference value in GL parameters 2. Is there any tax involved? - check the rounding on the tax codes and tax authority 3. Are you selling any items with any conversion factors, i.e different sales unit as to inventory unit? If so, check conversion on item as well as decimal settings on the unit. 4. Do you use any misc charges? If so, check your setup especially if tax is involved. Hope this helps. If you find the problem, please post on the forum so that we can know! Regards Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, NITIN DESALE nitindes...@... wrote: Dear all, I am facing below problem at the time of Sales Invoice posting. If anyone know this please reply ASAP. Posting The transactions on voucher IV09_0012857 do not balance as per 20/09/2009. (Company currency: -0.02 - secondary currency: 0.00) Posting has been canceled. Operation canceled An error occurred during update Thankx Nitin Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
[Axapta-Knowledge-Village] Very urgent
Hello everybody,
I am running the following job and getting the error saying 'Query extended
range failure. right parentheses expected near pos 18.
static void QueryExpressions(Args _args)
{
Query Query;
QueryRunQueryRun;
QueryBuildDataSourceQBDS;
InventTable InventTable;
;
Query = new Query();
query.addatasource(tablenum(InventTable));
query.datasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).value(strfmt('((Itemname %1) ItemName %2))', '*20*',
'*pipe*'));
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
I am not getting what is wrong with it. Its very urgent.
Thanks in advance
[Axapta-Knowledge-Village] Hi
Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level. Regards Ramesh
Re: [Axapta-Knowledge-Village] Very urgent
hi ..
Try this..
static void QueryExpressions(Args _args)
{
Query Query;
QueryRun QueryRun;
QueryBuildDataSource QBDS;
InventTable InventTable;
;
Query = new Query();
query.adddatasource(tablenum(InventTable));
query.adddatasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).*value(strfmt(Item Name %1 Item Name %2, *20*,*pipe));*
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
On Tue, Sep 22, 2009 at 11:25 AM, Nagesh nageshsi...@yahoo.com wrote:
Hello everybody,
I am running the following job and getting the error saying 'Query extended
range failure. right parentheses expected near pos 18.
static void QueryExpressions(Args _args)
{
Query Query;
QueryRun QueryRun;
QueryBuildDataSource QBDS;
InventTable InventTable;
;
Query = new Query();
query.addatasource(tablenum(InventTable));
query.datasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).value(strfmt('((Itemname %1) ItemName %2))', '*20*',
'*pipe*'));
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
I am not getting what is wrong with it. Its very urgent.
Thanks in advance
Re: [Axapta-Knowledge-Village] Hi
Hi, I could not get your requirement. Are u updating the ItemCode for an already exisiting item ?? Regards, Anitha On Tue, Sep 22, 2009 at 11:25 AM, ramesh_p2384 ramesh_p2...@yahoo.co.inwrote: Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level. Regards Ramesh
Re: [Axapta-Knowledge-Village] Very urgent
Hi,
If you are trying to achieve a condition where in you are filtering items
which has 20 (*20*) in it and ends with pipe (*pipe):
Then you can try out following code:
static void QueryExpressions(Args _args)
{
Query query;
QueryRunqueryRun;
QueryBuildRange qbr;
InventTable inventTable;
str range;
;
query = new Query();
qbr =
query.addDataSource(tablenum(InventTable)).addRange(fieldnum(InventTable,
ItemName));
range = strfmt('((%1 like %2) (%1 like %3))',
fieldStr(InventTable, ItemName), *20*,*pipe);
qbr.value(range);
//Or you can just specify like this
//qbr.value(*20*pipe);
queryRun = new QueryRun(query);
while(queryRun.next())
{
inventTable = queryRun.get(tablenum(InventTable));
info(inventTable.ItemId);
}
info(queryRun.query().dataSourceNo(1).toString());
}
Hope this helps!
Regards,
Sumit
On Tue, Sep 22, 2009 at 12:24 PM, Anitha S mail2eani...@gmail.com wrote:
hi ..
Try this..
static void QueryExpressions(Args _args)
{
Query Query;
QueryRun QueryRun;
QueryBuildDataSource QBDS;
InventTable InventTable;
;
Query = new Query();
query.adddatasource(tablenum(InventTable));
query.adddatasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).*value(strfmt(Item Name %1 Item Name %2, *20*,*pipe));
*
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
On Tue, Sep 22, 2009 at 11:25 AM, Nagesh nageshsi...@yahoo.com wrote:
Hello everybody,
I am running the following job and getting the error saying 'Query
extended range failure. right parentheses expected near pos 18.
static void QueryExpressions(Args _args)
{
Query Query;
QueryRun QueryRun;
QueryBuildDataSource QBDS;
InventTable InventTable;
;
Query = new Query();
query.addatasource(tablenum(InventTable));
query.datasource(tablenum(Inventtable)).addrange(fieldnum(Inventtable,
itemname)).value(strfmt('((Itemname %1) ItemName %2))', '*20*',
'*pipe*'));
QueryRun = new queryrun(query);
while(queryrun.next())
{
inventtable = Queryrun.get(tablenum(Inventtable));
info(inventtable.itemid);
}
}
I am not getting what is wrong with it. Its very urgent.
Thanks in advance
[Axapta-Knowledge-Village] EDI in AX2009/?
What are AX 2009 EDI capabilities? Is there a document?
[Axapta-Knowledge-Village] We would like invest $30,000 in your Solid Future Income (SFI) business!, 9/22/2009, 9:00 am
Reminder from: Axapta-Knowledge-Village Yahoo! Group http://groups.yahoo.com/group/Axapta-Knowledge-Village/cal We would like invest $30,000 in your Solid Future Income (SFI) business! Tuesday September 22, 2009 9:00 am - 10:00 am (This event repeats every day.) Location: Dothan, Al Notes: Details by email -- therocgroup9436...@easy.com All Rights Reserved Copyright © 2009 Yahoo! Inc. http://www.yahoo.com Privacy Policy: http://privacy.yahoo.com/privacy/us Terms of Service: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Hi
Hi i am not modifying any existing item number,i want replace the item number with my newly created item code in the inventtable form. Regards Ramesh From: Anitha S mail2eani...@gmail.com To: Axapta-Knowledge-Village@yahoogroups.com Sent: Tuesday, 22 September, 2009 12:29:59 PM Subject: Re: [Axapta-Knowledge-Village] Hi Hi, I could not get your requirement. Are u updating the ItemCode for an already exisiting item ?? Regards, Anitha On Tue, Sep 22, 2009 at 11:25 AM, ramesh_p2384 ramesh_p2384@ yahoo.co. in wrote: Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level.. Regards Ramesh Yahoo! India has a new look. Take a sneak peek http://in.yahoo.com/trynew
[Axapta-Knowledge-Village] VendTable Form In Ax 2009
Hi All, I am using Ax 2009 sp1 with India localization. I am facing an uneven problem in customizing the VendTable Form. I am adding a field (a normal table field) on to the design of the VendTable form. When I compile and try to open the form, facing with the below error. Error executing code: object not initialized. (C)\Classes\\visible (C)\Forms\VendTable\Methods\init (C)\Classes\SysSetupFormRun\init - line 3 Please help me Regards Dileep
Re: [Axapta-Knowledge-Village] Hi
Hi, So ur requirement is for the *current record*, u r generating an item code on a *button click event* . if my understanding is correct, u can write your logic of updating the Itemid in the button click event itself. Regards, Anitha. On Tue, Sep 22, 2009 at 1:28 PM, rameshp papineni ramesh_p2...@yahoo.co.inwrote: Hi i am not modifying any existing item number,i want replace the item number with my newly created item code in the inventtable form. Regards Ramesh -- *From:* Anitha S mail2eani...@gmail.com *To:* Axapta-Knowledge-Village@yahoogroups.com *Sent:* Tuesday, 22 September, 2009 12:29:59 PM *Subject:* Re: [Axapta-Knowledge-Village] Hi Hi, I could not get your requirement. Are u updating the ItemCode for an already exisiting item ?? Regards, Anitha On Tue, Sep 22, 2009 at 11:25 AM, ramesh_p2384 ramesh_p2384@ yahoo.co. inramesh_p2...@yahoo.co.in wrote: Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level. Regards Ramesh -- From cricket scores to your friends. Try the Yahoo! India Homepage!http://in.rd.yahoo.com/tagline_metro_4/*http://in.yahoo.com/trynew
[Axapta-Knowledge-Village] Withholding tax for Thailand in GLS layer
Hi, anybody out there managed to get the withholding tax for Thailand in the AX2009 Sp1 + GLS layer to work (or even the non Thai Withholding tax to work)? The GLS document does not give any clear example as to how to get it to calculate withholding tax and seems we cannot get it to do anything even with parameters set and item master setup etc Would appreciate anyone can give any quick advice or example . or tell me it does not work and I need some hotfix . before I scream loud enough MS hears me in Redmond (since that seems to be the only way I will get them to listen to me ;) ) Thanks and buckets of appreciation in advance J James
Re: [Axapta-Knowledge-Village] Hi
on the invent master form the one u have created... 1.hope it opens everytime u click new button or ctrl + N... ok... 2. u must be having two buttons on ur form ok or cancel 3.in class declaration part of the form declare buffer of invent table Inventtable invt; 4.in the init method of the form say invt = element.args.caller(); 5. on the clicked method (event) of OK button say invt.itemid = formcontrol.valuestr(); //fromcontrol is the name of the control which has label itemid or itemname whatever u have named it..declare auto property of the control to yes hope it works for u...if any Qstns get back 6. Thanks Regards Pradeep S.Itnal mob:+91-9886529409 --- On Tue, 22/9/09, Anitha S mail2eani...@gmail.com wrote: From: Anitha S mail2eani...@gmail.com Subject: Re: [Axapta-Knowledge-Village] Hi To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, 22 September, 2009, 12:29 PM Hi, I could not get your requirement. Are u updating the ItemCode for an already exisiting item ?? Regards, Anitha On Tue, Sep 22, 2009 at 11:25 AM, ramesh_p2384 ramesh_p2384@ yahoo.co. in wrote: Hi All i have a problem in Form level. I.e i have developed a one form - name is InventMaster, that form should be open from InventTable Form using with (Ctr+N) or click new. upto this part i have done, whenever my form is open from InventTable form ,there i can select all my fields after when i click ok button one Itemcode is generated. So finally i want that itemcode should be inserted at Inventtable form level. for this problem where i have to write code in form level. Regards Ramesh Keep up with people you care about with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/connectmore
Re: [Axapta-Knowledge-Village] Withholding tax for Thailand in GLS layer
Withholding works for IN in the GLS CONS...it seems few of the hotfixes has been released for the same, i'm not sure about the exact KB articles. Santosh --- On Tue, 22/9/09, James Flavell djf1...@gmail.com wrote: From: James Flavell djf1...@gmail.com Subject: [Axapta-Knowledge-Village] Withholding tax for Thailand in GLS layer To: Axapta-Knowledge-Village@yahoogroups.com Date: Tuesday, 22 September, 2009, 2:44 AM Hi, anybody out there managed to get the withholding tax for Thailand in the AX2009 Sp1 + GLS layer to work (or even the non Thai Withholding tax to work)? The GLS document does not give any clear example as to how to get it to calculate withholding tax and seems we cannot get it to do anything even with parameters set and item master setup etc Would appreciate anyone can give any quick advice or example … or tell me it does not work and I need some hotfix … before I scream loud enough MS hears me in Redmond (since that seems to be the only way I will get them to listen to me ;) ) Thanks and buckets of appreciation in advance J James Connect more, do more and share more with Yahoo! India Mail. Learn more. http://in.overview.mail.yahoo.com/
Re: [Axapta-Knowledge-Village] Sales Invoice posting Error in Ax 4.0......Very Urgent
You are using 'in connection with balance' OR 'one voucher only' under journal settings..If its one voucher only, you will never be able to post the journal untill both the amounts will be unbalance. first try to balance both the entries e.g. debit and credit should be balanced. Santosh --- On Mon, 21/9/09, Anitha S mail2eani...@gmail.com wrote: From: Anitha S mail2eani...@gmail.com Subject: Re: [Axapta-Knowledge-Village] Sales Invoice posting Error in Ax 4.0..Very Urgent To: Axapta-Knowledge-Village@yahoogroups.com Date: Monday, 21 September, 2009, 10:27 PM try modifying the settings and check... Regards, Anitha On Tue, Sep 22, 2009 at 9:44 AM, NITIN DESALE nitindesale@ yahoo.co. in wrote: Hi, I checked its there as you said. Regards Nitin Desale --- On Tue, 22/9/09, Anitha S mail2eanitha@ gmail.com wrote: From: Anitha S mail2eanitha@ gmail.com Subject: Re: [Axapta-Knowledge- Village] Sales Invoice posting Error in Ax 4.0..Very Urgent To: Axapta-Knowledge- vill...@yahoogro ups.com Date: Tuesday, 22 September, 2009, 9:30 AM Hi, Check the set up in GL-SetUp-Journals-Journal names General Tab - Voucher - New Voucher If this is set to In connection with balance, then the journal which you are posting should be balanced. Hope this helps!!! Regards, Anitha On Sun, Sep 20, 2009 at 9:51 AM, NITIN DESALE nitindesale@ yahoo.co. in wrote: Dear all, I am facing below problem at the time of Sales Invoice posting. If anyone know this please reply ASAP. Posting The transactions on voucher IV09_0012857 do not balance as per 20/09/2009. (Company currency: -0.02 - secondary currency: 0.00) Posting has been canceled. Operation canceled An error occurred during update Thankx Nitin Keep up with people you care about with Yahoo! India Mail. Learn how. Add whatever you love to the Yahoo! India homepage. Try now! Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos
[Axapta-Knowledge-Village] RE: Withholding tax for Thailand in GLS layer
Just to add the Non Thailand withholding tax can now get to work J But still the Thailand one has no result.does anyone know what supposedly is the difference for the Thailand one? Is it just that withholding tax is calculated per item rather than total invoice (hence can mix items that have or do not have withholding tax on same invoice)? Or is it that the withholding tax is supposed to be realized at time of invoice rather than payment for thailand? Thanks again James From: James Flavell [mailto:djf1...@gmail.com] Sent: 22 September 2009 17:45 To: 'Axapta-Knowledge-Village@yahoogroups.com' Subject: Withholding tax for Thailand in GLS layer Hi, anybody out there managed to get the withholding tax for Thailand in the AX2009 Sp1 + GLS layer to work (or even the non Thai Withholding tax to work)? The GLS document does not give any clear example as to how to get it to calculate withholding tax and seems we cannot get it to do anything even with parameters set and item master setup etc Would appreciate anyone can give any quick advice or example . or tell me it does not work and I need some hotfix . before I scream loud enough MS hears me in Redmond (since that seems to be the only way I will get them to listen to me ;) ) Thanks and buckets of appreciation in advance J James
[Axapta-Knowledge-Village] Re: Year end error
Hi Eddie, Thanks for your response. It was a very strange situation, and after much looking around, it appeared that someone had changed the AOS system user. It appears that this AOS system user did not have SysAdmin rights... Anyhow, we have now given it SysAdmin rights, and all works fine. Very strange things... I hope you are well. Regards, Yifat --- In Axapta-Knowledge-Village@yahoogroups.com, Eddie edwardjosl...@... wrote: Hi Yifat Just a shot in the dark: Maybe try and run the Recalculate period balances in the GL before running the year end? Eddie --- In Axapta-Knowledge-Village@yahoogroups.com, yifath1 ymervis@ wrote: hello I am on AX 2009. SP 1. Trying to run a year close, and we are getting the following error: Cannot delete a record in Ledger balance transactions (LedgerBalancesTrans). Account number: , . Error accessing database connection. Any idea? I have copied it over to our test environment, and it works fine... no error. Any idea what I should be looking for? Thanks, Yifat
[Axapta-Knowledge-Village] How to stop Printing Reports (Bank Checks) before it was taken int Batch Process
Hi all, I have a Issue. Is it Possible To Print ALLChecks In One Go using the Batch Processing. If Possible Then How To Capture The ALL Printing Doc Files keep in Batch Processing. please see this and do needfull help. Thanks Kishore
