I guess you know by now why it is average if you dont already have the stock purchased but if you already have it purchased I believe it takes the actual cost (cant total remember right now but I believe so) right!?? Maybe I am thinking of the case when batchnumber is part of financial inventory and all of a batch is priced the same and so average cost of the batch is basically still the same as the actual cost (can someone confirm does Axapta ALWAYS do average cost at time of sales invoice even if actual cost is known???) BTW can anyone tell me is it possible and where to turn off the average cost ... my customer would prefer zero cost to be posted if the actual cost is not known (or alternatively the estimated sales cost to be based on the purchase line amount the sales is reserved against). Thanks James
-----Original Message----- From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 19:01 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Inventory Closing My personal recommendation: recalculate every day (interesting for adjusted production calculations and because of performance => closing will be faster) closing (= recalculate and close) can be done monthly _____ From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: donderdag 16 september 2004 11:58 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Inventory Closing yep .. thanks ... but whats the frequency that you recommend for a recalculation run ... i suspect if the transaction volume is high then you have to run it daily ???? wrong ???? jim Van Den Langenbergh Gunther <[EMAIL PROTECTED]> wrote: Hi Jim, temporary (before closing or recalculation) your value will be wrong in many cases: f.i. suppose you buy and invoice 100 pieces of an item at $20 a piece. (there is no history before this point) later you buy again 100 pieces at $40 a piece but they are only received , not invoiced. First thing: AWP is always used temporary (before recalculation/closing) You sell 50 pieces. You could think that temporary 50 pices are drawn at $30 (because of temporary AWP) This is not true. When "physical value" is off (inventory model group) these 50 will be drawn at $20 because the last 100 don't have financial price (because no invoice), so it doesn't add to the AWP for the moment. If you recalculate/close after the last 100 are invoiced it will correct the AWP to $30 and so also the issue of 50 pieces. Try it for for many examples, it is always a case of: "stock can be issued before all financial value is known, so it is issued a a wrong price". So you see that recalculation is necessary also if you chose AWP. So the rule is: invoice prices (for purchases) and cost calculation (for production) sets the financial value for incoming stock and because you could have issue transactions before you know the definite price for stock you will always have to recalculate/close hope this helps, greetz, Gunther Van den Langenbergh (Belgium) _____ From: Jim Jo [mailto:[EMAIL PROTECTED] Sent: donderdag 16 september 2004 8:10 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Inventory Closing Hi all .. May be this could be a foolish ! Correct me if am wrong ! Costing method used - FIFO ! >From my understandin when you do a recalculation Axapta adjusts the inventory values of those items which were drawn from the inventory on average cost price to the cost price by lot id. Jus curious .. why cannot it be done while doing the transaction itself. And if you use the weighted average costing method there wont be any settlements proposed when you do a recalculation. Please comment ! Regards Jim. _____ Do you Yahoo!? New <http://us.rd.yahoo.com/mail_us/taglines/10/*http://promotions.yahoo.com/new _mail/static/efficiency.html> and Improved Yahoo! Mail - Send 10MB messages! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. _____ Do you Yahoo!? Take <http://us.rd.yahoo.com/mail_us/taglines/mobile/*http://mobile.yahoo.com/mai ldemo> Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT <http://us.ard.yahoo.com/SIG=129jcpvb6/M=298184.5285298.6392945.3001176/D=gr oups/S=1705001380:HM/EXP=1095415302/A=2319498/R=0/SIG=11thfntfp/*http://www. netflix.com/Default?mqso=60185352&partid=5285298> click here <http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S= :HM/A=2319498/rand=851502360> _____ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <http://groups.yahoo.com/group/Axapta-Knowledge-Village/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] ribe> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
<<attachment: winmail.dat>>
