MRP error with alternative items
If you use the alternative item from SAP instead of beas then you could get the error "divide by zero".
Workaround: use the beas item alternative instead of sap item alternative
Alternative materials was not visible for phantom assemblies at the MRP
Previous: alternative items for phantom assemblies was not shown by MRP alternative tab
Bin Management: It does not allow to locate in two or more bin locations at the same time
Previous: Sometimes system did not allow to assign a material twice for different locations
Now: System allows to generate more than 1 booking for different locations
Item - Variant in field quantity was not working properly
Bill of Material - Field Quantity
(1) Old: beas don't saved the formular in field "Quantity". New: Fixed
(2) Old: if you activate "Change" (2), Type of Variable was empty (3). New: Now default Value is number
(3) Old: Type of Variable was always german. Now it's translated
Batch Calculation for 50.000 records throws error in beas_protokoll table
Past: there is an error when clicking on the reset status button. Problem is related to Query on HANA syntax
(<empty>)Error executing Procedure: SQLSTATE = 37000
[SAP AG][LIBODBCHDB32 DLL][HDBODBC32] Syntax error or access violation;257 sql syntax error: incorrect syntax near "prior": line 1 col 81 (at pos 81): Call delete from beas_protokoll where base_doctype='pre...
now: Error is fixed, Queries changed to HANA Syntax
Product Configurator, Set-Object does not read value from Parameter correctly
If you use Set-Objects in Groups, it could be that these parametes (so_) will not "refreshed" after selecting the corresponding parameter (bell_color).
Product Configurator, error 'Variant is already in use' when using an already existing Variant
if you work in the configuration with mode "recognize double entries / automatically":
and you get after running thru the configurator the message, that your configuration already exist under a previous variant number, and this number will be shown upper left in the window......
the Button "update" must be switch to "OK"..... but this will not work...
Time Recording, Flex Time Tolerance/Rounding Rules not taken into account at times passing midnight
Past: When working with a shift that passes midnight there was a problem if the time exceeded the end time of the shift.
If there were rounding in or after the shift, the system had cut the time at the end of the shift.
In the example below the calculated to-time was cut to 2:00
Now: The times will be calculated correct.
Slowness problem in Beas, new Beas version
PreRequisites: This problem is only reproducible with MSSQL 2014 and MSSQL 2016.
Problem: If you try to generate a goods receipt for an existing work order position system creates the SAP document and also generate the journal information. Problem we have is in the query to retrieve account information, with new versions of SQL server some queries has a bad performance. We don't have an error, problem is that process to generate the goods receipt document in some customers take more than 1 minute.
Solution: We modified beas internally to generate queries to retrieve account information in an improved way.
Business Performance / Absorption Cost: Import of Production activities will not work for Multi Branches
if you import Production activities and need this data for the Absorption Costing Results.... you'll get no calculated AC data.
Error when doing a goods receipt or goods issues to BIN warehouse for items with more than 21 characters
Past: we couldn't finish the process when generating a receipt/issue SAP document, this happens when inserting the item into a bin-warehouse.
MRP Filter Drawing number create SQL Error
MRP - Order recommentation - Filter by Drawing number created an SQL Error
**^Error while Display Report: Select Error: SQLSTATE = S0022
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'U_beas_znr'.
SQL-Syntax:SELECT TOP 200 oitm.itemcode, oitm.itemname, oitm.prcrmntmtd, case when oitm.prcrmntmtd='M' then 'Y' else 'N' end kzfertigen, case when oitm.prcrmntmtd='M' ...
If you current use beas 9.2 PL 5 you can replace the mrp_view_search.psr file from beas 9.2-005-031-000
Project System: Don't check the personal costs
past: when performing the calculation of the project budget, the costs related of the work of the personnel is not included.
now: the costs related to the personel activities are included
how to reproduce:
Open the resource Master Data related to the project and change the cost parameters on the Cost tab
Open a personnel master data and check the field "Use own cost rate" and select a cost rate per minute
Open the projects window and create a new project containing a task that has this resource related to it
Then on the work order window create a time receipt for this resource on this new order created related to the project
On the budget of the Project, we can check that the labor cost is included, the same as the journal entries from the work order:
APS – Wrong calculation if you calculate only one workorder, beas don't check the reservation limits.
APS - If you calculate only one workorder, beas doesn't check the reservation limits. It's only working, if you calculate all workorders
Workaround: Execute hshsfollow SQL statement on the SQL Server
drop function [dbo].[to_varchar]
CREATE function [dbo].[to_varchar](@adt_datetime datetime,@as_format varchar(20))
with execute as caller
declare @ls_return varchar(20)
select @ls_return=convert (varchar(20),@adt_datetime ,112);
select @ls_return=substring(convert (varchar(20),@adt_datetime ,120),1,10);
if @as_format='yyyy-mm-dd hh:mi:ss'
select @ls_return=convert (varchar(20),@adt_datetime ,120);