[Axapta-Knowledge-Village] Grids that show only One Record, not all Records, no filters!

2010-09-08 Thread George Burrell
We have an AX 2009 SP1 hotfix rollup 4 installation. I have struck an unusual, and seemingly intermittent issue. When starting an AX client on the AOS server many grids only shows one record - Users, On line Users, Sales Orders, Customers. A report we were testing shows one line also. On

[Axapta-Knowledge-Village] Re: Changing Units of Measure in AX2009

2010-08-30 Thread George Burrell
Thank you for this Michael. Have you considered bringing the feature back through modifying this class? I suspect it might be prudent to follow the lead of Microsoft on this occasion. George B

[Axapta-Knowledge-Village] Sales and Cost of Sales in conflict in AX 2009 - one order line

2010-06-10 Thread George Burrell
Strangest thing I have seen in a long while. We have a case where the Sales quantities and values on a Sales Invoice are for partial delivery. They are also correct Cost of Sales and Inventory are for the FULL order! There was a Credit Note raised for the Partial Delivery - and I was

[Axapta-Knowledge-Village] Re: Financial Statements - making reports capable of back-dating

2010-05-24 Thread George Burrell
Thank you for this suggestion. However it is my belief that a correctly defined Date Interval Code should take care of the backdating for us. I don't want users changing anything but Reference Date. When setting up the Date Interval Codes, I thought I detected some difference between the

[Axapta-Knowledge-Village] Financial Statements with Dimension Filter and 100% columns - AX2009

2010-03-23 Thread George Burrell
Here are steps to re-create: IMPORTANT - Dimension Focus to be Account and One Financial Dimension - e.g. GL account and Cost Centre Build simple row definition - say 3 GL Account Element lines. Build 3 columns in a report to use the above .. Main Focus, a Current Column, and a 100%

[Axapta-Knowledge-Village] Re: Job to Zero Out Inventory Cost

2010-03-03 Thread George Burrell
Obviously an Inventory Close needs to be a part of this. Also ensuring Items are at Financial status - not a mixture of Physical and Financial. This is somewhat dependent on parameter settings and choice of Costing policy - I assume this is Weighted Average in this case because of the choice of

[Axapta-Knowledge-Village] Re: Job to Zero Out Inventory Cost

2010-02-22 Thread George Burrell
Joe, which cost policy are you using here. Judging by the procedure you are following, I suspect it is Weighted Average or Date Weighted Average. You have not mentioned whether you performed a CLOSE once you have completed this work. If my above assumption is correct, then a Close would

[Axapta-Knowledge-Village] Re: New Fields on Purchase Tab of Inventory Posting Profiles

2010-02-18 Thread George Burrell
Useful response thank you James. I am thinking that certainly for FIFO that no change would be necessary. Perhaps the big clue is the presence of the Purchase Packing Slip Tax posting capability. It looks like the accrual for tax can be kept separate from the accrual for the goods and

[Axapta-Knowledge-Village] Re:Phd Survey ERP systems

2009-11-27 Thread George Burrell
I tried to participate in the survey but it did not work. Surprise! George

[Axapta-Knowledge-Village] Creation of PDF Files from AX print dialogue

2009-09-29 Thread George Burrell
Hello. At our site we ARE able to print to a PDF if we are on Terminal Services. We CAN print to PDF if we log into an XP work station as the XP administrator. PROBLEM : We can NOT print to PDF from Ax 4 if we log into the XP machine as a regular (non-administrator) user. Network

[Axapta-Knowledge-Village] Sales Documents : e-mailing of PDF attachments

2009-08-11 Thread George Burrell
Has anyone else struck issue where it is possible to Post (say) a Sales Order Confirmation, with printer being e-mail and file type PDF from Terminal Services (Windows Server 2003) BUT Error messages and corrupt PDF created if from XP Work Station? I am trying to find out if we have

[Axapta-Knowledge-Village] Re: Unit of Measure conversion -- URGENT Pls. FOR POSTED TRANSACTI

2009-07-26 Thread George Burrell
You may find you need to use Inventory Management Periodic Close Adjust Adjustments to correct the unit costs of receipts, in order for stock issues and stock to have the correct unit costs as well after the close. This would probably need to be used in conjunction with Inventory Counting

[Axapta-Knowledge-Village] Re:Posting Inventory Transaction without posting to ledger accounts

2009-07-13 Thread George Burrell
Cutting this operation out of the Inventory to General Ledger Interface may be near impossible - Bills of Material Journals are regarded as another Inventory feature along with Counting, Profit and Loss, Movement Journals. I would normally set up the Posting Profiles (Production Tab) so that

[Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions

2009-07-07 Thread George Burrell
Even though you have a fully settled receipt transaction, what happens if you want to adjust a purchase price on a fully settled receipt transaction. What happens if it is linked to a fully settled issue transaction. In my mind, being fully or partially settled is not relevant for the

[Axapta-Knowledge-Village] Re: Inventory closing adjusting already closed transactions

2009-07-04 Thread George Burrell
To me the main impacts of a Close (as opposed to a Recalculation) are as follows: (a)No further INVENTORY TRANSACTIONS permitted up to that date. (b) Receipts have permanent links to specific issues. The VALUES in these links can be adjusted. (c)Drill down of Settlements lead to

[Axapta-Knowledge-Village] Re:Inventory closing adjusting already closed transactions

2009-07-02 Thread George Burrell
This is normal. Even in a closed period, if a Purchase Price is adjusted (e.g. through Close/Adjust Adjustments etc), the impact of that has to flow onto issues of stock if they are linked to that Purchase transaction. Don't confuse this with the GL impact, which of course be felt on the

[Axapta-Knowledge-Village] Re: Urgent Help Required- Sales Advance Invoicing

2009-06-24 Thread George Burrell
This sounds more like a Pre-payment to me! Pre-payments can be linked to a specific Sales Order. Work through this option.

[Axapta-Knowledge-Village] Inconsistency - Vendor Balance and Open Transactions

2009-05-26 Thread George Burrell
Greetings We have just encountered a very, very unusual scenario. The Vendor Balance is approximately $40, while Open Transactions is zero! This appears to be a consistency problem - analogous with having Inventory On Hand not matching the sum of the Inventory Transactions total.

[Axapta-Knowledge-Village] Vendor Account Statement and Vendor Ageing Report disagree

2009-05-26 Thread George Burrell
Issue Number 2! Another very, very rare issue. Has anyone found Vendor Account Statement failing to reconcile with the Account Balance and the Vendor Ageing Report? Site is at Version 3 Service Pack 6. We will be checking for relevant fixes in V4 and AX 9005, but thought I would share

[Axapta-Knowledge-Village] Printing to PDF Printer

2009-04-16 Thread George Burrell
Printing documents such as Sales Confirmations, Delivery Notes, Invoices etc is causing some issues .. Seems that the documents DO print if certain Terminal Services users are logged in. But for others, there are obstacles. I would have thought that messages below would not be so

[Axapta-Knowledge-Village] Re: Microsoft Support Question

2009-03-27 Thread George Burrell
Microsoft Support is superb in Asia/Pacific. They always go the extra mile. Just take care with how you manage your side of the arrangement. The partnership relationship works very well for me. George

[Axapta-Knowledge-Village] Inventory Valuation by Dimension is inaccurate?

2009-03-02 Thread George Burrell
For a big installation, I have noticed that Inventory Valuation By Item Group is far more accurate that Inventory Valuation By Dimension. The difference seems to be that the report by Item Group correctly takes account of the situation where there is a positive Financial Quantity and a Negative

[Axapta-Knowledge-Village] Re: Urgent-Decimal Places in Purchase Unit Price

2009-03-01 Thread George Burrell
Why not use Price per quantity? For example, put in price to 2 decimal places, but with price quantity of 1,000. I think this area can become complicated if you are pricing to 5 decimal places, but producing invoices etc to 2 decimal places. The pricing quantity is standard is Ax

[Axapta-Knowledge-Village] Re: Need help in Master Planning in AX9

2009-02-22 Thread George Burrell
There is another parameter that is influential for planning of items: You can forecast for Today's Date, or Days Date plus Lead time. The latter produces some strange results - it will tend to ignore Purchase Orders during lead time. Has anyone else encountered this, and if so, what did

[Axapta-Knowledge-Village] Re:Master Planning

2008-12-23 Thread George Burrell
Currently Inquiries Nett Requirements Update on each Sales Order would provide the answers. Not sure what you mean when you say planning must be with respect to Sales Order line only. I suppose if your policy was Requirement (AKA lot for lot), then a particular Sales Order line would suggest

[Axapta-Knowledge-Village] Re: Trade Agreement Imports

2008-12-22 Thread George Burrell
Thank you for the suggestion here. I have checked the Dimension Groups and found Purchase Price is activated for all groups that have Warehouse as a Dimension. However I was really pleased to have your suggestion - it did remind me to check this rather obscure setup. George

[Axapta-Knowledge-Village] Trade Agreement Imports

2008-12-21 Thread George Burrell
Has anyone seen the following: Wanting to import Trade Agreements with different prices for different WAREHOUSES However as far as the Import program is concerned, the Warehouse is not part of unique key, therefore it is treated just like the price itself. Therefore, if your import file

[Axapta-Knowledge-Village] HTML e-mail messages as part of Print Management

2008-11-18 Thread George Burrell
Hello A client wishes to Include HTML message in body of an e-mail during Sales Order - Delivery: Hi Bill Smith Thank you for placing your order with Torpedo7 Ltd. We can confirm shipment of your Order Number 414043 It was dispatched on 11/11/2008 You can track you shipment's

[Axapta-Knowledge-Village] Exorbitant Number of Iterations .. FIFO Cost

2008-11-11 Thread George Burrell
I was running recalculation on two items in a Manufacturing company with quite deep Bills of Material, and also lots of Sales Order to Purchase Order links (in lieu of stock transfers). These people have also got some intercompany links set up but within a single company. Adjustments to Physical

[Axapta-Knowledge-Village] Re: Mixing Financial Dimensions on Inventory Postings

2008-11-05 Thread George Burrell
Rishi On thinking about this further, the requirement may not be so radical! When you enter an Inventory Movement Journal line, you are prompted for GL account for the expense side of the posting. I am informed that it should be technically feasible to allow user to enter a series of

[Axapta-Knowledge-Village] Mixing Financial Dimensions on Inventory Postings

2008-11-03 Thread George Burrell
Hello experts An unusual request today - I have been asked to suggest means whereby: Debit Expense Account Credit Inventory .. In a Sales (or Inventory Journal) process could be given different dimensions for Debit and Credit lines I have checked both accounts, Dimensions 1

[Axapta-Knowledge-Village] Master Scheduling, Transfer Orders, Marking, Reservations

2008-10-14 Thread George Burrell
We have situation where a Branch of an organization wants to sell an item that is stocked at the Head Office. I can make Head Office be replenishment Warehouse for the Branch - either for the item, or for everything. I can set a parameter for Master Scheduling that has Marking Standard.

[Axapta-Knowledge-Village] Re: Inventory Recalculation

2008-09-21 Thread George Burrell
Yadhav You say: --- My requirement is such that During the Invoice(which is received during the next month), the rate of the item might Change. So how will it affect the Item rate since the Inventory is already closed for the month. I have packing slip updated the item for

[Axapta-Knowledge-Village] Re: Inventory Recalculation

2008-09-17 Thread George Burrell
If you can get away WITHOUT ticking Include Physical Value, I strongly recommend you do so. The advantage of recalculating Financial Values only is that any adjustment go into the designated Adjustments field on the Inventory Movement. Adjustments to Physical Values modify the Physical Value

[Axapta-Knowledge-Village] Marking puzzle

2008-09-17 Thread George Burrell
Good afternoon subscribers Has anyone had any problem when manually marking a Sales Order to a Purchase Order.. The list of Purchase Orders I am presented with includes SOME of the invoiced Purchase Orders, but not all. I see 3 invoiced Purchase Orders, but the earliest invoiced

[Axapta-Knowledge-Village] Base Calendars

2008-09-07 Thread George Burrell
Trying to provide user documentation on working with Calendars, Working times etc. According to official documentation, Base Calendar means more than just an original to copy from. Changes to Base Calendar should actually feed through to those days, identified with Base Calendar Control, in

[Axapta-Knowledge-Village] Job Scheduling _ Scheduling Date

2008-08-24 Thread George Burrell
On two different installations of Ax - one LIVE one TEST (but different data) we see strange issue. When going Update Job Scheduling on a Production Order, we see Scheduling date in June 2008. One says 25/6/2008, the other 19/6/2008 as defaults. When I actually click OK to make Job

[Axapta-Knowledge-Village] Creation of PDF to attach to email

2008-08-20 Thread George Burrell
I need to be emailing PDF attachments for Delivery Notes, Invoices etc. Have it all set up in Print Management. The trouble is that a number of these will not be able to be opened by recipient .. Get error message along the following lines: There was an error opening this document. The

[Axapta-Knowledge-Village] Re: Movement journal for initail inventory load

2008-05-11 Thread George Burrell
I really can't see the counting journal having any particular advantages over the movement journal! The movement journal allows you to nominate the offset account for posting which is of course helpful. Our developer wrote a program along the lines of the approach documented in the Developer