All work
- Creditor Activities - Processed Orders Tab Uses Last Modified DateDEV-10546Resolved issue: DEV-10546Monica Holliday
- Stored procedure usp_JIWA_Creditor_Update_Period_Balances us not calculating FXPeriod2, FXPeriod3 and FXPeriod4 correctly under some circumstancesDEV-10779Resolved issue: DEV-10779Scott Pearce
- Debtor Transaction Entity has malformed SQL in the ReadRecordDEV-10753Resolved issue: DEV-10753Scott Pearce
- Some thread-safe methods for UI updates have the wrong number of arguments, and may result in runtime errorsDEV-10836Resolved issue: DEV-10836Scott Pearce
- Ability to suppress popup message when Ignore Backorder Allocations is tickedDEV-10651Resolved issue: DEV-10651Scott Pearce
- Rework GL Years / Periods in Manager / Journal Sets to facilitate asynchronous journal postingDEV-10816Resolved issue: DEV-10816Scott Pearce
- Improvements to IFS PluginDEV-10487Resolved issue: DEV-10487Stuart Barnes
- Add ability to specify printer in IFS ConnoteDEV-10466Resolved issue: DEV-10466Stuart Barnes
- Warehouse Summary SOH - Forecast Work Order Component WIPDEV-10540Resolved issue: DEV-10540Monica Holliday
- Landed Cost - Negative Cost Apportioned to last line using when Unit Cost is zeroDEV-10767Resolved issue: DEV-10767Scott Pearce
- OriginalStatus property of Landed Cost Shipment business logic is not accessible by pluginsDEV-10306Scott Pearce
- POS to cater for refunds and returnsDEV-10510Resolved issue: DEV-10510Scott Pearce
- Successful Webhook Messages are not recording the response body in SY_WebhookMessageResponse tableDEV-10821Resolved issue: DEV-10821Scott Pearce
- Warehouse Transfers Out - PATCH is not setting Line details correctlyDEV-10813Resolved issue: DEV-10813Scott Pearce
- Add Email routes to the REST APIDEV-10693Resolved issue: DEV-10693Scott Pearce
- Add REST API event that indicates when a webhook message and response is being savedDEV-10667Resolved issue: DEV-10667Scott Pearce
- Periodically ingest webhook messages of status 0 (unsent) that were created by clients unable to POST the webhookDEV-10662Resolved issue: DEV-10662
- Add support for creating a credit note based on a sales order to REST APIDEV-10617Resolved issue: DEV-10617Scott Pearce
- Webhook HTTP response is always logged as 200 if there was no webexception instead of the actual response.DEV-10615Resolved issue: DEV-10615Mike Sheen
- Add mechanism for Plugins to cancel or modify webhook before it is sent to the APIDEV-10614Resolved issue: DEV-10614Scott Pearce
- Webhook responses of 4xx should not be retried and marked as permanently failed (except 429)DEV-10611Resolved issue: DEV-10611Mike Sheen
- Add to SY_WebHookMessageResponse table when clients fail to send webhooksDEV-10593Resolved issue: DEV-10593Mike Sheen
- Batching up of Webhook MessagesDEV-10345Resolved issue: DEV-10345Mike Sheen
- Add mechanism to REST API to limit which instance of multiple API services is to service Webhook retriesDEV-9921Resolved issue: DEV-9921Scott Pearce
- Unique Orders To.. calculation is incorrect in Batch Printing & EmailingDEV-10666Resolved issue: DEV-10666Scott Pearce
- Sales Order Sort and Search by Invoice Initiated Date to include TimeDEV-10566Resolved issue: DEV-10566Scott Pearce
- Order Total on Payments tab excludes Freight charges when all items are backorderedDEV-10517Resolved issue: DEV-10517
- Sort Tasks in Search Service Manager Tasks formDEV-10660Resolved issue: DEV-10660Scott Pearce
- Warehouse Transfers - SOH stuck in In Transit WarehouseDEV-10859Resolved issue: DEV-10859Scott Pearce
- Webhooks - Change order of sending messagesDEV-10757Scott Pearce
- Added Component Tree tab to Work Order FormDEV-10860Resolved issue: DEV-10860Mike Sheen
- Work Order - Does not create Sub-Assemblies when Explode Policy is "When Shortfalls".DEV-10765Resolved issue: DEV-10765Scott Pearce
- If rounding errors in work order component allocations cause the "Unable to locate enough free input line details records to allocate to the output item line detail." error, tell the user to head over the "Component Allocations" tab to rectify.DEV-10679Resolved issue: DEV-10679Scott Pearce
- Don't use ratio calculations on work orders when setting the full output amount to avoid the error "Unable to locate enough free input line details records to allocate to the output item line detail.".DEV-10678Resolved issue: DEV-10678Scott Pearce
- Work order gives error "Unable to locate enough free input line details records to allocate to the output item line detail." when setting to status to "Closed"DEV-10672Resolved issue: DEV-10672Scott Pearce
- Work order read performance improvementDEV-10568Resolved issue: DEV-10568Scott Pearce
- Improve Work Orders workflow for more efficient UXDEV-10239Resolved issue: DEV-10239Scott Pearce
37 of 37
Stored procedure usp_JIWA_Creditor_Update_Period_Balances us not calculating FXPeriod2, FXPeriod3 and FXPeriod4 correctly under some circumstances
Done
Description
Environment
None
Attachments
2
Details
Assignee
Scott PearceScott PearceReporter
Mike SheenMike SheenComponents
Fix versions
Priority
Medium
Details
Details
Assignee
Scott Pearce
Scott Pearce
Reporter
Mike Sheen
Mike Sheen
Components
Fix versions
Priority
MediumCreated 11 April 2024 at 02:33
Updated 12 March 2025 at 03:35
Resolved 16 April 2024 at 22:34
Activity
Monica Holliday3 May 2024 at 06:34
Passed testing 07.02.01.00 SR19
Scott Pearce16 April 2024 at 22:34
Data structure change, so cannot be part of an SR. You can deploy the attached sql script on existing 7.2.1 sites to fix the issue, however.
Mike Sheen11 April 2024 at 02:35
Fixed stored proc ALTER script attached.
This stored proc is called as part of the period rollover function.
If there are allocations against transactions in periods 2 or later, then this stored procedure is not setting the CR_Main.FXPeriod2, CR_Main.FXPeriod3 or FXPeriod4 balance fields correctly - it omits the allocated amount from the calculation.
This causes the period balance display on the screen (for FX Creditors) to be incorrect.
FXPeriod1 is, however correct.
Note the difference between the setting of the @FXPeriod1Bal variable in the stored proc and the setting of the @FXPeriod2Bal, @FXPeriod3Bal and @FXPeriod4Bal
Stored proc does not exist in version 8, and so does not apply to that version.