help-zahnradData check

Administration > Utility programs > Database Test > Data check

Top  Previous  Next
Expand/Collapse Toggles

Beas includes a data check function which checks all relevant data for consistency.

 

As Beas can only function correctly if data is consistent, all errors that occur during the data check must be processed and rectified in advance.

 

The data check is started for example

- if a program update is performed

- via Administration > Utility programs > Data Check

 

The data check is performed immediately. The Beas data check always creates messages using the Beas message system. As well as displaying the error, the message window offers help or appropriate interactive analyses. Messages from data check cannot be created as SAP activity. The message window is opened automatically if messages are output, and it can be opened afterwards via Administration > Utility programs > Data Check.

 

If there are data errors that could affect the MRP run or APS material check, a warning is displayed when starting the MRP run, although it will still start in most cases.

 

The following tests are carried out:
- Data content check

- Check and extension of Procedure SBO_SP_TransactionNotification
- Plan times of all resources and resource groups are calculated
- Standard calculation schema is checked and corrected if necessary
- Manufacturing Position: The switch "Disposition", "Order reporting", "Material posting" and "Consideration of scheduling" are checked and corrected if necessary
- Operation types are checked and adjusted, installed, or corrected
- Quality control orders: cross-references are checked and corrected
- Print documents: The table beas_document_header / beas_document_line are rebuilt. If necessary, re-defined UDF's are added.
- WEBAPP: standard Web applications are imported
- Several default values ​​are set
 

Via "news" at any time the result of the test can be viewed. After a new check, previous results are deleted from the message list and new ones are inserted. See news

At the end of a message the message number is displayed. A blue question mark indicates that additional information is available on that topic. Click the icon.

Use the button "Close activity" to hide selected messages. Multi-selection is supported.

 

In the following list all possible messages are summarized:

Message

Meaning

tnsfnfg04442

Beas adds various extensions to the procedure on SBO_SP_TransactionNotification.

 

tnsfnfg04443

Beas adds various extensions to the procedure one SBO_SP_TransactionNotification. In this case, an SQL error has occurred. More information in the messages when you click "View".

tnsfnfg04444

Beas adds various extensions to the procedure one SBO_SP_TransactionNotification. This process has not been carried out - or the procedure does not exist.

checkdb05l044

Extended error notification system enabled: Configuration Wizard > System > Extended Error Messages: SAP activity

In this case, a business partner needs to be defined - switch below, "activity business partners" because the SAP Business One activity-system requires the disclosure of a business partner.

If nothing is done, no activities are generated.

checkdb05lacc44

In a perpetual inventory system, the WIP accounts must be set up. Affected is the WIP stock account and the WIP inventory variance account.

After creating accounts, set up in Configuration wizard > Production > Valuation and booking of assembly > Account Determination > Define WIP accounts > "START" button, or press the button directly in the message.

Account determination is done automatically and must be checked afterwards.

If these are not specified, no postings are possible in the production area.

checkdbwialacc44

In Configuration wizard > Production > Valuation and booking of assembly > Account Determination > Define WIP accounts > "START" button, the WIP accounts are defined. Faulty or nonexistent accounts had been deposited and must be corrected.

If no correction is made, no postings are possible in production.

blockzeroq1dbc

"Block negative stock" has been disabled. When working with negative values, no MRP is possible. All planning functions in Beas are blocked as a result.

Action: re-activate this switch!

 

 

ass55manageonhnd

Negative stocks are present in the system. as a result, planning functions will put out incorrect values. To keep data approximately correct, Beas does not consider negative values in the planning functions.

Action: correct existing negative stocks and bock the negative posting facility completely.

 

Setup: Administration > System initialization > Document settings > Block negative inventory by: enter "Company"

ass55itemdfltwh

 

ass55wbz93

For several items no lead time is stored. If there is a scheduling ID, a lead time is also required. Otherwise there will a wrong requirement date in the order recommendation report

 

For assemblies, this can be done automatically if routings are stored. Enable:

ass55w5z93

For several items a faulty material group is stored. If no material group is stored, this can lead to erroneous results in the calculation.

 

Material groups are defined under Administration > Setup . Inventory > Material group and deposited in the Item master > Material Group.

ass55w5del

Incorrect item number. There are item numbers with illegal characters.

Under no circumstances may be used: spaces (Asc 32) and apostrophe (Asc 39).

This could lead to severe program errors in any area.

ass55wbz9d

For several items of type PURCHASE PART a faulty or no scheduling ID is stored. Please check scheduling in the item master, see "breakdown".

 

Without correction, the order recommendation report works incorrectly.

ass5dsbz9d

Several items are defined as manufacturing parts, without having the scheduling ID. Please set the switch "break down" for the affected items.

 

Without correction, the order recommendation report works incorrectly.

ass55item1unitstl

For several BoM items a value is missing for quantity factor.

Without correction, this can lead incorrect calculations, for example in

 

- Precalculation

- Manufacturing

- Order recommendation report

 

Please correct corresponding BOM items. Edit BOM > Quantity field "per"

Affected in the bill processing is the "ever" (the amount field, after the word "each")

ass55itemunitvb

 

ass55itemunitbom

In several item part lists quantity units are stored, which are not stored in the data base.

Without correction, this can lead to incorrect calculations, etc. in

 

- Precalculation

- Manufacturing

- Order recommendation report

 

Action: there are two possibilities:

a) Enter missing units under Administration > Setup > Inventory management > Units of measurement

b) Edit BoM - behind the quantity" field there is the field for the unit

c) Edit item master > "General" tab > orange arrow after "Production UoM"

 

ass55item1unitvb

In several BoMs unknown item numbers are stored, or item numbers are missing.

 

These entries can lead to additional errors:

- No consideration in order recommendation report

- No postings possible

 

Beas offers an automatic correction.

ass55itemunitvbm

In item entries Inventory / Production UoMs are defined, which have no conversion formula.

Result:

- Incorrect calculation in order recommendation report. For this reason, the calculation is disabled.

- Erroneous postings

 

Two possibilities to solve this problem:

a) enter conversion formula under Administration > Setup > Inventory management > units of measurement

b) Correct units o.M. in Item master > "General" tab > orange arrow after "consumption unit"

assv1w5del

Item Version

Items that have item version(s) and are neither batch- nor serial-managed are not supported. For MRP to run correctly, remove the item version from these items or convert them to batch-managed items. (assv1w5del)

assv2w5del

Item Version

IMPORTANT: Items that have item version(s), are neither batch- nor serial-managed, and have separate bill of materials are not supported.

For MRP to run correctly, remove the item version from these item or convert item to batch-managed items.

Note: You must fix this before using MRP.
 

calccheck303245

With Beas 2008-0-11-22 the connection between Offer/Customer order and the Precalculation has been changed. With this repair program the connection can be reestablished for existing documents. The repair should always be performed.

repcheck03245

The communication module has been installed. There are standard reports are available, which need to be imported once and which can be changed or adapted. It is recommended to import these reports.

qscheck13245

Quality control order - quantity units: For a correct display of the measurement positions a unit needs to be deposited. Otherwise, no decimal places are displayed.

Beas has issued a correction program to fill default values.

1. Click on edit to open the editing window.

2. Enter a valid unit of measure

3. This will be entered to all measurement positions, which do not have stored a unit of measure.

fagcheck03245

External operations: The data structure has changed. Costs of external operations are now stored in a different field. Existing entries have to be adjusted. Beas can perform the correction automatically.

If no correction is made, pre- and post-calculation cannot calculate correctly, valuation methods lead to erroneous results and to erroneous account postings.

amgmet0435

In item master (OITM) there are entries in which "mngmethod " is not filled.

It may be that these items cannot be edited or posted. Click on "Edit" to perform an automatic correction.

ass75itemunitvbm

Order related items in storage orders.

There are make to stock work orders, in which order-related items are stored. For a correct calculation in order recommendation report, these work orders need a reference to customer orders.  

Click EDIT to open the list of all affected positions.

ass55waoapl00

Work order - work sequence 0.

There are work orders with a work sequence containing a position 0. This position will not be processed correctly and should therefore be deleted.

Click EDIT to open the list of all affected positions.

ass55woabgkzft

Several production items are not completed. There are unfinished work item in closed work orders.

This condition can lead to problems. Click EDIT to display production list with all affected work  orders. These need to be re-opened. Open work order > right-click > select "Open". Then it can be closed again. The associated components are also closed and the necessary closing entries (WIP Account crediting) are performed.

amgmet1pers32

Links to Human resource master.

The Beas and SBO HR master are now linked. There are some entries in which the connection is not correct. The link here may be performed automatically.

ass35afolink

Wrong BoM links.

BoMs are linked to non-existent operation sequences. Click EDIT to display all affected assemblies.

If no correction is made:

The affected BoM items are not posted during backflushing.

ass35resok

Resources without capacity.

There are several resources without free capacity. In order recommendation this leads to infinite lead times! Affected column: planning/planned capacity or number Machines|Employees

ass35priceok

Resources without costs.

There are several resources at no cost. This leads to wrong results in calculation.

Affected: Fields COSTS/ cost ratio to marginal costs and total costs.

ass35grpok

Resources with wrong group assignment.

There are several resources without or with incorrect resource groups. Click EDIT, the resource list opens where the resources can be corrected.

agcheck001

In several entries faulty operation types are registered.

Effect: various functions are not shown because these have been deposited in operation.

Measure:

a) correct manually: If you click on the message "EDIT", all document types are displayed, in which a faulty operation type is stored.

b) create the missing operation types

c) carry out the correction using SQL

 

Example: Add operation-type 'std' if link is corrupted

1. Creating an operation type "std"

2. Execute the following SQL statements

 

update "BEAS_AG" set "AGTYP"='std' where "AGTYP" not in (select "AGTYP" from "BEAS_AGTYP")

update "BEAS_APL" set "AGTYP"='std' where "AGTYP" not in (select "AGTYP" from "BEAS_AGTYP")

update "BEAS_FTAPL" set "AGTYP"='std' where "AGTYP" not in (select "AGTYP" from "BEAS_AGTYP")

srivv040

Serial numbers need to be unique. Otherwise Beas will not work correctly.

 

In Administration - System initialization - General settings - Stock - Unique serial numbers by set to "serial numbers"

Using other settings, serial number related items cannot be posted in Beas, because serial numbers are always displayed for selection.

With another setting, at postings the following error could occur:

10001172 - Leere Strings sind in Zeile 1 (eindeutiges Feld) nicht zulässig [OSRN.SysNumber][line: 0]

 

Measurements:

Use settings as described above. If a change of settings is impossible due to existing data entries, serial numbers need to be entered subsequently.

 

 

510XXX error codes:

Error code

Description

510010

'(extwo92241) Incoming goods for the external production must be registered via production - external production - Incoming goods for external production'

510020 

set @error_message=  'Item with wrong or missing itemversion in '+@ls_1+' Numbers window: '+@ls_2

510030 

set @error_message=  'Item locked by itemversion control:'+@error_message

510040 

set @error_message='negative stock on a Bin-Warehouse is not allowed'

510050 

left('Reserved goods cannot be charged: '+@error_message

510060 

Item(s) locked by itemversion control:'+@error_message,200)

510070 

negative stock in a Bin-Warehouse is not allowed'

510080 

Locked by reservation system: '+@error_message, 200)

510090 

Item(s) locked by itemversion control:'+@error_message

500011 

set @error_message='negative stock in a Bin-Warehouse is not allowed'

510100 

Locked by reservation system: '+@error_message

510110 

Item with wrong or missing itemversion in '+@ls_1+' Numbers window: '+@ls_2

510120 

Item with wrong or missing itemversion in '+@ls_1+' Numbers window: '+@ls_2

510130 

negative stock in a Bin-Warehouse is not allowed'

510140 

Locked by reservation system: '+@error_message, 200)

510150 

Blanket Agreements and Sale Order must have the same I-Version: '+@error_message

510160 

Item(s) locked by itemversion control:'+@error_message

510170 

Item(s) locked by itemversion control:'+@error_message

510180 

negative stock in a Bin-Warehouse is not allowed'

510190 

Locked by reservation system: '+@error_message

510200 

Blanket Agreements and Sale Order must have the same I-Version: '+@error_message

510210 

Item(s) locked by itemversion control:'+@error_message

510220 

negative stock in a Bin-Warehouse is not allowed'

510230 

'Locked by reservation system: '+@error_message

510240 

negative stock in a Bin-Warehouse is not allowed'

510250 

'Locked by reservation system: '+@error_message

510260 

set @error_message='negative stock in a Bin-Warehouse is not allowed'

510270 

Locked by reservation system: '+@error_message, 200)

510280 

negative stock in a Bin-Warehouse is not allowed'

510290 

'Locked by reservation system: '+@error_message

510300

negative stock in a Bin-Warehouse is not allowed'

510310 

'Locked by reservation system: '+@error_message, 200)

510320 

UoM Group cannot be changed because this item is used in some WO!'

510330 

set @error_message=  'This item is used in BoM! Cannot be deleted! Please check the reference report!'

510340 

set @error_message =  'Item is used and cannot be deleted!'

510350 

This item is used in precalculations (or components)! Cannot be deleted! Please check the reference report!'

510360 

This item is used in a configuration! Cannot be deleted! Please check the reference report!'

510370 

This item is used in a reclamation! Cannot be deleted! Please check the reference report!'

 


Help URL: https://help.beascloud.com/beas202402/index.html?datenpruefung1.htm