Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)
Suggested answer

Transaction Entry: Variance vs. Adjustment

(0) ShareShare
ReportReport
Posted on by

Hi,

Somewhat new to GP.  Can someone help me understand the true intended use of "Variance" vs. "Adjustment"?  Is an "adjustment" strictly for "0" Dollar transactions and Variance for "$" transactions?.....when used within Inventory?   

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Transaction Entry: Variance vs. Adjustment

    Hello rincontom 

    You are welcome to Dynamics GP Community,

    I would say simply that they are two document types associated with somehow several business processes to ensure that each process have its own document type and sequence number as well.

    Variance Transaction

    For the variance transactions, they are mostly attached with the inventory stock count, which occurs on a frequent bases to track the physical quantities versus the system quantities and record the variance (either negative or positive) and correct the quantity balances accordingly.

    For this transaction, specific accounts should be picked such as "stock count variances", if you check the item card > Accounts. You will find an account for variances. This is used to link the items with the proper "variances" account so that journal entry is automatically generated when a stock count is run.

    Adjustment Transaction

    A different document type, which is used for different purpose, such as items issued for hospitality, damaged, spoiled ...etc. In this essence, an adjustment transaction is recorded to keep track of this process. The accounts used for this type of the inventory transactions are practically the "Inventory account " and the "Inventory offset" account, which can be found on the item maintenance card > accounts.

    Now technically speaking, they are different document types used for different processes. Although, I know several clients using the document type "Adjustment" to record all inventory variances and other inventory related decreases or increases which are not a result of purchasing or sales. So it is after all how you design the system process to reflect your business needs and ensure proper book keeping

    Please never hesitate to share any further inquiries,

  • Suggested answer
    soma Profile Picture
    24,410 on at
    RE: Transaction Entry: Variance vs. Adjustment

    Please have a look on the below GP abbreviation for Document Type Variance vs Adjustment.

    Document Type

    Specify whether the transaction is an adjustment or variance. Select Adjustment to record an increase or decrease to inventory quantities because an item has been received or sold. Select Variance to record an increase or decrease to inventory quantities based upon a physical count of the items on hand.

    Be sure to select the correct document type. If you select the wrong one, you'll need to delete the transaction with the wrong type and start over. A variance transaction records an increase or decrease, but is based upon discrepancies between a physical count and the system record. Because adjustments are based on receivings or allocations, entering a variance as an adjustment would distort reports of quantities received and allocated. Similarly, entering an adjustment would distort reports of quantity discrepancies. These discrepancies would appear on the Transaction Posting Journal, Reprint Transaction Posting Journal and Purchase Receipts Report.

    Hope this helps!!!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans