Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Error in posting Purchase Journal - "Amount must be negative..."

Posted on by 25

Hi there,

Im trying to upload an invoice with multiple distributions through the Purchase Journal, but i keep getting this error below even though my amount is already negative in the GL account.

I managed to solved some issues from an earlier thread (subj "Purchase Journal - GL Distributions") but i cannot seemed to get past this error and i cannot figure out what i did wrong.

This is what im currently trying to upload,

pastedimage1590911792853v1.png

pastedimage1590911823209v2.png

pastedimage1590907960716v1.png

Im not sure if im doing anything right in the first place, but basically, i have a bunch of handphone bills that i am trying to upload via the purchase journal instead of creating the invoices one by one in the system as i find it highly inefficient doing the latter.

Im a relatively new user to this system so id appreciate any thoughts and suggestions, thank you!

  • Gulshan Shubham Profile Picture
    Gulshan Shubham 2,200 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Hi Basitah,

    You managed it quite wisely. As long as the Dr. and Cr. side is matched, nothing is messed.

  • Basitah Profile Picture
    Basitah 25 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Thanks, Gulshan.

    I couldnt managed to fix the VAT at the vendor card, so i ended up splitting the tax line entirely on its own and it seemed to post well. Hopefully i didnt mess up the anything at the back end though.

    pastedimage1591956312154v1.png

  • Suggested answer
    Gulshan Shubham Profile Picture
    Gulshan Shubham 2,200 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Hi.

    Yes. Now you just have to create the missing VAT posting setup for the combination being highlighted in the error message.

  • Basitah Profile Picture
    Basitah 25 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Thanks Gulshan. I would guessed it worked because now it's showing me a different error about the VAT Posting Setup, but i would assumed this is at my vendor Setup?

    pastedimage1591099095849v1.png

  • Verified answer
    Gulshan Shubham Profile Picture
    Gulshan Shubham 2,200 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Here, you are creating a Purchase Invoice. Hence, the Vendor Account must be credited i.e. the amount in last line must be negative. So, in the last line put the same amount as it is now buy with a negative sign and in all the other lines make the amount positive. 

    Then, try to preview post or post. Let me know if it resolves the issue.

  • Basitah Profile Picture
    Basitah 25 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    Thanks, Gulshan. I tried, but now it gave me this error,

    pastedimage1590982153054v1.png

    This is currently how my batch is currently set up,

    pastedimage1590982261667v2.png

  • Suggested answer
    Gulshan Shubham Profile Picture
    Gulshan Shubham 2,200 on at
    RE: Error in posting Purchase Journal - "Amount must be negative..."

    In the last line select general posting type as Purchase. Currently it's showing blank.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans