Documentation/ Reading correction rules/ Separating two values held in one cell
Separating two values held in one cell
One cell of the document holds two values together, for instance the number of boxes and the number of units. As the right one cannot be determined, the line is saved with no quantity.
On this page
Symptoms in the documents
- Lines with no quantity on documents that do carry one.
- The cell holds two numbers together, in the form "1 10.00".
How the rule works
The rule finds the row in the text of the document and takes the value it is told to: the first, the second or whichever is configured. That value is saved in the matching field.
Where the cell holds a single number, the rule does not act.
Documents the rule applies to
The rule applies to documents processed after it is switched on. Documents already loaded are not changed: to put those right they have to be processed again or edited by hand.
How to request a correction rule
Which of the two values is the right one has to be determined. The test is the document's own arithmetic: the value that, multiplied by the price, gives the printed amount.
Rules are created by talking to Dijit IA. Two things are needed:
- The reference of a document where the error shows, the number in the list's ID column. The rule is built from that document, which has to belong to your company and have its supplier identified.
- The wrong figure and the right one, stating the line and the field. A precise description saves the back and forth: "the quantity is saved as 0 on every line and should be taken from the units column" works; "it does not read it properly" does not.
Dijit IA creates the rule for your company and says in the conversation what it has done. A document belonging to another company on the account cannot be used to create one.
Afterwards, check the result on that supplier's next documents. A rule that cannot find the figure leaves the document unchanged, so the risk is not that it fails: it is that it gets something wrong.