Beas 9.2 PL 5 Hoftix 8 - Errors fixed

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

Past:

**^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' ...

 

Workaround:

If you current use beas 9.2 PL 5 you can replace the mrp_strukturansicht_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]
go

CREATE function [dbo].[to_varchar](@adt_datetime datetime,@as_format varchar(20))
RETURNS varchar(20)
with execute as caller
as
begin
   declare @ls_return varchar(20)
    if @as_format='yyyymmdd'
        select @ls_return=convert (varchar(20),@adt_datetime ,112);
        if @as_format='yyyy-mm-dd'
        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);

 

  return (@ls_return)
end;

GO