Documentation/ Reading correction rules/ Correcting the source column of a figure
Correcting the source column of a figure
The document holds two columns of similar content and the figure is taken from the wrong one. Where the column read is empty, the line is saved with a value of zero.
Document › Products tab › Correct list data › Correct a misread column
On this page
Symptoms in the documents
- Every line at quantity zero, or with a price that does not belong to that column.
- The document holds two columns of similar content and one of them is empty.
- The error repeats on every document from that supplier and always in the same column.
How the rule works
The rule holds the name of the correct heading, exactly as printed in the document. From then on the figure is taken from that column on every line. Each line is matched to its row in the document by the description and by the order.
The rule can be applied to the quantity, the price, the discount, the amount, the VAT, the code, the description, the batch and the barcode.
Rule you can create from the application
This rule is created from the screen, on the products tab. It affects your company only and can be undone. The heading has to be written exactly as it appears in the document, with its abbreviations and its punctuation.
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
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.