[Axapta-Knowledge-Village] Credit Limit.

Dear All, i have checked the Mendatory Credit Limit, and have a credit limit amount. now if customer exceed Credit Limit and under Parameters i have setup as below Credit Limit Type: Balance Check Credit Limit: Balance Message when exceeding Credit Limit: Error now when ever

[Axapta-Knowledge-Village] On hand inventory adjustment - Date

Hi all We need to do a on-hand adjustment to revalue inventory as of a certain closing date. The date which wee need to do adjustments are on the 31/3. Closings have been done until 30/6. When doing a on-hand adjustment selection from the 31/3 closing, the posted quantities and values of

[Axapta-Knowledge-Village] Help On A Calculation With An Exponent.

I have the following calculation I am trying to do: T = (1-((1/(1+I))^n)/I)*((1+I)/I*30)/(1+(I*DFP)/30); I do not get the proper result returned to me. When I try a T=N^2; where N=60, I get a 62 returned. How would I use an exponent in X++.

[Axapta-Knowledge-Village] Weighted Average Date

Hi All, Anyone can help me, please..?? I want to ask about the inventory value in Ax 4, which using inventory model group Weighted Average Date (allow financial negative value). For example: Date 7/2 : purchase 3 pcs @ $2.00 Date 7/3 : purchase 4 pcs @ $2.50 Date 7/7 : sold 2 pcs How

[Axapta-Knowledge-Village] Upload AP Invoice By Excel

Dear All, I am using AX 3.0 and want to upload my AP invoices by excel. I need to know which table contains the AP invoices so I can choose it while creating the excel throw the wizard. Appreciate your help. Thanks Fahad

[Axapta-Knowledge-Village] Restricting Access on Lokup Filter

Hello, I have a form that has a Employee Lookup Filter, and I would like to restrict access on that form and have regular employees not choose anyone else, but allow the supervisor access to the filter. What is the best way for me to accomplish this. I have tried setting a security key

Re: [Axapta-Knowledge-Village] Restricting Access on Lokup Filter

Hi, I think, your supervisor comes from some parameters form, that user can change the value. So, in my opinion, you can put filter code in execute query of datasource, by catching the current login user, and can check its value, with the value setup in parameters. I hope it helps...   Manish

RE: [Axapta-Knowledge-Village] On hand inventory adjustment - Date

Onhand adjustment is base don the last closing. You cannot change this. If you want as at 30/3 then you need to cancell all closing and recalcs back to that date _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of

[Axapta-Knowledge-Village] Sales and Purchase forecast

Hi All Anyone can help me on sales and purrchase forecast. Through financial module I can generate cash flow forecast report, actuals(open order and invoiced) and not forecasted sales and purchase. It would be of great help if anyone can guide me through the steps to include forecasted sales

[Axapta-Knowledge-Village] OLAP Cube Design Problems - URGENT

I am trying to build an OLAP cube . I created a Query My query is like below. Reqtrans Inventtable Relation Inventtable.itemid = Reqtrans.itemid JoinType 1::1 -

Re: [Axapta-Knowledge-Village] OLAP Cube Design Problems - URGENT

hi.. Try creating a view with these tables and bring in all the necessary fields. Attach the view to the query data source. Now try to process the cube. Hope this helps. On Tue, Jul 21, 2009 at 2:09 PM, Gokhan CAN gokh...@agcyazilim.com wrote: I am trying to build an OLAP cube … I

[Axapta-Knowledge-Village] Purchase Order Creation from Purchase Requisition by Centralized User.

Hi every one, Scenario: There are 4 (A, B, C, D) companies. Purchase Requisitions for B, C, D companies will be created in their respective companies. But approving and Converting those Purchase Requisition to Purchase Orders will be done by A company Employer and should be

[Axapta-Knowledge-Village] AX Images in Report builder 2.0 report

Hi All,   I am facing an issue while displaying the images in report builder which are stored in SQL DB from AX. I am able to store the image from AX into an AX table and able to see it in AX image control in a form. How ever I am creating a report in Report Builder 2.0 to show the image in

[Axapta-Knowledge-Village] Querying Ax With XML Documents

Hello all, I need to have a trading partner query the Ax database for available stock and pricing by passing XML and we will respond by sending XML document back. Can I do this within AX, or should I query the database directly from a .NET or PHP scripting.

RE: [Axapta-Knowledge-Village] Re: AX versioning solution

Thanks Anil, I am looking for a full revision solution whereby the user has to submit the revision and have it approved etc before it impacts the system. I have some ideas of how to do it via the user creating new sales orders and these impact existing sales orders once approved. The main