Inventory Adjustment Issue

Our fiscal YE is end of Feb, so inventory adjustments are being made. On the 28th, inventory counts on one item (as an example but this isn't a one-off) were at 27, it was counted at 22, and on the 29th when the manager went to put in the adjustment, the count was now -47 and they had to add 69 items to make the count valid. And, on the quantity report and in the item's record, the count now says 22, but when you drill in to the item's transaction detail, the on-hand quantity is 89. 

Has anyone else come across this, and is it Leap-Year madness?

Parents
  • 0

    Hi  , 

    Thank you for bringing up your concern regarding inventory adjustments as you approach your fiscal year-end. 

    Based on the details you've shared, it seems there could be a discrepancy caused by the timing of inventory adjustments and the reflection of these adjustments in the reports. While the article content provided below doesn't directly address the specific issue of discrepancies in reported quantities after adjustments, there are a few steps you can take to ensure accuracy in your inventory reporting:

    1. Review the Inventory Adjustment Process: Ensure that each adjustment entry is correctly posted by following the standard procedure. This includes selecting the Inventory & Services module, adjusting inventory with accurate quantities, and posting adjustments properly.

    2. Verify Adjustments with Reports: Utilize the Inventory Adjustment Details Report and the Inventory Transaction Report to review the changes in quantity and value of items adjusted. This can help identify any discrepancies or errors in the adjustment entries.

    3. Reverse Incorrect Adjustments: If you find an incorrect adjustment entry, you can reverse it by posting another inventory adjustment with opposite values and quantities. This will negate the effect of the original incorrect adjustment.

    4. Inventory Quantity and Value Consistency: If encountering errors related to inventory quantity and value discrepancies, ensure to adjust the inventory to correct quantities at the relevant locations as indicated in the articles.

    Regarding your specific situation with varying counts and the reference to "Leap-Year madness," it's unlikely related to leap year adjustments but rather a discrepancy in how adjustments are recorded or reflected in reports. It's essential to closely monitor the timing of adjustments and their reflection in your system.

    If these steps do not resolve the issue or if you need more detailed guidance, I recommend reaching out to Sage Support for personalized assistance. They can provide more in-depth troubleshooting based on your specific setup and data.

    In the meantime, here are the links to the articles that might help you with the process:

    We hope this helps address your concern, and please do not hesitate to reach out for further assistance.

    Warm Regards,
    Erzsi

Reply
  • 0

    Hi  , 

    Thank you for bringing up your concern regarding inventory adjustments as you approach your fiscal year-end. 

    Based on the details you've shared, it seems there could be a discrepancy caused by the timing of inventory adjustments and the reflection of these adjustments in the reports. While the article content provided below doesn't directly address the specific issue of discrepancies in reported quantities after adjustments, there are a few steps you can take to ensure accuracy in your inventory reporting:

    1. Review the Inventory Adjustment Process: Ensure that each adjustment entry is correctly posted by following the standard procedure. This includes selecting the Inventory & Services module, adjusting inventory with accurate quantities, and posting adjustments properly.

    2. Verify Adjustments with Reports: Utilize the Inventory Adjustment Details Report and the Inventory Transaction Report to review the changes in quantity and value of items adjusted. This can help identify any discrepancies or errors in the adjustment entries.

    3. Reverse Incorrect Adjustments: If you find an incorrect adjustment entry, you can reverse it by posting another inventory adjustment with opposite values and quantities. This will negate the effect of the original incorrect adjustment.

    4. Inventory Quantity and Value Consistency: If encountering errors related to inventory quantity and value discrepancies, ensure to adjust the inventory to correct quantities at the relevant locations as indicated in the articles.

    Regarding your specific situation with varying counts and the reference to "Leap-Year madness," it's unlikely related to leap year adjustments but rather a discrepancy in how adjustments are recorded or reflected in reports. It's essential to closely monitor the timing of adjustments and their reflection in your system.

    If these steps do not resolve the issue or if you need more detailed guidance, I recommend reaching out to Sage Support for personalized assistance. They can provide more in-depth troubleshooting based on your specific setup and data.

    In the meantime, here are the links to the articles that might help you with the process:

    We hope this helps address your concern, and please do not hesitate to reach out for further assistance.

    Warm Regards,
    Erzsi

Children
No Data