...

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 setup

Supplier must be ticked as "Distributor"

Image Added

Make the Deal Active when Ready to use

Image Added

Purchase Deal Use - stock arrives

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

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)

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

Image Added

Create pick

This creates a return to supplier sales order to be picked

Image Added

Complete pick

The pick is done using normal warehouse pick screen

Cogs uses current average cost

Image Added

Create Credit Note and adjust average cost

Order will move to Invoiced status

Average cost will be updated as follows

1. Value to be removed = Value on sales order - value of COGS
2. Spread difference over remaining stock

Image Added