Purchase Assignment
Use purchase assignment to connect a vendor’s Business Central purchase line to the transportation cost it supports. A link identifies the document type, document number, and line number. Entering a vendor invoice reference or attaching an invoice file alone does not create this financial link.
You can match an existing planned Cost line, import new Cost lines, or distribute a Purchase Invoice or Posted Purchase Invoice line across several Forwarding Orders. For existing unposted sources, Link to Purchase Line, Import Purchase Document, Charge Allocation, and Freight Order assignment all use TMS Setup > Finance and Invoicing > Settlement > Purch. Document Linking Mode. Its default, Open and Released, permits either status; Open Only and Released Only narrow that choice. After linking, the purchase document supplies the actual quantity, price, discounts, currency, and amount. Posting an already linked unposted purchase document updates its link to the posted document. You can also link eligible Posted Purchase Invoice and Posted Purchase Credit Memo lines directly to Settlement after posting under their separate rules.
For the meaning of Financial Effect, Pricing Mode, and positive or negative amounts, start with Settlement principles.
Enter a planned Cost’s quantity, price and discount as you would on the purchase document. An ordinary Cost / Standard with Quantity 1 and Price 500 has Amount 500 and P/L Amount −500, before discounts or VAT. TMS applies the financial direction automatically. Negative quantity or price remains available when the purchase line itself should be negative; see Quantity, Price, and Amount signs.
Before you start
Make sure that:
- the Forwarding Order exists and its status allows Settlement changes;
- for direct linking or importing existing lines, the purchase document is an unposted Order, Invoice, or Credit Memo in a status allowed by Purch. Document Linking Mode, or an eligible Posted Purchase Invoice or Posted Purchase Credit Memo;
- Buy-from Vendor, Pay-to Vendor, posting date, currency, and the purchase lines are complete;
- each relevant Charge has Purchase Line - Type and Purchase Line - No. matching the purchase line’s Type and No.;
- the source line has not already been assigned through Settlement or a Freight Order;
- the source is within the supported Settlement document scope.
For initial linking, follow the document-specific source requirements below; prepayments, deferrals, and partially processed sources remain outside the supported flow. Prices may include or exclude VAT. Use the corresponding posted-document actions when the invoice or credit memo has already been posted. The existing posted single-line link and whole-document import actions still require zero actual invoice discount. The posted invoice Charge Allocation action described below retains its support for actual invoice discount. Comment lines cannot receive a new cost allocation. After linking, changes to the existing source line are authoritative: Settlement accepts its new VAT, discount, price, quantity, unit, description, location, and dimension values. Changing Type / No. on that same physical line does not require its old Charge mapping to match again.
VAT-inclusive sources use the existing amount model: document prices and amounts keep their source VAT basis, while Net Amount Excl. VAT and P/L Amount exclude VAT. Linking or importing does not recalculate the purchase document or switch its VAT-price setting. Later supported source changes continue to update Settlement through the existing synchronization.
For initial linking or import of an unposted purchase line, Allow Invoice Disc. may be Yes or No. The flag only permits invoice discount calculation; Inv. Discount Amount and Inv. Disc. Amount to Invoice must both be zero. If either amount is nonzero, the error names the document and line whose actual invoice discount needs review. TMS preserves the flag and source amounts instead of switching the flag off or removing the discount. Ordinary line discounts remain supported.
Pending Approval and Pending Prepayment are excluded from new unposted links in every linking mode. The selection list and command both check the mode; if a document or the setting changes after selection, TMS checks the current values before linking. TMS does not automatically release or reopen the source. See Source document linking status.
Create and Add to Document have a different purpose: they create new purchase lines in a document with Status = Open. Their behavior does not change with Purch. Document Linking Mode, including when that setting is Released Only. The setting governs new links to purchase lines that already exist.
For both Link to Purchase Line and Import Purchase Document, a filled Customer/Vendor No. on the current Cost row limits the selection list to documents whose Buy-from Vendor No. matches it. A blank value on Cost shows all vendors. When importing from an Income row, TMS ignores its customer number and shows all vendors, even if that number also exists as a vendor. This applies to Purchase Orders, Purchase Invoices, Purchase Credit Memos, Posted Purchase Invoices, and Posted Purchase Credit Memos. After selection, the source supplies Buy-from Vendor and its name to the linked or imported Cost. Pay-to Vendor remains on the purchase document and can differ from Buy-from Vendor.
The purchase source selection windows opened from Settlement include a read-only Comment column. It explains existing Settlement or Freight assignments and source limitations. For invoices, it also shows any identified unposted or related posted credit-memo numbers; a credit memo can show the invoice it references. Review these details before selecting a source.
Comments provide guidance; they add no new selection restrictions. The existing link and import checks still decide which sources can be used. If a document or its assignments change while the lookup is open, close and reopen the lookup to refresh its selection snapshot and comments.
Choose the right workflow
| Your situation | Action and result |
|---|---|
| The vendor invoice line already exists, and you already planned its cost in Settlement. | Use Link to Purchase Line. The current planned Cost line receives the existing purchase line. |
| The purchase document contains costs that have not yet been entered in Settlement. | Use Import Purchase Document. TMS creates new Cost lines for its eligible, unallocated lines. |
| The invoice is already posted, and its cost is planned in Settlement. | Use Posted Purchase Invoice Line. TMS replaces the current Cost’s planned values with the posted line’s actual values. |
| The invoice is already posted, and its costs are not yet entered in Settlement. | Use Posted Purchase Invoice under Import Purchase Document to create new posted Cost rows. |
| A vendor credit memo is already posted. | Link its line to an existing Cost row, or import its free lines as new Cost / Credit rows. The source sets the Credit effect; a normal credit reduces cost. |
| One vendor invoice line covers several Forwarding Orders. | On the purchase line, use TMS > Charge Allocation and choose the exact planned Cost line for each order. |
| You have planned Cost lines, but the purchase document or its lines do not exist yet. | Use Create or Add to Document. These actions create purchase lines. |
| The carrier invoice belongs to a Freight Order and its related Forwarding Orders. | Use the Freight Order assignment workflow. |
Add to Document adds new purchase lines. To connect an invoice line that has already been entered, use Import to Settlement or Charge Allocation. Otherwise you can duplicate the vendor charge.
Link one purchase line to an existing cost
Use this when, for example, you planned a carrier cost of 500 and now have the vendor’s invoice for 520. The link replaces the planned values with the actual values on the same Settlement row. Review the purchase document before selecting its line and confirm that its status is allowed by Purch. Document Linking Mode. With the default Open and Released, no Release step is required for an Open source.
Your User Setup must have TMS Allow Purchase Document Allocation enabled to use Link to Purchase Line, including links to posted invoices and credit memos. If your User Setup record is missing or this option is off, both Link to Purchase Line and Import Purchase Document are disabled. Reopen the Forwarding Order after changing this option.
- Open the Forwarding Order and expand Settlement.
- Select the existing Cost line without a document link. Check the Charge mapping for the intended purchase line.
- Choose the source document type. The source sets Financial Effect to Standard for a Purchase Order or Purchase Invoice, or Credit for a Purchase Credit Memo; the old effect does not restrict linking.
- Choose Import to Settlement > Link to Purchase Line > Purchase Invoice Line. For another document type, choose Purchase Order Line or Purchase Credit Memo Line.
- In Purchase Document Assignment, find the document using Document No. and Vendor Invoice No.. A filled Customer/Vendor No. on the current Cost filters Buy-from Vendor No.; a blank value shows all vendors. The list does not filter document status. Check the source vendor before selecting its line.
- Select the one purchase line that belongs to this cost and confirm the lookup. Check Type, No., Quantity, Direct Unit Cost, Line Amount, and currency before confirming. Do not select a comment or an already allocated line.
- Review the updated Settlement row. Confirm its document reference, Financial Effect, quantity, price, amount, currency, and dimensions.
The selected Charge must map to the purchase line’s exact Type and No. Matching the description or amount is not sufficient. If several Charges use the same purchase posting object, selecting the required Code on the planned Cost line makes the intended Charge explicit.
This action works on the current Cost line, not a batch of selected Settlement rows. Repeat it for other invoice lines. A Cost row already linked to another source must first be detached through the supported workflow.
Old Needs Review, Legacy, or Unresolved markers and old planned values do not prevent linking when there is no conflicting document or allocation identity. The chosen source replaces the vendor, Financial Effect, quantity, price, discounts, amount, currency and exchange-rate context, dates, description, unit, location, and dimensions. Quantity uses the actual source quantity in Per Unit mode. Blank source location and dimensions clear the previous values. The owning Forwarding Order remains. A compatible existing Charge Code is retained, even if another matching Charge has Default for Purchase Import enabled. Otherwise, TMS selects a Charge using the source’s Type / No.: a marked default takes priority; without one, the first matching Code in ascending order is used. That selected Charge replaces the old Code. TMS still checks source eligibility, existing assignments, and actual document, Freight, or correction references.
For a normal quantity-based line, TMS copies the purchase quantity and Direct Unit Cost and changes Pricing Mode to Per Unit. Amount is the source amount before line discount; Line Amount is after line discount. P/L applies the Cost and Standard/Credit direction to the actual amount excluding VAT after applicable discounts. Description, unit, currency, exchange-rate context, and dimensions also come from the source. The old estimate is replaced; it is not retained as another cost.
Example: a planned Cost with Amount 500 linked to a Purchase Invoice line with quantity 1, price 520, and no discount becomes Amount = 520, Line Amount = 520, and P/L Amount = −520 on the same row. For a source with price 100 and a 20% discount, the row becomes Amount 100, Line Discount Amount 20, Line Amount 80, and P/L Amount −80. No extra Cost row is added.
Import a whole purchase document
Use this when the purchase costs do not already have planned Settlement rows and all free lines on the selected document belong to the current Forwarding Order. Review the purchase document before importing it; no Release step is required.
Whole-document import requires a User Setup record with TMS Allow Purchase Document Allocation enabled for your user. An administrator can enable this option. It controls both the Import Purchase Document and Link to Purchase Line action groups, including posted documents. Reopen the Forwarding Order after changing this option.
- Open the Forwarding Order and expand Settlement.
- Choose Import to Settlement > Import Purchase Document > Purchase Invoice. Use Purchase Order or Purchase Credit Memo for those document types.
- Select the unposted document. A filled Customer/Vendor No. on the current Cost row filters Buy-from Vendor No.. A blank value on Cost, or importing from an Income row regardless of its customer number, shows all vendors. The list includes only statuses allowed by Purch. Document Linking Mode. For invoices and credit memos, review Buy-from Vendor, the vendor reference, Currency Code, Allocation Status, and Free Lines.
- Confirm the selection.
- Read the result message. It reports how many Settlement lines were created and how many already allocated lines were skipped.
- Review every new Cost line and the Settlement totals.
TMS creates one new Cost row for each eligible, unallocated purchase line. It ignores comments and skips lines already allocated elsewhere. If all eligible lines are allocated, there is nothing to import.
Whole-document import does not search for and replace existing planned Cost rows. If the same cost is already planned, use single-line linking instead. If only some free lines belong to this Forwarding Order, link those lines individually.
For each imported purchase Type / No., TMS prefers the Charge marked Default for Purchase Import. If none is marked, it uses the first matching Code in ascending order, including when several Charges match. This fallback is independent of list sorting, filters, and record creation order; it does not mark a default or change any Charge record. No mapping or multiple marked defaults stops import. Configure a preferred choice in Charges. Selection is shared across the company for that type and number; it does not vary by vendor or document description. The FWO type’s allowed service/charge set still applies: if the selected default or fallback is disallowed, import stops without trying another match. Changing the default does not reclassify existing links or history.
Configuring the first Charge for a complete type and number enables its import default automatically. Additional Charges for that pair stay unmarked, including when the existing Charges have no default. Existing mappings are not assigned defaults during upgrade; a manually cleared flag stays cleared when saving or selecting the same mapping again.
To choose a different Charge for a particular source line, prepare a Cost row with the intended compatible Code and use single-line linking. Selecting that Cost and running whole-document import does not pass its Code to the new rows.
| Allocation Status | Meaning |
|---|---|
| Not Allocated | None of the document’s allocatable lines is linked. |
| Partially Allocated | Some lines are linked; Free Lines shows the remaining count. |
| Fully Allocated | All allocatable lines are linked. |
| No Allocatable Lines | The document has no cost-bearing lines to import. |
These counters describe line availability. TMS still checks the selected lines and Charge mappings when you confirm the import.
Link an already posted purchase invoice
Use these actions when the invoice was posted before its transportation costs were assigned to Settlement. The link still identifies a specific invoice line. TMS reads the posted values without reposting the purchase or changing its financial entries.
Before linking, check that:
- the invoice is not Cancelled, Corrective, or a prepayment invoice;
- Prices Including VAT may be on or off; actual invoice discount amounts are zero, and the source has no deferral or other processing outside the supported Settlement scope;
- the invoice line has not already been allocated in active or posted Settlement or Freight Order records;
- the posted line’s Type / No. has a valid Charge mapping, and the existing Cost, if used, has no conflicting document, Freight, or correction references. A compatible existing Code is retained; otherwise TMS uses the matching Charge marked Default for Purchase Import, or the first matching Code in ascending order when none is marked.
Payment alone does not prevent linking: an otherwise eligible paid invoice can be used. Pay-to Vendor can differ from Buy-from Vendor; the posted invoice supplies Buy-from Vendor to Settlement.
Replace an existing planned Cost
- Open the Forwarding Order and expand Settlement.
- Select the existing Cost row without a document link. Check its Charge Code and Customer/Vendor No., which filters the source list when filled. The source supplies the linked row’s status, vendor, Financial Effect, and actual amounts.
- Choose Import to Settlement > Link to Purchase Line > Posted Purchase Invoice Line.
- Select the matching invoice line. The list shows the current Cost’s Buy-from Vendor when Customer/Vendor No. is filled, or all vendors when it is blank. Review its vendor, document number, Type, No., quantity, direct unit cost, amount, and currency before confirming.
- Review the same Settlement row. It now has the posted invoice and line references, actual quantity, price, amount, currency, unit, and dimensions, and is marked Posted.
For example, a planned Cost with Amount 500 linked to a posted invoice line for 520, without discounts, becomes Amount 520 and P/L Amount −520 on the same row. No additional Cost is created. An already allocated source line cannot be linked again, including when its earlier FWO or Freight Order has been closed.
Import new costs from a whole posted invoice
- Open the Forwarding Order and expand Settlement.
- Choose Import to Settlement > Import Purchase Document > Posted Purchase Invoice. Your User Setup must allow TMS Allow Purchase Document Allocation.
- Select the invoice. A filled Customer/Vendor No. on the current Cost row filters Buy-from Vendor No.. A blank value on Cost, or importing from an Income row regardless of its customer number, shows all vendors. Review its vendor, reference, currency, Allocation Status, and Free Lines.
- Confirm, then review the result message and the new Cost rows.
TMS creates one Posted Cost for each eligible free invoice line. Comments are ignored; lines already allocated in active or posted Settlement or Freight records are skipped. Each imported Type / No. uses the matching Charge marked Default for Purchase Import, or the first matching Code in ascending order when none is marked. If any required mapping or source check fails, the import does not retain a partial set of new rows.
This action does not replace existing plans. Importing an invoice for 520 while a planned Cost with P/L −500 remains creates another row with P/L −520, giving total P/L −1,020. Use the single-line action when the expense was already planned.
Corrections and limits
Correction Baseline Status = Linked After Posting means that the purchase invoice was already posted when its Cost was linked to Settlement. The actual values are verified; the status records when the link was established.
Review the source carefully before confirming. To correct an eligible direct assignment, use the detach actions on the Posted Purchase Invoice lines. The Detach Settlement action in Settlement uses the same mechanism, including supported posted sources. Detaching an assignment does not reverse the invoice. For a full cancellation, replacement invoice, or editable credit based on the invoice, use the standard correction actions. Independently created vendor credits can still be linked through the supported actions.
The Forwarding Order can still be closed and archived when its usual posting checks pass. Unknown prior correction history does not by itself block FWO closure.
To distribute a posted invoice line across several FWOs, use TMS > Charge Allocation on the Posted Purchase Invoice line. For a posted credit memo, use the separate credit-memo actions; new split allocations from posted credit memos and posted Freight Order assignment are not provided by the posted invoice allocation action. Existing links established before posting continue through their normal posting and supported correction workflows.
Link an already posted purchase credit memo
Use this to record a vendor credit that was already posted before its Settlement assignment. A normal posted credit memo line for 100, without discounts, becomes Cost / Credit, Amount = 100, and P/L Amount = +100, reducing expense and increasing profit. A negative source amount remains negative in Amount; on Cost / Credit its P/L is also negative.
The credit memo itself must not be Cancelled. A Corrective or Correction credit memo can be linked when otherwise eligible: it can represent the credit that cancels or corrects an invoice. Prices may include or exclude VAT; zero actual invoice discount and no prepayment, deferral, or other unsupported processing are still required. A payment or application by itself does not prevent linking. The source line must be free in both active and archived Settlement and Freight records. The source supplies Buy-from Vendor, even when Pay-to Vendor differs.
The posted line also supplies Location Code: a blank source location clears the planned location. Linking and import preserve the actual posted amount, including when current currency rounding settings differ from those used by the posted document.
Link one posted credit memo line
- In the Forwarding Order Settlement, select an existing Cost without a conflicting document, Freight, or correction reference. A filled Customer/Vendor No. filters the source list by Buy-from Vendor No.; a blank value shows all vendors. The old status and Financial Effect do not restrict selection.
- Confirm the source’s Charge mapping. A compatible existing Code is retained; otherwise TMS uses the matching Charge marked Default for Purchase Import, or the first matching Code in ascending order when none is marked. Linking sets the effect to Credit from the source, including when the plan previously used Standard.
- Choose Import to Settlement > Link to Purchase Line > Posted Purchase Credit-Memo Line.
- Select the required source line, checking its document number, vendor reference, quantity, price, amount, and currency.
- Review the same Cost row. The posted source replaces the plan, including its description, quantity, price, unit, amount, currency context, and dimensions. No new Cost row is created.
For example, a planned Cost / Credit with Amount 80 linked to a posted credit memo line for 100 becomes Amount 100 and P/L Amount +100 on that same row, assuming no discounts.
Import a whole posted credit memo
- Choose Import to Settlement > Import Purchase Document > Posted Purchase Credit-Memo. Your User Setup must allow TMS Allow Purchase Document Allocation.
- Select the credit memo. A filled Customer/Vendor No. on the current Cost row filters Buy-from Vendor No.. A blank value on Cost, or importing from an Income row regardless of its customer number, shows all vendors. The list initially shows the highest document numbers first; review the vendor, reference, currency, Allocation Status, and Free Lines.
- Confirm and review the new Cost rows and the import result.
TMS creates one Cost / Credit row per eligible free source line. Comments are ignored, and already allocated lines are skipped, including allocations in transportation history or Freight Orders. Each Type / No. uses the matching Charge marked Default for Purchase Import, or the first matching Code in ascending order when none is marked. A mapping or source validation failure rolls back the whole import.
Whole-document import does not replace planned credit rows. If a credit with P/L +80 was already planned, importing a source credit of 100 adds another P/L +100; total P/L becomes +180. Use the single-line action to replace the plan.
Both actions establish a verified Posted link with Correction Baseline Status = Linked After Posting. They do not repost the credit memo or change its financial entries. Review the source carefully. Eligible direct Posted Purchase Credit Memo links can be removed through Detach Settlement in Settlement; the same command includes any supported archived members of that source group. FWO closure follows the usual posting checks.
Allocate one purchase line across Forwarding Orders
Use this when one vendor invoice line is shared by several jobs. TMS splits the line’s quantity and amounts across the selected Settlement rows; their total remains equal to the source line.
- In each affected Forwarding Order, prepare a free Cost row without an existing document, Freight, or correction reference. Its Customer/Vendor No. must exactly match the source document’s Buy-from Vendor No., and its existing, nonblank Charge Code must map to the source line’s Type / No.
- Open the Purchase Invoice and confirm that its status is allowed by Purch. Document Linking Mode, or open the Posted Purchase Invoice if it has already been posted.
- Select the one purchase line to distribute.
- In the line actions, choose TMS > Charge Allocation. The current source line must have no existing Settlement or Freight allocation, including posted transportation history. For an unposted invoice, Open and Released allows either status, while Open Only and Released Only require the selected status. A posted invoice uses its separate eligibility checks and has no Release step.
- In Select Allocation, choose Distribution Type. Options include Equal, By Number Of Logistic Units, By Gross Weight, Selected Forwarding Orders, and By Footage. Choosing a distribution type resets the selection, so review the Select checkboxes afterward.
- Select only the Forwarding Orders that should receive this cost. The list contains orders with at least one free Cost row for the same Buy-from Vendor and a matching existing Charge mapping. A blank or different vendor, a blank Charge Code, or an incompatible Charge mapping excludes that row.
- Check Settlement Line No., Charge Code, and Settlement Description for every selected order. TMS selects the row automatically only when that FWO has exactly one eligible target. If several qualify, use Settlement Line No. to choose the exact row. Mass allocation keeps its existing Charge Code; it does not replace an incompatible code with another mapping.
- Review Charges Distribution Ratio. Every selected order must receive a positive share and the complete allocation must total 1 (100%). For weight, footage, or unit-based distribution, check that the underlying values are complete.
- Confirm the allocation. If currency rounding reduces a share to the available remainder or leaves an order with a zero final amount, TMS shows the final net amounts and the orders to exclude before saving. Review this warning and continue only if the result is suitable. Then review Allocated Amount on the purchase line and the linked Cost rows in each Forwarding Order.
The allocation dialog rejects unsupported distribution types. If a previously saved type is unsupported when the dialog opens, selections and ratios are cleared and an explanation is shown. Choose a supported type and review the selected orders before confirming; you can also cancel the dialog.
On purchase invoice and credit-memo lines, including posted documents, Allocated Amount shows one total for linked active and posted Settlement allocations. It uses net amounts excluding VAT in the document currency, with the document sign. Identical copies of the same FWO and Settlement line count once, with a matching active copy taking precedence over posted versions. Source identities, quantities, allocation shares, amounts, and currency context must agree before copies are combined. Conflicting historical snapshots remain separate contributions for review. The former separate Allocated Amount (Posted) column is hidden.
Choose Allocated Amount to open its details. Active-only links open Settlement Lines; posted-only links open Posted Settlement Lines. If the document line has both, Linked Settlement Lines shows them together with FWO Status and Posted Version. The details retain every linked historical version for comparison, including repeated copies counted only once in the total. Choose Forwarding Order No. to open the order or its exact posted version; in the combined list, Settlement Line No. opens the individual Settlement row. Zero totals can also be opened when linked rows exist.
On the Posted Purchase Invoices list and Posted Purchase Invoice card, Charged Forwarding Order(s) shows the current linked orders when the document is read. Refresh or reopen the page after allocation or detach. Choose the value to open Linked Settlement Lines for the whole invoice, including all linked active and posted FWO versions. From there, choose Forwarding Order No. to open the corresponding order. An order can appear more than once when several Settlement lines or posted versions are linked. The compact order text can be shortened for a long list; the details still include every linked Settlement row. If no links remain, the field is blank and its drilldown does not open a list.
Sales invoice and credit-memo lines, including posted documents, provide the same Allocated Amount column and navigation for their linked Income rows.
The dialog selects one Settlement target per Forwarding Order for this purchase line. It does not automatically select the first Cost row or create missing planned rows. Repeat the process separately for other purchase lines.
The vendor match uses Buy-from Vendor, not Pay-to Vendor. For example, an invoice bought from vendor A but paid to vendor B lists only eligible Costs for vendor A. A blank vendor is not a wildcard in multi-FWO Charge Allocation. The separate single-line link and import selection lists show all vendors when the current Cost’s Customer/Vendor No. is blank. Whole-document import from an Income row also shows all vendors, regardless of its customer number. After selection, these workflows copy the source values as described above.
The allocation command checks the selected persisted targets again before applying the distribution. If a selected Cost is no longer free or its vendor or existing Charge mapping no longer matches, allocation stops instead of selecting another row or replacing its code. Correct the target or reopen the selection and review it again.
For a Posted Purchase Invoice, the command updates the selected active Cost rows with Document Type = Posted Invoice, the source invoice/line references, Posted = Yes, and each allocation factor. Quantities and amounts are split; the source price and discount percentage are retained. The posted invoice header, its lines, and financial entries are not modified. Paid invoices can be used; cancelled, corrective, correction, prepayment, and deferral sources are rejected. VAT-inclusive input amounts and invoice discounts are copied from the posted source, while P/L remains excluding VAT. No new Cost rows are created. A failure in any target rolls back the complete group.
Invoice allocation ratios keep high precision internally. Equal for three orders uses thirds rather than rounding each factor to 0.33; the allocator rounds monetary values and assigns the remaining cents to the last target in FWO/Settlement order. When every order receives a nonzero final amount, the original ratios are retained. The displayed ratio can show fewer decimal places than the stored factor. By Gross Weight requires a positive total selected weight.
Each rounded share is limited to the remaining amount. If some money remains but it is less than the calculated share, the order receives that remainder. A zero final share is excluded from a new direct purchase invoice allocation, for both open and posted invoices. TMS creates no purchase link for an excluded order and leaves its planned Cost unchanged. The warning identifies these orders and the final net amounts excluding VAT. Declining it leaves the allocation unsaved.
With currency precision 0.01 EUR, these examples have no discounts or VAT:
| Source amount | Selected FWO | Final document amounts | Result |
|---|---|---|---|
| 0.02 EUR | 4, equally | 0.01; 0.01 | The third and fourth FWO are excluded after confirmation. |
| 0.03 EUR | 2, equally | 0.02; 0.01 | Both FWO receive an amount; the second receives the available remainder. |
| 1.00 EUR | 3, equally | 0.33; 0.33; 0.34 | All three remain linked, with the original high precision thirds. |
| 1,000.00 EUR | 2, equally | 500.00; 500.00 | Each Cost has P/L Amount −500.00. |
If orders are excluded, the remaining allocation factors are recalculated from each final net amount divided by the source net amount. The full quantity is distributed among those remaining orders. For 0.02 EUR, quantity 1, and four equal selections, the two retained FWO each receive amount 0.01, factor 0.5, and quantity 0.5. Later changes to the open purchase line update these two linked orders; they do not add the excluded orders back. When no order is excluded, quantity continues to use the original allocation factors.
A source with zero net amount, such as a fully discounted purchase line, keeps the existing allocation behavior: a zero source amount alone does not exclude all its orders or discard its quantity and discount information. API and background calls cannot silently accept a warning or exclude orders. If the request requires this rounding warning, it returns an error with the proposed result; the caller must submit explicit final recipients and proportions.
Posting and source synchronization use the same remaining-amount limit. Net amounts and discounts are distributed consistently, and LCY/ACY remainders are conserved. Rounding cannot make an ordinary positive source’s final share negative. Existing historical allocations are not rewritten by this change.
A purchase line cannot simultaneously have a direct Settlement allocation and a Freight Order charge allocation. An existing allocation must be removed through its own workflow before assigning the line again.
The same existing-link check runs before opening Select Allocation and in the allocation command, including a second check after it locks the source and targets. An already assigned line raises an error; the command does not silently return or extend an existing allocation. This check includes zero-amount links and every related FWO, irrespective of the proposed targets, vendor, or Charge Code. A retained physical source-line reference also keeps the line assigned even if its saved document reference is inconsistent.
Cost signs and vendor credits
Enter a normal purchase invoice or credit memo using the usual Business Central quantity and direct unit cost. TMS derives the Settlement direction from the source document type.
| Source line, without discounts | Financial Effect | Amount / Line Amount | P/L Amount |
|---|---|---|---|
| Purchase Order, Purchase Invoice, or Posted Purchase Invoice | Standard | 100 | −100 |
| Purchase Credit Memo or Posted Purchase Credit Memo | Credit | 100 | +100 |
For a planned Per Unit Cost, quantity 1 and price 100 produce Amount = 100. In Fixed Amount, enter Amount = 100 for the same cost before discount. Standard gives P/L −100 and Credit gives P/L +100, assuming no discounts. See quantity, price, and amount signs.
Negative quantities or prices reverse the arithmetic as well. They are not a substitute for selecting Credit, and changing the sign of a linked Settlement row is not how you create a vendor credit.
To record a new vendor credit, create a Purchase Credit Memo from separate Cost / Credit rows, link an existing unposted memo in a status allowed by Purch. Document Linking Mode, or use the posted credit-memo actions. This records the cost reduction separately from the invoice. For a full cancellation through Business Central Cancel, use the automatic workflow below. There is no Full Reversal command. Detaching a posted invoice’s Settlement assignment only removes the analytical link; it does not reverse the purchase or its financial entries.
Cancel a linked posted purchase invoice
For a complete guide to all three invoice actions, active and posted FWOs, and the financial result, see Invoice Corrections and Corrective Forwarding Orders.
Use the standard correction actions on the Posted Purchase Invoice. Business Central eligibility checks still apply.
| Action | Result |
|---|---|
| Cancel | A full corrective credit memo is created and posted, with linked Cost / Credit Settlement. |
| Correct | The full credit and the replacement Purchase Invoice both receive their own linked Settlement rows. Edit the replacement before posting as required. |
| Create Corrective Credit Memo | The copied credit lines are linked while unposted and remain editable for a full or partial vendor credit. |
The original invoice allocations retain their references and amounts. New managed rows have Correction Type = Document Correction. While a credit created by Cancel or Correct matches the original financial values, TMS reverses the exact saved shares, including rounding: a cost of 100, allocated 60 / 40, receives credits of 60 / 40. If the credit remains unposted, its amounts can be changed like any other corrective credit.
For an editable credit or replacement, TMS applies the original allocation factors to the current source quantities and amounts. A partial credit of 20 against that 60 / 40 allocation gives 12 / 8. The source document supplies price, discounts, currency, and dimensions; rounding remainders are conserved. Edit the financial line, not the managed Settlement values. New lines without an inherited original allocation require their own assignment.
Active original FWOs keep the new allocations on the same order. If an allocation belongs only to posted history, TMS asks once to create a separate active corrective FWO, using Correction FWO Type Code. There is one child per original FWO and operation; Correct uses that same child for its credit and replacement invoice. Its Ordering Party is the original FWO customer, while Cost rows retain the purchase vendor. The factory does not add transportation stages, cargo, or agreement/Service Set charges.
Original posted FWO and Freight records remain unchanged. Identical historical versions do not multiply the allocation or create extra child orders; a matching active copy takes precedence. An inconsistent source identity or allocation group is rejected instead of guessed. Has Corrections opens the linked orders and documents; Corrects Forwarding Order returns to the original. The combined profit display includes current active corrections, including unposted documents, as well as posted corrections.
Post the editable credit memo or replacement invoice when its changes are complete. This also applies to a credit left unposted by an unsuccessful Cancel or Correct. TMS checks the current document against its Settlement allocation; it does not require the original invoice’s price, quantity, or line count. Its existing Settlement links then refer to the posted document lines. Manual posting does not resume the original Correct action, create a replacement invoice, or perform that action’s cancellation bookkeeping.
Deleting a supported unposted corrective-credit or replacement line removes its managed active Settlement rows, regardless of which correction action created the credit. Deleting a replacement invoice does not reverse its already posted credit. The corrective FWO cannot be deleted while any Settlement rows remain; deleting it when empty keeps the operation audit record. The corrective FWO header stores the original order number, posted version, and correction operation ID; posting retains these references in its posted header. Its managed financial sources must be posted and their copied links complete before the FWO can be posted, even if Posted Documents Control is disabled. Posting a retained credit manually does not leave an outstanding requirement to create a replacement invoice.
These same three actions are supported for posted sales invoices, producing Income rows. Ordinary Copy Document and credit memos created independently of the invoice correction actions still need explicit linking or import. The feature applies to new operations and does not rebuild older corrections. Managed correction rows remain outside ordinary detach. See Settlement.
Create purchase lines from planned costs
Use these actions only when the required purchase lines have not been entered yet:
- Create > Purchase Order or Create > Purchase Invoice creates a new document from compatible planned Standard Cost lines.
- Create > Purchase Credit Memo creates a new document from compatible planned Credit Cost lines.
- Add to Document > Select Purchase Document adds the current or selected Cost rows as new lines to a compatible document with Status = Open. Standard offers orders and invoices; Credit offers credit memos.
These actions create and link new purchase lines while the document is Open, independently of Purch. Document Linking Mode. You do not need to release a document before TMS creates its new lines. To match existing lines instead, use the corresponding direct link, import, or allocation action; those new links require the source status selected by the linking mode.
For Add to Document, select only the intended unlinked Cost rows. They must match the selected document’s Buy-from Vendor, Financial Effect, currency, and currency factor. Do not mix Standard and Credit in one selection. Creating a new Purchase document also requires compatible posting dates and dimensions across its Cost rows.
If the invoice line is already present, return to single-line linking instead of adding it again.
Review, edit, and post linked documents
After assignment, check the document reference and Settlement totals before posting. Linking is not posting: an Open or Released linked invoice remains unposted until you post it in Business Central.
You can Reopen a linked purchase document for supported edits when Business Central requires it. Saving changes to description, quantity, unit, dimensions, Direct Unit Cost, line discounts, or Line Amount refreshes the complete Settlement allocation. TMS also refreshes older linked snapshots before posting. Review every affected Forwarding Order when a line is shared. The purchase document remains the source of these actual values. Existing links remain valid after a source-status or linking-mode change; a new link, import, Charge Allocation, or Freight Order assignment must satisfy the current Purch. Document Linking Mode.
Changes to the same physical source line, including Type / No., refresh Settlement from that source. Changing allocation membership or replacing the source line requires the supported detach and reassignment workflow. An ordinary deletion of a linked purchase line is blocked: detach first. Standard header changes such as a currency change can temporarily delete and recreate lines; that Recreate operation preserves the link and refreshes it to the recreated line. After financial posting, the actual posted line supplies the final quantity, price, discounts, amounts, currency, description, unit, location, and dimensions for every Settlement share. Allocation shares and Forwarding Order references are preserved.
Post the linked source in full. For a linked Purchase Order, choose Receive and Invoice for the full quantity in one posting operation. Separate receipt posting is unsupported even if you receive the full quantity.
Partial receipts, partial invoicing, combined receipts, item tracking, warehouse processing, prepayments, and deferrals are outside the supported Settlement flow. After successful posting, TMS changes the existing source reference to the Posted Purchase Invoice or Posted Purchase Credit Memo and marks the linked Settlement rows as posted. Open the related document from Settlement to verify it.
For a source that was posted before assignment, use the posted-invoice workflow or the posted credit-memo workflow. These create direct posted links and require no further purchase posting.
Remove or change an assignment
Use Detach Settlement for a direct purchase assignment. The command is the same whether you start in Settlement or on the financial document.
On Purchase Invoice lines, Detach Settlement is enabled only when the current line has linked active or posted Settlement rows. A link on another invoice line does not enable it. Detach All Lines checks the complete invoice instead.
- Select the linked Cost row in Settlement and choose Import to Settlement > Detach Settlement. Alternatively, select the source purchase line and choose TMS > Detach Settlement where that action is available. Detach does not require Reopen: an eligible unposted document can remain Released, because its source line is not changed.
- Review the confirmation. It applies to the complete direct allocation of the source line, including other FWOs and all supported posted versions.
- Confirm and review all affected orders. Active Cost rows become unlinked Fixed Amount plans with their existing P/L and currency values. Archived rows retain their complete financial snapshots and lose only the source and allocation references.
- Edit an active plan or choose its replacement source as needed. A new direct replacement link, Charge Allocation, or Freight Order assignment to an unposted source must satisfy Purch. Document Linking Mode. Delete an unwanted unposted source line separately after detaching.
Detach does not delete the purchase line or restore an earlier estimate. A Cost with P/L Amount = −520 remains at −520 after detach, even if the original estimate was −500. Current exchange rates are not applied during detach. If saved values depend on VAT or invoice-discount context, the active plan uses its saved net amount excluding VAT as the new Amount base; its P/L stays unchanged. The corresponding archived values are not normalized or recalculated.
To detach the complete Purchase Invoice, use TMS > Detach All Lines next to Detach Settlement. The command includes every source line with a direct reference, regardless of selection or page filters. It is available for active or archived references. All groups are checked before any change; failure rolls back the entire operation.
For example, one purchase line is allocated to five FWOs: three posted and two active. Detaching that source line clears every related physical reference: both active rows and all archived versions of the other three orders. The active rows remain plans with their previous P/L. Posted quantities, prices, discounts, amounts, currency amounts, and P/L remain exactly as saved. Closing a FWO does not cause its assignment to be skipped.
Supported archived source types are Order, Invoice, Credit Memo, Posted Invoice, and Posted Credit Memo. Freight Order parent allocations, TMS correction history, unresolved legacy links, and archived Quote, Blanket Order, or Return Order references are outside this direct-detach workflow. Active FWO status and source-processing checks still apply. Complete the amount-model wizard for rows that require conversion before detaching them.
Detach a posted purchase invoice
Use this to remove a direct Settlement assignment while keeping the Posted Purchase Invoice and its financial entries. Links established before or after invoice posting use the same command. Archived members are included, even when no active Settlement rows remain.
- Open the Posted Purchase Invoice and go to Lines.
- Choose TMS > Detach Settlement for the current line’s complete group, or TMS > Detach All Lines for the whole invoice.
- Confirm once. TMS checks the source and every active and archived member before writing; a failure leaves all references intact.
- Review the retained active plans and posted history. All affected source references are cleared. Existing generated-row and agreement controls still apply to the active plans.
An enabled action means references exist; it does not guarantee that the complete group is eligible. Cancelled or corrective invoices, Freight allocations, TMS correction chains, invalid identities, and unsupported source processing remain blocked. Payment alone does not prevent detach.
Both actions preserve posted invoice lines and amounts, vendor ledger entries, and payment applications. The Detach Settlement action in Settlement calls the same mechanism; it is not limited to unposted purchases. These commands change the assignment only. Use a Purchase Credit Memo when the vendor’s charge itself must be credited.
Detach a posted purchase credit memo
In the Posted Purchase Credit Memo line actions, open TMS and choose:
- Detach Settlement to remove all direct Settlement links of the current line, including active FWOs and every linked posted FWO version.
- Detach All Lines to remove all direct Settlement links of the credit memo, including lines outside the current selection or filters.
The current-line action is enabled only when that line has Settlement links. The all-lines action is enabled when any line in the document has links, even if the selected line is unlinked. Zero amounts still count as links. After confirmation, the same common command used from Settlement removes the assignments: active rows become plans, posted FWO amounts stay unchanged, and the credit memo and its financial entries remain. Existing source and correction checks still apply. Charge Allocation is not offered on posted purchase credit memos.
Review the retained plans before linking a replacement to avoid counting an expense twice. Use Posted Purchase Invoice Line or Posted Purchase Credit-Memo Line, as appropriate, to link a suitable active Cost to its replacement source. Archived Settlement remains a historical record; detach does not make it an editable plan or reopen its FWO.
Assign a carrier invoice through a Freight Order
Use this route when the purchase cost should first appear in Freight Order Charges and then be allocated to that Freight Order’s related Forwarding Orders. Complete the existing Purchase Invoice and confirm that its status is allowed by Purch. Document Linking Mode before assigning it.
- Open the Freight Order and check its Pay-to Vendor No. and assigned Forwarding Order stages.
- In Charges, choose Assignment > Purchase Document.
- In Purchase Document Assignment, select the unallocated invoice lines for this Freight Order. This entry point lists unposted Purchase Invoices in statuses allowed by Purch. Document Linking Mode, whose Pay-to Vendor matches the Freight Order’s Pay-to Vendor. Buy-from Vendor can differ; it is not restricted to the Freight Order’s Pay-to Vendor or Carrier.
- Confirm the selection, then choose the distribution type and participating Forwarding Orders in Select Allocation.
- Confirm and review the new Freight Order charges and the allocated Cost rows in each Forwarding Order’s Settlement.
This workflow creates Freight charge records and their Settlement allocations. Each Cost takes its vendor from the invoice’s Buy-from Vendor; the invoice retains its Pay-to Vendor. For example, an invoice with Buy-from A and Pay-to B can be assigned to a Freight Order with Pay-to B, and its Cost records identify A. Do not also import the same purchase line directly into Settlement.
The new Freight charge uses the Charge matching the purchase line’s Type / No. marked Default for Purchase Import, or the first matching Code in ascending order when none is marked. Configure a preferred choice in Charges.
In Select Allocation, Planned Amount (LCY) includes the Cost amounts for the Buy-from Vendors of the selected invoice lines. If several selected lines or invoices share a Buy-from Vendor, that vendor’s amounts are counted once. If invoices from different Buy-from Vendors share the Freight Order’s Pay-to Vendor, the column combines their Cost amounts for each Forwarding Order.
Before creating a new assignment, TMS checks that the invoice’s Pay-to Vendor still matches the Freight Order’s current, nonblank Pay-to Vendor. If they differ, assignment stops without creating its Freight charge or Settlement allocations. Close and reopen the selection after changing the invoice or Freight Order.
To cancel an assignment, select its charge in Freight Order > Charges and choose Assignment > Delete Assignment. After confirmation, TMS deletes the selected charge and all its active Cost Settlement allocations together. The purchase document and its financial entries remain. The deleted allocations do not become planned costs. The affected Forwarding Order statuses must allow Cost Settlement changes. The Freight Order Charges Editable setting controls manual field editing and is not required for this action.
Cancellation does not require the saved quantities or amounts to match the purchase, a verified source link, or the purchase document to still exist. A posted purchase alone does not prevent cancellation while the entire transportation assignment remains active. TMS checks ownership and correction dependencies; an archived allocation, a related correction, or ambiguous ownership stops the whole operation before deletion. If another session changes the assignment, refresh the Freight Order and retry.
An eligible open purchase line can be assigned again when no other active or archived allocation references remain. Assigning a posted purchase line to a Freight Order remains unsupported. The direct Detach Settlement command still handles direct purchase allocations; use Delete Assignment on the Freight Order for a Freight charge. Ordinary deletion of linked charges remains protected.
Troubleshooting
| Problem | What to check |
|---|---|
| The invoice is not listed for single-line linking. | Use Purchase Invoice Line for an unposted invoice, or Posted Purchase Invoice Line for a posted invoice. Check Purch. Document Linking Mode and the current Cost’s Customer/Vendor No.: when filled, it filters Buy-from Vendor No.; when blank, all vendors are shown. Also check source eligibility and existing allocations. |
| An unposted purchase cannot be linked, imported, or allocated. | Check the source status against Purch. Document Linking Mode. The same mode applies to direct linking, import, Charge Allocation and Freight assignment; Pending Approval and Pending Prepayment are excluded. The error identifies the current document status and required mode. Other source and allocation checks still apply. Create and Add to Document retain their Open requirement. |
| Import Purchase Document and Link to Purchase Line actions are disabled. | Ask an administrator to check your User Setup record and TMS Allow Purchase Document Allocation, then reopen the Forwarding Order. |
| An order is missing from Select Allocation. | Check that it has a free Cost with Customer/Vendor No. equal to the source Buy-from Vendor and an existing, nonblank Charge Code mapped to the source Type / No. Blank or different vendors and blank or incompatible codes are excluded. If several rows qualify, select the exact Settlement Line No. |
| TMS asks for Settlement Line No. | More than one compatible Cost row exists. Choose the intended row with the lookup. |
| The source Charge cannot be resolved. | A compatible existing Code is retained. Otherwise, configure a missing Purchase Line - Type / Purchase Line - No. mapping or correct multiple marked defaults. Without a marked default, the first matching Code in ascending order is used. Similar descriptions or equal amounts do not establish a match. |
| Whole-document import reports several defaults. | Clear the extra Default for Purchase Import flags among matching Charges. At most one may be marked. |
| Whole-document import selected a different Charge than expected. | Mark the intended matching Charge as Default for Purchase Import. With all flags off, TMS uses Code ascending, independently of the list order. For a line-specific choice, use a planned Cost row with the intended compatible Code and single-line linking. |
| Cost appears twice after import. | Whole-document import creates new rows. Check whether the same cost was already planned; use single-line linking when replacing a plan with an actual source. |
| A source line is already allocated. | Review its existing Settlement or Freight allocation, including posted transportation history. Closing an FWO or Freight Order does not make the source line free. |
| Ordinary costs increase profit. | Check Financial Effect and the signs of Quantity, Price, and Amount. An ordinary positive purchase line uses Standard with positive quantity, price, and Amount; its P/L Amount (LCY) is negative. |
| Allocation fails with a zero share. | Check selected orders and the values used by Distribution Type. Every selected share must be greater than zero. |
| A linked purchase line cannot be changed or deleted. | Reopen the document when standard Business Central requires it. Saved changes to the existing line update Settlement automatically, including VAT and invoice discounts. For deletion, detach the complete eligible allocation first. |
| The document has already been posted. | Use the posted invoice actions or the posted credit-memo actions. The source sets Standard or Credit on the existing Cost. |
| A posted credit memo line cannot be linked to a Cost. | Check the Customer/Vendor No. filter on the current Cost, Charge mapping, actual document/Freight/correction references, active and archived allocations, and source eligibility. The old Financial Effect or Needs Review marker alone does not prevent linking. |
| An old Cost is marked Needs Review or Legacy. | If it has no conflicting source or allocation identity, link the actual purchase line directly. Its source values replace the old plan and verification state; recreating the Cost first is unnecessary. |
| A paid invoice cannot be linked. | Payment alone is permitted. Check cancellation/corrective status, invoice discounts, supported source processing, Charge mapping, and existing allocations. |
| Initial unposted linking or import reports an invoice discount. | Review Inv. Discount Amount and Inv. Disc. Amount to Invoice on the named document and line; both must be zero. Allow Invoice Disc. = Yes alone is allowed. TMS does not switch the flag off or change the source discount amounts. |
| Detach Settlement does not apply to the row. | Check its source identity and amount-model conversion. Eligible active and archived direct invoice references use the same command. Freight allocations, TMS correction chains, unresolved links, and unsupported archived document types remain excluded. |
| Posted invoice detach is enabled but fails. | Check the reported source, active FWO status, verification state, Freight or TMS correction references, cancellation, and stale identities. Archived members alone do not block detach. A failed Detach All Lines operation keeps all links intact. |