Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

Help to change account of ADJUST COST batch job!!!!!!!!!!

rated by 0 users
This post has 2 Replies | 3 Followers

Not Ranked
Posts 9
Points 195
adept_kz Posted: 08-20-2008 13:36

Hi all!

Please help me to solve the problem. Navision uses "Inventory Adjustment Account" field (table 252 - General Posting Setup) during posting inventory adjustments (positive and negative). I want to change this, I need that program must use another field in different table.

 In cu5802 (Inventory Posting To G/L) I found this.

SetAccNo(VAR GenJnlLine : Record "Gen. Journal Line";InvtPostBuf : Record "Invt. Posting Buffer")

WITH InvtPostBuf DO BEGIN

  IF UseInvtPostSetup(InvtPostBuf) THEN

    InvtPostSetup.GET("Posting Group 1","Posting Group 2")

  ELSE

    GenPostingSetup.GET("Posting Group 1","Posting Group 2");

  ..... .....

"Account Type"::"Inventory Adjmt.":

  BEGIN

    GenPostingSetup.TESTFIELD("Inventory Adjmt. Account");

    GenJnlLine."Account No." := GenPostingSetup."Inventory Adjmt. Account";

  END;

..... .....

but simple replacement of the value doesn't work.

 

  • | Post Points: 35
Top 500 Contributor
Posts 32
Points 835
To be honest it sounds like quite an invasive modification. I would maybe look at creating a journal to move values from one account to another as opposed to hacking the Navision costing model.
  • | Post Points: 5
Top 10 Contributor
Male
Posts 5,414
Points 67,853
DynamicsNAVMVP
Moderator
SystemAdministrator

Forst explain why you need to do this? It apears that you would have accounts out of balance if you did this, and maybe you just have the posting groups setup wrongly.

The only time I have ever had to change the accounts like you are suggestion was prior to version 3.00, when inventory posting group setup did not exist, and I had clients that needed the functionality that is now available as standard in NAV. 

David Singleton - MVP Dynamics NAV Dynamics NAV Consultant since 1991 Available for Navision Go-Live assistance
Dynamics Book
  • | Post Points: 5
Page 1 of 1 (3 items) | RSS


Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.