Re: [Axapta-Knowledge-Village] Currency Issue

2006-01-07 Thread Alejandro Lozano
Hi Brandon, We had the same issue some weeks a go, and the way we fixed it was just to increase the numbers in: General Ledger/Setup/Parameters/Maximum Penny Difference (ie. 0.09) and Maximum Penny-rounding in secondary currency, hope this help Regards AxAlex --- Brandon George <[EMAIL PROTEC

Re: [Axapta-Knowledge-Village] EnterprisePortal

2006-01-07 Thread hany abodoma
thanks that is very nice helpkumar gaurav <[EMAIL PROTECTED]> wrote:in the developer help file you have very nice tutorials to start with.   they are areally helpful, another document available is with product CD.   hope you will find it usefull   bye Kumarhany_abodoma <[EMAIL PROTE

[Axapta-Knowledge-Village] Currency Issue

2006-01-07 Thread Brandon George
Hello everyone!    I hope everyone is doing great. I wanted to review an issue that is going on right now that we have. You see we have a company who mostly sale's and deals with USD currency. But the company does have Canadian Customers who they want to bill in CAD Dollars. When they try

Re: [Axapta-Knowledge-Village] Axapta query

2006-01-07 Thread Varden Morris
Try this buddy:         InventDim inventDim;    InventSum inventSum;    InventQty inventQty;    ;     while select sum(postedQty), sum(received), sum(deducted), sum(registered),    sum(picked), sum(reservPhysical)    from InventSum group by itemId    join InventDim

[Axapta-Knowledge-Village] Re: Programmable sections

2006-01-07 Thread drescher_r
--- In Axapta-Knowledge-Village@yahoogroups.com, amit bansal <[EMAIL PROTECTED]> wrote: > > hi dear Hi hunny! ;) >basically prog section are used for the complex design reports > what u hav to do just pick the data according to ur query and display in the prog section according to u

[Axapta-Knowledge-Village] Axapta query

2006-01-07 Thread fhfaulknor
I'm trying to get the quantity on hand for an item in a particular wharehouse. I have the equivalent SQL query, but unable to convert it to Axapta query. This is the SQL query: SELECT SUM(postedQty + received - deducted + registered - picked - reservPhysical) FROM InventSum iSum INNER JOI