Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Prepmt. including tax

Posted on by 150

Hi,

Currently our transactions are setup to post as follows

When posting a purchase invoice for an inventory item

  Inventory Accrual 1000

  Inventory Interim -1000

  COG 1000

  COG -1000

  Inventory 1000

  AP -1000

When posting a purchase invoice for an inventory item using a Prepayment Purchase Order

      Prepaid 1000

      A/P -1000

When posting a purchase invoice for an inventory item using a Prepayment Purchase order AND checking the box that says "Prepmnt. Inc Tax" the entries are weird (one real example)

    COG 3138.61

     AP -2773.15

     Taxes 470.01

     Rounding fees 125.11

     Prepaid - 835.47

     Prepaid -125.11

We have to make a journal entry to remove the amount from rounding fees and also there shouldn't be a remaining balance in COG, it should be in inventory until we sell it like the other purchase transaction except for the amount that is prepaid.

Any help in figuring out was is going on here or where to look for a setting that is causing this would be appreciated.

Sam

  • Suggested answer
    swenger Profile Picture
    swenger 150 on at
    RE: Prepmt. including tax

    Yes. Atleast yo confirmed my issue to be real.

    Thanks

    Sam

  • RE: Prepmt. including tax

    Unfortunately, I do not. A quick check doesn't find anything in BCIdeas. You may want to add your request to fix this here.

    https://experience.dynamics.com/ideas/search-ideas/?forum=e288ef32-82ed-e611-8101-5065f38b21f1&q=purchase%20prepayment&page=2

    I hope, even though not what you were hoping to learn, my response has answered your question.

  • swenger Profile Picture
    swenger 150 on at
    RE: Prepmt. including tax

    Thanks.

    Do you know if MS has plans to deal with this issue in a future release.

  • RE: Prepmt. including tax

    If this is a 100% pre-payment and you were referring to North American tax, you may be running into what Microsoft has warned about in learn.Microsoft prepayments instructions.

    Note: We recommend that you do not use a prepayment percentage of 100 in the following cases:

    If you are located in North America. Due to how taxes are calculated, a prepayment percentage of 100 can lead to issues with prepayment invoices.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans