...

Here is a PO with all of the above issues.

Stock count differences

Image RemovedImage Added

Price Differences

Image RemovedImage Added

After all changes - user will be prompted - what to do when counted different to invoiced

Image RemovedImage Added

Price Variance Journals will be created the Creditor Invoice is created

Uses the Purchase Price Variance GL Control Account

Image RemovedImage Added

Can view all that has happened on the Purchase Order

Image RemovedImage Added

All linked Journals can be found from the Purchase Order

Image RemovedImage Added

An example of the Journals created by discrepancies

Image RemovedImage Added

FX Purchase Orders and Goods Received Not Invoiced Account Balance from rounding

...

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.

Image RemovedImage Added