Sap-Business-One-Tips-Tricks

Page 2 of 40
1. Create a Production Order.
2. Issue only some of the components to production: A1007 – 4 Units A1110 – 4 Units
Page 3 of 40
At this stage, the ‘Actual Component Cost’ field is updated in the ‘Production Order’:
Index
Page 6 of 40
Why does an item which is defined as a Sales Bill of Materials show 100% as gross profit in the Gross Profit window?
Business Scenario: In Document Settings -> General tab the display for a bill of materials (BOM) of a sales type is set to ‘Price and Total for Parent Item Only’. This setting allows users to enter a sales price on the parent item instead of setting independent sales prices for the component items. The ‘Base Price Origin’ field is also set at ‘Item Cost’ as basis for gross profit calculation.
Page 4 of 40
3. Receive the finished item through the ‘Receipt from Production’ window.
It is at this stage the ‘Actual Product Cost’ and the Total Variance fields are updated in the ‘Production Order’:
This value has been computed using this formula: Issued Quantity x Current Cost Hence:
Component A1007 A1110 Total Issued Qty 4 4 Current Cost GBP 83.34 GBP 13.00 Total Cost GBP 333.36 GBP 52.00 GBP 385.36
From the Documentation Resource centre, expand the required version e.g. SAP Business One 2007 -> Data Transfer Workbench Product Enhancement Solutions go to: A-Z Index - Product Enhancement Solutions Self Help go to: Support Self Help Application Archive: Expert Empowerment Sessions Reconciliation Engine in 2007 Notes
Expert on Phone Newsletter
September 2008 NhomakorabeaEditorial
Welcome to the September edition of the “Expert on Phone Newsletter”. For all of you who found this summer to be a bit wet and cold (especially in Europe) I hope the following Tips and Tricks will help cheer you up. Tips in this edition include: Calculation of Actual Component and Actual Product costs in production, and Gross profit in Sales BOM; How to stop users from creating/updating BOMs; How to populate Prior Period Bal in Customer Statements and Profit Centres in JE based on marketing docs… Should you have any comments/feedback please send to d.shah@.
Index
How are Actual Component and Actual Product Costs computed during a production process? Why does an item which is defined as a Sales Bill of Material show 100% as gross profit in the Gross Profit window? How to set up alerts for ‘Task’ Activities? Where does the default ‘House Bank’ come from when using ‘Cheque’ as a means of payment in the ‘Outgoing Payment’ window? Why are open A/R Invoices not shown in Recommendation Report during the Dunning Wizard run? Why can users with ‘Read-Only’ authorisation to Price Lists not create or update Bill of Materials? How is the field 'Prior Period Balance' populated in the 'Customer Statement' print out? How is the ‘Info Price’ field used in Goods Issue function under Inventory -> Inventory Transactions? Why are Profit Centres set in marketing documents not showing in journal entries? How can we change the number of Invoice lines appearing in the Cheque for Payment stub?
Note: The ‘WIP – Variance’ Account is taken from the ‘WIP Inventory Variance Account’ field in the Item Group, Warehouse or Item Level depending on the setting on the ‘Set G/L Accounts By’ field of the Parent item.
Component A1007 A1110 Total Planned 5 8 Issued Qty 4 4 Difference 1 4 Current Cost GBP 83.34 GBP 13.00 Total Cost GBP 83.34 GBP 52.00 GBP 135.34
The ‘Total Variance’ field is also populated by the sum of the variances that occurred during the production process; in this case it is GBP 135.34. 4. When the Production Order is closed, the system automatically creates a journal entry for the ‘Total Variance’ as follows:
Page 7 of 40
The Sales BOM is shown below:
Popular Links Service Market Place From the Service Market Place Link to get to: Documentation Resource Centre Go to: Support Online Support - Documentation Resource Centre Data Transfer Workbench (DTW) Landing page
Page 5 of 40
The Actual Product Cost of GBP 520.70 is computed as the ‘Actual Component Cost’ plus any difference between the ‘Planned’ and ‘Issued Quantity’. Hence: Actual Component Cost + Quantity Difference = GBP 385.36 + GBP 135.34 = GBP 520.70 The Quantity Difference of GBP 135.34 is calculated as follows: