admin/tradon
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
1,271 Commits 2 Branches 1 Tag
main
Commit Graph

28 Commits

Author SHA1 Message Date
laurentbarontini
52459a267b Pricing manual 2026-06-11 10:49:05 +02:00
laurentbarontini
a98415fe62 Purchase tree 2026-06-04 18:45:09 +02:00
AzureAD\SylvainDUVERNAY
4c08b95b3b Import Price Bug Fix 2026-06-03 10:05:36 +02:00
laurentbarontini
c95b273291 Badge 2026-06-02 19:38:14 +02:00
laurentbarontini
83f7e43a6e Bug fee cog 2026-05-29 08:07:09 +02:00
laurentbarontini
a9b048d4cf Auto-calculation: formulas recalculate on cell change 
- Template: calcMode=auto, calcOnSave=1
- VBA: removed xlCalculationManual, added ForceRefresh macro
  (clears cache + Application.Calculate for manual DB refresh)
- Workflow: change Setup!B6:B9 -> formulas recalculate automatically

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-05-29 07:36:06 +02:00
laurentbarontini
7da99b3bf7 Live UDF formulas in template, remove gApiEnabled guard 
- GL_Accounts_Client_Template.xlsx: C6:C13 now have real formulas
  =GetAccountAmount(Setup!$B$6,...) instead of text placeholders
- GLAccountsExcelApi.bas: removed gApiEnabled flag entirely, UDFs
  call RunQuery directly; add SetManualCalculation helper macro
- Works in Excel safe mode + manual calc: F9 triggers DB queries

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-05-29 01:25:15 +02:00
laurentbarontini
242406588c Excel desktop POC: direct SQL via VBA, safe mode launcher 
- GLAccountsExcelApi.bas: RefreshGLApi reads Setup!B6:B9 directly,
  calls PostgreSQL via ADODB without sheet.Evaluate or live UDF formulas
- Connection string pointed to vps107.geneva.hosting / postgres
- GL_Accounts_Client_Template.xlsx: fixed formula text cell refs (B6 not B7)
- Ouvrir_Excel_SafeMode.bat: launches Excel /safe with template to bypass
  print spooler freeze (splwow64 deadlock on edit mode entry)

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-05-29 01:13:04 +02:00
laurentbarontini
0fffb341fe Go to matching 2026-05-26 18:54:07 +02:00
laurentbarontini
f0ed5b9bd3 GR 2026-05-24 18:19:57 +02:00
laurentbarontini
1075f49bd1 GR 2026-05-24 18:13:34 +02:00
laurentbarontini
1efaad8c38 GR 2026-05-24 18:05:31 +02:00
laurentbarontini
4b9621a5f0 Notes 2026-05-21 14:20:51 +02:00
laurentbarontini
3a1b9f2d90 Invoice template 2026-05-20 09:52:27 +02:00
laurentbarontini
c27c915700 notes 2026-05-06 15:15:52 +02:00
laurentbarontini
bfa874da43 Accounting notes 2026-05-05 20:14:42 +02:00
laurentbarontini
0f218374a7 Fee adj when th qt change 2026-05-01 15:12:22 +02:00
laurentbarontini
e03dee7def Th qt modification 2026-05-01 09:16:07 +02:00
laurentbarontini
83aa474073 rules 2026-04-30 15:38:27 +02:00
laurentbarontini
75bd34b673 Bug fee financing interest 2026-04-30 13:51:54 +02:00
laurentbarontini
adac3ca630 Rules 2026-04-29 21:54:36 +02:00
laurentbarontini
30d4362c09 Check From To + pricing component domain filter 2026-04-28 19:23:42 +02:00
laurentbarontini
308252215f padding doc 2026-04-26 19:19:41 +02:00
laurentbarontini
fbfa73110f padding acc 2026-04-26 14:35:07 +02:00
laurentbarontini
8906f00d36 Notes 2026-04-10 14:40:06 +02:00
laurentbarontini
b68f475e22 Pricing manual 2026-04-10 07:52:59 +02:00
laurentbarontini
90eab73430 price component 2026-04-09 22:46:32 +02:00
laurentbarontini
5ae8af84fb Add note for bot 2026-04-08 17:15:11 +02:00