ZUGSEIL Wiki - User contributions [en]

RHB:Gleitender Durchschnitt

2024-11-11T12:07:40Z

Christianrekittke: /* Task List */

{{WBSElement|WBSNumber=ZS-PC-0018}}

[[File:RhB Prozess 3.png|thumb|RhB Prozess 3 - Anpassung FI Schnittstelle]]
[[File:RhB Prozess 6.png|thumb|RhB Prozess 6 - Anpassung FI Schnittstelle]]
=== Projektziele ===

==== 1) Es ist pro Kunde einstellbar, wie der Warenwert berechnet wird: ====
* GLD (Gleitender Durchschnitt, Gewichtete Durchschnittsmethode)
* Effektiver Einkaufspreis
* Verkaufspreis mit Preislistenauswahl

==== 2) Anpassungen der FI Schnittstelle: ====
* Prozess 3, Materialentnahme von Lager: Beim Warenausgang muss der Gleitende Durchschnitt an die Kostenstelle des Mitarbeiters über die SST 7 gesendet werden.
* Prozess 6, Lagerwertänderung: Bei der Inventur und dem Ad-Hoc Wareneingang müssen die Artikel mit dem gleitenden Durchschnitt über die SST 7 an SAP übermittelt werden.

==== 3) Inventur-App ====

* Neuer Bereich zur Ansicht und Modifikation des GLD.

* Neuer Report: Für die Eruierung der Wertberichtigung soll ein Report erstellt werden, welcher die Artikel am Lager mit Umschlagshäufigkeit darstellt, sodass bei «Ladenhütern» eine Wertberichtigung in SAP vorgenommen werden kann. Auf Basis des Reports erfolgt die Buchung auf dem Wertberichtigungskonto in SAP '''manuell'''.

==== 4) Anpassung Warenausgangsreport ====

* Erweiterung des Reports mit dem gleitenden Durchschnitt, zusätzlich zum aktuellen Default-Einkaufspreis (zwei neue Spalten GLD und GLD Währung).

Zugehörige Tasks beim Kunden: [https://rhaetischebahn.atlassian.net/browse/BZ-122 BZ-122] und [https://rhaetischebahn.atlassian.net/browse/BZ-123 BZ-123]

=== Deadlines===

*Tests ab Mitte Oktober

==Main building blocks==

===FI Settings Admin App===

* Design Moqups (MH) > [[App:FI Hub core administration]]
**Simple setting for GLD and eventually price list for sales pricelist based valuation
*Feedback-Session (RS with SS und SL)
*Develop (MH & SL)

=== FI interface changes ===
ToDos:

* Change existing FI interfaces to transmit the GLD.

===Stock Intake Business Logic Service===
One background service, which performs stock intake as {{Yellow-Tag|Text=SOS-RPC}} call. It offers methods for various stock intake scenarios.

ToDos

*Design and document methods and background service (SS)
* Implement
**Implement the Stocktake Business Logic Service (Chris)
**Find and replace stock intake methods with SOS-RPC calls.
*Develop (SL)

===Report: GLD Umschlagshäufigkeits-Auswertung für Abschreibungen===
One report from Inventory, which helps the user for depreciation calculation, so that they can manually change the values. Is added to the [[App:Stocktaking]] app - see [[Dev:Stocktaking - Price entry screen|price entry screen]]

ToDos:

*add the download excel button to the screen
*Develop (SL)

=== Outgoing Goods Report ===
ToDos:

* Add GLD and GLD currency columns.

==Project plan==
{| class="wikitable"
!
!W-40
30.-04.10.
!W-41
07.-11.10.
!W-42
14.-18.10
!W-43
20.-24.10
!W-44
28.10-01.11
!W-45
04.-08.11.
!W-46
11.-15.11.
!W-47
18.-22.11.
!W-48
25.-29.11.
!W-49
2.-6.12.
|-
|Preparations
| colspan="2" |Preparation, Mockups, Process Definitions, ...
|
|
|
|
|
|
|
|
|-
|[[App:FI Hub core administration]]
|
|
|
|
|
| style="text-align:center; background-color:#555555" |DEV
| colspan="2" style="text-align:center; background-color:#555555" |QA
| rowspan="6" style="text-align:center; background-color:#FFCCCB" |Acceptance Tests
| rowspan="6" |Buffer
|-
|Change: FI Hub interfaces
|
|
|
|
|
| colspan="2" style="text-align:center; background-color:#8ACC5B" |DEV
| style="text-align:center; background-color:#FFFFE0" |QA
|-
|Neuberechnung GLD bei Wareneingang
|
|
|
|
| colspan="2" style="text-align:center; background-color:#8ACC5B" |DEV
| colspan="2" style="text-align:center; background-color:#FFFFE0" |QA
|-
|Inventory App "Moving Average" page
|
|
|
|
|
| colspan="2" style="text-align:center; background-color:#8ACC5B" |DEV
| style="text-align:center; background-color:#FFFFE0" |QA
|-
|New: Inventory App Report
|
|
|
|
|
| colspan="2" style="text-align:center; background-color:#8ACC5B" |DEV
| style="text-align:center; background-color:#FFFFE0" |QA
|-
|Change: Outgoing goods report
|
|
|
|
|
| style="text-align:center; background-color:#8ACC5B" |DEV
| colspan="2" style="text-align:center; background-color:#FFFFE0" |QA
|}

==Relevent Events==
{| class="wikitable"
! colspan="2" |
!ZS
!RhB
!Acceptance criterion
|-
| rowspan="4" |Sep
|KW 36
| rowspan="4" |
| colspan="2" rowspan="4" |
|-
|KW 37
|-
|KW 38
|-
| KW 39
|-
| rowspan="4" |Okt
|KW 40
|
|
|
|-
|KW 41
|
|
|
|-
| KW 42
|
|
|
|-
|KW 44
|
|
|
|-
| rowspan="4" |Nov
|KW 45
|
|
|
|-
|KW 46

|
|
|
|-
|KW 47
|
|
|
|-
|KW 48
|
|
|
|}
==Task List==
FI-Hub Core Admin App

* [https://jira.b-op.org/browse/BTF-1964 BTF-1964] - FI Hub Core Administration App. {{Gray-Tag|Text=Not planned, later}}

FI Schnittstellen

* [https://jira.b-op.org/browse/BTF-1956 BTF-1956] - FI-Hub: Anpassung existierende FI-Schnittstellen zur Übermittlung des GLD. {{Yellow-Tag|Text=Planned}}

Neuberechnung GLD

* [https://jira.b-op.org/browse/BTF-1955 BTF-1955] - WPC - Neuberechnung Lagerbewertung (GLD). {{Green-Tag|Text=Done, in testing}}
** Wareneingang
** Inventur
** AdHoc-Inventur
** Finish Picking Control

* [https://jira.b-op.org/browse/BTF-2071 BTF-2071] - IOD - Aktualisierung Lagerbewertungsmengen bei Warenausgang. {{Green-Tag|Text=Done, in testing}}

Inventory App

* [https://jira.b-op.org/browse/BTF-2048 BTF-2048] - Inventory app: Neuer Bereich zur Ansicht und Modifikation des GLD. {{Yellow-Tag|Text=Planned}}
* [https://jira.b-op.org/browse/BTF-1962 BTF-1962] - Inventory app: Neuer Report "GLD Umschlagshäufigkeits-Auswertung für Abschreibungen". {{Yellow-Tag|Text=Planned}}

Warenausgangs-Report

* [https://jira.b-op.org/browse/BTF-1963 BTF-1963] - Warenausgangs-Report: Erweiterung um GLD. {{Green-Tag|Text=Done, in testing}}

==Meeting Notizen==
*

== Related articles==

*[[RHB:Innovation Roadmap]]
*[[App:FI Hub core administration]]

Test case T.7 Retroactive price change after settlement of supplier bill

2023-07-18T15:43:23Z

Christianrekittke:

==== Prerequisite ====

* Development of new feature --> [[AUA:Retroactive price change of positions on stock (after po payment)]]

{{Note|These items might have been shipped, so the value chages also have to be applied to already made handouts with corrective bookings}}
===General case===
Things to do in the software
*Step A @ AUA digital: Create an order through dispomanager (for 10'000€)
*Step B @ LOGWIN or AUA digital: Expect shipment and intake (for 10'000€)
*Step C1 @ AUA-SAP: Payment has been performed (e.g. 9500 €)
*Step C2 @ AUA: Change PO Position values in new feature
Expected bookings on FI-Side
* At the moment of value change (STEP C2)
**A financial document shall be created with these bookings per inbound position line
***On price reduction:
****'''Credit Inventory''' --> HABEN
****'''Debit''' '''WERE''' 102020 --> SOLL
***On price increase:
****'''Debit Inventory''' --> SOLL
****'''Credit''' '''WERE''' 102020 --> HABEN
***Content lines on SAP should show Supplier-No, PO-Number, article-no, product/variant and quantity
***No cost center reference.
**If other financial bookings were already created for some of the stock (e.g. for handouts to employees) then additional adjustment bookings need to be created for those.
===Test variations===
*Subtest A: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (Cash discount / Skonto)
*Subtest B: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (increased logistic cost)
*Subtest C: Price reduction on invoice (item price related) --> Pricechange attributable per position
*Subtest D: Price increase on invoice (item price related) --> Pricechange attributable per position
==Related pages==
*[[AUA:FI integration - Test cases]]
__NOTOC__

Test case T.7 Retroactive price change after settlement of supplier bill

2023-07-18T12:51:12Z

Christianrekittke:

==== Prerequisite ====

* Development of new feature --> [[AUA:Retroactive price change of positions on stock (after po payment)]]

{{Note|These items might have been shipped, so the value chages also have to be applied to already made handouts with corrective bookings}}
===General case===
Things to do in the software
*Step A @ AUA digital: Create an order through dispomanager (for 10'000€)
*Step B @ LOGWIN or AUA digital: Expect shipment and intake (for 10'000€)
*Step C1 @ AUA-SAP: Payment has been performed (e.g. 9500 €)
*Step C2 @ AUA: Change PO Position values in new feature
Expected bookings on FI-Side
* At the moment of value change (STEP C2)
**A financial document shall be created with these bookings per inbound position line
***On price reduction:
****'''Credit Inventory''' --> HABEN
****'''Debit''' '''WERE''' 102020 --> SOLL
***On price increase:
****'''Debit Inventory''' --> SOLL
****'''Credit''' '''WERE''' 102020 --> HABEN
**Content lines on SAP should show Supplier-No, PO-Number, article-no, product/variant and quantity
**No cost center reference.
===Test variations===
*Subtest A: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (Cash discount / Skonto)
*Subtest B: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (increased logistic cost)
*Subtest C: Price reduction on invoice (item price related) --> Pricechange attributable per position
*Subtest D: Price increase on invoice (item price related) --> Pricechange attributable per position
==Related pages==
*[[AUA:FI integration - Test cases]]
__NOTOC__

Test case T.7 Retroactive price change after settlement of supplier bill

2023-06-30T16:04:24Z

Christianrekittke:

==== Prerequisite ====

* Development of new feature --> [[AUA:Retroactive price change of positions on stock (after po payment)]]

{{Note|These items might have been shipped, so the value chages also have to be applied to already made handouts with corrective bookings}}
===General case===
Things to do in the software
*Step A @ AUA digital: Create an order through dispomanager (for 10'000€)
*Step B @ LOGWIN or AUA digital: Expect shipment and intake (for 10'000€)
*Step C1 @ AUA-SAP: Payment has been performed (e.g. 9500 €)
*Step C2 @ AUA: Change PO Position values in new feature
Expected bookings on FI-Side
* At the moment of value change (STEP C2)
**A financial document shall be created with these bookings per inbound position line
***On price reduction:
****'''Credit Inventory''' --> HABEN
****'''Debit''' '''WERE''' 102020 --> SOLL
***On price increase:
****'''Debit Inventory''' --> SOLL
****'''Credit''' '''WERE''' 102020 --> HABEN
**Content lines on SAP should show Supplier-No, PO-Number, article-no, product/variant and quantity
===Test variations===
*Subtest A: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (Cash discount / Skonto)
*Subtest B: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (increased logistic cost)
*Subtest C: Price reduction on invoice (item price related) --> Pricechange attributable per position
*Subtest D: Price increase on invoice (item price related) --> Pricechange attributable per position
==Related pages==
*[[AUA:FI integration - Test cases]]
__NOTOC__

Test case T.7 Retroactive price change after settlement of supplier bill

2023-06-30T16:01:50Z

Christianrekittke:

==== Prerequisite ====

* Development of new feature --> [[AUA:Retroactive price change of positions on stock (after po payment)]]

{{Note|These items might have been shipped, so the value chages also have to be applied to already made handouts with corrective bookings}}
===General case===
Things to do in the software
*Step A @ AUA digital: Create an order through dispomanager (for 10'000€)
*Step B @ LOGWIN or AUA digital: Expect shipment and intake (for 10'000€)
*Step C1 @ AUA-SAP: Payment has been performed (e.g. 9500 €)
*Step C2 @ AUA: Change PO Position values in new feature
Expected bookings on FI-Side
* At the moment of value change (STEP C2)
**A financial document shall be created with these bookings per inbound position line
***On price reduction:
****'''Debit Inventory''' --> HABEN
****'''Credit''' '''WERE''' 102020 --> SOLL
***On price increase:
****'''Credit Inventory''' --> SOLL
****'''Debit''' '''WERE''' 102020 --> HABEN
**Content lines on SAP should show Supplier-No, PO-Number, article-no, product/variant and quantity
===Test variations===
*Subtest A: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (Cash discount / Skonto)
*Subtest B: Payment was more than invoice due to shipment cost --> Pricechange attributable to all positions (increased logistic cost)
*Subtest C: Price reduction on invoice (item price related) --> Pricechange attributable per position
*Subtest D: Price increase on invoice (item price related) --> Pricechange attributable per position
==Related pages==
*[[AUA:FI integration - Test cases]]
__NOTOC__