Skip to main content
Microsoft Dynamics NAV forum
Answered

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

editSubscribe (0) ShareShare
ReportReport
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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Demystifying Copilot with Sundar Raghavan

Sundar explains how Copilot for Service is meant to function separately...

Business Process Guidance Badges and New…

The Microsoft Success by Design is the framework for implementing Dynamics 365…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,244 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,919 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans