TRANXACT.AI Aide

Charges on sales and purchase orders: line charges, header charges and Spread by

Since release 20261106f a sales order and a purchase order have a Charges tab and a Charge allocation tab. A charge on a line belongs to that line; a charge on the whole order is counted once and shared out over the lines by value, quantity, weight or by hand, and invoiced with each line. In India, charges on a sales order get GST.

You can add freight, packing and forwarding, inspection, insurance, handling and other charges to a sales order or a purchase order. A charge can be on one line, or on the whole order. A charge on the whole order is shared out over the lines.

Où le trouver

Open a sales order (CRM › Sales Orders) or a purchase order (Supply Chain › Purchase Orders). The record page has two tabs next to Lines:

LanguetteCe que cela montre
FraisEvery charge on the order. Use Add line to add one.
Charge allocationHow much of each whole-order charge each line carries.
  • The Lines tab also has a read-only Charges column. It shows each line’s own charges plus its share of the whole-order charges.
  • The separate screens Sales Document Charges (CRM › Pricing Procedures) and Purchase Order Charges (Supply Chain › Purchase Charges) have the same Line and Spread by fields.

Line charges and header charges

ChargeHow you make itCe que cela fait
Line chargePick a line in Line.The charge belongs to that line only. It is added into the order’s charges total.
Header chargeLeave Line empty.The charge is for the whole order. It is counted once in the order’s charges total, and it is also shared out over the lines.

The order total is the lines, plus tax, plus charges. Each charge counts once, so the split never adds anything to the total. Orders saved before this release keep their totals.

Paid to says who receives the charge:

  • On this order (the default): the customer pays it, or the supplier bills it. It is in the order total.
  • Accrued: it is paid to someone else, such as a carrier or customs. It is recorded but not in the order total.

Since release 20261113 a sales order’s charge also has Paid to (partner): the carrier, customs broker or other supplier it is paid to. See Who a sales-order charge is paid to.

When you cannot change a charge

  • Charges worked out from the condition records show as Frozen. You cannot edit or delete them. To change one, change its condition record, or add a charge by hand.
  • Purchase order: once goods have been received, its charges are locked.
  • Sales order: once any charge has been invoiced, or the order is invoiced, closed or cancelled, its charges are locked.

Répandu par

Spread by decides how a header charge is shared out over the lines:

Répandu parHow the charge is shared
By value (the default)In proportion to each line’s value.
By quantityIn proportion to the quantity ordered.
By weightIn proportion to quantity times the item’s gross weight. Gross weight comes from the item’s warehouse record, or else from its stocking unit. If the items have no weight, the charge is spread by value instead, and the Charge allocation tab says so.
By handType a share for each line on the Charge allocation tab. Shares are relative to each other, so <1>, <1> and <2> split the charge 25%, 25% and 50%.

The shares always add up to the charge exactly, to the cent. They are worked out again when the lines or the charge change.

Invoicing a sales order

  • Each line’s share of a header charge is billed with that line, in proportion to the quantity invoiced.
  • The last invoice for a line bills whatever is left of its share.
  • A header charge that has no shares is billed in full on the first invoice, as before. This applies to orders from before this release, and to a hand-spread charge with no shares typed.

GST on sales order charges (India)

For a company in India, a charge billed to the customer gets GST, just like the order’s lines. GST uses the order’s GSTIN and place of supply. It is split into CGST plus SGST (or UTGST) within a state, or charged as IGST between states.

CodeWhere it comes from, in order
SAC codeThe charge’s own SAC code; otherwise its condition’s SAC code; otherwise the usual code for the kind of charge: freight 9965, packing 9985, insurance 9971, inspection 9983, handling 9967.
Code de la TPSThe charge’s own GST code; otherwise its condition’s; otherwise the rate of the SAC code on the order date; otherwise the company’s default code.
  • The sales charge conditions FRS1 (freight), PKS1 (packing), INS1 (insurance) and ISS1 (inspection) are set to their SAC codes and GST18 where nothing was set before.
  • GST on charges is added to the order’s tax and total. The order also shows how much of its tax is GST on charges. On the invoice, the charge line carries the same GST code and SAC code.
  • Charges that are accrued, or shown but not added to the total, get no GST on the order. Under reverse charge, no GST is charged on the order.
  • Companies outside India get no GST on charges, so their totals are worked out as before.

Example: freight for the whole order, spread by weight

  1. Open the sales order and choose the Charges tab.
  2. Press Add line. Choose Kind of charge <Freight>, Amount <600>, leave Line empty, and choose Spread by <By weight>. Save.
  3. Open Charge allocation to see each line’s share. The Charges column on Lines shows the same share beside each line.

How to reuse: the amounts and shares in angle brackets are examples; put your own in their place.

See Charges on orders: freight, insurance, inspection and duty, and India: the purchase order calculation schema, from gross price to GST.

  • A purchase order charge has Paid to (supplier), on Supply Chain › Purchasing › Purchase Charges › Purchase Order Charges and on the order’s Charges tab: a freight forwarder who bills the freight instead of the order’s supplier, for example.
  • A charge paid to a supplier other than the order’s own is marked accrued and is not added to the order’s total.
  • The approver sees who is paid on PO Approvals, and the landed cost estimate made when the goods are received shows which supplier will bill each charge.