Administration > Utility programs > Data check - robinfeng/beashelp GitHub Wiki

---

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, it can be opened afterward's 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 indicated, 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 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

• Pre-calculation
• 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 hmtoggle_plus1 For several items warehouse unit or consumption unit is missing.

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

• Pre-calculation
• 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 "consumption unit"

Alternatively using SQL (Hana Syntax! Can be entered in MSSQL in SQL windows) [new unit] = new unit of measurement [wrong unit] = unit to be replaced

Consumption unit; UPDATE "OITM" set "U_me_verbr" = '[new unit]' where ifnull("U_me_verbr",'')='[wrong unit]'

warehouse unit: UPDATE "OITM" set "InvNtryUom" = '[new unit]' where ifnull("InvNtryUom",'')='[wrong unit]'

Purchase unit: UPDATE "OITM" set "BuyUnitMsr" = '[new unit]' where ifnull("BuyUnitMsr",'')='[wrong unit]'

Sales unit: UPDATE "OITM" set "SalUnitMsr" = '[new unit]' where ifnull("SalUnitMsr",'')='[wrong unit]'

Example UPDATE "OITM" set "SalUnitMsr" = 'Pcs' where ifnull("SalUnitMsr",'')='Piece'

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 warehouse/consumption units 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 Pre-calculation 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. Use the following SQL statement to do this automatically:

(Note: execute this statement in a test data base first, and check the result. This statement works correctly for SAP Business One 8.82 and 9.0 with MSSQL. It was tested with other versions.

update osrn set distnumber=isnull(distnumber,'') + convert(varchar(20),sysnumber) from osrn where (select count(*) from osrn s2 where s2.itemcode=osrn.itemcode and s2.distnumber=osrn.distnumber) > 1

---

返回 主页