Date: 2026-03-21 Database Server: localhost:1433 (SQL Server) Primary Database: Stickerei_Mueller_GmbH Secondary Database: Mueller_Verwaltung Analysis Scope: All operational areas of the GSD ERPframe/FIBUframe system
| Field | Value |
|---|---|
| Legal Name | Stickerei Muller GmbH |
| Address | Bergstr. 17, 91456 Diespeck |
| Phone | 091617830 |
| Fax | 0916178366 |
| info@stickerei-mueller.de | |
| VAT ID (EGUStID) | DE304215527 |
| Tax Number | 203/139/40064 |
| Creditor ID (SEPA) | DE62ZZZ00001873960 |
| Home Currency | EUR |
| FiBU Version | 6.3.03 |
\\SERVER-FILE\Buchhaltung\Elster Zertifikat\| Account | Bank | IBAN | BIC | Status |
|---|---|---|---|---|
| 1210 (Primary) | Sparkasse i Landkreis Neustadt a d Aisch | DE47762510200221312044 | BYLADEM1NEA | Active -- last statement 2026-03-18 |
| 1100 | Postbank Nurnberg | DE65760100850083820858 | PBNKDEFF760 | Inactive since 2007 |
\\SERVER-FILE\Allgemeine Ordner\ARTIKELbilder im ERP| Year | Journal Entries | Total Soll/Haben |
|---|---|---|
| 2016 | 290 | EUR 32,230,672 |
| 2017 | 291 | EUR 38,163,386 |
| 2018 | 322 | EUR 33,568,757 |
| 2019 | 306 | EUR 58,995,461 |
| 2020 | 254 | EUR 44,728,560 |
| 2021 | 322 | EUR 54,805,303 |
| 2022 | 302 | EUR 47,858,552 |
| 2023 | 320 | EUR 63,223,551 |
| 2024 | 298 | EUR 55,312,468 |
| 2025 | current | -- |
| 2026 | current | -- |
Current fiscal year is 2025 (set in FiFirmenstamm), with 2026 already created.
Only EUR is configured (WaehrNummer=1). This is a single-currency operation despite international clients.
| Database | Purpose |
|---|---|
| Stickerei_Mueller_GmbH | PRODUCTION -- primary operational database |
| Mueller_Verwaltung | Verwaltungs-GmbH (holding/admin company) |
| MuellerGmbH | Legacy/historical |
| MuellerUebung | Training database (no access) |
| stickerei_dev | Development |
| stickerei_test | Testing |
| Table | Rows | Description |
|---|---|---|
| ActivityLog | 1,516,825 | System activity log |
| _Email_Beleg_adresse | 689,667 | Email sending per document address |
| ArchivBelegzeilen | 353,222 | Archived document line items |
| Lagerbewegungsprotokoll | 191,846 | Stock movement log |
| FiBuchungsArchiv | 170,177 | Archived financial postings |
| Belegreferenz | 163,635 | Document cross-references |
| FiBuchungsID | 154,378 | Financial posting IDs |
| ArchivBelegkopf | 126,311 | Archived document headers |
| BelegKontierung | 91,564 | Document account assignments |
| Preise | 90,656 | Price records |
| FiStapelBuchungen | 88,534 | Batch financial postings |
| LoginJournal | 64,237 | User login history |
| FiOffenePosten | 58,051 | Open financial items |
| _Email_Beleg | 37,539 | Email sending per document |
| Artikel | 29,771 | Articles/items |
| Belegkopf | 907 | Active document headers |
| Kunden | 947 | Customers |
| Lieferanten | 586 | Suppliers |
| Personalstamm | 77 | Employees |
| Users | 36 | System users |
| Table | Rows | Purpose |
|---|---|---|
| _Email_Beleg_adresse | 689,667 | Email tracking per address per document |
| _Email_Beleg | 37,539 | Email tracking per document |
| _Events | 479 | Custom event handlers |
| _Fracht_KdNummer | 168 | Customer freight account numbers |
| _Functions | 13 | Custom calculation functions |
| Row ID | Username | Type | State | Locked | Role/Notes |
|---|---|---|---|---|---|
| 1 | GSDAdmin | 160 | 2 | No | System admin (automated) |
| 2 | Admin | 160 | 1 | No | Administrator |
| 5 | Master | 161 | 1 | No | Template user |
| 7 | Benutzerstandard | 161 | 1 | No | Default user template |
| 9 | Richter | 160 | 1 | Locked | Former employee |
| 10 | Schmidt | 160 | 1 | No | Roland Schmidt |
| 14 | Herrmann | 160 | 1 | No | GSD consultant/admin |
| 16 | hauser | 160 | 1 | Locked | Former |
| 17 | k.knofler | 160 | 1 | No | Karin Knofler (Kalkulation) |
| 19 | s.glass | 160 | 1 | Locked | Former |
| 20 | b.schmid | 160 | 1 | Locked | Birgit Schmid |
| 27 | Verkauf | 161 | 1 | No | Sales template |
| 29 | GSD | 160 | 1 | No | GSD support |
| 31 | rupprecht | 160 | 1 | No | Manuela Rupprecht (Buchhaltung) |
| 39 | glassj | 160 | 1 | No | Johanna Glass-Heinz (GF/CEO) |
| 42 | Wilhelm | 160 | 1 | Locked | Former |
| 45 | FIBUrechte | 161 | 1 | No | FIBU rights template |
| 47 | Perlwitz | 160 | 1 | No | Renate Perlwitz (Buchhaltung) |
| 48 | UPS_Tracker | 160 | 1 | No | UPS integration service |
| 51 | Gerlich | 160 | 1 | Locked | Former |
| 54 | glasst | 160 | 1 | No | Tereza Glass (Buchhaltung) |
| 58 | glassb | 160 | 1 | No | (Glass family member) |
| 60 | Calabrese | 160 | 1 | No | Vanessa Calabrese (IT) |
| 61 | bouabid | 160 | 1 | No | Zied Bouabid (Musterung) |
| 62 | schuhk | 160 | 1 | Locked | Former |
| 64 | galuschge | 160 | 1 | No | Nicole Galuschge (Buchhaltung) |
| 65 | temliakova | 160 | 1 | No | Oksana Temliakova (Kalkulation) |
| 66 | herzog | 160 | 1 | No | Lena Herzog (Produktionsvorbereitung) |
| 67 | focht | 160 | 1 | Locked | Former |
| 68 | Siebenhorn | 160 | 1 | No | Alexandra Siebenhorn (Musterung) |
| 69 | szabo | 160 | 1 | No | Nicole Szabo (Produktion) |
Type 160 = Regular user, Type 161 = Template/role user, State 1 = Active, State 2 = Inactive
| User | Workstation | Application | Last Login |
|---|---|---|---|
| herrmann | SERVER-ERP | GSD ERPframe + SXPframe | 2026-03-21 (today!) |
| glassj | PC-GF1 | GSD ERPframe | 2026-03-20 |
| perlwitz | PC-VERSAND1, PC-BUCHHALTUNG2 | GSD ERPframe | 2026-03-20 |
| bouabid | PC-MUSTERUNG4 | GSD ERPframe | 2026-03-20 |
| siebenhorn | PC-MUSTERUNG2 | GSD ERPframe | 2026-03-20 |
| temliakova | PC-MUSTERUNG3 | GSD ERPframe | 2026-03-20 |
| szabo | PC-PRODUKTION1 | GSD ERPframe | 2026-03-20 |
| glasst | PC-BUCHHALTUNG1 | GSD ERPframe | 2026-03-20 |
| galuschge | PC-BUCHHALTUNG4 | GSD ERPframe + FIBUframe | 2026-03-19 |
| PC Name | Department |
|---|---|
| SERVER-ERP | Server (admin/automated tasks) |
| PC-GF1 | Geschaftsfuhrung (CEO office) |
| PC-BUCHHALTUNG1-4 | Accounting (4 workstations!) |
| PC-MUSTERUNG2-4 | Sample/Pattern department (3 workstations) |
| PC-PRODUKTION1 | Production |
| PC-VERSAND1 | Shipping |
| ID | Code | Name | Level | Inventory | Archive | Follow-up |
|---|---|---|---|---|---|---|
| 1 | BE | Bestellung (Purchase Order) | 0 | Order | Yes | -- |
| 2 | WE | Wareneingang (Goods Receipt) | 3 | Stock+ | Yes | -- |
| 3 | AN | Angebot (Quote) | 1 | -- | Yes | -- |
| 5 | AV | Avis (Advice Note) | 2 | Reserve | Yes | -- |
| 6 | AB | Auftrag (Sales Order) | 2 | Reserve | Yes | LS1 |
| 7 | LS | LS ALT (OLD - do not use!) | 3 | Stock+ | No | -- |
| 8 | AR | Rechnung (Invoice) | 4 | Stock+ | Yes | -- |
| 9 | GS | Gutschrift (Credit Note) | 4 | Stock+ | Yes | -- |
| 10 | KA | Einnahmen (Income) | 0 | -- | Yes | -- |
| 11 | KQ | Ausgaben (Expenses) | 0 | -- | Yes | -- |
| 14 | LS1 | Lieferschein (Delivery Note) | 3 | Stock+ | Yes | AR |
| 15 | MA | Master-Auftrag (Master Order) | 2 | -- | Yes | AB |
| 16 | AG | GarantieRechnung (Warranty Invoice) | 4 | -- | Yes | -- |
| 17 | TD | Transportdokument (Transport Doc) | 3 | Stock+ | Yes | -- |
| 18 | LS-M | Lieferschein Muster (Sample Del. Note) | 3 | -- | Yes | AR |
| 19 | AB-XX | Auftrag Test (Test Order) | 2 | Stock+ | Yes | LS1 |
| 20 | ER | Eingangsrechnung (Incoming Invoice) | 4 | -- | Yes | -- |
MA (Master Order) -> AB (Sales Order) -> LS1 (Delivery Note) -> AR (Invoice)
There is also a BelegartAction linking Invoice (AR, BelegartId=8) to BelegImpExKonfig ID=3 (X-Rechnung Export), meaning invoices trigger electronic invoice export.
| ID | Name | Mode | Path | Foreign System |
|---|---|---|---|---|
| 1 | ZUGFeRD E-Rechnung 2.0 Export | Verkauf | \\server-erp\D\ERechnung\Ausgang |
Yes |
| 2 | ZUGFeRD Import | Einkauf | \\SERVER-ERP\ERechnung\Eingang\ |
Yes |
| 3 | X-Rechnung Export | Verkauf | \\server-erp\D\ERechnung\Ausgang |
Yes |
Key Finding: The company uses both ZUGFeRD 2.0 and X-Rechnung electronic invoicing formats.
| Type | Name | Count | Total Net EUR | Notes |
|---|---|---|---|---|
| LS1 | Lieferschein | 465 | 443,684 | Largest active pool |
| AB | Auftrag | 246 | 508,296 | Active sales orders |
| TD | Transportdokument | 71 | 248 | |
| BE | Bestellung | 46 | 812,553 | Purchase orders |
| AR | Rechnung | 28 | 26,825 | |
| MA | Master-Auftrag | 19 | 137,400 | |
| GS | Gutschrift | 9 | 2,660 | |
| (orphan) | No type | 16 | -- | |
| Other | KQ, KA, WE, LS | 7 | -- | |
| TOTAL | 907 |
| Type | <=30 days | 31-90 days | 91-365 days | >1 year | No date | Oldest |
|---|---|---|---|---|---|---|
| AB (Order) | 48 | 49 | 101 | 48 | 0 | 2022-12-03 |
| LS1 (Del. Note) | 215 | 96 | 52 | 102 | 0 | 2019-01-17 |
| AR (Invoice) | 5 | 10 | 1 | 12 | 0 | 2010-02-04 |
| BE (Purch. Order) | 0 | 0 | 0 | 46 | 0 | 2013-12-16 |
| MA (Master Order) | 8 | 3 | 8 | 0 | 0 | 2025-10-06 |
| TD (Transport) | 51 | 3 | 17 | 0 | 0 | 2025-12-11 |
CRITICAL FINDING: There are 225 documents older than 1 year still in the active table: - 46 purchase orders from 2013-2014 (EUR 812K total!) -- likely forgot to archive - 102 delivery notes from 2019+ that should have been invoiced/archived - 12 invoices from 2010+ still active - 48 orders from 2022 still open
| Customer | Orders | EUR (Net) |
|---|---|---|
| HOLLAND (H&S/LA.I.PE.) | 185 | 254,189 |
| Loewe | 6 | 109,634 |
| HERMES HOLDING | 14 | 71,309 |
| Fashionart | 2 | 69,557 |
| CHANEL | 9 | 62,336 |
| Vuitton (43819) | 17 | 34,097 |
| HERMES (Sister) | 10 | 19,961 |
| Vuitton (43839) | 9 | 10,634 |
| Vuitton (42754) | 9 | 9,359 |
| DIOR | 2 | 2,500 |
| Type | Count | Total Net EUR |
|---|---|---|
| LS1 (Delivery Note) | 44,396 | 46,853,033 |
| AR (Invoice) | 38,562 | 102,096,768 |
| LS (Old Del. Note) | 24,550 | 8,080,589 |
| AB (Sales Order) | 14,444 | 44,050,694 |
| TD (Transport Doc) | 2,116 | 151,719 |
| MA (Master Order) | 1,054 | 7,911,947 |
| GS (Credit Note) | 986 | 2,381,435 |
| AN (Quote) | 144 | 10,557 |
| BE (Purchase Order) | 43 | 757,694 |
| AV (Advice Note) | 8 | 19,280 |
| Year | Invoices | Revenue (EUR) | YoY Change |
|---|---|---|---|
| 2009 | 1,806 | 2,868,976 | -- |
| 2010 | 1,584 | 3,946,111 | +37.5% |
| 2011 | 2,048 | 4,192,288 | +6.2% |
| 2012 | 2,118 | 5,128,725 | +22.3% |
| 2013 | 2,434 | 5,821,617 | +13.5% |
| 2014 | 2,356 | 7,126,553 | +22.4% |
| 2015 | 2,172 | 6,289,217 | -11.8% |
| 2016 | 2,614 | 6,531,117 | +3.8% |
| 2017 | 2,498 | 5,639,953 | -13.6% |
| 2018 | 2,817 | 6,174,751 | +9.5% |
| 2019 | 2,535 | 6,808,667 | +10.3% |
| 2020 | 1,897 | 5,530,490 | -18.8% (COVID) |
| 2021 | 2,394 | 6,362,974 | +15.0% |
| 2022 | 2,208 | 6,263,024 | -1.6% |
| 2023 | 2,542 | 7,305,836 | +16.6% |
| 2024 | 2,145 | 6,743,734 | -7.7% |
| 2025 | 1,954 | 7,510,226 | +11.4% |
| 2026 (YTD) | 439 | 1,852,509 | (Q1 partial) |
Key Finding: The company has grown from ~EUR 3M (2009) to ~EUR 7.5M (2025) annual revenue. Peak year appears to be 2025 at EUR 7.5M. 2026 is tracking at ~EUR 7.4M annualized.
| Month | 2024 Invoices | 2024 EUR | 2025 Invoices | 2025 EUR |
|---|---|---|---|---|
| Jan | 185 | 622,517 | 134 | 482,758 |
| Feb | 141 | 655,459 | 117 | 609,713 |
| Mar | 194 | 552,702 | 197 | 725,619 |
| Apr | 207 | 585,040 | 145 | 682,931 |
| May | 186 | 445,990 | 142 | 1,096,552 |
| Jun | 165 | 457,548 | 137 | 580,117 |
| Jul | 182 | 580,762 | 141 | 475,591 |
| Aug | 175 | 719,614 | 102 | 296,202 |
| Sep | 236 | 627,524 | 201 | 777,947 |
| Oct | 204 | 555,422 | 221 | 629,261 |
| Nov | 129 | 358,123 | 215 | 520,405 |
| Dec | 141 | 583,033 | 202 | 633,130 |
| Rank | Customer | Invoices | Total Revenue (EUR) |
|---|---|---|---|
| 1 | HOLLAND (H&S/LA.I.PE.) | 11,135 | 14,941,960 |
| 2 | HERMES (Sister SRL) | 3,368 | 8,332,888 |
| 3 | DIOR | 1,266 | 5,736,092 |
| 4 | Loewe | 1,959 | 5,677,802 |
| 5 | CHANEL | 1,002 | 5,020,176 |
| 6 | VUITTON (41385) | 1,118 | 2,983,499 |
| 7 | Givenchy | 453 | 2,912,228 |
| 8 | ZAMASPORT | 348 | 2,524,756 |
| 9 | THOMAS | 464 | 2,479,377 |
| 10 | VUITTON (41008) | 329 | 1,847,407 |
Key Finding: Holland & Sherry (via LA.I.PE.) is by far the largest customer at EUR 15M lifetime, followed by luxury houses Hermes, Dior, Loewe, and Chanel. The business is heavily concentrated in luxury fashion embroidery.
| Metric | Value |
|---|---|
| Total Customers | 947 |
| Active (no order block) | 544 |
| No block status set | 390 |
| Blocked (Auftragssperre=1) | 6 |
| Partial block (=2) | 7 |
| Suppliers | 586 |
| Language | Customers | % |
|---|---|---|
| Italian (ITA) | 249 | 26.3% |
| French (FRA) | 233 | 24.6% |
| German (DEU) | 219 | 23.1% |
| Not set | 146 | 15.4% |
| English (ENG) | 100 | 10.6% |
Key Finding: The customer base is primarily Italian and French (luxury fashion houses), with German domestic customers and English-speaking international ones.
| Country | Customers |
|---|---|
| Italien | 110 |
| Frankreich | 63 |
| Deutschland | 49 |
| Grossbritannien | 21 |
| Osterreich | 7 |
| Vereinigte Staaten | 6 |
| Spanien | 5 |
| Belgien | 4 |
| Schweiz | 4 |
| Portugal | 3 |
| Hongkong | 2 |
| Others (1 each) | 8 |
| Payment Term | Customers |
|---|---|
| Not set | 641 |
| Bonifico 60 gg + 10 dffm | 122 |
| 60 Jours date de facturation | 59 |
| Bonifico 30 gg + 10 dffm | 23 |
| 14 Tage netto | 19 |
| Rein netto sofortige Kasse | 18 |
| Sans delai net | 16 |
| net 60 Days after Invoice Date | 11 |
| Immediately net after Receipt | 9 |
| Others | ~25 |
Key Finding: 67% of customers have no payment terms set (defaults apply). Of those set, 60-day terms (Italian/French style) dominate, reflecting the luxury fashion industry norms.
There are 17 separate Vuitton customer records (IDs 572, 590, 844, 1173, 1198, 1205, 1238, 1364, 1426, 1427, 1429, 1432, 1507, 1518, 1550, 1553, 706), representing different Vuitton workshops/locations. Two have special Vuitton customer numbers stored in _VUITTON_KDNR (S008, 2128).
| Metric | Value |
|---|---|
| Total Articles | 29,771 |
| Articles with stitch counts | 1,499 |
| Min stitch count | 250 |
| Max stitch count | 6,018,000 |
| Average stitch count | 47,390 |
| Customer-specific prices | 12 |
| Total price records | 90,656 |
| Group | Articles | % | Description |
|---|---|---|---|
| Muster (Samples) | 24,870 | 83.5% | Sample/pattern articles |
| Automatenstickerei | 1,699 | 5.7% | Machine embroidery |
| Topstick - Leistung | 1,602 | 5.4% | Topstick services |
| Maxi - Leistung | 874 | 2.9% | Maxi machine services |
| Michel & Sohn (Blumen) | 225 | 0.8% | Flower embroidery |
| Maxi - Lieferung | 89 | 0.3% | Maxi deliveries |
| Kleinmaschinenstickerei | 88 | 0.3% | Small machine embroidery |
| Automat. - Lieferung | 65 | 0.2% | Automated deliveries |
| Topstick - Lieferung | 47 | 0.2% | Topstick deliveries |
| S.C. Mueller RO | 43 | 0.1% | Romanian subsidiary |
| Effektenmaterial | 41 | Special effects material | |
| Sonst. Stickmaterial | 32 | Other embroidery material | |
| Packstucke | 29 | Packaging | |
| Nebenarbeiten | 13 | Secondary work | |
| Others | ~50 | Various |
Key Finding: 83.5% of articles are samples/patterns (Muster). The actual production services are split between Automatenstickerei, Topstick, and Maxi machines. The distinction between "Leistung" (service) and "Lieferung" (delivery) articles is critical for pricing.
_Stiche: Stitch count per design (key for production pricing)_S_Rechnung: Invoice reference/calculation number_Kunde: Customer assignment_Farben: Colors_Groessen: Sizes_Standort: Production location_Kalkulation: Calculation method_berechnen: Calculation flag_VK_P_1/2/3: Sales prices for different price levels_VK_M_1/2/3: Sales multipliers_Saison: Season_Muster_kostenlos: Free sample flag_LeadTime: Lead time_Angebotsblatt_gedruckt/bestaetigt: Quote sheet printed/confirmedKey accounts:
| Account | Description |
|---|---|
| 1100 | Postbank Nurnberg |
| 1210 | Sparkasse Neustadt (primary bank) |
| 1400 | Sammelkonto Kunden (AR collective) |
| 1570 | Abziehbare Vorsteuer (input VAT) |
| 1576 | Abziehbare Vorsteuer 19% |
| 1776 | Umsatzsteuer 19% (output VAT) |
| 4970 | Nebenkosten des Geldverkehrs (bank fees) |
| 8300 | Erlose 7% (revenue 7% VAT) |
| 8400 | Erlose 16% (revenue 16% VAT -- historical) |
| 9000 | Saldovortrag Sachkonten (balance carry-forward) |
| 9008 | Saldovortrag Debitoren |
| 9009 | Saldovortrag Kreditoren |
| Key | Type | Rate | Description |
|---|---|---|---|
| M19 | Output | 19% | Standard German VAT |
| M07 | Output | 7% | Reduced VAT |
| M16 | Output | 16% | COVID-reduced VAT (2020 H2) |
| M05 | Output | 5% | COVID-reduced VAT (2020 H2) |
| M00 | Output | 0% | Tax-free domestic |
| MDL | Output | 0% | Tax-free export (third country) |
| MEG | Output | 0% | Tax-free intra-EU services |
| MEL | Output | 0% | Tax-free intra-EU delivery |
| V19 | Input | 19% | Standard input VAT |
| V07 | Input | 7% | Reduced input VAT |
| E19 | Input | 19% | EU acquisition VAT |
| E07 | Input | 7% | EU acquisition VAT (reduced) |
| REV | Input | 19% | Reverse charge EU |
| RED | Input | 19% | Reverse charge third country |
| B19 | Both | 19% | Construction withholding tax |
| KST | Description |
|---|---|
| 6000 | Stickereiproduktion (Embroidery production) |
| 6100 | Holland & Sherry |
| 6200 | Musterung (Sampling) |
| 6220 | Stickprogramme (Embroidery programs) |
| 6250 | Fremdleistung (External services) |
| 6300 | Material und Handel (Materials & trade) |
| 6500 | Grossautomaten (Large machines) |
| 6900 | Verwaltung (Administration) |
| 6920 | Werbekosten Personal |
| 6930 | Objekt Berlin |
| 6950 | Umlage Heizkosten (Heating allocation) |
| 6960 | Umlage Telefon (Phone allocation) |
| 6980 | Umlage Strom (Electricity allocation) |
| KTR | Description |
|---|---|
| 62501 | LV Taschen (Louis Vuitton bags) |
| 63001 | Stickmaterial (Embroidery material) |
| 63002 | Effektmaterial (Effects material) |
| 63003 | Stoffe (Fabrics) |
| 63004 | sonstiges Material (Other material) |
| 63005 | Hilfsstoffe (Auxiliary materials) |
| Category | Items | Total EUR |
|---|---|---|
| Debitoren (AR) | 52,754 | 165,350,729 |
| Kreditoren (AP) | 5,277 | 45,799,304 |
| Sachkonten | 20 | 301,513 |
| TOTAL | 58,051 | 211,451,547 |
Top 10 Debtor Accounts by Open Balance:
| Account | Open Balance EUR | Items |
|---|---|---|
| 46675 (HOLLAND) | 20,196,286 | 7,224 |
| 43761 (HERMES) | 14,244,585 | 3,466 |
| 42869 (Loewe) | 12,078,097 | 2,394 |
| 44856 (CHANEL) | 5,461,228 | 867 |
| 42522 | 4,952,125 | 430 |
| 43010 | 3,795,330 | 514 |
| 41008 (VUITTON) | 3,608,132 | 478 |
| 41385 (VUITTON) | 3,410,106 | 1,301 |
| 45220 | 3,119,331 | 195 |
| 43189 | 3,064,956 | 287 |
WARNING: The open items total (EUR 165M debtors) is vastly larger than annual revenue (~EUR 7.5M). This strongly suggests that open items are not being cleared/matched properly -- likely many historical items that were paid but never matched in FiBU. This is a major data quality issue.
Multilingual payment terms in German, French, Italian, and English. Key types: - Immediate/cash: "Rein netto sofortige Kasse", "Sans delai net" - Short term: 8-14 days net - Standard: 30 days net - Extended: 60 days net, 60 gg + 10 dffm (Italian bonifico terms) - With discount: 2-4% discount for 8-10 day payment - Prepayment: "Vorauskasse", "Vorkasse 2% Skonto" - Direct debit: "Lastschrifteinzug"
| ID | Description | Active | Schedule | Last Run |
|---|---|---|---|---|
| 1 | Vuitton Auftrage schreiben (CSV) | No | Weekly | 2025-05-03 |
| 2 | Vuitton Ruckmeldungen schreiben | No | Daily | 2025-10-17 |
| 3 | Vuitton Ruckmeldungen schreiben - neu | Yes | Weekly | 2026-03-21 |
| 4 | UPS TrackingNummern auslesen + LS_ohne_UPS_Versenden | Yes | Weekly | 2026-03-21 |
Key Finding: Only 2 active scheduled jobs: 1. Vuitton feedback writing -- automated reporting to Louis Vuitton 2. UPS tracking number extraction + delivery note emailing -- automated shipping workflow
Named functions including custom calculation logic (Benutzerstandard, TEST, Herrmann, gsdtest, etc.). These contain custom Harbour/xBase code for: - Price calculations based on stitch counts - Bill of materials cost calculations - Stock management logic
The 10 active events include:
- Custom pricing calculations (_KALK_STICKPROGRAMME)
- Bill of materials (Stuckliste) element list processing
- Account assignment validation
- Document restore/copy logic
- Stock booking logic
Large number of macros, many are system-standard. Key custom ones include:
- _VUITTON_CSV_SCHREIBEN -- Write Vuitton orders as CSV
- _Vuitton_Rueckmeldungen_schreiben -- Write Vuitton feedback
- _VUITTON_RUECKMELDUNGEN_SCHREIBEN_NEU -- Updated Vuitton feedback (active)
- _TRACKINGNUMMER_AUSLESEN -- Read UPS tracking numbers (active)
All are demo/standard EDI converters: 1. VDA 4908 export demo 2. DB-to-XML export demo 3. VDA 4905 import demo 4. XML transformation for document data
The system tracks email sending extensively through custom tables:
- _Email_Beleg: 37,539 records (email per document)
- _Email_Beleg_adresse: 689,667 records (email per recipient per document)
- Recent activity shows emails being sent with statuses: oka (sent OK), okm (sent manual), N (new/pending)
- Last email activity: 2026-03-20
Key Finding: DOCUframe appears to be used primarily for email delivery tracking, not as a full DMS. The SXPframe application (seen in login logs as "GSD SXPframe") runs automated tasks on SERVER-ERP.
| ID | Method |
|---|---|
| 1 | UPS-Standard (ST) |
| 2 | UPS-Express (ES) |
| 3 | Fedex |
| 4 | DHL |
| 5 | TNT |
| 6 | Beipack (included) |
| 7 | Paketgebuhren (package fees) |
| 8 | UPS Worldwide Saver (SV) |
| 9 | Spediteur (freight forwarder) |
| 10 | durch Boten (by courier) |
| 11 | Brief (letter) |
| 12 | Selbstabholung (self pickup) |
| 13 | TRANSPORT |
| 14 | DHL-Domestic Express (DOM) |
| 21 | DHL-Express Worldwide (EU) |
| 23 | DHL-Express Worldwide (DOC) |
| 25 | DHL-Express 9:00 (TDK) |
| 26 | DHL-Express Worldwide (NONDOC) |
| 27 | DHL-Economy Select EU (ESU) |
| 28 | DHL-Economy Select (NON-DOC) |
| ID | Carrier |
|---|---|
| 1 | UPS Standard |
| 6 | DHL_Parcel_DE |
| 8 | DHL Express (since 6.11.2025) |
168 customer freight account records in _Fracht_KdNummer, mapping customers to carrier accounts:
- Example: Customer 10006 has UPS account TT8611 (Saver), TT8612 (Standard), and DHL account 58555
Extensive UPS integration via custom fields:
- _UPS_VERS_UPSNR -- Sender UPS number
- _UPS_AG_UPSNR -- Client UPS number
- _UPS_AG_NAME -- Client name
- _UPS_EMPF_NAME -- Recipient name
- _UPS_VERS_ZAHLT / _UPS_AG_ZAHLT / _UPS_EM_ZAHLT -- Who pays
- _UPS_Tracking_Nbr -- Tracking number
- _UPS_Samstag -- Saturday delivery
- _UPS_ProForma_Invoice -- Pro forma invoice
- _UPS_ENV -- UPS envelope
- _UPS_KD_Be -- Customer reference
| Department | Count | Key Staff |
|---|---|---|
| Sticksaal (Embroidery hall) | 10 | Kalisharo, Keskin-Orhun, Khlus, Noss, Ostapschenko, Qalisharo, Ramminger-Mertel, Sokolova, Celtikoglu, Hariuc, Zdrinca S. |
| Buchhaltung (Accounting) | 4 | Rupprecht, Perlwitz, Glass T., Galuschge |
| Musterung (Sampling) | 2 | Bouabid, (shared with Endkontrolle) |
| Kalkulation (Costing) | 2 | Knofler, Temliakova |
| Puncherei (Punching/Digitizing) | 4 | Magyari-Szabo, Zemsch, Beer, Rabenstein |
| Produktion | 2 | Wehr, Szabo N. |
| Endkontrolle (QC) | 2 | Arkadieva, Coley |
| Holland & Sherry | 2 | Denisenko, Knauer |
| Verwaltung (Admin) | 3 | Kessler Y., Lindner, Kleefisch |
| Produktionsvorbereitung | 1 | Herzog |
| IT | 1 | Calabrese |
| Cutter/Laser | 1 | Dziuba |
| Garnlager (Thread warehouse) | 1 | Ebert |
| Ausbrennerei | 2 | Marcu, Zdrinca M. |
| Handarbeit/Musterung | 1 | Vietrova |
| Adlersticker | 1 | Ludwig |
| Not assigned | ~38 | Various |
Stickerei Muller Verwaltungs GmbH & Co. KG -- This is the holding/administrative company (Komplementar-GmbH), a separate legal entity with: - Tax number: 252/167/48507 - VAT ID: DE133952006 - Same address: Bergstr. 17, 91456 Diespeck
| Table | Mueller_Verwaltung | Stickerei_Mueller_GmbH |
|---|---|---|
| FiBuchungsArchiv | 216,750 | 170,177 |
| ArchivBelegzeilen | 146,794 | 353,222 |
| ArchivBelegkopf | 43,909 | 126,311 |
| Artikel | 14,441 | 29,771 |
| Kunden | 748 | 947 |
| FiOffenePosten | 15,724 | 58,051 |
| FiSachkonten | 600 | 631 |
| Personalstamm | 17 | 77 |
| Users | 19 | 36 |
Key Finding: Mueller_Verwaltung has MORE financial postings (216K vs 170K) but fewer documents and customers. This suggests it handles inter-company financial transactions, property management, or payroll -- while the GmbH handles operational business.
| Metric | Stickerei_Mueller_GmbH | Mueller_Verwaltung | MuellerUebung |
|---|---|---|---|
| Kunden | 947 | 748 | No access |
| Artikel | 29,771 | 14,441 | No access |
| Belegkopf | 907 | 745 | No access |
| ArchivBelegkopf | 126,311 | 43,909 | No access |
| Users | 36 | 19 | No access |
The MuellerUebung (training) database was not accessible with the provided credentials.
The following custom tables exist with significant data:
- _Email_Beleg_adresse (689,667 rows) -- email tracking
- _Email_Beleg (37,539 rows) -- email tracking
- _Fracht_KdNummer (168 rows) -- freight customer numbers
Language-aware (4 languages: DEU, FRA, ITA, ENG)
Order Management (Belegkopf + Belegzeilen)
Status tracking, printing status
Article/Item Lookup (Artikel)
Price list lookups (6 VK price numbers)
Shipping/Tracking (Packstuecke, UPS fields)
Payment matching
Invoice Revenue Reporting
| Rank | Table | Purpose | Rows |
|---|---|---|---|
| 1 | Belegkopf | Active document headers | 907 |
| 2 | Belegzeilen | Active document lines | 1,796 |
| 3 | Kunden | Customer master | 947 |
| 4 | KundenAdresse | Customer addresses | ~1,000 |
| 5 | Artikel | Article master | 29,771 |
| 6 | Preise | Price records | 90,656 |
| 7 | ArchivBelegkopf | Archived documents (history) | 126,311 |
| 8 | ArchivBelegzeilen | Archived doc lines | 353,222 |
| 9 | FiOffenePosten | Open financial items | 58,051 |
| 10 | Packstuecke | Package tracking | 18,151 |
| 11 | _Email_Beleg_adresse | Email tracking | 689,667 |
| 12 | Personalstamm | Employee data | 77 |
Vuitton CSV Order Integration -- Automated writing of Vuitton orders to CSV files (currently via _VUITTON_CSV_SCHREIBEN macro). The API should provide a structured Vuitton order export endpoint.
Vuitton Feedback Reporting -- Automated generation of feedback/status reports for Louis Vuitton (_VUITTON_RUECKMELDUNGEN_SCHREIBEN_NEU). Runs weekly.
UPS Tracking Number Extraction -- Automated reading of UPS tracking numbers and sending delivery note emails (_TRACKINGNUMMER_AUSLESEN). Runs after each business day.
Email Dispatch for Documents -- Automated sending of delivery notes and invoices via email, tracked in _Email_Beleg / _Email_Beleg_adresse.
E-Invoice Generation -- ZUGFeRD 2.0 and X-Rechnung export for invoices (BelegartAction links AR to X-Rechnung config).
Custom Pricing Calculations -- Stitch-count-based pricing through custom events and functions (_KALK_STICKPROGRAMME), with location-based multipliers (Musterung 2x, Verdopplung 1.5x, Diespeck 0.5x, Ausland 0.4x).
Order Status Dashboard -- Expose the 907 active documents with customer names, ages, and values. Flag the 225 documents older than 1 year that may need cleanup.
Customer Revenue Lookup -- Enable natural-language queries like "How much did Hermes order last year?" using ArchivBelegkopf aggregations.
Sample/Pattern Search -- With 24,870 sample articles, an AI-powered search by customer, stitch count range, color, or season would be immediately useful.
Delivery Note to Invoice Flow -- The 465 active delivery notes waiting to become invoices represent the immediate revenue pipeline. An API endpoint to list "ready to invoice" items would accelerate billing.
Open Items Cleanup -- The EUR 165M in open debtor items (vs EUR 7.5M annual revenue) indicates 20+ years of unmatched items. An AI tool to suggest matching/clearing would be transformational for the accounting team.
Automated Vuitton Reporting -- Replace the weekly batch macro with a real-time API that Vuitton (or other customers) can query directly.
Package Tracking Integration -- The 18,151 packages with UPS/DHL tracking could feed a customer-facing tracking portal.
Multi-Language Document Generation -- Payment terms and customer communications already exist in 4 languages. The API should serve language-appropriate content based on customer Sprache setting.
Report generated 2026-03-21 by automated analysis of GSD ERPframe SQL Server database.