Versions Info..

Version # Current # Date Items
3.2.9 0 25 Apr 2023
1
3.2.8 0 07 Mar 2023
1
3.2.7 0 21 Aug 2022
1
3.2.6 0 24 Jun 2022
1
3.2.5 0 21 Jun 2022
1
3.2.4 0 03 Mar 2022
1
3.2.3 0 21 Feb 2022
1
3.2.2 0 31 Jan 2022
1
3.2.1 0 11 Jun 2021
1 Fixed 18 June 2021: I've just picked up on what appears to be a miscalculation of a cost recoup line on an owner statement. Details as follows: Owner Code: 1505 Owner Name: Auchan Romania Statement: 1505_202104 I've attached the PDF of the April statement (and the March statement too, to show what the previous month's cost's closing balance was) so you can see. It appears as though the amount recouped from the cost has been deducted twice (instead of just once). These are my calculations of what the cost recoup should be: Statement Cost O/Bal Amt Recouped Cost C/Bal 202103 £1,227.57 £299.63 £927.94 202104 £927.94 £242.72 £685.22 i.e. closing balance of the cost on the 202104 statement being £685.22, whereas on the statement it shows as £442.50 (which is a second recoup amount of £242.72 coming off the balance) Fixed: 18 Jun 2021 The error was in the trigger on deletion of statement lines. I have corrected and tested on a restored back up of the live database. Also corrected the cost left for this statement
2 Admin Synch For some unknown reason the Owner Xero Record link (Xerocontactid) hadn’t been saved – now done! Fixed: 17 Jun 2021
3 Organisation Merge The merge function didn’t copy the OwnerNo (LegacyCode) across although everything was properly linked using the newer OwnerCode. I have updated the OwnerNo manually now. In addition I’ve changed the merge procedure to Changed unique LegacyCode constraint to only be enforced on non-merged Owners Copy MergeFrom LegacyCode to new LegacyCode Fixed: 30 Jun 2021 Changed unique LegacyCode constraint to only be enforced on non-merged Owners Copy MergeFrom LegacyCode to new LegacyCode
3.1.11 0 02 Jun 2021
1 Due date is showing required date Fixed: 05 Jun 2021
2 context menu on statement edit has delete that doesnt work Fixed: 05 Jun 2021 delete removed - use bulk delete instead
3.1.10 0 18 May 2021
1 A really strange Xero API error – it insists you have an email address for the Organisation before you can add contacts – I’ve changed next version so it doesn’t try and add contacts to Xero unless we have a main email address! Fixed: 25 May 2021
2 Payments on invoice not showing when clicking link from tables - fixed next version Fixed: 25 May 2021
3 Changed Generic Table template/scripts so the contextmenu functions are in the script file not the template. Should have performance benefits. Fixed: 25 May 2021
3.1.9 0 06 May 2021
1 Currency on invoice print in payment section has apostrophe Fixed: 11 May 2021
2 Owner statements PDFs - to include legacy owner number Fixed: 13 May 2021
3 I've just come across something quite concerning regarding the 202103 statements in Xero we produced on the new system which causes really issues for our P&L and Mickey's work: For statements that have lines for recouping costs, these should all be going to the cost account code 'Production Expenses' (2300). I've come across, and subsequently checked others, where many seem to be going to 'Cash Based Internet Costs' (2040) and also found a few going to 'Documentary Costs' (2000) - see examples: 1021_202103 1_202103 9_202103 89_202103 982_202103 What's more strange is that for one of the statements which I had to regenerate (due to the issue of lineid in xero broker duplicating an Invoice line on some statements), the original statement for this owner had a recouping cost line going to Cash Based Internet Costs, and then when I re-generated the statement, the same cost recoup line changed to Documentary Costs. I don't see what would cause this change? For this example, where the account code changed, it was for: 1358_202103, which has a re-generated statement of 1358_202103_a. Also, what are the rules for creating a new xero statement with the '_a' addition versus other times when I've regenerated and pushed to xero, and it simply updates the xero bill (rather than creating a new one with the _a)? But the main priority here is getting the account codes for these recouping cost lines back to Production Expenses (2300). Is there a logic as to why they've gone to either 2040 or 2000 in the first place rather than 2300? Fixed: 13 May 2021 Just to clarify – you are concerned about the Supplier invoices in Xero that are created for Owner Statements. Where these lines are recouping costs there is an issue with how they are coded. This goes back to a discussion of a few days ago – currently the system tries to get the line from the equivalent sales invoice and replaces the 1st character of that code with a 2 If it can’t find it codes it to 2000. I can see that there maybe a floor in the coding when there is no equivalent sales invoice line – I have fixed it for next version. So are you saying for any statement line that has LineType=’COST’ the account code should be 2300 – this includes Owner and Prodn costs? Isn’t it a pretty simple fix of Xero using find and recode?
4 Marketing Section not showing legacy contacts Fixed: 14 May 2021 all data was there just a migration error on the record links - now corrected
5 Statement Edit form is a bit crude and wont change new statement header summed values Fixed: 25 May 2021
6 Sales Import with validation to complete Fixed: 25 May 2021 Beta release: 25 Apr 2021
3.1.8 0 02 May 2021
1 Error posting to Xero ACA01 and VCR01 Fixed: 04 May 2021 It was because both statements had been voided in Xero and therefore no further invoices with the same Invoice Number are allowed. I’ve change the code so that if that specific error is encountered we try again appending ‘_a’ to the invoice number. They are both posted now and the change in the app will be in the next version 3.1.8
2 Customer lookup on modal rights - Title and Sales Order. Partial search not working. Fixed: 06 May 2021 Also removed OrdNO >0 constraint on rights table so -ve temp Sales Order No doesnt cause error saving rights
3 Version No causes menu bar to be too big on laptops Fixed: 06 May 2021
4 Inv 15017 seems to be duplicated Fixed: 11 May 2021 It was an issues with r21_vw_SalesOrders and the join to system notes - now fixed
5 Saving record fails to update Xero Fixed: 13 May 2021 Previous Bug fix problem. Forgot to check if 'ErrorNumber' exists in dictionary
3.1.7 0 30 Apr 2021
1 I was just logged into the app under a 'normal' user (ie not a super user) to see what functionality was available and picked up on a few things. Is it possible to remove the following features/functionality from normal users view? 1) Xero button found in Owners/Owner Records, then on the 'Statements' tab, both by right-clicking and the 3 blue menu button brings up the menu showing the option for Create Xero Inv. 2) On the System menu at the top, can we remove the 'PPV' submenu (which also includes another xero API button for PPVs) 3) Also within the System menu, can we remove the 'Xero Connection' submenu link (where a user can currently go to and click the edit button and change the settings!). Fixed: 30 Apr 2021 For non-super users I’ve: 1. removed the system menu entirely 2. removed the statements tab from the record card – they can see statements under financials – just the Xero version
2 1) Arthur Cauty, Code: ACA01, legacy nr 1123 Statement total and earnings are correct, however it is showing some rogue invoices and dormant PPV lines (albeit at 0 value) - I've attached the PDF. e.g. in the Info section, invoices 11166 (about 6 years old), and showing lines for PPV08,12,14 (which are not active PPVs) 2) Black Jelly Films Pty Ltd, code: BJF01, legacy nr 1609 Statement total is a negative amount. From looking at the statement this is due to the costs section recouping more than the total earnings for the month. The maximum amount being recouped in the costs section should not exceed the total earnings for the month, i.e. an owner should never have a statement total lower than 0. Fixed: 02 May 2021
3 Zak - Actually its when we navigate to Owner (1577) from global search the Contact is not intitialised. I've had to fix some problems my side with the website getting out of sync with access over the last few months (hadn't completely disabled users ability to change data which was no longer exported back to access). This means I've been putting data manually into your db through the interface and have come across some issues: 1. ADDING OWNER CONTACT REQUIRES MOBILE INPUT: - You are forced into adding something in the "Mobile" field. If you don't add something, no error will be displayed, but the field will not update and will act as if you never clicked save in the first place. I've been getting around this by entering a " into the input box but this needs to be fixed. 2. OWNER CONTACTS DON'T HAVE A TELEPHONE INPUT: - There is no "telephone" box: some contacts have both a telephone and mobile, some have just a telephone, this isn't being shown in that box and I can't change/add the data I need to add into those fields. Lots of legacy data is in the "tel" field and this can't be accessed at the moment. 3. OWNER RECORD VALUES SEEM TO BE MISSING: - I think "First Name" is missing from Owner's Record? There is a "Name" and a "Last Name" section. I believe the "Name" field is actually the "Company" field and the "First Name" field is missing. 4. ERROR ON EDITING OWNER RECORD: - On changing a value in the owner record, I get an error and it does not update. (I am trying to update the ABC owner "Company" from "ABC" to "ABC Australia" which is as mentioned above being done through the "Name" field) - The following error is returned: Fixed: 02 May 2021
4 XeroBroker - issue with legacy invoice edit lines and delete lines 22 14939 4497e1dc-83ba-416c-a7a0-e71d8d548ba3 GBP 17750 10200 Fixed: 04 May 2021 Have temp fixed XeroBroker data for invoice lines. New version of XeroBroker 2.1.0.4 - now deletes all lines 1st for an Invoice, CreditNotes and Journal Lines so that deleted lines are removed before all are re-created.
3.1.6 0 29 Apr 2021
1 Some statements error posting to Xero - CEL01 202103 Fixed: 29 Apr 2021 Issue was 1. Item Code -1 not in Xero. 2. Where no Sales Xero invoice ID found for statement line - costs etc error generated before it tried to post via API
2 Bulk pdf download failing on 2nd statement Fixed: 29 Apr 2021 Bug because Id change the table source to a view and missed removing a table alias on multiple pdf loop
3.1.5 0 25 Apr 2021
1 Admin Synch - add new address fields of Town, County, Country etc to tblBuyers synch Fixed: 25 Apr 2021
2 Create Statement SP Change to exclude Customer invoice codes in PPVImport table rather than any code like 'PPV%' - in theory this could catch a normal customer. Also ignore stat header creation for INFO lines only Change stat header creation for new sum fields Fixed: 25 Apr 2021
3 Generic lookup change fires if it is cleared. Ideally it should only fire on a return key down or when chars have been entered Fixed: 25 Apr 2021
4 Statements table is slow to load. Need to change StatHeader table to sum data per view Fixed: 25 Apr 2021
5 Orders of more then 47 lines fail to save. I think the issue is that invoice lines are added in memory – not committed to database until save If there is an issue while creating invoice everything is lost Solution is 1/ write a new invoice form that saves each line in a temp table in database during processing. When save is hit then it will populate main tables Or 2/ write an import process for big invoices Either of these options requires some effort so can we add as a “Wish” for now and schedule for later - next month? Fixed: 25 Apr 2021 Added a max fields setting in Django settings - set to 20000 now instead of standard 1000.
6 Admin Synch Legacy owner code 443, 202007 Owner name: Sean Langan The story is: back in Aug 2020 we mistakenly made a double payment to this owner of £231.07. For transparency reasons we added this double payment as a cost on account via the database so the owner could see each month their earnings going towards paying Journeyman back for this double payment. However on xero we reconciled this double payment as an overpayment that future statements would go towards. So we were essentially doubling up. Since the recouping was all done already via the statements, the statement total came to £0, so the adjustment in xero we have been making since Aug 2020 is that we would edit the owner bill be removing the recouping line, so that it just showed the raw earnings, and then we would allocate this against the overpayment in xero. Fixed: 29 Apr 2021 Hi Luke This is really confusing!!! Whatever the details the overriding principal is that Xero now owns the amount due to Owners because it’s the only place you match cash to! The StatementTotal is now essentially a Xero field (the xero invoice total) so if you want it to be something different you’d need to edit Xero? The accounting is your choice but would this work? The StatementTotal is in reality the Commission due to the Owner – the Xero Invoice Total - so if you want it to show as 0 then can you just add a -ve line to the invoice and then make a dummy receipt to clear it?
3.1.4 0 22 Apr 2021
1 Fixed: 22 Apr 2021 Added address type to form so that if its order address dont add town,county,country.
2 The table functions aren't working correctly. Fixed: 22 Apr 2021 It was because the table source was change to a view so the table aliases needed removing
3.1.3 0 18 Apr 2021
1 Fixed: 22 Apr 2021 Xero Items added during invoice processing. Checked if updated and they are but IsSold and IsPurchased flags werent being updated but have changed now.
2 Fixed: 22 Apr 2021 Edit Sales Order - currency defaults to GB if no Customer default currency set. It was just visual - the currency description is stored on the order header but it has no effect other than display. Its now storing the correct description but any old orders effected will need edit and save
3 Fixed: 22 Apr 2021 Generic table context menu position on large no of rows faulty. Script file changed.
4 Create Statement SP - PPV not coming through and then PPV03 missing Fixed: 23 Apr 2021 Change PPV Code search from Name to Code now we are live. Also changed PPV03 Owner lookup to look at ne PPVOwners table populated under new app
3.1.2 0 15 Apr 2021
1 Added Support Log fro super users
2 Added back Inv edit for Xero posted sales from Xero Sales Update subject to warning
3 Fixed Owner lookup issue for lookup clearing
4 Added missing Order details for rights
5 Added Cost Report
3.1.1 0 09 Apr 2021
1 Fixed CreditNote line deletion
2 Change temp order/credit sequence to negative to ensure no conflict with main no
3 Enable context menu from right click of hyperlink
4 Prevented edit of xero posted sales order
5 Changed Xero Invoice Date and Due Date to the date from the app not the date exported
6 Changed lookups so enter key on input loads list per clicking the lookup
7 Sales Order - set focus on customercode lookup on entry. Set focus on TapeCode on new add new line.
8 Xero Sales Update - fix bug on delete message updated to Xero.
9 Fixed Contact Email autocomplete and key up/down error after lauching contact modal from sales order
3.1.0 0 06 Apr 2021
1 Change Bank details on Sales Invoice per LH
3.0.9 0 06 Apr 2021
1 Fixed BIC No on Sales Invoice
3.0.8 0 05 Apr 2021
1 Added triggers to tapes and organisation tables to get new codes and TapeNr/OwnerNr (LegacyCode) if dupe found.
2 Altered Organisation Save for message for failed Xero Update
3.0.7 0 03 Apr 2021
1 Fixed PPV Validate - PPV lookup - now looks up list irrespective of imported files.
3.0.6 0 29 Mar 2021
1 Owner Statement List filtered to non-legacy orders not updated to Xero
2 Fixed Xero Connection Refresh for new Django version
3 Xero Invoice Number set to Order Number
4 Sales Update List filtered to non-legacy orders not updated to Xero
3.0.5 0 28 Mar 2021
1 Fixed Data Migration Org Code assignment to have more logical numbering
3.0.4 0 28 Mar 2021
1 Unique index on Organisation Name and fixed Organisation Merge
3.0.3 0 28 Mar 2021
1 Changed tables to use UpdatedBy nvarchar(150)
3.0.2 0 28 Mar 2021
1 Contact Numbering fix
3.0.1 0 28 Mar 2021
1 First Live Release - Django 3.1.7