Purchase Orders > Purchase Order Processing > Purchase Order Receipts > PO Receipts With Apportionment

PO Receipts With Apportionment

You use this program to apportion non-merchandise charges across all lines of a purchase order.

You can enter the receipt of an entire purchase order and enter the apportionment details at the same time. Once you have entered the required details, you are returned to the Purchase Order Receipts program to post the receipt and apportionment transactions.

This facility can be used as an alternative to the Landed Cost Tracking system or Cost Multiplier facility (see Comparing Receipt Methods).

Receipt in Entire Purchase Order

Field Description
Apportionment Details

Select this to perform the following:

  • apportion non-merchandise charges across all lines being received into stock.
  • change the receipt quantity against selected lines, using the Receipt Lines listview. Quantities can be changed without entering any non-merchandise charges.

Non-merchandise charges are only included in the Last cost of an item if you enabled the option: Include non-merchandise costs (Purchase Orders Setup).

No apportionments are applied to lines which require inspection (Stock Codes).

You cannot select this function for order lines containing items which are defined as traceable.

[Note]

If your GRN numbering method is defined as Automatic (Set Key Information) then regardless of whether you specified that GRN numbers must be assigned to individual purchase order lines, the program allocates one GRN number for all lines being receipted in (and for all the non-merchandise elements).

Any residual values calculated by the system following apportionment are added to the last purchase order line. If, however, as a result of applying the residual value the charge becomes negative, then the charge is set to zero and the difference is added to the undistributed value.

A residual value may arise when the system is unable to apportion a charge absolutely across all lines. For example: If you have 5 purchase order lines and you apportion 100.06 using the Equal line method, then each line should be assigned 20.01. However, this would result in only 100.05 being distributed. In this scenario, the last order line is assigned 20.02.

Post Select this to receipt in the valid lines for the purchase order.
Details  
Purchase Order Totals  
Number of lines to be receipted in This displays the total number of lines for the selected purchase order which can be receipted.
Total value for apportionment This indicates the total value of the purchase order lines selected for receipt.
Non-merchandise apportionment This indicates the total value of apportionment charges applied to the purchase order.
Total value including apportionment This indicates the total value of the purchase order lines selected for receipt plus the non-merchandise apportionment value.
Inspection/Traceable Totals  
Number of inspections/traceable lines

This indicates the number of items on the purchase order that are defined traceable or that require inspection.

Stock items are defined as traceable and/or requiring inspection using the Stock Codes program.

Total value items This indicates the total value for the traceable and inspection items on the purchase order.
Receipt Details
GRN

Enter a GRN number to be used as the key to the GRN suspense file.

You can only access this field if you selected the setup option: GRN suspense system is required, and your GRN numbering method is defined as manual (Purchase Orders Setup).

Reference This is displayed only if you indicated that the GRN suspense system is not required (Purchase Orders Setup).
Notation Enter a notation that you want to print on the journal report.
GRN source

Enter a code (in the range 1 to 5) indicating the source of the transaction. For example: a code of 1 could indicate returns.

Totals for each code are printed on the GRN Audit Trail report.

You can only access this field if you selected the setup option: GRN suspense system required (Purchase Orders Setup).

Supplier's delivery note

Indicate the supplier's delivery note number which will be stored in the inspection file.

This number can be printed on inspection documents and used as a to link to a sales order.

Automatically issue to job(s) Select this to automatically issue items to jobs, without operator intervention.
Cost basis

Indicate the cost basis to use for the receipt. This defaults to Purchase price for local currency supplier receipts and to Price at entry for foreign currency supplier receipts.

If you add an apportionment, then the apportionment is done according to the prices based on the cost basis using the calculation: Apportionment amount * ((rec-qty * price) / Total purchase order value for all lines). Note that if you do the apportionment and then change the cost basis, the apportionment is not adjusted.

Option Description
Current cost Select this to use the warehouse cost defined against the stock item for the receipt (Inventory Warehouse Maintenance for Stock Code - unit Cost field).

When receipting a combination of stocked and non-stocked lines, non-stocked items are receipted at Purchase price.

Purchase price Select this to use the cost specified when entering the purchase order line, excluding tax.
Price + Tax Select this to use the cost specified when entering the purchase order line, including tax according to the tax code entered on the purchase order line.
Price at entry Select this to calculate the purchase price by multiplying the cost entered on the purchase order line by the exchange rate used when the purchase order was created (to convert it into the local currency). Changes to the currency exchange rate after the purchase order was entered are ignored.

This only applies to receipts for foreign currency suppliers.

Current price Select this to calculate the purchase price by multiplying the cost entered on the purchase order line by the current exchange rate (to convert it into the local currency).

This only applies to receipts for foreign currency suppliers.

Use default bin  

PO Apportionment Details

Field Description
Cancel Select this to ignore all apportionment entries you made and return to the Purchase Order Receipts program.
Accept and Close Select this to accept the entries you made and to return to the Purchase Order Receipts program.

You use the Purchase Order Receipts program to actually post the receipt and apportionment values.

This function is only enabled when the Undistributed value of each apportionment line is zero.

Non-Merchandise Apportionment

You use the fields in this pane to indicate the charge elements that you want to apportion to lines across the order.

Field Description
Delete apportionment line Select this to remove the currently highlighted charge line.
Enter New Apportionment Select this to add a new apportionment charge line to the list of charges to be apportioned.
Distribute Non-Merchandise Costs

Select this to calculate and display the cumulative non-merchandise value for each line (except Manual lines) in the Receipt Lines listview, after you entered the required charges in the Non-Merchandise Apportionment pane.

Note that values are only apportioned to receipt lines with a tick in the check box of the Receipt Lines listview.

These values are also displayed in the Line Apportionment pane.

The details you entered for each charge line are validated and you are prompted to enter or change any details which are missing or incorrect.

To distribute the Manual lines, highlight the manual apportionment line in the Non-Merchandise Apportionment listview, select the Receipt Line(s) to which you want to apportion the manual cost and apportion the manual costs to the lines in the Line Apportionment listview.

This option must be selected if you Enter New Apportionments. The non-merchandise costs are recalculated and apportioned to the Receipt Lines again (except for the Manual costs, which are cleared and have to be manually re-entered).

Line apportionment view Indicate the information to display in the Line Apportionment listview after selecting the Distribute Non-Merchandise Costs function.
OptionDescription
By Apportionment EntrySelect this to display the apportionment information for the line currently highlighted in the Non-Merchandise Apportionment listview.
By PO LineSelect this to display the apportionment information for the line currently highlighted in the Receipt Lines listview.
Description

Enter the description of the charge (e.g. Duty or freight). The description is mandatory and must be unique for each purchase order processed.

This description is reflected in the GRN suspense file in the stock code field, enabling you to identify each charge line when printing GRN reports.

Method

Indicate the apportion method you want to add. As many apportionments as required can be added.

Apportionments can be associated with different suppliers or different ledger codes, but they must each have a unique Description.

Each line generates an individual GRN transaction (if the GRN suspense system is required) that can be matched within the AP Invoice Posting program when the supplier's invoice is received.

Option Description
By value

Select this to apportion the charge amount proportionately to each merchandise line according to the value of each line.

The program calculates the value of the entire purchase order, and then applies the charge amount to each line according to the value of each line.

For example: If the purchase order value is 100 and a purchase order line is valued at 15, and the charge amount is 10, then the program applies the formula: (15/100 x 10) as the non-merchandise value for that line.

By volume

Select this to apportion the charge amount proportionately to each merchandise line according to the volume calculated for each line.

If the volume is not defined against a non-stocked item, then a volume of 1 is assumed.

By mass

Select this to apportion the charge amount proportionately to each merchandise line according to the mass calculated for each line.

If the mass is not defined against a non-stocked item, then a mass of 1 is assumed.

By quantity

Select this to apportion the charge amount proportionately to each merchandise line according to the stocking quantity to be received for each line.

The program calculates the total quantity for the entire purchase order, and then applies the charge amount to each line according to the line quantity.

By equal line

Select this to apportion the charge amount equally for each line.

For example: If there are 100 purchase order lines to receipt in, and the charge amount is 100, then the non-merchandise amount for each line is 1.

Manual

Select this to manually enter an apportionment charge against the Receipt Lines.

The apportionment amount is added to the Undistributed amount and you have to manually distribute the amount to each applicable purchase order line in the Line Apportionment listview, until the Undistributed amount is zero.

Supplier

Enter the supplier code for which the charge is applicable.

This defaults to the supplier assigned to the purchase order, but can be changed.

Supplier name This indicates the name of the supplier code selected.
Currency

Indicate the currency of the Amount.

This defaults to the currency defined against the supplier or, if this is not defined, the currency in which the purchase order was entered.

Amount

Enter the amount you want to apportion to the selected Receipt Lines.

To enter a foreign currency amount, you specify the applicable currency at the Currency field.

Amount (Local) This indicates the amount in the local currency of your company.
Ledger code

Enter the ledger code to which you want to post the non-merchandise amount.

If the GRN suspense system is installed and GRN matching is required for the supplier, then this code defaults to the company GRN suspense account (General Ledger Integration).

The default GRN suspense ledger code can be changed, if the option: Request ledger code for - Purchase order receipts is enabled (Inventory Setup). However, if you change the code from the GRN suspense control account, then the GRN suspense account in the General Ledger will not balance to the GRN Trial Balance report.

See Field considerations in Notes and warnings.

Ledger code description This indicates the description for the ledger code entered.
Undistributed This indicates the undistributed apportionment amount for the line.

You can adjust the apportionment values against each line in the Line Apportionment listview. You cannot select the Accept and Close option until the Undistributed amount reaches zero.

Receipt Lines

The Purchase Order receipt lines are displayed in this listview.

If the purchase order consists only of inspectable items, then you can only change the receipt quantity for each line, but no apportionment is allowed.

Once you have entered the required apportionment details and you select the Distribute Non-Merchandise Costs option, the program calculates and displays the cumulative non-merchandise value for each line in the Receipt Lines listview.

Column Description
Check box

A tick in this column indicates that the line must be receipted and included in the apportionment(s).

All lines are selected for inclusion by default.

If you deselect a line, then that line is not receipted in and none of the apportionment charges are allocated to the line.
Stock code This indicates the code of the item being receipted.
Description This indicates the description for the stock code.
Warehouse This indicates the warehouse for the currently selected stock code.
Receipt qty

This indicates the receipt quantity for the line, but can be changed.

If the purchase order unit of measure differs from the stocking unit of measure, then you can change both the receipt quantity and the stocking quantity to receive.

See also Purchase Order Receipt.

Uom

This indicates the unit of measure for the Receipt quantity.

If the purchase order unit of measure differs from the stocking unit of measure, then you can change both the receipt quantity and the stocking quantity to receive.

Total apportionment This indicates the calculated apportionment amount calculated for the line.
Manual This indicates the manual apportionment amount for the line.
Price This indicates the price according to the Cost basis used for the receipt.
P/Order value This indicates the Purchase order value, not the receipt value (i.e. it is not adjusted according to the Cost basis used for the receipt).

Line Apportionment

This indicates the breakdown of the apportionments according to the Line apportionment view selected.

Column Description
Description This indicates the apportionment charge description.
Method This indicates the apportionment charge method.
Value

This indicates the portion of the apportionment charge applied each stock code for the line highlighted in the Non-Merchandise Apportionment listview.

These values are calculated by the system for all charge lines not defined as Manual, when you select the Distribute Non-Merchandise Costs option from the Non-Merchandise Apportionment tab.

For Manual apportionments, you enter the portion of the manual apportionment charge to apply to each stock code.

The calculated values of non-manual apportionment types can also be changed.

The undistributed amount for each apportionment line is displayed in the Undistributed column of the Non-Merchandise Apportionment listview. This value must be zero before you can select Accept and Close to return to the Purchase Order Receipts program.

Stock code This indicates the code of the stock item to which the apportionment applies.

Notes and warnings

Program access

  • This program is loaded when you select the Receipt All option from the Purchase Order Receipts program.

Warning

Because this function overwrites any manually entered non-merchandise values, you should first change receipt quantities before applying apportionment values. The recommended processing sequence is as follows:

  • Change receipt quantities as required.
  • Enter apportionment details and apply the values.
  • Manually adjust the non-merchandise values for individual purchase order lines.
  • Exit from the apportionment screen.

Restrictions and limits

  • You cannot apply Apportionment Details for order lines containing items which are defined as traceable, or which require inspection (Stock Codes).

    If the purchase order consists of both inspectable and non-inspectable items, then apportionment details are applied only to the non-inspectable items.

GRN numbering

  • If your GRN numbering method is defined as Automatic (Set Key Information) then regardless of whether you specified that GRN numbers must be assigned to individual purchase order lines, the program allocates one GRN number for all lines being receipted and for all the non-merchandise elements.

Residual values

  • Any residual values calculated by the system following apportionment are added to the last purchase order line. If, however, as a result of applying the residual value the charge becomes negative, then the charge is set to zero and the difference is added to the undistributed value.

    A residual value may arise when the system is unable to apportion a charge absolutely across all lines. For example: If you have 5 purchase order lines and you apportion 100.06 using the Equal line method, then each line should be assigned 20.01. However, this would result in only 100.05 being distributed. In this scenario, the last order line is assigned 20.02.

Field considerations

Operator access to the following fields within this program can be restricted. You configure this using the Security Fields function of the Operators program.

Field Description
PO Receipt All apportionment GL code Controls whether an operator can change the Ledger code to which the non-merchandise amount is posted when using the PO Receipts with Apportionment program.