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).
Field | Description | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apportionment Details |
Select this to perform the following:
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.
|
||||||||||||
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.
|
||||||||||||
Use default bin |
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. |
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.
|
||||||||||||||
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.
|
||||||||||||||
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. |
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). |
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. |
This program is loaded when you select the Receipt All option from the Purchase Order Receipts program.
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:
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.
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.
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.
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. |