Wednesday, January 24, 2018

Dynamics NAV - Amount needs to be rounded in G/L Entry

C12 - ApplyCustLedgEntry
Run Cust. Ledger Entry Table
Check Flowfields Original Amount, and Remaining amount and round what is feeding them

Check Detailed Cust_ Ledg_ Entry and round the Amount fields
---------------------------------------------------
  update [Cronus$Detailed Cust_ Ledg_ Entry]
  set [Amount]=Round([Amount],2),[Amount (LCY)]=Round([Amount (LCY)],2),
  [Debit Amount (LCY)] = Round([Debit Amount (LCY)],2),  [Credit Amount (LCY)] = Round([Credit Amount (LCY)],2),
  [Debit Amount] = Round([Debit Amount],2),  [Credit Amount] = Round([Credit Amount],2)

  where [Entry No_] >= '996000'


---------------------------------------------

Do this for all unposted entries.
Check the Detailed Customer Ledg. Entries for the entry number

----------------------------------------------
For fixed assets, check the FA Ledger Entry acquisition amounts
----------------------------------------------
update [SUPERPHARMTT$FA Ledger Entry] set [Amount]=Round([Amount],2), [Debit Amount] = Round([Debit Amount],2),  [Credit Amount] = Round([Credit Amount],2) where [FA No_] ='FFF120'

No comments:

Post a Comment