Previous Topic

Next Topic

Book Contents

Book Index

AP Shipments - Additional Costs tab

Navigator > Tasks > Accounts Payable > Enter Shipments > Additional Costs tab

Enter additional costs to be apportioned as additional cost for the shipment lines based on the Type selected. The Receipt cost for shipment lines includes the unit additional cost. The unit additional cost is also saved to the Supplier record for the product.

Note: If Additional Costs are changed after Invoices and Receipts have been posted, you will need to click Update Costs (Alt+T) to save the changes.

Creditor Code

The Creditor code for the Additional Cost. This is the creditor who invoiced you, for example, it could be a freight company.

Cost Code

The type of Cost. Defaults from the Creditor.

Description

The Cost code description, can be edited.

Period

The period in which the costs were incurred.

Date

The date the costs were incurred.

Reference

The creditor's invoice reference for the cost.

Amount

The amount to be apportioned.

Type

Additional costs can be apportioned to products on a shipment, for example, by Weight, by Volume. Default is Manual if Manually Apportioned is selected from the Receipt tab.

Additional Cost Apportionments are calculated as follows,

Weight

ApportionWeightAmountBs = Sum(AdditionalCost.CostAmountBs where AdditionalCost.ApportionType = Weight)

ApportionTotalWeight = Sum(ShipmentLine.ExtendedWeight where ShipmentLine.ManuallyApportion = False)

Then for each ShipmentLine where ShipmentLine.ManuallyApportion = False and ShipmentLine.ExtendedWeight <> 0 additional cost per unit from weight = ApportionWeightAmountBs * (ShipmentLine.ExtendedWeight / ApportionTotalWeight) / ShipmentLine.Quantity

Volume

Apportion Volume AmountBs = Sum(AdditionalCost.CostAmountBs where AdditionalCost.ApportionType = Volume )

ApportionTotal Volume = Sum(ShipmentLine.Extended Volume where ShipmentLine.ManuallyApportion = False)

Then for each ShipmentLine where ShipmentLine.ManuallyApportion = False and ShipmentLine.Extended Volume <> 0 additional cost per unit from Volume = Apportion Volume AmountBs * (ShipmentLine.Extended Volume / ApportionTotal Volume ) / ShipmentLine.Quantity

Cost

Apportion Cost AmountBs = Sum(AdditionalCost.CostAmountBs where AdditionalCost.ApportionType = Cost)

ApportionTotal Cost = Sum(ShipmentLine.Extended Cost where ShipmentLine.ManuallyApportion = False)

Then for each ShipmentLine where ShipmentLine.ManuallyApportion = False and ShipmentLine.Extended Cost <> 0 additional cost per unit from Cost = Apportion Cost AmountBs * (ShipmentLine.Extended Cost / ApportionTotal Cost ) / ShipmentLine.Quantity

Quantity

Apportion Quantity AmountBs = Sum(AdditionalCost.CostAmountBs where AdditionalCost.ApportionType = Quantity)

ApportionTotal Quantity = Sum(ShipmentLine.Extended Quantity where ShipmentLine.ManuallyApportion = False)

Then for each ShipmentLine where ShipmentLine.ManuallyApportion = False and ShipmentLine.Extended Quantity <> 0 additional cost per unit from Quantity = Apportion Quantity AmountBs * (ShipmentLine.Extended Quantity / ApportionTotal Quantity) / ShipmentLine.Quantity

Currency

The currency of the amount.

Amount Bs

The amount converted to base currency at the exchange rate.

Rate Type

The Rate Type for the exchange rate.

Exchange Rate

The exchange rate to be applied to the cost. If the Shipment Line field is selected (see Customise below), the Exchange Rate and Creditor Code of the Shipment are used.

Grid toolbar

ToolbarExpand

Expand Toolbar (Ctrl+F9)

Expand the toolbar to give access to all toolbar options. Press Esc to close the expanded toolbar.

Insert (F4)

Insert a new line.

Move (Shift+Up) (Shift+ Down)

Move selected lines.

Delete (F3)

Delete a selected line.

Customise (Alt+F5)

Opens Customise Fields, you can customise the fields visible in the grid.

ActionTransaction

Insert invoice for cost (Ctrl+I)

Inserts an Invoice Transaction for the Additional Cost line, for the Creditor. Opens AP Transactions. If an invoice has already been created using the Reference, a warning will be displayed.