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