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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Accounts not hit post ...
Microsoft Dynamics AX (Archived)

Accounts not hit post invoice booking.

(0) ShareShare
ReportReport
Posted on by Krishnaji Shukla 150

Hi All,

Two invoices were booked against a particular purchase order in microsoft dynamics ax 2012.

However, after booking the invoices 'the purchase,inventory receipt account'  and the 'purchse expenditure for prodcut account' associated with the Item group of the Items in the purchase order did not reflect the appropriate financial details (debit and credit).

The 'post physical inventory checkbox' and the 'post financial inventory checkbox' have been selected for the Item model group to which the items in the purchase order belong.

So, what could be the reason for the above mentioned problem? Finally, one of my associates suggested that at the backend in AX 2012 there is a table which also includes 'post physical inventory checkbox', however we are not sure which table to look into.

Please help me find a resolution.

Thanks

Krishnaji Shukla

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounts not hit post invoice booking.

    Hi Krishnaji Shukla,

    Can you share the voucher that you identified (incl. the posting types used for each line)?

    What do you mean exactly by saying that the purchase order did not reflect the appropriate financial details?

    Would be great if you could clarify.

    Many thanks and best regards,

    Ludwig

  • Daxer Persson Profile Picture
    Daxer Persson 3,005 on at
    RE: Accounts not hit post invoice booking.

    Which item type do you use (item/service)?

    Is stocked set to Yes on the Item model Group?

    Do you get inventory transactions for your item?

    NB: For physical receipts check also AP-parameter for posting of product receipts allowed for purchase orders.

  • Krishnaji Shukla Profile Picture
    Krishnaji Shukla 150 on at
    RE: Accounts not hit post invoice booking.

    Hi Ludwig,

    Following are the account names (in German language) and the type in the voucher.

    Nicht genehmigte Leistungen/RG:Ledger journal

    Verb. LuL nicht genehmigte Rechnungen: Vendor balance

    Umsatzsteuer aus EG-Erwerb:Tax

    Abziehbare Vorsteuer aus innergem. Erwerb:Tax

    Einkauf von Waren EU:Purchase expenditure for product

    Umsatzsteuer aus EG-Erwerb:Tax

    Abziehbare Vorsteuer aus innergem. Erwerb:Tax

    Verbindlichkeiten aus Lieferungen und Leistungen: Vendor balance

    Nicht genehmigte Leistungen/RG:Vendor incoming

    Verb. LuL nicht genehmigte Rechnungen: Vendor incoming

    Umsatzsteuer aus EG-Erwerb:Tax

    Abziehbare Vorsteuer aus innergem. Erwerb:Tax

    And answering your question after booking of invoices the  'the purchase,inventory receipt account' should be debited and the  'purchse expenditure for prodcut account' should be credited, however this is not happening.

    Thanks

    Krishnaji Shukla

  • Krishnaji Shukla Profile Picture
    Krishnaji Shukla 150 on at
    RE: Accounts not hit post invoice booking.

    Hello,

    Which item type do you use (item/service)? Item

    Is stocked set to Yes on the Item model Group? Yes

    Do you get inventory transactions for your item? Not Sure

    Thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounts not hit post invoice booking.

    Hi Krishnaji Shukla,

    The account 'Nicht genehmigte Leistungen' indicates that a kind of service is used in the posting process.

    Yet, you write that the item used is a stocked item.

    Do you have the ledger integation activate in the item model group?

    Can you share a screenprint of your item model group and also of the voucher that is generated?

    (The German language is not the issue but the way how you listed the transactions above, which is difficult for me to follow up).

    Many thanks and best regards,

    Ludwig

  • Krishnaji Shukla Profile Picture
    Krishnaji Shukla 150 on at
    RE: Accounts not hit post invoice booking.

    Thanks for the reply. Not sure if I am allowed to share images you requires, is there no other way that you could help me out.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounts not hit post invoice booking.

    Hi Krihsnaji Shukla,

    No issue. If you can't attach a screenprint than let's try to clarify it without them.

    What I still cannot understand is what you mean by saying ... did not reflect the appropriate financial details

    Can you elaborate on this especially how you found out that there is something wrong with the financial details, what report or inquiry form you used, etc.

    Best regards,

    Ludwig

  • Krishnaji Shukla Profile Picture
    Krishnaji Shukla 150 on at
    RE: Accounts not hit post invoice booking.

    Actually I handle the issues raised by our clients for whom we have installed AX. Now, one of our clients raised an issue stating that she booked two invoices against a particular PO, according to her when she booked these invoices the system should have automatically created a booking against balance sheet inventory account 1100 (number mentioned by her) and another account 5200 (number mentioned by her) should have been credited.

    All the items in the PO that she is talking about have the same Item Model and Item Model group. When I went into the details of the Item model I found that 1100 is a main account with account type: Purchase Expenditure uninvoiced and 5200 is a main account with account type: Purchase expenditure for product.

    The PO has a mixture of following Items: Exchange PBA (probably a mother board), mobile phones and tablets.

    This is all the information that I have and I am not sure how to proceed further to address the issue.

    Thanks

    Krishnaji Shukla

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Accounts not hit post invoice booking.

    Hi Krihsnaji Shukla,

    I think you need more information and need to have a look at the packing slip and invoice voucher. The packing slip transactions will be reversed when posting the invoice and you need to check all vouchers together.

    Another thing that you can check is whether the item model group has the stocked parameter active. If it does not, then costs are expensed, as you described.

    Best regards,

    Ludwig

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans