mibuso.com
Home› NAV/Navision Classic Client

Adjust Exchanges Rates Batch Job - NAV 4.0 SP3

fgudeljfgudelj Member Posts: 29
edited 2010-03-23 in NAV/Navision Classic Client
Hi.

We have problem with Adjust Exchanges Rates Batch job in NAV 4.0 SP3 in Croatia.
When running batch job, near finishing "Bank Account ..." part of job (near 100%) we get error message: "Gen. Posting Type must not be in Gen. Journal Line Journal Template Name='', Journal Batch Name='', Line No. = '0'.

We tried to trace in codeunits, and in setup's to find why this job won't go through.


Job parameters that I entered are:
Currncy Tab:
Field code: AUD|EUR|USD|CHF

Options Tab:
Starting date: 01.01.09
Ending date: 31.12.09
Posting date: 31.12.09
Adjust Customer, Vendor and Bank Accounts ... YES


Also when i tried to run this batch job for only one currency (EUR) I get same error, but this time it comes to 100% of Customer.


Please HELP!!

Regards,

Filip
Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/

Comments

  • SunsetSunset Member Posts: 201
    Not sure, but off the top of my head, I would guess that your gains/loss accounts have been set to either purchase or sale. Then when NAV tries to post the currency exchange the posting routine returns the error as there isn't purchase sale on the line being posted.

    The error that you are getting is because NAV has made an automatic journal line, and is trying to post it. But as there is an error (not correct info on the line) NAV reports which line there is an error on.
    Don't just take my word for it, test it yourself
  • fgudeljfgudelj Member Posts: 29
    edited 2010-03-23
    Sunset,

    our Gain account has no posting setup on it - it's blank. I've attached screenshot of account posting setup.
    But Loss account has posting setup on it, but only on fields: General Prod. Posting Group and VAT Prod. Posting Group. - is this maybe cousing problems in posting???
    Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/
  • jannestigjannestig Member Posts: 1,000
    Have a look at your currency setup table, you have up to 8 accounts that it could be refering too.
  • ssinglassingla Member Posts: 2,973
    fgudelj wrote:
    Sunset,

    our Gain account has no posting setup on it - it's blank. I've attached screenshot of account posting setup.
    But Loss account has posting setup on it, but only on fields: General Prod. Posting Group and VAT Prod. Posting Group. - is this maybe cousing problems in posting???

    Exactly.. Remove them and try to run the batch job...
    CA Sandeep Singla
    http://ssdynamics.co.in
  • fgudeljfgudelj Member Posts: 29
    ssingla that did it. Thanks.
    Filip Gudelj | Dynamics NAV Consultant | http://bsinsight.wordpress.com/
Sign In or Register to comment.