[Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to GL

2004-10-20 Thread markoleary1967
Hi James Answers... * Physical gets posted to a separate GL account to financial. * Setup is done for AR (sales orders) and AP (purchase orders). * Posting seems to work consistently for AR and AP. Hope that makes sense. Cheers Mark --- In [EMAIL PROTECTED], "James Flavell" <[EMAIL PROTECTE

[Axapta-Knowledge-Village] Creating Financial Statements using Rows and Setup

2004-10-20 Thread bob . brinker
Hi Everyone, I hope someone in the group is familiar with creating Axapta Financial Statements. I am trying to determine how Financial Statement rows and Financial Statement (Setup) are used to create Financial Statements? I have checked the Axapta resoureces and cannot find this explained anywh

RE: [Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to GL

2004-10-20 Thread James Flavell
Thanks mark,   Next questions:   Have you setup the system so that physical invetory is posted to GL? If so has it been setup to be done in both AR and AP modules?  If so is it setup to post to the same GL account as financial inventory?   Thanks James   -Original Message-Fr

[Axapta-Knowledge-Village] Re: Inventory valuation reconciliation to GL

2004-10-20 Thread markoleary1967
Hi James In response to your questions * FIFO * Close has been run each month before compare * Inventory is higher than GL * Comparing GL Trial Balance to Inventory>Reports>Statistics>Physical Inventory by Dimension * Version 3.0 Build#1951.2410/514-90 SP2/OP023-19 * Inventory accounts have bee

RE: Possible Spam:[Axapta-Knowledge-Village] Planned purchase order to be grouped by Vendor, Item group and warehouse

2004-10-20 Thread Harry Deshpande
Hi Vaibhav   You will have to finger around in class prodPurch   Regards   harsh   From: Vaibhav Pednekar [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 October 2004 3:48 a.m. To: [EMAIL PROTECTED] Subject: Possible Spam:[Axapta-Knowledge-Village] Planned purchase order to b

[Axapta-Knowledge-Village] Document handling in Axapta 3.0 SP3

2004-10-20 Thread dirk8540
In 3-Thier thin client mode (AOS server) document handling is diabled. In 3-Thier fat client (also AOS mode) and in 2-Thier document handling is working fine. Any Solution? Thanks. Yahoo! Groups Sponsor ~--> Make a clean sweep of pop-up ads. Y

[Axapta-Knowledge-Village] Planned purchase order to be grouped by Vendor, Item group and warehouse

2004-10-20 Thread Vaibhav Pednekar
Dear All, Thank you in advance. Can anybody help me out with code for the following requirement. After master scheduling is run, we get planned orders. Now once the planned purchase orders are generated, i want to firm them in the following way - One Purchase order for items from same item

Re: [Axapta-Knowledge-Village] X++ to Convert Negative to Positive

2004-10-20 Thread Subrahmanyam Mamidi
Its me again.   why do you want to use already existing function abs()? This makes your life easier.   /*/  return Abs(InventJournalTrans_Qty)will return the absolute ( positve ) value.   /***

Re: [Axapta-Knowledge-Village] X++ to Convert Negative to Positive

2004-10-20 Thread Subrahmanyam Mamidi
1. Are you sure that you have specified the datamethod  and the data source ( in the field properties ) for this function?.    2. After that, can you reset the compilation errors to see the refreshed errors. 3. It may be required to modify the code as below.   /*

[Axapta-Knowledge-Village] use business analysis whith oracle 9i

2004-10-20 Thread sguettler
hi all, what is the best way to bring axapta 3.0 business analysis (OLAP) in contact whith an oracle 9i database? is it neccessary to use the microsoft sql anaylsis server or is there an ohter possibility? thanks for help!! sascha Sharing the knowledge on Axapta. Yahoo! Groups S

Re: [Axapta-Knowledge-Village] X++ to Convert Negative to Positive

2004-10-20 Thread Varden Morris
Bob   I see nothing wrong with the method away from the bracket that comes before you assign a value to the variable result.[EMAIL PROTECTED] wrote: Hi All,I am trying to convert a negative number to positive for a report and amgetting errors:1-Unknown source for data method Quantity2-Operand Ty

RE: [Axapta-Knowledge-Village] Inventory valuation reconciliation to GL

2004-10-20 Thread James Flavell
A few things to get the ball rolling:   What type of model are you using? avg, FIFO, STd? I take it you have been running the closing every month (or before you compare invent and GL)?   Which module has the higher value?   Which reports are you using to comapre the modules? Which vers