Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. The Price each in the FX currency is converted to a price ea in AUD - this involves rounding to two decimal places
  2. The stock is received using the rounded AUD value each x qty 
  3. The invoice line is calculated using the total FX amount (FX each x qty) and then converting this to AUD and then rounding it
  4. So because the calculations are different a variance in AUD may exist
    1. Example
      1. Qty 2080
      2. price ea 5.84 in British Pounds, FX rate of 0.55 AUD to GBP - results in AUD $10.62 each
      3. Stock receipt journal creates value in Goods receipt not invoiced GL account using AUD$10.62 each x 2080 = $22,089.60
      4. 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
      5. 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
      6. For many lines this can build up to a more significant value.

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 

  1. Set up a deal with the quantity, date range, supplier prices
  2. Receipt of product will create a PO on the fly as the product is counted in the warehouse

Purchase Deal

Supplier must be ticked as "Distributor"

Image Added

Make the Deal Active when Ready to use

Image Added

Just In Time (JIT) Receipt of Product in the warehouse > create the PO

Image Added

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.

Image Added

Counting of items is all using scanning

Image Added

Once lines are scanned then process counted lines in plan status (like other purchase order receipt processes)