Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Financial inventory &a...
Finance | Project Operations, Human Resources, ...
Suggested answer

Financial inventory & Physical inventory

(1) ShareShare
ReportReport
Posted on by anika.afi 45

Hi dear,

I want to ask your opinion in such case:

there is a tracking dimension group (Batch & SN are active) that is used for big amount of items (in the production environment). The issue is there are Physical and Financial inventories are disabled.

And now it is necessary to turn them on (it will be done through modification).

As I understood right no restrictions from the physical inventory side couldn't be.

But what about Financial inventory? Cost value will be recalculated after warehouse recalculation. Will it be a good decision? I feel that there can be some issues later with cost calculation (I'm not strong at this)

I will listen to all your ideas and assumptions (ax 2009)

Thanks in advance,

Anika

  • Dolores Young Profile Picture
    Dolores Young on at
    RE: Financial inventory & Physical inventory

    Hello Anika,

    The best way to do this would be to count out all stock of the items whose tracking dimension group you want to change, then run an inventory close. Change the tracking dimension group and bring in the stock with correct costs.

    It is a big job!

    Regards

    Dolores

  • anika.afi Profile Picture
    anika.afi 45 on at
    RE: Financial inventory & Physical inventory

    Hi Ludwig,

    I can't check it (don't have access), but suppose that more than 100kk.

    Thanks,

    Anika

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Financial inventory & Physical inventory

    Hello anika.afi,

    If you use those items in productions then I would expect that you have at a minimum physical inventory transactions recorded in the inventtrans table.

    Can you double check and confirm that?

    Best regards,

    Ludwig

  • anika.afi Profile Picture
    anika.afi 45 on at
    RE: Financial inventory & Physical inventory

    Hello Osman,

    Thanks for your reply. It's helpful.

    Kind regards,

    Anika

  • anika.afi Profile Picture
    anika.afi 45 on at
    RE: Financial inventory & Physical inventory

    Hello Ludwig,

    1) The items are semi-finished goods & finished goods.

    2) The customer wants to count adjustments for each serial number. AND they want to have a better and more clear situation about physical on-hand.

    And also the issue is that customer has more than 2000 production orders every day.

  • Suggested answer
    OsmanIstanbul Profile Picture
    OsmanIstanbul 2,803 on at
    RE: Financial inventory & Physical inventory

    Hi Anika,

    At one of my clients, I marked financial inventory for the warehouse dimension after some transactions posted, (by a job) and it caused some problems such as negative cost per warehouse. So, I do not suggest marking it for items that have open transactions.

    If you are able, you can create new products and transfer your on-hand inventory to your new products with a new setup.

    Best Regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Financial inventory & Physical inventory

    Hello Anika,

    What kind of items do you have? Are these all kind of dummy or service items?

    Why is it that you want to start calculating phys.&financial values for those items?

    Best regards,

    Ludwig

  • anika.afi Profile Picture
    anika.afi 45 on at
    RE: Financial inventory & Physical inventory

    Hi Dolores,

    Item model group: FIFO.

  • Dolores Young Profile Picture
    Dolores Young on at
    RE: Financial inventory & Physical inventory

    Hello Anika,

    What is the costing model you are using (e,g FIFO, weighted average)

    Thanks

    Dolores

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans