When the next document cannot find the one before it — transcript
Play this as a presentation — one slide per step, with the same narration. Every word of every step is on this page.
This presentation is for you if you are the person at GadgetSphere who is asked why an invoice cannot find its order, why an order still shows a balance, or why a void was refused. In about twelve minutes you will learn to read the empty grid, close what will never come, take a chain apart in the right order, and run a short weekly check.
Step 1 — Work out why the grid is empty, in order
After this step an empty KO For grid will cost you minutes, not an afternoon. Ask in this order. Is the source finalised? A draft leaves nothing to find. On a purchase invoice drawing a receipt, is it for the same supplier, branch and currency? Did the company have an enabled pair for this source and target when the source was finalised? That is the commonest cause, and the screen cannot tell it apart from the next: has the source been fully taken? A line whose balance reaches zero has its row deleted, so a finished order is recorded by an absence. Was it closed? Is the balance you expected on another document type’s row? And on a purchase invoice or receipt, has a colleague’s unfinished draft already knocked it off? The source’s Doc Link tab shows what it is already linked to.
Reference: Purchase Invoice (Internal) — Knocking off a purchase order or a goods receipt
Step 2 — Close what will never come, and keep the reason
After this step a dead balance will stop distorting your figures. An open sales order line holds stock that could be sold to someone else, and an open purchase order line pushes available quantity up. On a purchase order, the CLOSE button zeroes every line’s open quantity and deletes all the order’s rows, and it records nothing in the Closed Queue KO report. The red Close on a row of the PO Line with GRN KO report closes that line’s goods-receipt balance only and copies it into the closed queue first, so the record survives. On a sales order, the Close on SO Line with SI KO does the same for the invoice balance, and the delivery note’s balance stays open. Write the reason in the order’s remarks first, and remember that closing is not voiding: the order stays final.
Reference: Purchase Order (Internal) — Where the open quantity comes from, and when it is released
Step 3 — Take a chain apart from the last document back
After this step a void refused for linked documents will go through. BigLedger refuses to void a document that another document has been knocked off from. Only the Sales Order screen names the blocking documents; a purchase order or goods receipt gives a fixed knocked-off message, and an invoice says only that it has been returned. So read the source’s Doc Link tab, void the last document first and work back. Voiding a purchase invoice gives the quantity back to its goods receipt, re-creating its row, but only while that pair is still enabled, so never disable a pair before voiding. Once e-invoicing is on for a company, a sales invoice cannot be voided from its button; the route is a cancellation request or a credit note. Undo to Draft, where it is offered, meets the same refusal, and it releases links without unposting anything.
Step 4 — Bring back a document finalised before its pair existed
After this step you will know the way back. Adding a pair today does nothing for documents already finalised: nothing on a timer looks for them, and the watchdog written for this case is not registered, so it never runs. For a document that posts nothing, such as a sales order, where Undo to Draft is offered, take it back to Draft and finalise it again. The open-queue step runs again and now finds the pair. For anything that posts, do not do that: re-finalising does not post it again, so the document and the ledger can disagree. Re-queue those yourself in the Data Fix applet, under Generic Documents, Missing Open Queue: pick the document’s type and the pair’s target, search the dates, and tick only the missing documents. It runs the open-queue step alone and posts nothing. Support is needed only to add Data Fix to your login, or when a document you expect is not listed.
Reference: Organization — Recovering documents finalised before the configuration was right
Step 5 — Run the weekly check of what is still open
After this step you will see what is still open without opening documents one by one. Every Monday, run SO Line with SI KO in the Sales Order applet and PO Line with GRN KO in the Purchase Order applet. Each lists order lines against what has been invoiced or received, with the quantity outstanding. A purchase line older than the supplier’s lead time is a chase for your buyer; a sales line nobody will ship is a close. Available stock reads the stored balances, while some reports work the balance out from the links, so the two can disagree while both are doing their arithmetic correctly. When the pair is configured, the links are right and a balance is still wrong, it is a support matter: send the order number, the company, and the quantities ordered and invoiced or received.
Reference: Invoice part of a sales order and give the customer paperwork — Step 4: Watch the balance
Check yourself
Three to five questions on what you just heard. Every correct answer links to the page that makes it correct, so you can check the source, not just the mark.
Answer key
- Because a line at zero has its row deleted, so both cases leave no rows — Purchase Invoice (Internal) — Knocking off a purchase order or a goods receipt
- The void is refused with a fixed knocked-off message; the receipt's Doc Link tab shows the invoice that blocks it — I voided the document and the report still shows it: what a void undoes — When BigLedger refuses to void at all
- The Close on that line's row in the PO Line with GRN KO report, after writing the reason in the remarks — Purchase Order (Internal) — Where the open quantity comes from, and when it is released
- Nothing; take them back to Draft and finalise again where Undo to Draft is offered, or re-queue them in Data Fix — Organization — Recovering documents finalised before the configuration was right