...
- The supplier does not have the stock now = sends it later with another purchase order to you
- The price on the supplier invoice is not the same as the purchase order and this is not discovered until after the stock has been received
- The supplier sends stock in multiple shipments - and hence there is multiple invoices for a PO
- The supplier sends invoices that cross Purchase Orders
- The supplier does not require pricing on the Purchase Order
For landed cost variations to expected landed cost prices - see Landed Costing
Contents
| Table of Contents |
|---|
The Supplier does not know pricing until they send the goods
The Purchase Order can be sent to suppliers with no pricing - this flag will remove prices from the PDF sent to the supplier
Stock does not arrive
If a stock item does not arrive on a purchase order - count the received qty as zero = the purchase order will then be processed normally.
...
The invoice price variance will be allocated by the system to a control account "Purchase Price Variance" and the stock will NOT be revalued.
After the PO has been received and the stock is in the system - the stock can be revalued using Landed Costing by allocating additional costs.
The supplier Charged Freight
When a supplier charges freight the costs are allocated by $ value across the goods by the system.
Supplier freight is not known until the supplier invoice is entered and includes freight.
- The average cost is updated by averaging the freight based on line item value.
- The average cost update is limited to the value that would have resulted if all the stock is still in the system
- if there is less stock remaining than was received then not all the freight will be allocated and some will remain in the "Carriage In" control account
If you do not want the freight allocated or you want to allocate it using a different method then enter it as a separate invoice.
Example PO
Here is a PO with all of the above issues.
Stock count differences
Price Differences
After all changes - user will be prompted - what to do when counted different to invoiced
Price Variance Journals will be created the Creditor Invoice is created
Uses the Purchase Price Variance GL Control Account
Can view all that has happened on the Purchase Order
All linked Journals can be found from the Purchase Order
An example of the Journals created by discrepancies
...
FX Purchase Orders and Goods Received Not Invoiced Account Balance from rounding
When the stock arrives - the value of stocking the goods is linked to the "Goods Received Not Invoiced" GL Account
When the invoice is created the same GL account is referenced - and the net result should be zero.
However - an Foreign Exchange purchase order may have a small variance due to rounding
- The Price each in the FX currency is converted to a price ea in AUD - this involves rounding to two decimal places
- The stock is received using the rounded AUD value each x qty
- The invoice line is calculated using the total FX amount (FX each x qty) and then converting this to AUD and then rounding it
- So because the calculations are different a variance in AUD may exist
- Example
- Qty 2080
- price ea 5.84 in British Pounds, FX rate of 0.55 AUD to GBP - results in AUD $10.62 each
- Stock receipt journal creates value in Goods receipt not invoiced GL account using AUD$10.62 each x 2080 = $22,089.60
- Creditor invoice removes value from Goods Receipt not invoiced GL account converting FX total (2080 x 5.84 = GBP 12,147.20) - converting to AUD $22,085.82
- This would leave a small value ($22,089.60 - 22,085.82 = $3.78) in the Goods Received not invoiced GL account for this line
- For many lines this can build up to a more significant value.
- Example
Purchasing Deals (Blanket Orders)
When an agreement is in place for a
- quantity per SKUs
- that are expected in a date range
- with an agreed price
- and are not sent based on purchase orders supplied to the supplier
If you agree that the supplier is to send you
- 50 of Product A @ $25.00
- 34 of Product B @ 29.00
- 10 of Product C @ 1.67
- Between dates 1 AND 2
Then each shipment the supplier supplies a unique identifier and related invoice for the shipment
Then
- Set up a deal with the quantity, date range, supplier prices
- Receipt of product will create a PO on the fly as the product is counted in the warehouse
Purchase Deal setup
Supplier must be ticked as "Distributor"
Make the Deal Active when Ready to use
Purchase Deal Use - stock arrives
Just In Time (JIT) Receipt of Product in the warehouse > create the PO
Creation will then open the PO receipt screen > where the items can be added
| Note |
|---|
items are not limited to those on the deal. However pricing for any item on an active deal will come from the deal. |
Counting of items is all using scanning
Once lines are scanned then process counted lines in plan status (like other purchase order receipt processes)
Return to Supplier
Find the PO - create return to supplier
Once a Purchase Order has been received the stock can be returned to the supplier
Create pick
This creates a return to supplier sales order to be picked
Complete pick
The pick is done using normal warehouse pick screen
Cogs uses current average cost
Create Credit Note and adjust average cost
Order will move to Invoiced status
Average cost will be updated as follows
- Value to be removed = Value on sales order - value of COGS
- Spread difference over remaining stock
| Note | ||
|---|---|---|
| ||
Note that the average cost update does NOT include the original Purchase order landed costs - you will have to do a manual cost update if you want to remove those as well. This is because not all of the po may be returned and hence the landed cost allocation used on the PO may not apply |