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 › Fix list data › A column read wrong
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.
How this rule is created
On the products tab, the Fix list data button opens a panel with two cases: A column read wrong — this one — and Discounts in € instead of %. Picking the first opens Dijit IA with that document already in the conversation.
The column heading has to be written exactly as it appears in the document, with its abbreviations and its punctuation. The rule affects your company only and is taken off by asking Dijit IA.
Documents the rule applies to
The rule applies to the documents processed from the moment it exists, and it also corrects the document it was built from, there and then. The other documents already uploaded do not change: Dijit IA tells you to delete them and upload them again.
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.