Info-Mail 2.0GB: Unterschied zwischen den Versionen

Aktuelle Version vom 20. Mai 2021, 11:08 Uhr

Plug-Plant offers the possibility to install a query routine which will inform you about possible errors in your inputs. There are more than 60 queries already. This query routine runs daily to eliminate occurrred errors immediately.

1 Introduction

If in a query is found a result we and/or you will get a mail. This mail as well contains the query as the articles involved.

At (1) you will find the general form of address.

The title of the query is marked in yellow (2). You will find it in the table below.

The headline (3) names the relevant dates,

which (4) will be listed in detail.

Please beware: only the affected articles and forms will be listed!

New now: you will either get an information if the queries have been executed and no result found.

You will get the Info-Mail configurated as required. So remarked errors can be edited or corrected directly and the queries of comming day will be without result found.

2 tabular list

In the table below you will find all query routine as well as a link to solution approaches. You will find out that at some queries alternative titles are listed. With these queries you have the choice we will adjust to your operational circumstances.

If you want to have installed another query do not hesitate to ask us. We will install it for you.

We have named the queries with S (Standard) and E (Extension). The installation of the E-queries is combined with additional costs.

3 Possible solutions

You are able to cancel or delete and enter new lines from ordes or production and you are used to master data mainenance. There you need no support.

If you are not used to work with the SQL-Developer, please get in touch with Plug-Plant support.

3.1 Queries about orders

3.1.1 S101

Order lines without order header? That can happen but is easy to handle. Generate a new order header for the relevant customer but enter no order lines. Save it and note the new order number.

Now in SQL generate the following script:

Update B_AUFTRCOL set 'old_ordernumber' = 'new_ordernumber';
commit;

Then the new order should be filled with the order lines.

3.1.2 S102

The listed articles are trade goods; in the main data they have no fixed vendor.

Enter the chosen supplier in order or main data.

Please beware: if you enter the supplier in article data the existing order lines will not be changed!

3.1.3 S103

This report informs you that a package as well is a production device. Therefore it could have a different VAT.

Fill in the correct rate in the order lines.

3.1.4 S104

The amount has been changed after order registration. The label amount has not been adapted automaticall to the packing units.

Change label amount in the order.

⇒ If this happens more often it is possible to install a trigger. Please get in touch with Plug-Plant support.

3.1.5 S105

You have created new articles or forms and entered new cultivation schedules?

If in the cultivation schedule the line

from week = 1 | to week KW = 53 | Target PF = XY | Basic PF = ab |  Time in days = 0 Tage
so different Target form (sales form) and Basic form

as first or second line in this cultivation schedule?

⇒ This line should be deleted.

If articles of this cultivation schedule are trade goods as well this line has to be written at the end of this schedule. Else it will be chosen as a first hit in production time. Target and basic form then are identical!

3.1.6 S106

This report in the result complies with the query above but has been tested directly to trade goods.

Please check if these articles are in production already. This error sometimes happens when after (automatic) setting of production are done any changes or cancelation.

Please cancel the mentioned lines and enter again. Then implement automatic orders again.

3.1.7 S107

In the order header for inner country orders the field Report VAT must be set, for foreign country orders it has not to be set. Furthermore in customer - company properties the field "VAT Group" for different invoicing of foreign country customers will be aligned.

• ⇒ take care for correct use of this field.

For flate rate companies only will be checked if the "VAT code" in the order header really is set.

3.1.8 S108

For an inner country order the field VAT is not filled though it needs an entry.

For foreign country orders it is the opposite: there must be no entry.

3.1.9 E152

In the function to this report is integrated a script to delete the reported lines. This script has to be adjusted.

This script may only be used by routined users. Do not hesitate to contact us.

3.2 Queries about produktion

3.2.1 S201

Did the customer confirm this order already? Then release it.

Otherwise ask the customer if he still wants the articles.

Further delay will postpone the delivery date!

Eventually this order has to be cancelled.

3.2.2 S202

Compare production with the orders. Here accidental one order has been entered twice.

These entries should be corrected for not producing superset.

The younger order could be deleted with the script "Doppelte Zeilen eine löschen" (double lines delete one) .

3.2.3 S203

Often it happens that a customer changes his order and canceles articles completely. If there is a production for these articles already this will be the related report.

There are two possibilities for adjustment in the Info-Mail:

1. You want to check the order yourself and adapt the production amount.
2. The order line will be deleted directly with the query of Info-Mail.

Tell us what is practible for you when Info-Mail will be installed.

3.2.4 S204

If there are delivery notes for orders already but no production this for sure accidental has happened.

Please check if you can unfix the mentioned order/delivery note in the surplus module Wartung yourself. Otherwise get in touch with your PAT support.

Make up the entry in production if there shall happen a delivery.

3.2.5 S205

In the reported order lines in order administration the status "PR" has been entered. But there is no production line in the production table.

Depending on adjustment of the query

• the status has been changed to "AN". Please check if this order still is actual and enter a production. Then set this line to "PR" by releasing the (marked) line with F8.
• please check if a production shall happen. Cancel the mentioned order line and enter it again, then release it with F8.
  • ⇒ if there are to many lines please get in touch with your Plug-Plant support.
  • Eventually you have to cancel the order line if the production date is exceeded.

3.2.6 S206

In production enttry there happened a mistake.

Either at Purchasing or at Purchase of material for production an entry of the batch should have set to the production.

Please check your work flow and add the batch.

3.2.7 S208

Check the order lines. Why has there been a negative amount in the order?

3.2.8 S209

3.2.9 S210

3.2.10 S211

Please check why the amount differs!

• Has there been a change in the order after start of production?
• Is the production amount correct?

The order line should be cancelled and entered again before given to production.

3.2.11 S212

Please check as well in the production data details why the amount differs!

• Has there been a change in the order after start of production?
• Is the production amount correct?

The order line should be cancelled and entered again before given to production.

3.2.12 S213

This query checks if in the production company for an internal purchaise the correct amount is set. Correct the production amount in accordance to the mother order.

3.2.13 S214

In the order line open the requested production data details. For one article there should be no double lines referring to one date neither with status X (= planned) nor Z (= produced).

Check the entries in production and delete the wrong line.

If this happens more often get in touch with your Plug-Plant support.

3.2.14 S215

A production entry shall be resetted via menu Options. Sometimes PAT calculates wrong and do not set back the amount to "0". This query is a safe against that error.

Check the amount of this article at production time and eventually correct the production amount.

3.2.15 S216

In production difference entries are created as a surplus against failure. These entries in the D-line always should be negative.

Reset the amount with menu Options.

If this mistake occurs again, please contact your support at Plug-Plant.

3.2.16 S217

In Sequential number Administration batches are listed, which are not in production but have status "P". Please change the status to "2" for losses or "D" for delivered. Alternatively create a new production entry for this batch.

3.2.17 E254

In this query there are two different ways of the function, which will be adjusted depending to the work flow in your company

and FL_PRODOK = 'J'

1. By using Serial print production labels - Track-Trace this part must be commented out.
2. By creating batches from tablet with PPApp-Produktion this part must run.

These are the two ways to create batch numbers.

3.2.18 E256

Please check as well order and production if these changes of the date are correct.

3.2.19 E257

Check batch number and set the possibly wrong recorded batch to loss.

3.3 Matching of mother / daugther orders

3.3.1 S301

3.3.2 S302

Transfer this order to the production company.

3.3.3 S303

The mother order has been transferred multiple!

⇒ Cancel one of the daughter orders.

3.3.4 S304

Cancel the daughter order which belongs to the mother order.

3.3.5 S305

3.3.6 S306

Please check if the cancelation of the daughter order is correct.

• If so the mother order as well should be cancelled;
• if not transfer a new daughter order.

⇒ It is possible that the change has been made in one of these orders while the order in the other company as well was opened. Afterwards both orders have been saved.

3.3.7 S307

The order lines of mother and daughter always should have the same status.

Please check which of thes orders does have the wrong status and make the corresponding corrections.

3.3.8 S308

In the order lines of mother and daughter should be the same amount. One of the orders has been changed later.

Please check why it has been changed and enter the correct amount. If the article yet is not in production you can enter this line in the mother order again. Then again transfer it to the daughter with "automatic orders".

⇒ It is possible that the change has been made in one of these orders while the order in the other company as well was opened. Afterwards both orders have been saved.

3.3.9 S309

In the order lines of mother and daughter should be the same delivery week. One of the orders has been changed later.

Please check why it has been changed and enter the correct delivery week to the other order in the other company.

3.4 Queries on invoices

3.4.1 S401

After writing the delivery notes - not yet printed - you possibly take out some articles from the invoice. The invoice will be created and all articles of the order will change the status to "RE" gesetzt. But the articles taken out not have been invoiced.

With this query the not invoiced articles in the delivery note will get the additional text "Not invoiced". Please check if these statements are correct. Now finally the delivery note can be printed.

In the report of the following day these articles not will be listed again.

3.4.2 E451

The invoice has to be cancelled due to national conditions. Afterward please correct the invoice.

Please enter the VAT for these lines.

Check if the main data of this article or product form are complete.

3.4.3 E452

The invoice has to be cancelled due to national conditions. Afterward please correct the invoice.

Please enter the price for the listed lines.

Check if this article is listed in the actual price list. If necessary the price list has to be adapted.

3.5 Monitoring the main data

3.5.1 S504

In "WARTUNG" in tab "8" the function Löschen Artform- und Arteigen-Leichen has to be executed.

3.5.2 S505

In the form of the listed article in the properties is set a hook in column "Inactive".

Please check if this hook has to be unset or another production device has to be used.

3.5.3 S506

Before entering a new product form it has to be created in the mask "product form of variety". Here you will find the how to.

Do you think this report is wrong because this product form already exists? It is possible that you have set a blank space in addition.

3.5.4 S507

The basic form in table properties is not listed in the mask "product form of variety".

⇒ Any basic form listed in the properties of an article has to be defined in this mask.
Do you think this report is wrong because this product form already exists? It is possible that you have set a blank space in addition.

3.5.5 S508

This query will be helpful to those of our customers who have more companies but same clientele and different staff members for the customers main data. Accidently double assigned Fibu-numbers will be recognized and can be corrected the following day.

3.5.6 S509 & S510

The queries S509 und S510 check if series name (S509 = blue frame) or rather concern variety name (S510 = green frame) are identical in the masks variety list - name and variety list - companies. Sometimes it only is a blank space to much.

Making the corrections in mask variety list - name there opens a window asking if these changes
a) should be transferred to all companies
b) should be executed in existing orders as well
⇒ these questions should be confirmed with >>Yes<<.

Making the corrections in mask variety list - companies there opens a window asking if these changes should be transferred to all companies. This question should be confirmed with >>Yes<<.

3.5.7 S511

Please fill in the field without dates in the cultivation schedule.

3.5.8 S512

The basic form of the production device has to be listed as product form. Enter it to the product form table and take care that it gets an existing cultivation schedule.

3.5.9 S513

For this product form there exists no properties. Which product device shall be taken?

3.5.10 S515

In Customer - company properties for inner country clients the field Calculate VAT has to be set, for foreign country clients it has not to be set.

3.5.11 E551

Enter the price group at product form/properties in the mentioned product form.

3.6 Queries to functions of the data base

3.6.1 S601

In table B_Log errors are reported. many of them belong to functions running in the background.

Please contact your Plug-Plant support to correct these errors.

3.6.2 S602

The Produktion history has to be installed again that all inputs can be traced.

3.7 Queries on bill of material

3.7.1 S701

You already work some time with bill of material? Have a look at similar articles and take over the samples for the reported articles.

Have you created lots of new articles where you need a bill of material for, first create one bill of material to one article as a sample. This sample afterwards can be taken over to the other articles with STDIMPEXP.

If you are not used to the tool STDIMPEXP do not hesitate to contact your support at Plug-Plant.

3.7.2 S702

For searching faults please proceed in the outlined order.

1. Check first if the listed article number in bill of material is the right and eventually correct it.
2. Check if in the main data of the article for the listed form the hook is set at "bill of material" and the "Bill of material Type" registered.
3. If a new article or another product form of an existing article shall be used in bill of material it must be registered in the main data.

3.7.3 S703

After saving the bill of material accidently the article number has been deleted and renewed and saved.

1. Search out with the listed articles which article number has been deleted. In most cases there will be a corresponding report with a missing bill of material.
2. The bill of material has to be enterd new.
3. In the SQL-Developer the surplus lines have to be deleted. So this message will not be reported again.

Alternatively a new bill of material only saved with its header. In SQL-Developer for the relevant varieties the timest of B_Stueckliste can be copied to listtimest of B_Stuecklistecol.

3.7.4 S704

This report is flexible and can be adjusted to your company:

• two lines for graftings;
• three lines for production of Trios;
• multiple queries to different article groups for seed mixtures or Duo, Trio, Quattro.

Check the reported bill of material and correct the entries:

• add or delete line;
• check in the article number if the amount is correct.

⇒ if the amount assignment is correct get in touch with Plug-Plant. The select in this function of Info-Mail has to be adjusted.

3.7.5 S705

In the order with click at the line header the Produktion details can be opened. Articles with 'E1...' (ready plants grafted) should have single production steps for:

• Understock (propagation)
• scion variety (propagation)
• grafting
• potting

If you have named your articles different then please get in touch with Plug-Plant. The query will be individually adjusted.

Find out which production step is missing and check your entries in bill of material and production.

3.7.6 S706

In the order with click at the line header the Produktion details can be opened. Articles with 'TR...' (half ready plants grafted) should have single production steps for:

• Understock (propagation)
• scion variety (propagation)
• grafting
• potting

If you have named your articles different then please get in touch with Plug-Plant. The query will be individually adjusted.

Find out which production step is missing and check your entries in bill of material and production.

3.8 Queries on work list

3.8.1 S801

You already work some time with work lists? Have a look at similar articles and take over the samples for the reported articles.

Have you created lots of new articles where you need work lists for, first create one work list to one article as a sample. This sample afterwards can be taken over to the other articles with STDIMPEXP.

If you are not used to the tool STDIMPEXP do not hesitate to contact your support at Plug-Plant.

Hint: The query is built up that way that cultivation schedules starting with '#' in Name (long field (PRDGRP.BEZ)) will be excluded.

3.8.2 S802

4 Settings

The settings necessary will be entered in "PAT - Maintenance" at Infomail Receiver and Infomail Settings.