Data check

Message

Meaning

tnsfnfg04442

Beas adds various extensions to the procedure one SBO_SP_TransactionNotification. These values are pasted starting ​​from the text '- ADD YOUR CODE HERE' . If this text is not found, beas cannot enter its extensions. This can be the case, if the procedure has been manipulated.

In this case please restore the original or insert the placeholder at a suitable point.

Precise structure:

[TAB]ADD[TAB]YOUR[TAB]CODE[TAB]HERE

There may be no spaces, only TAB characters.

Re-run data check.

Omitting the data check can lead to the following problems:

- No control in warehouse management at bookings into negative stock

- No control of reservations, the reservation function may work incorrectly

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. Maybe, 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, in the production area no postings are possible.

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!

The following features are not working correctly with negative stock enabled:

- Correct stocktaking

- Warehouse management

- Reservation Function

- Batch Management

- Serial Number Management

- Material Requirements Planning

We strongly advise not to work with negative stocks!

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

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

For several items the default storage is not defined. This is required for several standard  functions.

Action: Edit item and set the standard warehouse.

This is done in the Item master > inventory data tab > default warehouse

If the default warehouse is not defined, this will result in the following problems:

- Incorrect results in order recommendation report

- WIP account determination is not possible

- Manufacturing: backflushing not possible

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:

Item structure > right mouse button > third tab in right-click menu > compute resources > calculate lead time.

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 "break down".

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"

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.