The WIP Report for SAP Business One (SQL version) provides real-time access to the Work Orders and their details that make up the WIP balance in the general ledger. The WIP report allows you to view WIP by work order and drill into the actual work order (with golden arrow) from the report to see other details of the order. The standard reports in SAP Business One do not include a report similar to the WIP report by Audaz.
This report allows the user to validate the balance in the general ledger for work in progress providing subledger detail critical in auditing trial balances. The parent part section shows the work order planned and completed quantity for the work order. The detailed section lists the components that make up the work order and by double clicking the component ID. This will show inventory transactions that articulate with the totals on the report.
The “Ret Qty” column indicates products, whether final product or component, that are returned to inventory. This column will indicate the finished product being put into inventory as well as any components that were sent back to stores.
The report also has a selection to allow you to run a summary report. This is useful if you want a quick reconciliation of Work in Progress to the financial statement.
Do you find yourself wanting to retrieve information that is not found in existing SAP B1 reports? Our custom reports model gives you more value with flexibility to meet your needs. Check out existing reports at our report store that cost a fraction of the cost of report development. If you don’t see what you need, send us a request on our request page and we’ll get you a rapid-fixed-fee quote.
*NOTE: This report only handles non-batch/non-serialized inventory items. It does not handle resources or batch/serial items. If you have a need for this, let us know.