SQL Account Releases

• #Fixed Sales Cash Sales 6 – Receipt-TM-U220 (SST) DocNo alignment problem
• #5757: Bank Recon word will overlay with others when too long
• Adjust eCommerce to post customer phone to DPhone1, customer id to DocRef4
• Fixed Bug eCommerce: Credit note did not knock off when posting payment
• AR/AP PM, CN, Refund & Contra add Knockoff DocNo info for error “Knock off amount must not exceed outstanding amount”
• Fix bug: Auto bank recon PDF last record not showing

• Upgrade Database Version 181
• #5742: Customer Refund listing preview prompt error “Document_CompanyBankAcc: Could not open DataSet”
• Feature #5754: AR/AP Contra auto open couple contra form upon save if couple company code is empty
• Add GL.Auto.BankRecon.UOVBMY
• Added column Recon At at auto bank recon
• #5036: GL Journal Entry form mode not working if FromDocType are CN & DN
• #5745: Different date format for PBB statement (CSV)
• #5743: Invalid numeric input error when load MAYBANK statement

• Fix GL Bank Reconciliation Report – Clear Transaction should exclude cancelled document
• Fixed Sales Local – Cash Sales Collection Report unable to shown detail information
• #5704: GL P&L Report Net Sales & Gross Profit/(Loss) have to show out even 0
• #5726: AR/AP Balance Report Local C/F not 0 due to incorrect local outstanding for CN
• Fixed Cust Contra Voucher – Full format had invalid character
• Feature #5727 : Auto Bank Recon – Add OCBC
• Add E-Commerce: AddToCart
• #5711: Auto Bank Recon – Support Maybank different statement format
• #5714: Auto Bank Recon – PBB statement has different format
• #5707: Auto Bank Recon – HLBB statement has different format

• Upgrade Database Version 180
• Fixed JV Description overlap when Description too long
• #5715: Unable to Save when Knockoff Invoice for some situation
• Add E-Commerce: Lazada, Shopee & Woocommerce

• Upgrade Database Version 179
• Add SST-02 (2020) format
• GL Receipt & Payment Report Prepayment Account should include transaction of Payment that transfer from AP Deposit
• Add Supplier Deposit Listing Report
• Enable Support Supplier Deposit for GL OR & GL PV format
• Feature #5679: Maintain Batch support DIY Views
• #5697: Unable to edit customer invoice contains SV tax code even though without payment knockoff
• Feature #5701: GL Cash Book Detail & Tax ledger transaction “Description2” field should refer to CompanyName field value
• Feature #5553: Add Supplier Deposit Entry & Report
• Feature #5565: Stock Assembly, Disassembly & Job Order’s BOM Template become blank once the document has been saved
• GL Bank Reconciliation support Auto Bank Recon feature

• #5678: AR/AP Balance Report’s Current Balance & C/F incorrect when Refund knockoff CN falls in different month
• Fixed GL Bank Reconciliation Report – Clear Transaction not sorting
• Fixed GL Bank Reconciliation Report – Clear Transaction Transactions not only shown once when there is Same DocNo
• Update SST-02 (2019) Add Digital Tax Refund Calculation
• Fixed GL PnL – Comparison – 22C1P preview error when user use – when 0 as displayformat
• Auto Get Buying Rate from Maintain Currency when Currency Rate is 1 for GL PnL Currency report
• Auto Get Buying Rate from Maintain Currency Currency Rate is 1 for GL BS – 3C1P-IFRS-Currency report
• Fixed SST Listing 4-DST-02(2020) Preview Error when Tariff more the 15
• #5653: Maintain Stock Item if have multiple UOM with rate=1, should allow to change rate if IsBase is unticked
• #5690: Prompt access violation error when Customer/Supplier Code format is %.3s-%.0s%.4d
• Ignore tax return checking on document if GST/SST is not started
• #5673 User able to access Sales Analysis by document when user did not purchase S&P module
• Feature #5672: Stock Take sync stock item add new field – Shelf
• #5669: Supplier bank account lookup does not exclude inactive record

• Upgrade Database to Version 178
• Add Dashboard
• #5529: Process SST SV with Past IV Project Code is empty
• #5521: Points Entry Grid Caption for Code incorrect
• #5512: Grid cell always align to right on display dpi other than 100%

• Upgrade Database to Version 176
• Fixed Sales & Price History Group by DocNo, Tax & Tariff shown incorrect grouping information
• #5486: Import Serial Number with Prompt Replace Unit Price Dialog prompt error control has no parent window
• #5494: AR Payment edit and change “From Deposit” to another deposit not update the Deposit Amount in AR Deposit
• #5492: GL Maintain Opening Balance 2nd Description is empty
• #5489: Customer Refund slow after choose customer code if knockoff has over 1k records
• Feature #5427: Maintain Item Template add Location & Project fields
• #5475: GL Cash Book – Save Prompt Error if user empty the Amount Column

• #5391: Sales Profit Estimator should convert to customer currency when click “Update Unit Price” button
• #5467: SL Invoice unable to posting via BizObject If Exceed Credit Limit with overridden permission
• #5048: Should not prompt dialog if user set Overdue or Credit Limit to 0 and the user allow to override
• #5468: Add calculator editor numeric column in GL Cash Book and Journal Entry
• Feature #5440: Document Transfer Dialog by default filter 7 Months from target document DocDate
• Feature #5453: AR/AP Documents browse grid add 2nd company name column
• Feature #5437: All GL Account Lookup add 2nd Description column
• #5457: COM client cannot capture invalid logon credential

• #5417: GL Profit Loss & Balance Sheet – Fixed Date params show as number
• Stock Purchase Planning (Current & Next 3 months) report file has fixed Get SQty instead of Qty for PO and SO in each months.
• Fixed Customer CN full page formate Company Header overlaping the Company Logo
• Fixed Discount Amount not shown when using Disc Column for Sales Invoice 3 (Sales Disc)
• Feature #5412: Stock Transfer Listing Report add “SubTotal (Tax)” column in detail grid
• #5413: Stock Transfer Listing “Actual Amount” should sum up for IN qty amount only
• #5419: GL Ledger untick “Include Zero B/F with Transactions Before” should determine by LocalBalance instead of Balance field as some account has Local value but foreign value is zero
• #5418: Supplier Analysis by Document grouping 1 level but show level 2 report on screen
• #5421: GST-SG the box 13 should refer to net sales because box 4 has including CN in F5 return
• #5433: AR/AP Statement’s Balance not sum correctly
• Rename SST-02 file name
• Add Sales Local – Sales Order Listing (Tax 1)-SO2PO Report
• Add Sales Local – Cash Sales Listing – Z Report
• Add Sales Local – Cash Sales Collection Report
• Add Stock Purchase Planning (Current & Next 3 months) report
• Feature #5410: SL/PH Invoice & Cash Sales add “Transfer To Credit Note” option
• Feature #3660: Document Entries that has payment info and has been reconciled with bank upon user click edit/delete will prompt confirmation message

• #5359: List index out of bound error when double click GL PnL or Balance Sheet Format
• Add GL Bank Reconciliation Report – Clear Transaction Report
• #5395: Enable sync via USB cable using Stock Take App
• #5403: Customer Payment Deposit Drop down unable to show Description
• #5394: Customer Statement Report same date if got two Payment Transactions (OR) should sort by docno instead of amount
• #5381: GL Account delete Prepayment Account raise Access Violation error

• Upgrade Database to Version 175 – Tunning Table SY_PROFILE, AR_CUSTOMER, AP_SUPPLIER, GL_CBDTL, GL_JEDTL, GST_TR_DRAFT, GST_TR & AR_CUSTOMERBANKACC table
• Add Sales Points-Summary report
• Fix Sales Points-Statement Error when no Balance c/f is zero
• FR3 Report – Reduce Column Usage on FR3 Export to excel for Sales Quotation 8
• Add Sales Points Listing Report
• Fixed Sales Yearly Analysis Export pdf line become not straight
• Feature #5352: Enlarge the Height for Group/Sort By
• Sales Points should exclude Point where less then 0
• Update Sales Points-Statement Footer Notes
• Convert Stock Transfer Listing to FR3
• #4919: Click “Read MyKad” button does nothing

• Upgrade Database to Version 174 – Add SL_PT & ST_Take table
• Fixed SST Listing Summary Tariff not shown
• Reduce Column Usage on FR3 Export to excel for Sales Local – Cash Sales Listing (Tax 1)
• Add Cust Local – Due Document Listing – Outstanding Service Tax report
• Fixed Cust Local – Invoice Listing – Level 1 preview error
• Feature #5351: GL P&L, Balance Sheet, AR/AP Aging & Statement Report forms’ report template add Load & Save buttons
• Feature #5320: IV/PI Fast Entry add CompanyName
• Feature #5344: Enlarge the Document Number Display till max

• Upgrade Database to Version 173 – Tunning SY_USER table
• Change title to GL Opening Balance for GL Opening Balance report
• Fixed Sales P&L By Document – Level 2 export pdf line become not straight
• Feature #5273: Support advance password policy
• Feature #4959: Process SST return prompt list of outstanding service invoices over 12 months
• Bug #5285: BizObject – System will Prompt Catastrophic error or hang
• Feature #5251: View Sales/Purchase Price History Add Fields (Doc Description, Branch Name, DocRef 1-4, DocNoEx, CC & Country)
• Feature #5274: Sales/Purchase Price History Grid add Detail Seq column
• #5281: Search Reg No prompt error