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

(0) Share

Report

Posted on by Basitah

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,

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!

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Gulshan Shubham 2,210 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Basitah 36 on at

Like (0)

Report

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

This is currently how my batch is currently set up,

Was this reply helpful? Yes No
Verified answer

Gulshan Shubham 2,210 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Basitah 36 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Gulshan Shubham 2,210 on at

Like (0)

Report

Hi.

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

Was this reply helpful? Yes No
Basitah 36 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Gulshan Shubham 2,210 on at

Like (1)

Report

Hi Basitah,

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

Was this reply helpful? Yes No