Dynamics365 WikiTroubleshootingAbnormal large amount posted in Report as Finished
Dynamics365 WikiTroubleshootingAbnormal large amount posted in Report as Finished

Symptoms:

Abnormal large amount posted due to entering scanned bar code as Quantity

Pasted image 20231030100557.png
Pasted image 20231030100625.png

Migration:

Inventory Side

  • Warehouse management parameters >>> General >>> mobile device >>> Scanned Quantity Limit.

  • Update InventTrans with the right values.  Both Quantity and CostAmountPhysical.

  • Write it into an X++ job for moving to Production

  • Run a Consistency check for On-Hand for the items
    This should update InventSum based on our changes

Financial Side

  • Need to post General Journals to correct these amounts.
  • Or update Amount fields of GeneralJournalAccountEntry and GeneralJournalAccountEntry
  • since large number might cause journal imbalanced like the following
    Pasted image 20240109152541.png
  • Run Consistency check >>> Ledger Transaction >>> Fix
    Pasted image 20240109152701.png
  • Financial Dimension Sets >>> Rebuild Balance

Leave a Reply

Your email address will not be published. Required fields are marked *