[Axapta-Knowledge-Village] RE: Negative Inventory after posting Picking List ( urgent )
Hi, You have a dimension group for your item where "physical inventory" is NOT on. Therefor he doesn't check on a specific configuration for enough stock (only a check for all configurations together). In your case : he has enough if he doesn't consider con2 because you have 1000 (Con1 + con2). But he stills takes it from the asked con2 so you'll end negative. It is not a bug. To avoid this: check physical inventory on the dimension group for all dimension where you want the check for enough stock for that dimension. In that case he could not have picked it. to rectify: change the the configuration dimension booked con2 to con1 in "edit dimensions" = item - function - edit dimensions or do a transfer in a journal for 300 pcs from con1 to con2 greetz, Gunther From: Gokhan Can [mailto:[EMAIL PROTECTED] Sent: woensdag 16 maart 2005 20:27To: Axapta-Knowledge-Village@yahoogroups.comSubject: Negative Inventory after posting Picking List ( urgent ) Hi; I have a huge problem at my customer. Customer started to complete production order and after posting picking list I have seen some inventory dimensions has negative stock. I have found the bug but I do not know how to solve it... Warehouse is ware_1 Item A has 2 konfigurations Con_1 and Con_2 . I am using batch number and I have a batch number Batch_1 When I check my on hand stock I see ** Con_1 Ware_1 Batch_1 1000 pcs avaliable In my picking list on production order I need 300 pcs Con_2 User who type picking list to system entered like this and posted Con_2 Ware_1 Batch_1 300 and posted with out any error. Now If I chekc my on hand stock I see 2 lines Con_1 Ware_1 Batch_1 1000 pcs avaliable Con_2 Ware_1 Batch_1-300 pcs avaliable Has anybody faced this problem before ??? Is there any solution ? Gökhan CAN Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] RE: Negative Inventory after posting Picking List ( urgent )
hi, i think i made a little mistake. Configuration is not a storage dimension and you can not check/uncheck "physical dimension", it is in fact always on so it always should avoid go negative (ofcourse if in inventory model group phys. neg. inventory is on then everything is ofcourse possible) Wat version do you have? it works correctly in 3.0 SP3. Gunther From: Gokhan Can [mailto:[EMAIL PROTECTED] Sent: donderdag 17 maart 2005 10:05To: Axapta-Knowledge-Village@yahoogroups.comSubject: YNT: [Axapta-Knowledge-Village] RE: Negative Inventory after posting Picking List ( urgent ) Physical inventory is checked as not to use. You have misunderstood I think that I have con_1 batch _1 1000 pcs and have no con_2 at all. The problem is if I check con_2 batch_1 300 pieces , I suppose program to give a message that you have not stock for con_2 batch_1 in ware _1 but t does not give an error create a InventDm by itself and get -300 pieces from that dimension. gkhan can Kimden: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED]Gnderilmi: Per 17.03.2005 10:10Kime: Axapta-Knowledge-Village@yahoogroups.comKonu: [Axapta-Knowledge-Village] RE: Negative Inventory after posting Picking List ( urgent ) Hi, You have a dimension group for your item where "physical inventory" is NOT on. Therefor he doesn't check on a specific configuration for enough stock (only a check for all configurations together). In your case : he has enough if he doesn't consider con2 because you have 1000 (Con1 + con2). But he stills takes it from the asked con2 so you'll end negative. It is not a bug. To avoid this: check physical inventory on the dimension group for all dimension where you want the check for enough stock for that dimension. In that case he could not have picked it. to rectify: change the the configuration dimension booked con2 to con1 in "edit dimensions" = item - function - edit dimensions or do a transfer in a journal for 300 pcs from con1 to con2 greetz, Gunther From: Gokhan Can [mailto:[EMAIL PROTECTED] Sent: woensdag 16 maart 2005 20:27To: Axapta-Knowledge-Village@yahoogroups.comSubject: Negative Inventory after posting Picking List ( urgent ) Hi; I have a huge problem at my customer. Customer started to complete production order and after posting picking list I have seen some inventory dimensions has negative stock. I have found the bug but I do not know how to solve it... Warehouse is ware_1 Item A has 2 konfigurations Con_1 and Con_2 . I am using batch number and I have a batch number Batch_1 When I check my on hand stock I see ** Con_1 Ware_1 Batch_1 1000 pcs avaliable In my picking list on production order I need 300 pcs Con_2 User who type picking list to system entered like this and posted Con_2 Ware_1 Batch_1 300 and posted with out any error. Now If I chekc my on hand stock I see 2 lines Con_1 Ware_1 Batch_1 1000 pcs avaliable Con_2 Ware_1 Batch_1-300 pcs avaliable Has anybody faced this problem before ??? Is there any solution ? Gkhan CANSharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Re: Physical reduction
Thanx, I will tris it out. -Original Message- From: anilsinha1968 [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 11:52 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Physical reduction Hi, There is some difference. If on Item Model group is not set for Physical Negative Inventory. Then you can realize the difference. With you Example: I had production order for EP with 1 BOM line (consumption is 1 on 1) onhand Bom line: 500 BATCH1, 300 BATCH2 started qty 1000 If physical Negative Inventory = No and you have not set for Physical Reduction, it wouldn't allow you to post Pick list. It will return you error that required quantity is less. Because required is 1000 and you have only 800 on hand. If physical Negative Inventory = No and you have set for Physical Reduction, it will allow you to post Pick list. But it will pick only 800 and rest (that is 200) will be remaining. Try this and see the Pick List line and On hand screen carefully you can easily figure it out. Hope this explains the use of Physical Reduction. Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com, Van Den Langenbergh Gunther [EMAIL PROTECTED] wrote: sounds right but it does not do that. I had production order for EP with 1 BOM line (consumption is 1 on 1) started qty 1000 onhand Bom line: 500 BATCH1, 300 BATCH2 when i flag physical reduction and start the production order (i do not post the picking list now) I get a picking list with 3 lines (reservation) 500 BATCH1 300 BATCH2 200 (empty) So I don't see any difference between flag on or off, but thanks anyway anybody experience with this? Gunther _ From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 10:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Physical reduction Hi I think what it does is, is that if there are only 15 on hand of an item, and the BOM requires 20, then the consumption on the picking list will be 15... Does that sound right? Yifat _ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 11:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Physical reduction Hi, Anybody an idea how physical reduction (see production: start) works? Can't figure it out what it exactly means. Thanks, Gunther Sharing the knowledge on Axapta. 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide! http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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/
RE: [Axapta-Knowledge-Village] Re: Physical reduction
Sorry to bother you all again but i don't see a difference when I test itItem: COMPOnhand: 500 BATCH 1 (Warehouse MW) and 300 BATCH2 (Warehouse TW) = this is physical onhand, no other transactions Bom: EP1 EP = 1 COMP Creation Production order for 1000 EP Start Production In picking list journal I see: Wich is exactly the same as if I turn physical reduction off at start. When I would post it it gives me an error because Warehouse and batch is primary and the 200 are not allocated. Anybody sees what's wrong here? thanks, Gunther -Original Message-From: anilsinha1968 [mailto:[EMAIL PROTECTED]]Sent: woensdag 2 februari 2005 11:52To: Axapta-Knowledge-Village@yahoogroups.comSubject: [Axapta-Knowledge-Village] Re: Physical reductionHi,There is some difference.If on Item Model group is not set for "Physical Negative Inventory".Then you can realize the difference.With you Example:I had production order for EP with 1 BOM line (consumption is 1 on 1)onhand Bom line: 500 BATCH1, 300 BATCH2started qty 1000If physical Negative Inventory = No and you have not set for Physical Reduction, it wouldn't allow you to post Pick list. It will return you error that required quantity is less. Because required is 1000 and you have only 800 on hand.If physical Negative Inventory = No and you have set for Physical Reduction, it will allow you to post Pick list. But it will pick only 800 and rest (that is 200) will be remaining.Try this and see the Pick List line and On hand screen carefully you can easily figure it out.Hope this explains the use of Physical Reduction.RegardsAnil Sinha--- In Axapta-Knowledge-Village@yahoogroups.com, "Van Den Langenbergh Gunther" [EMAIL PROTECTED] wrote: sounds right but it does not do that. I had production order for EP with 1 BOM line (consumption is 1 on1) started qty 1000 onhand Bom line: 500 BATCH1, 300 BATCH2 when i flag "physical reduction" and start the production order (ido not post the picking list now) I get a picking list with 3 lines (reservation) 500 BATCH1 300 BATCH2 200 (empty) So I don't see any difference between flag on or off, but thanksanyway anybody experience with this? Gunther _ From: Yifat Halili [mailto:[EMAIL PROTECTED]...] Sent: woensdag 2 februari 2005 10:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Physical reduction Hi I think what it does is, is that if there are only 15 on hand of an item, and the BOM requires 20, then the consumption on the pickinglist will be 15... Does that sound right? Yifat _____ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED]...] Sent: Wednesday, February 02, 2005 11:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Physical reduction Hi, Anybody an idea how physical reduction (see production: start)works? Can't figure it out what it exactly means. Thanks, Gunther Sharing the knowledge on Axapta. 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] mailto:[EMAIL PROTECTED]subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Yahoo! Groups Sponsor ~-- In low income neighborhoods, 84% do not own computers.At Network for Good, help bridge the Digital Divide!http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/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/ 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 the Yahoo! Terms of Service. clip_image002.jpg
RE: [Axapta-Knowledge-Village] Re: Physical reduction
Hi Tom, No, not on, but I honestly don't know how that should relate to each other (does this not only cares when running master planning?) Gunther -Original Message- From: taulbert2000 [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 15:41 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Physical reduction Hi, What's about your inventory dimension? Have you checked the flag Coverage plan by dimension? Tom --- In Axapta-Knowledge-Village@yahoogroups.com, Van Den Langenbergh Gunther [EMAIL PROTECTED] wrote: seems like my outlook makes a mess when i put more than one screenshot I replaced one with text now sorry for that _ From: Van Den Langenbergh Gunther Sent: woensdag 2 februari 2005 14:21 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Re: Physical reduction Oops first screenshots were wrong, here's the good post: Sorry to bother you all again but i don't see a difference when I test it Item: COMP invent. model group = physical negative inv = OFF Onhand: 500 BATCH 1 (Warehouse MW) and 300 BATCH2 (Warehouse TW) = this is physical onhand, no other transactions Bom: EP 1 EP = 1 COMP 1.Creation Production order for 1000 EP 2.Start Production 3.In picking list journal I see: Wich is exactly the same as if I turn physical reduction off at start. When I would post it it gives me an error because Warehouse and batch is primary and the 200 are not allocated. Anybody sees what's wrong here? thanks, Gunther -Original Message- From: anilsinha1968 [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 11:52 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Re: Physical reduction Hi, There is some difference. If on Item Model group is not set for Physical Negative Inventory. Then you can realize the difference. With you Example: I had production order for EP with 1 BOM line (consumption is 1 on 1) onhand Bom line: 500 BATCH1, 300 BATCH2 started qty 1000 If physical Negative Inventory = No and you have not set for Physical Reduction, it wouldn't allow you to post Pick list. It will return you error that required quantity is less. Because required is 1000 and you have only 800 on hand. If physical Negative Inventory = No and you have set for Physical Reduction, it will allow you to post Pick list. But it will pick only 800 and rest (that is 200) will be remaining. Try this and see the Pick List line and On hand screen carefully you can easily figure it out. Hope this explains the use of Physical Reduction. Regards Anil Sinha --- In Axapta-Knowledge-Village@yahoogroups.com, Van Den Langenbergh Gunther [EMAIL PROTECTED] wrote: sounds right but it does not do that. I had production order for EP with 1 BOM line (consumption is 1 on 1) started qty 1000 onhand Bom line: 500 BATCH1, 300 BATCH2 when i flag physical reduction and start the production order (i do not post the picking list now) I get a picking list with 3 lines (reservation) 500 BATCH1 300 BATCH2 200 (empty) So I don't see any difference between flag on or off, but thanks anyway anybody experience with this? Gunther _ From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: woensdag 2 februari 2005 10:37 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Physical reduction Hi I think what it does is, is that if there are only 15 on hand of an item, and the BOM requires 20, then the consumption on the picking list will be 15... Does that sound right? Yifat _ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 11:09 AM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Physical reduction Hi, Anybody an idea how physical reduction (see production: start) works? Can't figure it out what it exactly means. Thanks, Gunther Sharing the knowledge on Axapta. 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] mailto:[EMAIL PROTECTED] subject=Uns ubscribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. _ Yahoo! Groups Links * To visit your group on the web, go to: http
RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES
Also in production you have the same difference between physical amount and financial amount (like with a purchase: packing slip: physical and invoice: financial). Physical amount you could consider as an temporary amount (must be ON in inventory model group). If i'm not mistaken: a production is also a receipt and creates a physical amount when reported as finished (temporary) and a financial when costing (postcalculation) = definitive. Although I never used standard cost price as a validation method (I mainly use AWP) I saw that physical amount was based on qty * costprice (from item table) and financial was the real costprice (i.e. total of components and operations). So in case of FIFO or AWP this will definatly always be different. I only don't know what Axapta takes in case of standard costprice. I should think: the totalsof (QTY's * the standard cost of component) and totals of operations or maybe QTY * (standard cost of your produced item). But the last one seems to me not logic and it that case ofcourse you would end op with the same amount (if the qty's where equal). Gulan From: Des Patsourellis [mailto:[EMAIL PROTECTED] Sent: vrijdag 3 december 2004 12:23To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Thank you for your reply Gulan There was definitely no change in the cost price between the finished and costing phases as we are testing in a very controlled environment. What do you understand the difference between physical and financial inventory to be ? We have done further testing and each production order seems to create a variance between these two values. We have also tried switching off the financial inventory posting in the inventory model group,but then nothing is posted to the finished goods and work in progress accounts (posting only happens to the report as finished accounts). Regards Des From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 11:06 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Hi,I'm not sure but I remember that standard costprice also should berecalculated/closed (according to a specified model)Although receipts and issues are posted at standard costprice theircould be manual changes to the items costprice.Maybe their was a change in costprice between reported as finished andthe time of costing the production order.gulan-Original Message-From: despo1812 [mailto:[EMAIL PROTECTED] Sent: woensdag 1 december 2004 14:47To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL ANDPHYSICAL INVENTORY VALUESHi everyone,I would appreciate your help on the following:I have created a production order which carries a cost of R191.70 Whenanalyzing the integration entries in the Chart of Accounts I noticed thesystem posts Physical Inventory to the value of R191.66 and FinancialInventory to the value of R191.25 and posts the difference to InventoryAdjustment Profit.If one is using Std cost why does it generate this difference?Kind regards, Yahoo! Groups Sponsor ~--Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.Now with Pop-Up Blocker. Get it for free!http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM~- Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES
Hi again, in fact as a addition of my last mail I tested something: if produced item = standard cost = physical (reported as finished) = QTY (reported as finished) * standard costprice (item) = financial (costing) = total of costs components and route (operations) see you, Gulan From: Des Patsourellis [mailto:[EMAIL PROTECTED] Sent: vrijdag 3 december 2004 12:23To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Thank you for your reply Gulan There was definitely no change in the cost price between the finished and costing phases as we are testing in a very controlled environment. What do you understand the difference between physical and financial inventory to be ? We have done further testing and each production order seems to create a variance between these two values. We have also tried switching off the financial inventory posting in the inventory model group,but then nothing is posted to the finished goods and work in progress accounts (posting only happens to the report as finished accounts). Regards Des From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 11:06 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Hi,I'm not sure but I remember that standard costprice also should berecalculated/closed (according to a specified model)Although receipts and issues are posted at standard costprice theircould be manual changes to the items costprice.Maybe their was a change in costprice between reported as finished andthe time of costing the production order.gulan-Original Message-From: despo1812 [mailto:[EMAIL PROTECTED] Sent: woensdag 1 december 2004 14:47To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL ANDPHYSICAL INVENTORY VALUESHi everyone,I would appreciate your help on the following:I have created a production order which carries a cost of R191.70 Whenanalyzing the integration entries in the Chart of Accounts I noticed thesystem posts Physical Inventory to the value of R191.66 and FinancialInventory to the value of R191.25 and posts the difference to InventoryAdjustment Profit.If one is using Std cost why does it generate this difference?Kind regards, Yahoo! Groups Sponsor ~--Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.Now with Pop-Up Blocker. Get it for free!http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM~- Sharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES
Hi, I'm not sure but I remember that standard costprice also should be recalculated/closed (according to a specified model) Although receipts and issues are posted at standard costprice their could be manual changes to the items costprice. Maybe their was a change in costprice between reported as finished and the time of costing the production order. gulan -Original Message- From: despo1812 [mailto:[EMAIL PROTECTED] Sent: woensdag 1 december 2004 14:47 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES Hi everyone, I would appreciate your help on the following: I have created a production order which carries a cost of R191.70 When analyzing the integration entries in the Chart of Accounts I noticed the system posts Physical Inventory to the value of R191.66 and Financial Inventory to the value of R191.25 and posts the difference to Inventory Adjustment Profit. If one is using Std cost why does it generate this difference? Kind regards, Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/kGEolB/TM ~- Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
RE: [Axapta-Knowledge-Village] LIFO and Ave Cost
no problem From: Yifat Halili [mailto:[EMAIL PROTECTED] Sent: dinsdag 16 november 2004 10:03To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] LIFO and Ave Cost Hi Thanks for the quick response. I have just had a look and the client did run a few inventory closes on LIFO would it be ok if I cancelled them? And then change the inventory model group and then should I rerun them? thanks __ Yifat From: Johnny Raadshøj (MICROSOFT BUSINESS SOLUTIONS) [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 10:38 AMTo: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] LIFO and Ave Cost As long as you didn't close or recalculated your inventory it has no implications.If you closed the inventory and your inventory was valuated according to FIFO and not average cost you will have to cancel the close, change the valuation method and close the inventory again.Best regardsJohnny Raadshøj | MBS Axapta Support Escalation Engineer - ANZ SEA | Direct +61 2 9870 2407 | Mobile +61 4 0402 1285 | Fax: +61 2 9870 2210 | [EMAIL PROTECTED]-Original Message-From: yifath1 [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 4:33 PMTo: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] LIFO and Ave CostHi all,I have a client who was setup on ave cost (invent model group). Somehow, someone changed it to LIFO... and we only picked this up now. i dont know when it was changed or who changed it.I would like to change it back to Ave cost, but i dont know the implications.I did get a copy of the database, and changed the there, but when i did a sale the cost amount of the transaction was 0.00...I did a recalculation on the item but the ave cost still shows up at 0.00Can any help?RegardsYifatSharing the knowledge on Axapta. Yahoo! Groups LinksSharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
RE: [Axapta-Knowledge-Village] Constant Production Time for a batch
Hi, My opinion: impossible without extra programming: the route has fewer possibilities than the Bom (who has roundings and mutiple parameters). Gunther -Original Message- From: Üstün Uçtum [mailto:[EMAIL PROTECTED] Sent: dinsdag 9 november 2004 9:27 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Constant Production Time for a batch Hi, This will work for 250 units and multiples, but for 251 units, the time should be 30 min. Where axapta will calculate it as (15/250)* 251 = 15.06 minutes. thanks Ustun Uctum AXIS Information Technologies +90 216 360 06 53 www.axis-it.com -Original Message- From: vaibhav pednekar [mailto:[EMAIL PROTECTED] Sent: Sunday, November 07, 2004 1:17 PM To: [EMAIL PROTECTED] Subject: Re: [Axapta-Knowledge-Village] Constant Production Time for a batch hello UCS, sorry i find ur name difficult to write and pronounce. You can do the following:- In the Route on the operation under times tab u can specify - Run Time - 15 Process qty - 250 hours/time - for this u need to specify the conversion factor for hours to minutes for 30 min it is 0.0167 u can try the following also - Run Time - 30 Process qty - 500 Hours/Time - 0.0167 assuming that u have only one operation for which the times are defined. I hope this solves ur purpose. regards Vaibhav Pednekar --- \st|n Ugtum [EMAIL PROTECTED] wrote: Hi, I have a customer with the following request: Prosess time is 15 min for 1 to 250 pieces. ]n other word, he needs the production time to be 15 min. upto 250 pieces, then 30 min. between 251 to 500 pieces and so on (something just like to multiple in inventory management). Thanks, \st|n UGTUM AXIS Information Technologies +90 216 360 06 53 www.axis-it.com __ Do you Yahoo!? Check out the new Yahoo! Front Page. www.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links Sharing the knowledge on Axapta. Yahoo! Groups Links Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
RE: [Axapta-Knowledge-Village] Isn't weired with Axapta?
Hi subbu, I want to add some thing to the solution already offered. I'm pretty sure Axapta will detect this one by doing a consistency check on the vendor (it's somewhere in Basic - periodic) So if you will hunt down this kinds of 'faults' you could run this checks. They are originated not only by human mistakes but also because of crashes and other things. Probably Axapta will not automaticaly correct this error because it will not now the intention (add it again to payment terms or delete it for all the vendors?). Greetz, Gunther -Original Message- From: Subbu [mailto:[EMAIL PROTECTED] Sent: donderdag 4 november 2004 3:46 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Isn't weired with Axapta? Ax3.0 with SP3: Hi, I have created a new vendor and attached payment terms to 'A'. I went to the table and deleted record 'A'. Now, I came to the vendor which I just created and found still its using payment terms 'A' even though its deleted at the table level. I have two questions. 1. Do you think if it is allowed to delete a record when its in use? is it not violating the RDMS concept against the data integrity? 2. Its still showing up the 'A'. I cleared the user cache, but still its showing 'A' for the vendor. I am just wondering if you accept this issue with me. Any ideas are greatly appreciated!. Is Axapta going to screw my Implemetation ( Largest in USA )? I don't want to support this type of systems!. Thanks, Subbu 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 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/
RE: [Axapta-Knowledge-Village] Inventory Closing
If financial inventory is on (inventory dimension) average cost is not per item but per batch (I think this is what you mean by "actual cost"). The only way to not have awp (temporary is to use standard cost (inventory model group) From: James Flavell [mailto:[EMAIL PROTECTED] Sent: donderdag 16 september 2004 15:56To: [EMAIL PROTECTED]Subject: RE: [Axapta-Knowledge-Village] Inventory Closing 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 salescost to be based on the purchase line amount the sales is reserved against). ThanksJames -Original Message-----From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED]Sent: 16 September 2004 19:01To: [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:58To: [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 jimVan 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 yousee 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:10To: [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 and Improved Yahoo! Mail - Send 10MB messages! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To uns
RE: [Axapta-Knowledge-Village] Inventory Closing
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 yousee 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:10To: [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 and Improved Yahoo! Mail - Send 10MB messages! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
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:58To: [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 jimVan 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 yousee 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:10To: [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 and Improved Yahoo! Mail - Send 10MB messages! Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!?Take Yahoo! Mail with you! Get it on your mobile phone. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT 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 the Yahoo! Terms of Service.
