web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cost not capture at th...
Microsoft Dynamics AX (Archived)

Cost not capture at the time of Sales invoice

(0) ShareShare
ReportReport
Posted on by imran ul haq 4,017

Hi All

I invoiced the sales order, and when i see the voucher there is no COGS account entry. This item is the stocked item and produce from the production order. I checked the production orders and there is the cost for each production order. Then i checked the packing slip journals there is the voucher for the transactions. Also i checked the Inventory transaction form and checked the transactions (packing slips) involved with this sales order invoice, there is the physical cost but no financial cost. Financial cost should be there after invoicing.

And when i generate the sales analysis report, it is showing 100% contribution ratio as the cost is zero.

What can be the reason for not capturing the cost, and how i can fix this issue.

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Satya Kejriwal Profile Picture
    Satya Kejriwal 210 User Group Leader on at

    Hi Imran

    Please check the item model group if that Tim if the financial is ticked or not.

    Second possibility is the on-hand average of the item can be zero or negative at the time of sale. In that scenario also we faced the same issue.

    Please let me know if it helps.

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Thanks Satya for your reply,

    Financial posting is checked mark, and for the negative or zero inventory, we are completing the production order and at the same time we are creating the packing slip.

  • Satya Kejriwal Profile Picture
    Satya Kejriwal 210 User Group Leader on at

    What is the valuation method for the item you are invoicing?

    I would again encourage you to check on hand average of that transaction. You can check it now from the inventory transaction of that txn.

    If possible analyze the transactions of that item to check other transaction before and after this txn. Are other txns also having no cogs?

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    I am using FIFO valuation method, just now a thought came into my mind and for the testing i recalculate the inventory and then generate the sales analysis report and now i can see the cost their and in the inventory transaction form under the adjustment column i can see the amount, but still i am not getting why the cost is not captured at the time of sales invoice.

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,802 on at

    Dear Imran,

    If you have receipt inventory with cost either from purchase or production system will post cogs during sales invoice. Also make sure your posting profile is adequate. And item model group setup is as per your requirement.

  • Suggested answer
    Satya Kejriwal Profile Picture
    Satya Kejriwal 210 User Group Leader on at

    Hi Imran,

    I am again saying the same thing. There is high possibility that when you invoiced this sales order, there were not enough financial updated purchases. And after sales order invoicing, some purchase orders are also invoiced (financially updated). As a result, now when you are running the recalculation, all the issues (sales/transfers) will be valued at FIFO basis.

    To avoid this in future, there is one more option. On inventory model group, there is a check box 'include physical value' at the bottom of the form. You can check that so that every time you issue(sell), inspite of having no financial updated receipts, it considers the physical receipt values.

    I hope it will clarify. So, you should really analyse invent trans w.r.t. invent date, physical date and financial date.

  • imran ul haq Profile Picture
    imran ul haq 4,017 on at

    Hi Satya, i checked the inventory model group, the check box is marked in the  'include physical value'  and also for the sales i am using the production order and invoicing only when the production order get end, so the cost is there before invoicing. For now the problem is solved later i will check on this in detail.

    thanks for your Support Satya, and Prashant

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans