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 :
Small and medium business | Business Central, N...
Suggested answer

Prepmt. including tax

(0) ShareShare
ReportReport
Posted on by 152

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

I have the same question (0)
  • Cynthia Priebe, MCT, MCP Profile Picture
    201 on at
    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.

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

    Thanks.

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

  • Cynthia Priebe, MCT, MCP Profile Picture
    201 on at
    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.

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

    Yes. Atleast yo confirmed my issue to be real.

    Thanks

    Sam

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,214

#2
Sumit Singh Profile Picture

Sumit Singh 2,145

#3
YUN ZHU Profile Picture

YUN ZHU 1,887 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans