RE: [Axapta-Knowledge-Village] DIFFERENCE BETWEEN FINANCIAL AND PHYSICAL INVENTORY VALUES
Thank you Gulan I will investigate further to see if there are any other hidden costs which we may not have taken into account. I do agree with you though,that for standard costing if the quantities are equal one should get the same amount. Regards Des _ From: Van Den Langenbergh Gunther [mailto:[EMAIL PROTECTED] Sent: 03 December 2004 02:53 PM To: [EMAIL PROTECTED] Subject: 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 totals of (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:23 To: [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 AM To: [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 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 Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=1297fch33/M=294855.5468653.6549235.3001176/D=gr oups/S=1705001380:HM/EXP=1102164808/A=2376776/R=0/SIG=11ldm1jvc/*http:/promo tions.yahoo.com/ydomains2004/index.html click here http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=groups/S= :HM/A=2376776/rand=648509585 _ 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] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of http://docs.yahoo.com/info/terms/ Service. Yahoo! Groups Sponsor
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 AM To: [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 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 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
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/
