GL Inconsistency error in Transfer Order

Mally
Mally Member Posts: 128
edited 2012-10-27 in NAV/Navision Classic Client
I m using NAV 2009 R2 IN version, when I m posting (Ship) Transfer Order of more than 150 lines without any structure I m getting GL inconsistensy error.I have used tips and tricks I found differenece of only 0.01 amount. Please let me know how can I solve this problem of difference amount 0.01

Comments

  • raveendran.s
    raveendran.s Member Posts: 119
    Might be a amount rounding Issue. Try to play with that...
    --
    Regards,
    Raveendran.BS
  • Mally
    Mally Member Posts: 128
    What I should do in that Transfer Order?
  • Savatage
    Savatage Member Posts: 7,142
    does one of the lines have a value with many decimal points?
    example
    1.36475
    1.3648 (we round the above # down & try, if it doesn't work we round another decimal point off)
    1.365 (& so on)
    1.37 (& so on)
    1.4 keep cutting & rounding it down until it posts.

    (When we see that error (very rare) that's what we do.)
    for us it's not worth spending all day on a tenth of a cent.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Mally
    Mally Member Posts: 128
    Dear Cocnern,
    Thanxs for ur prompt response.When I m posting transfer order with adjust cost batch job then it is successfully posted after posting TO, when I run adjust cost batch job it is throwing me same error(GL inconsistency).

    Another thing as u told me to decrease decimal places. I have too many lines with 5 decimal places how I'll know that in which line I'll decrease decimal places.
  • vishalkumarjain
    vishalkumarjain Member Posts: 8
    edited 2012-10-27
    any reply for above situation because we also faced the same condition with one of our client

    the situation was :

    Transfer Order made for Item ABC with 36 Qty and internally system picked these qty (for transfer purpose) from diff. Item Ledger entry e.g. when Transfer Order shipped :

    Inventory Reduced (Main Store) : ABC -36 Pcs @ Value 277.55 (Cost per Unit taken by system is 7.70972)

    Inventory Added (In-Transit) : ABC +8 Pcs Value 61.32 (Cost Per Unit taken by system is 7.665)
    ABC +3 Pcs Value 22.99 (Cost Per Unit taken by system is 7.66333)
    ABC +25 Pcs Value 193.23 (Cost Per Unit taken by system is 7.7292)

    Now, in above condition, you can see that actually system picked three diff. ILE entries to transfer the required qty but only single ILE generated for outbound entry purpose.
  • vishalkumarjain
    vishalkumarjain Member Posts: 8
    This issue posted as a new case...

Categories