APNIPO Purchase Orders
<< Click to Display Table of Contents >> APNIPO Purchase Orders |
![]() ![]() ![]() |
This screen allows purchase orders to be created with the costs being charged to different ledgers. The costs are charged directly to the ledger specified. There is no receipting process. For example, if a purchase order is made against an inventory item, the stock on hand quantity and the item cost is updated directly from the purchase order.
This purchase order becomes the supplier invoice which has to be authorised for payment.
The screen can be used to enter supplier costs direct from the suppliers invoice, that is bypassing the issue of a purchase order. If you are entering direct from suppliers invoices and you want to enter the Invoice#, click on Options (Alt+O> and select Supplier Invoice? This option will allow the cursor to stop on the Invoice# field.
Line Types
GL IV JL JM JS PR |
Charge purchase to a general ledger account. Purchase items direct to inventory. Non inventory items will be charged against the items Income / Expense account. Charge to a job using a Labour activity code. Charge to a job using a Labour material activity code. Charge to a job using a Sub Contract activity code. Charge purchase to a Project indirect cost general ledger account. |
When charging to a job, an inventory or non inventory item can be selected to obtain an item description, or Item can be left blank. When the Item is blank or contains a non inventory item, the cursor will position on the Item description field.
To Charge Items To A Job
• | Change the Type column to JM or JL or JS |
• | From the Charge To column <F5> to select the required Job. |
• | If a New Job is required, from the JCJOBB:BrowseJobs screen press New Job or <Alt + N>. Complete the JCJOBM:Maintain Jobs screen to create a new job. |
• | NOTE The Charge To should be the customer the goods are to be charged to. This new job can now be selected. |
• | Skip the Item column, or select a non inventory item. |
• | Complete the Quantity and UnitPrice columns. |
• | Enter in the Charge: field the Unit Price to be charged to the customer. |
• | Replace "Enter Item Description Here" or the selected description with the required product description. |
• | After all line items are entered go <Alt + N>. From the buttons window you can print the purchase order, etc. |
Inventory Items
Entering Correct Quantities And Unit Price
It is critical that you order inventory with the correct quantities and unit prices.
Example:
For an item, the inventory cost is .10c EA, and the Retail Sell Price is .20c EA, and the item is recorded and sold as EA's.
If the item is purchased in packs of 100 then the item MUST be ordered as
Quantity |
UOM |
UnitPrice |
LineValue |
100 |
EA |
.10c |
10.00 |
It MUST NOT be ordered as:
Quantity |
UOM |
UnitPrice |
LineValue |
1 |
EA |
10.00 |
10.00 |
If the item is ordered as the pack quantity, the Last Cost will be recorded as $10.00 EA and the system will recommend the retail price be increased to $20.00 EA. The moving average cost also becomes incorrect, causing wrong stock valuations.
To prompt users of this possibility, a Warning Window will be displayed if the UnitPrice entered differs from the Last Cost by more than 10%.
Calculation Of Moving Average Cost
For inventory items, if the current quantity on hand is zero or minus, the moving average cost will be changed to the item cost of the stock receipt. You will be asked to confirm that the unit cost value is correct.
A moving average cost is maintained for all inventory items even when the costing method is Last Cost or Standard.
For Cost Of Sales, the product group costing method is used. For items using Moving Average Cost for costing, and the moving average cost is adjusted because of a zero or minus quantity on hand, an adjustment is made to cost of sales for the difference between the previous and current item costs.
Transaction:
Qty |
Value |
QOH |
M.AvgCost |
Value |
10 |
62.50 |
6 -4 |
6.25 7.30 |
37.50 -29.20 |
Cost of sales adjustment calculation:
$7.30 - $6.25 = $1.05 x 4 = $4.20
Freight & Other Charges
These add on costs can be handled in two ways:
1. | Add costs to the cost of the items purchased. |
This ensures that the items Last Cost and Moving Average Cost reflect the actual
costs of product into store. Click on the Freight Button to apportion these costs to
the item costs.
2. | Charge costs direct to a general ledger account - such as Freight Into Store. |
Use a Non Inventory Product Code, such as FREIGHT, and create a line for the
freight value.
GST
GST-Types
E I X S |
GST Exempt Inclusive Exclusive Special GST |
The whole invoice is exempt, no GST is calculated. GST is calculated as a factor of the invoice total. GST is calculated as a percentage of the line value total. Invoice GST is entered manually. |
The GST Amount can be changed if the GST Type is = X or S. The change window is accessed via the Change GST Amount button. The GST Type will be changed to S by the system if the GST amount is changed.
GST O/ride?
This override can be used if:
• | The supplier is GST registered, but the invoice needs to be GST Exempt. |
• | The supplier is not GST registered, but the invoice GST Type needs to be I or X . |
• | When using the GST Exempt (E) option a GL line can be entered direct to the GL GST account. |
Entering a Zero Quantity
Entering a zero quantity is possible if the LineValue type is used. Once the LineValue is entered the Quantity can be changed to zero.
A zero quantity is required when a price adjustment has to be made. The line comment can be used to record the calculation basis. Also refer to the use of the request for credit.
Default Unit Price
The Unit Price that is selected will be either:
The item's last cost if there is one or
The item's current cost based on the costing method used.
Note that the item's last cost is created when the purchase order has been authorised for payment.
Allocate To A Job
Charge Rate Calculation
A charge rate is selected based on the following logic and priority.
1. | The Unit Charge Rate for the activity code. |
2. | Using the normal sale pricing logic, an item price will be selected based on the |
customer's price type for the job. Any inventory markup for the job will be added
to the price. If a promo or customerised price is selected, any inventory markup for
the job is ignored. Customerised discounts will be selected.
3. | When a price has not been selected, the Charge Rate will be the Unit Price plus the |
appropriate markup for the job. For a material transaction (JM), the material markup
is applied. For a sub contract transaction (JS), the sub contracts markup is applied.
Changing the value
1. | Edit the field directly OR |
2. | Activate the Verify Price Selection screen using the Job Pricing button. |
3. | To change discounts use the Job Pricing button. |
Updating Item Last Cost
The supplier last cost is updated only when the purchase order is authorised for payment and where the item is purchased for stock.