Use Sidebar LHS to navigate
For global help click here

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 141 Next »

Where perishable goods are transacted the expiry date will be required

Table of contents

Overview

Each Purchase Order will be received by a warehouse from a supplier.  

  • Stock will then be moved from this warehouse to others using Inter warehouse Move Orders
  • If a supplier is sending direct to multiple warehouses you will require multiple purchase orders
  • Suppliers may send multiple shipments and invoices per purchase order (if flagged)

A purchase order for purchasing perishable stock may be created:

Where Used Report - for recalls

The where used report is designed to find stock received from a supplier and look to see where it was used in manufacturing or sent to customers.

The where used report will find traceable stock based on expiry dates and lot numbers.

Find all customers that received the stock


Also used to create inter-company purchase orders

For non-stock purchasing use Non-Stock Purchase Order

Sales Order at Risk Report

When Purchase Orders are Delayed - it is important to contact Wholesale Customers to modify their orders.

This report provides a

  1. List of sales orders indicating the number of order lines that are at risk
  2. The ability to open the product forecasting screen to view expected stock levels including inbound purchase orders

An email of the XLS will be sent to users at 1pm each day with secure feature Secure Features#ReceiveMarketplaceOrdersReport

Purchase Order Flow

Where to find purchase orders

Purchase Order Report

List of Purchase Orders that require Action

The Purchase Reports dashboard highlights all items that require action - note the legend at the bottom for details

Filter based on the role in the business to see the purchase orders that require action by that role.

Right click to open the related documents.

  • Only shows the PO's that require action
  • Brand is the predominant Brand on the PO
  • If PO is being sent direct to the customer it will have the "DropShip Customer" column details including related Sales order

Drop Ship Purchase Orders (supplier sends directly to customer or printer)

Drop ship purchase orders have a delivery address that is not your address

  1. It could be a customers address 
  2. It could be an address of supplier that changes it (eg prints onto a cup or makes soup from ingredients)
  3. It could be the address of a franchisee (when the PO has been placed by a Franchisor for direct shipment to franchisee)

If you do not want your suppliers to know your end customers addresses - then arrange the freight booking for a drop ship purchase order - the supplier documents will NOT include the address to be delivered to - it will only have the courier booking information.

Email of the PO Reports

Purchase Order report emails with summary information from the above are sent to users with any of:

Payments - timing of deposits and final payments

When suppliers expect deposits before starting work and final payment before releasing goods it is important to understand the cashflow implications and have a view of the timings of those

Can be viewed for next 8 weeks or for next 6 months.  Summarised by currency with a total cumulative requirement in Host Company base currency.

Setting payment timings on a purchase order - if this is not set the calculation uses warehouse reciept + Terms

Note defaults can be set on the supplier

To enter deposit payments on Purchase Orders - see Purchase Order from PO to Goods Receipt#PurchaseOrderDeposits

Goods Received not Invoiced Account

Used to confirm the movements in the Goods Received Not Invoice Account (or landed cost accounts)

  • Stock Receipt Journals
  • Creditor invoices

Has one line for each Purchase Order

Shows all transactions, Opening balance, difference, closing balance

Purchase orders are always stock receipted before being invoiced.  Proforma invoices are not journals.

Differences commonly occur when the PO has been received but not invoiced

  • the invoiced quantity is different to the counted qty
  • The receipt value is different to the invoice value
  • see Purchase Order Variations

Move Orders

Move orders move stock from one warehouse to another.  Examples include own warehouses and other places (like customers) where owned stock exists.

A Purchase Order that purchases stock for multiple warehouses - will create move orders when receipted to move stock from the receiving warehouse to the other warehouses.

This report shows all Move Orders that require attention - or have missing details

Managing Shipments - International Purchase Orders

This dashboard tracks key dates and required documents.  Note that confirmed date column is the latest confirmed date of the dates that are tracked on the PO.

International Purchase orders have key dates to meet and require specific documentation at key times

  • Proforma Invoice (supplied in advance of stock receipt and used by Customs)
  • Bill of Lading
  • Packing List
  • Packing Declaration

Documents attached to a PO

Documents can be attached anytime to a Purchase Order - if they are missing when require then they show in the list

Some SKU's require additional certifying documents to be provided with each purchase order - some examples

  • Fumigation - common with wood or outdoor furniture products
  • Veterinary Health - common for products for pets
  • TGA-ARTG (Australian Register of Therapeutic Goods) inspection
  • Refrigerant check 

Documents required with every shipment by SKU

This is where to indicate which SKU;s require documents with every shipment.

Expiring Certifications

It is also important to highlight any certifications on any SKU that will expiry in the next 12 months - eg

  • Electrical Certifications

Viewing products on order and the % paid by product

The Purchase Reports view has a view of all purchase order lines in the system



From the Purchase Order Screen - finding a purchase order

Enter PO number.

Enter the supplier then do a search limited by the supplier.

Searching by supplier ref

Searching by shipping company ref

Purchase Order Register - The central list

On the Supplier

In the Forecasting screen

Expected Purchase Orders show in the forecasting screen

For a snapshot of the current situation of the items on this PO

To see detailed planning buckets over time across all products by supplier etc

See Product Forecasting Based on Sales History

In the Warehouse Shipments in/out screen

Used by the warehouse to track things that are arriving and departing the warehouse including purchase orders

Franchisee's receiving a Franchisor Drop Ship Purchase order from a supplier will have an asterix to indicate it is a Franchisor PO.

Building up a Purchase Order

Purchase orders may be created in a number of ways

  1. Manually - see below
  2. Upload of XLS sheet to Purchase order screen (commonly used if your warehouse holds 3PL stock with non EDI customer or on cutover) - Purchase Order from PO to Goods Receipt#SpreadsheetimporttoaddlinestoaPO
  3. From Sales Based Forecasting Screen - Product Forecasting Based on Sales History
  4. From Daily Purchasing Requirements Screen - Daily Purchase Order
  5. From a Drop Ship Sales Order Line see Drop Shipments - supplier sends direct to customer
  6. From Franchisor Replenishment Dashboard see Retail and Warehouse Stock Replenishment


When a Franchisee creates a Purchase Order to their Franchisor - when the Status moves to "Sent" a mirror Sales Order is created in the Franchisor.

A Franchisor can also create a Sales Order to a Franchisee - and when Authorised a mirror PO will be created in the Franchisee that will be used for receipting the goods

Regardless of how a Sales Order from a Franchisor to a Franchisee is created - when the Sales Order in the Franchisor creates a Debtor invoice - a mirror Creditor invoice linked to the PO in the Franchisee will be immediately created.

Purchase Order lines can also be updated by xls import. 

  • For example if a supplier is sent quantities and changes them to fit into shipping containers
  • Use "Update lines" option when importing
  • When a Dropship Purchase order quantities are updated > the corresponding sales order quantities will also be updated

Items that are only sold as JIT assembly can also be purchased using the JIT SKU.  The stock receipt will list the kit components to be counted.

Add Supplier - some fields will pre-populate

Supplier related limits

The Filter items by supplier flag will make a smaller list when doing item searches

ETA for the lines will only have a value if different to the ETA on the header of the PO. You can update the ETA of a line from the PO screen

Foreign Currency Suppliers

When a supplier that is setup as a FX supplier - then the FX amounts will show

If a FX PO has GST an alert will show

Normally FX PO's should not be subject to GST. 

If you have created one and it is incorrect then

  1. remove the incGST from the supplier company
  2. move the PO back to plan status
  3. Adjust a line qty or price (causes the entire PO to recalculate)
  4. then adjust it back and put the status back.

Checking recent purchase prices across suppliers

When negotiating with suppliers and prices rapidly change it is useful to have a view of recent prices

Note that the values are the last date for any Supplier + Price combination 

Add multiple lines to the Purchase Order

Updating of pricing requires Secure Feature "Can Change Purchase Order Unit Cost"

  • Unit Price is AUD price
  • FC Price is Foreign Currency Price
  • Value = Qty x Unit Price
  • Notes is system generated notes
    • Examples
      • Expected Quarantine Start Date
      • Split - multiple use by
      • Split - part receipt
      • if an intercompany purchase order then notes from the order lines
  • Other Quantities on the order line
    • Shipped - once the supplier notifies you how many they have shipped
    • Received - updated by the counting process as stock receipt
  • Line Status - system generated
    • Counted - once counted
    • Cancelled - using right click menu on the line to cancel the line
    • Closed once PO received
  • ETA is set by the Purchase Order ETA and is used by planning and and sales orders

Spreadsheet import to add lines to a PO

Before importing an XLS spreadsheet > create a PO by choosing a supplier and saving

A two column spreadsheet (SKU, Qty) can be used to quickly add lines to a purchase order - this will use the default buy price on the SKU

A third column can be added (Price) to import the price - note if the supplier is a Foreign Currency Supplier then the price is assumed to be in the Foreign Currency

To import open transactions on mass

  1. Import Headers.  Columns include - PO, Warehouse Code, Forwarder Ref, Supplier Code, Summary, ETA
  2. Import lines across Purchase orders by adding a column to the PO lines spreadsheet of (PO)
  3. SKU's that are in a status of Runout or Inactive will not be imported
  4. By default the SKU import process limits to the items with that supplier nominated as the primary supplier on the SKU - to enable the import process to import any SKU regardless of supplier untick the "Filter items by supplier" on the PO

Can also update lines on the order 

When a purchase order is in Planning or Plan status updates can be made to the quantity and price for a SKU.

Columns required 

  1. SKU, Price, Qty

When there is no default buy price for the item from that supplier

When the supplier is not one of the suppliers listed on the Article with a default buy price then the default buy price for the default supplier will default.

In this example the default supplier has a default buy price of $10 in AUD - the FX supplier we chose did NOT have a default buy price.

If the default supplier is a Foreign Currency Supplier then the default buy price will be in the foreign currency.

A warning will show when no buy price is found for the supplier.

Cancelling lines on a Purchase Order

Right click to cancel a line on the Purchase order > the cancelled line will still be on the purchase order however it will no longer be visible

  • A log entry will be added to the PO log
  • Note - if a complex landed cost exists AND manual costs have been associated to the line THEN the line cannot be cancelled until these have been removed

Re-instating a cancelled line

  1. Use the SKU to recall the line on the PO and press save on the line 
    1. this will change the line status from "Cancelled" to "Plan" and the line will again be visible
  2. Note - Cancelled lines on Drop Ship Purchase orders CANNOT be re-instated due to requirement to re-instate the line on the sales order

Add attachments to the purchase order

Example shipping documents, supplier documents etc - see Useful things to know

Note that international purchase orders have a list of standard documents expected if they have a ship from port and ship to port - see Purchase Reports Dashboard#ManagingShipments-InternationalPurchaseOrders

Add Freight Charges to the Purchase Order

When a purchase order supplier also charges freight - add it to the purchase order.

Freight will be in the same currency as the creditor and FX currency will show adjacent to the field

Add Additional Charges to the Purchase Order

When a supplier charges additional charges there are two possible approaches

  1. Use landed costing to associate the charges to the stock cost > in this case a separate invoice (linked to the PO if you want) will be required
  2. Consider the costs to be expenses and not absorb them in product cost > in this case a SERVICE can be added as a purchase order line at any time up to status "Invoiced"

Send the Purchase Order documents and track correspondence

See Correspondence explained and Email Templates

Status menu > Email this Purchase Order to Supplier

Email Templates will open and allow you to edit the email and view the pdf attachment before you send it. System usage "Manual" and System Context "Purchase Order"

In order to print the Purchase Order when in Plan Status you will need the Secure Feature "Can Authorise Purchase Orders"

If you want to attach a PDF of the purchase order

  • Print Template YOURCOMPANYNAMEPurchaseOrder.mrt will be used - if not found then PurchaseOrder.mrt will be used
  • XLS will also be attached with SKU, Barcode and Carton Barcode to each purchase order sent
  • All emails sent of purchase orders will BCC to the sender

To set up a From email address for purchase orders sent via the 'Email this Purchase Order to supplier' status menu option:

  1. Admin menu, config, Contact/ID Types
  2. System Key, select Purchasing email
  3. Save (F4)

  1. Admin menu, Your Host Company, More tab
  2. Contact Info, Key, select Purchasing email
  3. Enter From email address in Detail
  4. Save Contact

Status Changes to track progress with suppliers

Change the status to keep track of where you are with this PO

  • Planning - internal planning only and still being adjusted
  • Plan - has been planned and is expected quantity
  • Sent - has been sent to supplier
  • Confirmed - quantities have been confirmed by supplier
    • After status confirmed > changes to lines are tracked. 
      • so if the purchase order status is moved back to unconfirmed then plan and lines are added or removed - an audit trail exists
  • Departed Supplier - supplier notifies they have shipped

Confirm Expected Date (and other key dates)

Use the Status Menu to lock the expected date - so you know it has been confirmed.  

It can be unlocked at any time to be updated by using the status menu again - A log entry is written for the lock and the unlock process.

The shipments dashboard will indicate if dates have not been confirmed and are approaching

Users are warned if dates are not in the following sequence

  1. Confirmed date
  2. Production Start Date
  3. Supplier Departure EXW
  4. Port Departure ETD
  5. Port Arrival ETA
  6. Delivery ETA

Purchasing stock requirements for Multiple warehouses (move orders after receipt)

A single purchase order may have requirements for multiple warehouses - this can be managed manually or created via Product Forecasting Based on Sales History

Warehouse to Warehouse Stock Move Orders will be created to manage stock moves.

Review the distribution tab if the stock is being sent to other warehouses when it arrives

If you change the quantity on the purchase order line - the mismatch will show and need updating so all stock has a warehouse it is intended for

Once all the purchase order lines have been counted the system will create the required inter warehouse move orders

International Shipping Tracking and required actions

Where you use a shipping company you can import the details across all your international PO's.   o import from a shipping company the shipping updates the columns required are:

  1. Order, Supplier Invoice, ex Factory date, Load port code, discharge port code, ETD, ETA at port, Est Delivered date,  Arrival Vessel

Shipping is updated on the PO screen

Standard documents are required to be attached to international Purchase Orders - if they are missing they are listed as missing on the Managing Shipments Report

Managing Shipping Containers

On the purchase order you can track the shipping details

Finding Containers using search

Enter a partial match to the container name and click on the binoculars



All matches (and partials) will be listed and double click on the PO you want

Multiple shipping containers

It gets more interesting when the PO is across multiple shipping containers - because normally the local transport wants to drop and pick up in a single journey - so want you to tell them which container to bring first (and they then book the pickup times at the port).  To decide which container to bring first you will want to know which container is carrying which products

  1. The Container # cannot be changed after a line has been Counted (Counted status).
  2. The Container # of a JIT kit cannot be changed after the kit has been exploded (on PO Received). 


Link the PO line to a container

Container #'s can be cleared if required


Split lines across containers

Splitting items between Containers:

  1. If an item is split between containers then there will be 2 lines for the SKU.
    1. The line for the selected container will have the original Ordered quantity and a Shipped quantity of the Keep quantity entered in the Split pop-up.
    2. The other line will have no Ordered quantity and a Shipped quantity of the remainder, i.e. the first lines Ordered quantity minus the first lines Shipped quantity.
  2. JIT Kits can be split across containers

Count receipt by container

The when a container arrives - filter the PO by the container and do the counts.  These will be added to stock and the PO will remain open waiting for the next container

Exploding JIT kits:

  1. Kits are exploded when the PO is marked as Received.
  2. A line will be added for each different component of a kit.
  3. The Ordered quantity of the component will be the Ordered quantity of the kit multiplied by the number of that component in each kit.
  4. If the kit has been split between containers it might not have an Ordered quantity so neither will the component.
  5. The Shipped quantity of the component will be set to the Shipped quantity of the kit, if any, multiplied by the number of that component in each kit.
  6. The component will have a setting of Not Billable.
  7. The component will have a zero price and value.
  8. The kit will have a setting of Exploded.

Landed Costing Estimates

There are two methods you can use for landed cost

  1. Complex Landed Costs - Where landed costs are expected to be invoiced some time after the stock is in store (or sold) use the estimated landed cost capability.  Use this method to allow the stock cost to reflect your expected costs and be updated later when the actuals come in.  See Landed Costing for complete details

  2. Simple Landed Costs - If not using estimates - you can use simple landed costing after the PO has been receipted. see Simple Landed Costing

JIT Kits can use both simple and complex landed cost calculations.

Building a landed cost estimate (complex landed cost required before stock receipt)

  1. Note that the user requires Secure Features Set Requires Landed Cost to set or clear the 'Requires Landed Cost' check box on a purchase order.
  2. Note that a landed cost can be created using the Landed Cost Estimate form (Purchase menu > Complex Landed Cost) and linked to a purchase order and this will set 'Requires Landed Cost' on the purchase order even if the user does not have the secure feature.

 

Enter details into the estimate

Note that multiple charges or actuals can be entered. See Landed Costing for complete details for example using actuals before stock arrives

Can enter foreign currency amounts for both estimates and actuals.  They will resolve to Host Company currency equivalents.

Review the calculations

When ready set it ready to use.

Purchase Order Deposits

Any purchase order may have a deposit recorded.  Use the Payments section to enter how you expect the deposit / final payment to be split.

Any number of deposits may be paid on a single purchase order.  The amount of the deposit is added as a credit to the final invoice amount.

A creditor may have default payment terms

Entering a PO Deposit Payment

FX suppliers will have an FX value and FX rate to enter

Creates a Creditor Prompt Payment (Payment without Invoice)

Balance required to be paid

Foreign Currency Purchase Order Deposit Payments

Note after the first deposit - any number of deposits can be added to the PO and the paid amount will reflect the total value

The deposits paid reduce the final invoice amount to be paid

Payments via a clearing account - eg FX service

Some organisations may a single payment to a FX management company with instructions of payments to make.   

  • Link all the payments to a single Batch and to a clearing account
  • Create a journal from the clearing account to the bank the amount was transferred from

Create a journal batch - and link the deposits to it

Note - in order for the batch to show up on the journal screen - select the journal type

Deposits will be to the clearing account

Create a journal from the clearing account to the bank

Adjust the journal type on the batch so the payment journal can be linked

Then check all the journals you want to link are linked

Close the batch

Batches that remain open will have new journals auto added to them until they are closed

Purchase Reports - Required Payments Tab

Indicates when payments are required for Purchase Orders in the system.

If a PO does not have payment terms then it is assumed that no prepayments will be required.  The invoice will be raised when the PO is received and the terms of the supplier are added to the payment due date.

Purchase Reports - Shipments Tracking Tab

Can see if a purchase order has had a deposit paid - this can be critical to ensure the supplier has started.

Receiving the Purchase order - In Out Dashboard

The In/Out dashboard lists all inbound and outbound stock and is where to find PO's that are expected in a warehouse.  Only items that are expected in the date range are displayed.

Inbound:

  1. Purchase Orders
  2. Franchisor Drop ship Purchase Orders arriving direct at Franchisee
  3. Franchisor Drop Ship via Warehouse Purchase Orders arriving after being checked at the Franchisor Warehouse
  4. Move Orders from other warehouses in the same ABN
  5. Special Orders expected from a Francisor
  6. Fabrications Expected

Outbound

  1. Sales Orders being picked up or sent to customers or Franchisees
  2. Waybills departing on a vehicle
  3. Franchisor Drop Ship via Warehouse Purchase Orders that have been checked
  4. Special Orders ready to ship
  5. Deliveries for Project Orders

There are multiple ways to receive Purchase Orders

Simple Stock Receipt without count

Where the stock does NOT require expiry dates or batches or counting - it can be receipted in a single click

Scan every stock item that has arrived to compare with expected

When stock does NOT require batch or expiry details - can scan all items received and compare with ordered quantity

Count the stock and enter batch and expiry dates

Select a purchase order from the list on the Warehouse in/out Dashboard

If an order has not been marked as received the user will be prompted

The system will prompt if the PO should be marked as Received - note you can review the list of items on the PO before making it as received.

If perishable items are included the temperature of each container can be tracked.

Staging Locations

Each warehouse may have multiple staging locations

Choose the locations you will put the stock after counting and before put away.  Staging locations are temporary locations where stock is check counted before putaway.

If you are not using a staging location - the system will recommend put away based on stock history / available spaces.

The staging locations must be "Floor Area" locations and flagged as "Staging Area Temporary Storage"

Organisations with a coarse warehouse use a system recommendation for put away and avoid staging area requirement.

Count the Stock

  1. Enter the quantity reported by the supplier (found on the shipping documents)
  2. Count the stock - capture useby / batch number / Serial number (if capture is on receipt not on sale)

JIT Kit parents will not be listed on the Stock Receipt form - only the components will be listed

If the PO uses Containers then a choice will be required and will filter the grid and the actions.  When "Process all Counted lines in Plan Status" clears all lines in a container the grid will change to show the next container with lines still in plan status from the PO.


You can be part way through the count - while moving stock that has been counted away.

BUT - Each line must be completely counted before it is stocked.

Lines can be short counted and the system will ask if the line should be split to be counted later or received later

Short dated stock is captured at point of receipt

If expiry dated products are received and the expiry days is less than the minimum required

The date on the stock is compared with:

  • Field on Article (Article form, Extended Attributes, Sell Rate and Forecast, 'Default Expiry Days')
  • if not found then Field on Supplier (Creditor form, Supplier tab, 'Default Use by days')

An email is sent to the Roles with the secure feature Secure Features#ReceiveShortDatedReceiptAlert for this branch on each event of short dated items.

The stock is indicated as a short dated receipt on Short dated stock exception report in the 'Short dated receipt' column at the right of the report. The column will be blank if the stock was not short dated on receipt.

When the supplier sends you more than you have ordered

When the supplier has sent you less than you have ordered (or you need to split the receipt to account for multiple use by dates or container or partial put away)

When the supplier has sent you at item you did not expect

Add the new line to the purchase order

When a JIT Kit is been purchased from a supplier

The kit is never stocked.  Only the components are in stock and kitted together when a kit is sold

The counting screen will shows the kit components - JIT Kits lines are created for the components when the PO is marked as received.

  • A line will be added for each different component of a kit.
  • The Ordered quantity of the component will be the Ordered quantity of the kit multiplied by the number of that component in each kit.
  • If the kit has been split between containers it might not have an Ordered quantity so neither will the component.
  • The Shipped quantity of the component will be set to the Shipped quantity of the kit, if any, multiplied by the number of that component in each kit.
  • The component will have a setting of Not Billable.
  • The component will have a zero price and value.
  • The kit will have a setting of Exploded.

The average cost used is the price of the kit divided by the number of components plus any Landed Costing amounts.  A kit with qty 3 of item A and qty 2 of item B will have average cost of JIT / 5 for each component.

The kit is not counted - it has the count updated by the count of the components on the PO to the minimum number of kits that could be assembled by the count.  Ie if one item is short the kit count will be short.

The counted items are not invoiced - only the kit item is invoiced using the counted qty

Updating Sell prices based on Purchase Prices

Can update the sell price and RRP price on an item from the purchase order

Partially shipped (and invoiced) Purchase Orders

If the supplier has only shipped some items - and has sent an invoice for those items - count only those lines, leave the other lines uncounted.

If the supplier has "Allow Partial PO invoices" then an invoice can be created for lines counted but not invoiced leaving other lines awaiting counting.   

  • Purchase Order > Status > Create Partial Invoice
  • Can create invoice only for lines with an invoice quantity instead of all lines counted > Create a partial invoice, of lines with Inv Qty, in Counted status, but not invoiced

Notes

  1. If a PO line has been invoiced in a partial invoice then 'Invoiced' will show in the Settings column of the PO form Order Lines grid and 'YES' will show in the Invoiced column of the Standard Stock Receipt grid. 
    1. The Invoiced column will not show unless the supplier of the PO has 'Allow PO partial invoice' ticked.
  2. If the PO being partially invoiced has a Delivery charge then 
    1. this will be on the first supplier invoice created.
    2. If the PO being partially invoiced has a Delivery charge then this will be apportioned to the PO lines by value calculated as ordered quantity x price.
    3. If there is less stock than the ordered quantity at the time that the PO line is received then only a proportion of the delivery charge will be allocated to the stock asset account.
    4. The average cost of the article will be recalculated to include the allocated delivery charge.
  3. Status menu option 'Create a partial invoice, of lines with Inv Qty, in Counted status, but not invoiced'.
    1. Similar to 'Create a partial invoice, of lines in Counted status but not invoiced' but it will not invoice using the Counted quantity if no Invoice quantity is entered.
    2. 'Part invoice total' will show in place of 'Invoice total' at top of Ship/Invoice Qty tab.
    3. Shows total of items in Counted status, with an Invoice quantity and not yet invoiced, i.e. the total that would be invoiced by the 'Create a partial invoice, of lines with Inv Qty, in Counted status, but not invoiced' status menu option.

Process All Counted Lines in Plan Status to Create Stock (updates Average cost )

This can be done multiple times for each purchase order as stock is counted.

Stock Received Not invoiced Account

The Stock Receipt Journal will update the "Goods Received not Invoiced" GL Account and the "Stock on Hand" Control Account from from GL Control Accounts 

  1. If an item ordered on a drop-ship via warehouse PO is GST inclusive then the franchisee buy price is the franchisor default sell price minus the tax

When the Creditor invoice is created the journal will update the "Goods Received not invoiced" GL account and the Trade Creditors GL Account from GL Control Accounts 

see Purchase Order Variations for more details

Average Cost

Average cost is updated in the following situations

  1. Stock is created from the purchase order
    1. Average cost = total value of stock / total stock
    2. When stock is added by a PO = New average cost = ( Total Value of stock before + Total Value of stock added ) / Total stock qty after new stock added
    3. Where
      1. Total Value of stock before = Stock on Hand x Average cost
      2. Total Value of stock added = new stock being added x cost of this stock
        1. Stock added by Purchase Order may include - see also Pricing when you sell products
          1. Freight cost on the PO to the same supplier
          2. Finance Uplift Charges if using finance to purchase
          3. Landed costs (see Landed Costing )

Average cost may also be updated manually by a user with Authority directly on the SKU and this will create the required corresponding stock revaluation journals.



When the PO is ready to invoice any discrepancies in counted vs ordered quantity are prompted for action

This will occur in the warehouse if set as the preference to invoice purchase orders based on stock receipt.  Otherwise this will occur when the supplier invoices is raised later.

What do you want to do with the additional items ?

  • An adjustment invoice is a separate invoice (or credit) for the additional items received (see below)
  • A general journal example is shown below

For a user to be able to invoice and close a PO with discrepancies - they will need Secure Features Close Purchase Order With Discrepancy

To receive an email every time a PO has order vs invoice or invoice vs count discrepancies Secure Features # ReceiveP O Invoice Discrepancies

Example of JIT item variance in Goods Received Not Invoiced Account

JIT items are a special case 

  1. stock is created of the components - but that SKU is never invoiced
  2. An invoice is created for the JIT item - but no stock is created
  3. Hence a variance is recorded to account for both these differences (you can find it linked to the PO)

Adjustment Journal to write off excess stock received

Both short deliveries and over deliveries will be journaled

Used if you are not expecting to be charged by your supplier for the additional items counted - the qty counted is receipted at average cost and the additional stock value for the additional items is then removed.

Put the stock away

Stock that is going into the warehouse is then put away from the staging locations 

The stock locations will default for all items that:

  1. Have a default stock location on the article - to the default location
  2. or - have stock in a location at the moment - to the current stock location

Quantities will default to full pallets

  1. If the item does not have a Pallet Capacity then Quantity will default to 0.
  2. if a pallet of the stock is less than the Total Quantity to be moved then Quantity will default to the pallet capacity
    1. A Pallet of the stock = Units Per Layer (Selling/shipping) multiplied by Layers Per Unit

Stock that is expected to go onto a move order can be put away. If your move order is intended to leave immediately it is recommended to pick the move order before putting stock away.

If an item that is being put away could also be put on a Move order (ie it is in plan status and not yet picked) then it will be highlighted and a legend will indicate that the line is in a Move Order. Right click on the highlighted line will list the move orders in a sub menu.

Creating the Creditor Invoice/s

Invoiced Quantities from the supplier need to be entered before the purchase order can be Invoiced or Closed

Invoiced amounts can be entered before or after the stock has been counted and put away

A Received Purchase Order that has not been Invoiced or Closed will be highlighted on the purchase order reports

Multiple invoices on a Purchase Order

can be created per purchase order if the supplier has "Allow PO Partial Invoice" ticked.

Choose "Create partial invoice" and an invoice will be created for only those lines with an invoice quantity that have not already been invoiced.

These purchase orders can end up with many lines and many invoices.  When entering new invoices it is helpful to hide those lines that have (1) already been invoiced and (2) an invoice quantity has been entered (even if not yet invoiced)

No invoiced lines hidden

Invoiced lines hidden

Lines with an invoice quantity hidden

Anytime - can enter the supplier invoice number and supplier invoice date. 

Note that entering the supplier invoice number will cause the purchase reports to show the date the invoice has been received from the supplier

The Supplier Invoice Number and Date PO form Ship/Invoice Qty tab. Both of these fields are saved in the PO when the Save Supplier Invoice button is clicked.

  • If the invoice has not been created 
    • then the Supplier Invoice Ref will be copied to the "Their Invoice No" field of the invoice and the date will be used as the Invoice Date when the invoice is created.
  • If the invoice has already been created 
    • then these fields will be copied to the invoice when the Save Supplier Invoice button is clicked and over-write the existing values.

There is also an Invoice Total field on the  PO form Ship/Invoice Qty tab that shows the PO total value including tax and Delivery.

This field will change when the Delivery, Unit Price or Inv Qty are updated.


Update the Invoiced Quantities from the supplier invoice

This can be done prior to receipt or after receipt of stock

Can enter Supplier invoice number and invoice FX rate to be used (it may be different to PO rate)

If you have the secure feature :Set P O Inv Qty To Counted
  • New Status menu option 'Set Inv Qty to Counted where Counted = Ordered' if:
    • PO is Received, Counted or Closed.
    • At least one PO line is eligible.
    • Option will set Inv Qty to Counted if:
      • Inv Qty has no value.
      • Counted = Ordered.
      • Line is not cancelled

If the Invoiced amount is less than the ordered amount - or you need to split the line for pricing reasons or are partially invoicing the PO can enter a smaller amount for the invoiced quantity.  For example if some stock was at a different price.

If splitting the line

If adding an unexpected item to the PO

Result

Purchase Discount

If a supplier provides a purchase discount you can decide how to account for it.

  1. Entered before the PO has been received will reduce the stock average cost (and hence affect sales order profit etc)
  2. Entered after the PO has been received will be journalled to a Purchase Price variance account (and not affect stock value)

The created journals

Create Creditor Invoice

When finished - Status > Close and invoice.  Any discrepancies will be prompted for action as per above.

If price on the creditor invoice is different to the price on the purchase order and used on the stock receipt journal - see Purchase Order Variations

If supplier has "Allow PO Partial Invoice" ticked then the PO will only become closed and invoiced once all lines have been invoiced.

PO Deposit overpayment:

When creating an invoice for a Purchase Order,

    1. if the total of deposits paid is greater than the total of goods and freight
    2. then add an invoice line to move the excess deposit back to the PO Deposits GL account
    3. and create a credit note for the supplier for the excess amount.


Creditor - view of deposits

  1. Creditor > Supplier Deposits

PO Deposit - convert to a credit note

  1. Creditor Prompt Payment form

    1. if sub type id Order Deposit and deposit is not linked to an invoice:

    2. If deposit is linked to a PO then the link must be cleared before the deposit can be cleared.

    3. If not linked to a PO then show an option to convert the PO deposit to a creditor credit note.

    4. If selected then open a creditor credit note with fields pre-filled.

    5. User must Save.

    6. Deposit will be reversed when credit note is saved.


Creditor Credit Note - ability to convert to a supplier deposit

  1. Creditor Credit Note, Action menu:

    1. If credit note has allocations then show a message to remove the allocations before converting to a PO deposit.

    2. If no allocations then show an option to convert credit note to a PO deposit.

    3. If selected, open a PO deposit form with fields pre-filled.

    4. User must link to a PO and Save.

      1. Order must be a purchase order, not cancelled, closed or invoiced.

    5. Credit note will be reversed when PO deposit is saved.

PO Deposit - convert to a credit note

  1. Creditor Prompt Payment form

    1. if sub type id Order Deposit and deposit is not linked to an invoice:

    2. If deposit is linked to a PO then the link must be cleared before the deposit can be cleared.

    3. If not linked to a PO then show an option to convert the PO deposit to a creditor credit note.

    4. If selected then open a creditor credit note with fields pre-filled.

    5. User must Save.

    6. Deposit will be reversed when credit note is saved.

PO and Sales Order Deposits can be reversed

  1. Allow debtor and creditor prompt payments to be reversed.

    1. Reverse Creates a general journal.

  2. When reversing a foreign currency journal ensure that the foreign currency amount is allocated between the journals

Simple landed costing - after items received into warehouse

Simple landed cost allows the stock to be created using only the PO supplier creditor invoice and then later adding associated charges.

Simple landed cost is not recommended for fast moving stock - see Landed cost options explained

Notes for JIT KITS

Simple Landed Cost tab, Purchase Order Items grid:

  1. Do not allocate costs on a PO with a kit until the PO has been received and the kit has been exploded into its components.
  2. A kit is an article with an Assembly type of JIT and/or the Exploded setting.
    1. PO items with kits will be displayed highlighted green.
    2. The Auto column check box will not be ticked and will be disabled.
    3. The kit will not participate in Auto Allocation.
    4. The Added costs column will be disabled.
  3. A kit component is an item exploded from a kit when the PO is received.
    1. The PO ea of a component is calculated by dividing the unit price of the kit by the number of components in the kit (not the number of different components).

Stock that is to be moved to another warehouse (Move Orders)

This only applies for Warehouses that are part of the same Host Company.  Stock going to a franchisee or different host company are being sold.

Move orders are created for you by the Purchase Order

When the stock is counted into the temporary locations - move orders are created by the system to move the stock to other warehouses based on the purchase order distribution

Enter a planned date

Review the move orders and enter a planned date they are to be sent - they will then show in the shipments expected screens

The planned delivery date will default based on the Interwarehouse Transport settings for standard times to move stock between warehouses.


Enter the delivery method.  The list of delivery methods are

  1. Your company
  2. Any Supplier with Standard Profile value = "Courier" (note turn on this profile on Host Company (your business/s))

Right click from the shipments expected screen to pick the move order

Pick the move order

Right click on a line to be picked to default pick

Right click on a stock location to pick the required full amount from that location

Enter the Consignment Note Number to mark the stock as in transit

Delivery method can be entered as text - or chosen from a list of previously used delivery methods.

Delivery Entity can be your Host Company (your business/s) or any Supplier flagged as "Is Courier" (enable this flag on Host Company)

The stock is no longer in either warehouse - but because you still own the stock - a temporary warehouse will have been created in the Despatching warehouse

Receive the stock when it arrives in the other warehouse

The expected shipments screen will show the move in order in the receiving warehouse

Count the stock and mark any discrepancies created

Then put the stock away (as shown in stock put away above)

Resetting Sell Prices after stock has arrived

It is common that the price stock is sold at is related to it's recent cost.  To make this easier there is a tab on the purchase order for this

Franchisor Setting Sell Price to Franchisees

The average cost is shown - however if a landed cost has not been used to value the stock then a % markup can be used to show what the cost are after a nominal landed cost

Set all the lines as ready to reprice, enter a landed cost markup % then review and adjust line by line

View the margins for the Franchisor and for the Franchisee for each item

Can modify the landed costs for an individual line - view the margins earn't by franchisor

Result

Updating the Sell price (or Markup)

Result


Configurations Required

Min Stock Days of expiry on the Article - used to test if the expiry date entered is as agreed by the supplier as min they will send you

Default use by days on the supplier - if no value on the Article the supplier value for min agreed useby days will be used.  Normally you will set this to the value for the majority of the stock they send you so you only have to over-ride on the Article those that need it.

Working with 3rd Party Warehousing

3rd party warehouses do not normally update the system for you directly.

Receiving Stock into a 3rd Party Warehouse

  • Update the purchase order as counted and stocked as normal

Picking stock from a 3rd party warehouse

Use the 3PL Picking Dashboard to find all orders to pick, select an email template to use, update it and then send an email with all picking slips

The picking slips will be created and then zipped and emailed (note that this may involved multiple emails depending on the volume)

Use the Despatched Orders (3PL) to update the list of orders that were sent once you have been notified the results - this will update the orders and the stock as picked

Settings

To enable the setting "Allow PO Partial Invoice" on the supplier - enable on the host company > Entity and Debtor / Creditor Profiling

Working as a 3rd Party Warehouse

If your warehouse holds other companies stock

  1. Set the average cost, the sell price and buy price to zero
  2. Create Purchase Orders to receipt stock at zero dollars
    1. can import xls sheet on PO screen to create easily
    2. can provide the stock owner a screen to upload directly to your system
  3. receipt and put away same as other stock
    1. Stock will be created at zero dollars and will not affect your balance sheet
    2. Creditor invoice will be created at zero dollars and can be emailed as proof of processing
  4. Create Sales Orders to ship the stock at zero dollars
    1. Can import xls sheet on sales orders screen to create large orders easily
    2. Can import xls sheet on sales orders screen to mass create large number of orders in single process
    3. Can provide the stock owner a screen to upload directly to your system
  5. then pick / pack / ship the stock
    1. Sales Invoice will be created but at zero dollars and can be emailed as proof of processing
    2. If using Marketplace Orders - a tracking number will be added by the scanning process



  • No labels