Tuesday, 5 June 2018

Revalue vs Non Revalue Items

When an item is not set to be revalued the following happens.

Scenario A with Non Revalued Item:


  • Item Purchased and Received into stock at $500.
  • Some of the item is subsequently sold
  • Item is Invoiced through purchasing at different unit cost say $550.

End Result for Scenario A of Non Revalued Item:

  • GL Updated with Inventory value of $500 from the Purchase Receipt
  • GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
  • Sub-ledger reflects the purchase receipt cost i.e. $500.
  • Invoice difference is reflected in the purchase price variance account. This does not affect inventory sub-ledger as the cost remains the receipted cost and the inventory account matches this value in the sub-ledger as the difference is posted to the purchase price variance account instead of inventory.
  • In the end the sub-ledger and GL balances but at the Receipt Cost.



When an item is set to be revalued the following happens.

Scenario B with Revalued Item

  • Item Purchase and Received into stock at $500
  • Some of the item is subsequently sold
  • Item is Invoiced through purchasing at different unit cost say $550.
End Result for Scenario B with Revalued Item

  • GL Updated with Inventory value of $500 from the Purchase Receipt
  • GL reduced with the Inventory and Cost of sale based on the purchase receipt i.e. $500.
  • Sub-ledger reflects the purchase receipt cost i.e. $500.
  • Purchase Invoice difference Debits the Inventory sub-ledger for the $50 as well as the GL (instead of the purchase price variance account used in Scenario A). 
  • The system automatically creates a journal to update the cost of sale and inventory where sales transactions were posted from this receipt layer. 
  • In the end the sub-ledger and the GL balances but at the Invoice Cost.

In the end it is all dependent on what you want to see in your General Ledger. 

And no - Revalue Inventory does not result in your sub ledger to general ledger being out of balanced.

Note the snip below is for the Revalued Item at 600 and not 500 as listed in the example scenario above.


Monday, 4 June 2018

Management Reporter Error - Change Tracking not enabled for tables GL00100, GL00102, etc

So you are deploying Management Reporter Data mart and get the change tracking error.

Now this would result in you having to set each table noted to have change tracking enabled.

Instead of doing this you can -
Go straight to GP,
Admin -> Setup-> Company-> Company, click the Options button, turn off Enable GL Reporting and Turn it back on. This will reset the change tracking and you can proceed.

Some tables your error would note:
GL00100
GL00102
GL00200
GL00201
GL10000
GL10001
GL10100
GL10101
GL12000
GL12001
GL20000
GL30000
GL32000
GL40000
GL40200
MC00200
MC40000
MC40600
SY00300
SY40100
SY40101