Please update DynaMod Server Socket to 2019.1 Build 0003

Please update DynaMod Process Manager to 2019.1 Build 0009

Please update DynaMod Client Socket to 2019.1 Build 0002


New Enhancement List

  • Enhanced ADIDAS Data Interface
    • Sales Data Interface: Remove Column of [Sales Person Name]; Leave it blank for column [Size], [EAN 13 Code] and [Receipt Number]
    • Inventory Data Interface: Leave it blank for column [Size] and [EAN 13 Code], suppressed zero balance quantity records.
    • Please update DynaMod Process Manager to 2019.1 Build 0007
  • Enhanced Payment Voucher Listing: Added column AccountNoPayment. (Ticket: 116233)
  • Enhanced Payment Voucher Listing: Added column MatchPaymentItemReferenceNumber. (Ticket: 116669) 
  • Enhanced Stock Image synchronization process for handle of large records (33,000 Images) to avoid system run Out Of Memory (DynaMod Process Manager 2019.1 Build 0008). (Ticket: 116243)
  • Added New eWallet Report Format, 'POS eWallet Payment Summary' , under 'POS Sales Summary' report screen. User can see their detail breakdown of eWallet cash sales.
  • Enhanced Stock Sales Analysis by Serial Number by re-written the logic and report formats. (Ticket: 116480)
    • The system default formats would be removed and new formats would be included.
    • Those customized format would be remained but unusable, kindly remove it.
    • New formats added:
      • 1. Stock Serial Sales Analysis by Document
      • 2. Stock Serial Sales Analysis by Stock Code
      • 3. Stock Serial Sales Analysis by Serial Number
  • Enhanced GL Posting for more prevention of missing but indicated as Posted. (Ticket: 115982)
    • Cash Sales
    • Customer Invoice
    • Customer Credit Note
    • Customer Debit Note
    • Customer Adjustment
    • Customer Receipt
    • Supplier Invoice
    • Supplier Credit Note
    • Supplier Debit Note
    • Supplier Adjustment
    • Payment Voucher
    • Journal Entry
  • Enhanced in Customer Maintenance screen by extend the width display of Credit Limit and Balance. (Ticket: 116569) 
  • Enhanced Stock Remark Template to make the layout more compact when preview. (Ticket: 116546)
  • Optimized Database Size and Data Posting Performance 300%
    • GL Transaction Table (Eg: 19GB reduced to 16GB)
    • GL with Tax Code Transaction Table (Eg: 20GB reduced to 0MB since being truncated)
    • GL with Tax Code Posting been revoked.
    • Account Transaction with Tax Code enquiry screen been revoked.
    • General Ledger Listing with Tax Code report screen been revoked.
  • Added SiteGiant Add New Product from DynaMod stock
  • Added SiteGiant Product match with Barcode
  • Added Include Shipping Fee feature for Marketplace Sales Order / Customer Invoice (Lazada / Shopee / SiteGiant)
  • Added Match All SiteGiant Product SKU with Stock ID or Barcode (DynaMod Process Manager)
  • Enhanced Create Sales Order / Create Customer Invoice for Marketplace orders with unified button for single or multiple selection (Lazada / Shopee / SiteGiant)
  • Enhanced SiteGiant Setup screen to validate Store API URL / API Key
  • Simplified Cash Sales Posting to gain some performance from posting process. Especially benefits for those heavy cash sales transactions.
  • Simplified Stock Balance calculation to gain some performance.
  • Enhanced the loading speed of Print Barcode Label. (Ticket: 116387) 
  • Added Integration with SQL Accounting System with the SDK provided (https://wiki.sql.com.my/wiki/SDK_Live)
    • New screen added [Common Module] - [System Utility] - [SQL Accounting Integration] - [SQL Accounting Integration Task]
      • The screen shows all of the system default available tasks with it's description. 
    • New screen added [Common Module] - [System Utility] - [SQL Accounting Integration] - [SQL Accounting Integration Project]
      • The screen allow you to configure an Integration project with SQL Accounting by defining the desired tasks.
      • You can test connection to SQL Accounting SDK here right after configure the authentication and database path with filename. (SQL Accounting using FireBird embedded database by default)
      • You can write dynamic query (SQL) to query the result from SQL Accounting database.
      • You can manually perform or test the task from here. If everything fine, then you can setup the auto process task in DynaMod Process Manager.
    • New total of 16 Tasks for SQL Accounting Integration automation are added in DynaMod Process Manager (2019.1 Build 0009) 
      • SQLACC_UPLOAD_AGENT
      • SQLACC_UPLOAD_AREA
      • SQLACC_UPLOAD_CURRENCY
      • SQLACC_UPLOAD_TERM
      • SQLACC_UPLOAD_PROJECT
      • SQLACC_UPLOAD_COMPANY_CATEGORY
      • SQLACC_UPLOAD_CUSTOMER
      • SQLACC_UPLOAD_CASH_SALES
      • SQLACC_DOWNLOAD_AGENT
      • SQLACC_DOWNLOAD_AREA
      • SQLACC_DOWNLOAD_CURRENCY
      • SQLACC_DOWNLOAD_TERM
      • SQLACC_DOWNLOAD_TARIFF
      • SQLACC_DOWNLOAD_STOCK_GROUP
      • SQLACC_DOWNLOAD_STOCK_TRANSFER_AS_RECEIVE
      • SQLACC_DOWNLOAD_STOCK
  • Added x64 program version (64bit) for below:   More Info
    • DynaMod
    • DynaMod Server Socket
    • DynaMod Client Socket
    • DynaMod Process Manager
    • Note: All are switchable by press the button 'Switch from x86 to x64' vice versa. The button is located at:
      • DynaMod: Menu - Help - Switch from 32bit to 64bit version
      • DynaMod Server Socket: Menu - Socket - x86 to x64
      • DynaMod Client Socket: Menu - Help - x86 to x64
      • DynaMod Process Manager: Menu - Help - x86 to x64
    • Note: You will still be able to update version even switched to 64bit version.
    • Note on 32 bits and 64 bits version:
    • If you have a 32 bits system, you are limited to maximum 4GB of RAM, and at most 3.5 of useable RAM. A 64 bits system don't have such limit.
    • Do not switched to 64 bits if your RAM are lower than 4GB. 64 bits version used more memory than 32 bits does.
    • Switched DynaMod Server Socket to 64 bits would be good as it has to handle multiple concurrent inquiry.
    • Switched DynaMod Process Manager to 64 bits would be recommended because from time to time it need to handle large data set process.
    • Swithced DynaMod Client Socket to 65 bits would be recommended because from time to time it need to handle large data set process for synchronization. (Provided you had more than 4GB RAM and better 64 bit Processor and OS)
    • Switched DynaMod to 64 bits only if you need to extract very large data such as Reporting (General Ledger, Stock Card etc) which generally you are facing 'Out of Memory' exception whenever using 32 bits version.
    • Running DynaMod 64 bits would be much more slower in some circumstances compare to 32 bits. Such as longer startup time and first time open a particular screen.
    • For an example: Giving a Lenovo ThinkPad W510 have an i7 intel CPU, that's a 64 bits CPU. The RAM can be extended up to 16Gb. (Only usable if you install a 64 bits OS). So your ThinkPad W510 is capable of running any 64 bits operating system, and ONLY a 64 bits OS can allow you to really access it's full capability.

  • Enhanced report performance of Profit and Loss Listing (Multi Level); Profit and Lost Listing. Reduced from 30 minutes to less than 1 minute.  (Ticket: 116640)
  • Enhanced the control of document once import, disallowed the change of Supplier or Customer. (Example, in GRN, import from PO, then supplier would be dimmed until doc saved.) (Ticket: 117179)
  • Enhanced User Location Fast Assignment for the performance of record saving. It would be reduced from 3-5 min (for scenario of 200+ users and 40+ locations) to less than 1 min (It would be perform saving for only those modified records). (Ticket: 116469)
  • Enhanced the Migration Wizard (SmartSQL to DynaMod) to limit the SmartSQL database name by maximum 20 characters to prevent error during the process. The process would be check and prompt friendly reminder message if the SmartSQL database name length is more than 20 characters. (Ticket: 117229)
  • Enhanced B.I Report - Pivot Format to allow create, save and restored for new unbound fields (formula). (Ticket: 116304)
  • Enhanced database validation by added follow validate tasks: (Ticket: 117212)
    • Purchase Order (Quantity Over Matched)
    • Goods Receive Note (Quantity Over Matched)
    • Sales Order (Quantity Over Matched)
    • Delivery Order (Quantity Over Matched)
    • Stock Transit (Quantity Over Matched)
  • Added Generate Customer Invoice function for SiteGiant Orders
  • Enhanced Stock Aging Listing, the stock value would be referring to the As At Date unit cost with the location balance quantity whenever has location filtered. (Ticket: 116686)
  • Enhanced Subsidiary Synchronize of Multiple Barcode by not sync the record if the barcode already been assigned in Stock Maintenance. (Ticket: 115881)
  • Enhanced database validation by added follow validate task: (Ticket: 117099)
    • Salesman
  • Enhanced Stock Transfer for checking over matched from Stock Transit, the system would alert user upon document being posted.  (Ticket: 115915)
  • Enhanced checking of document whether had been over matched: (Ticket: 117211)
    • Supplier Invoice - Check whether over matched for imported Purchase Order, Goods Receive Note.
    • Goods Receive Note - Check whether over matched for imported Purchase Order.
    • Goods Return Note - Check whether over matched for imported Goods Receive Note.
    • Customer Invoice - Check whether over matched for imported Sales Order, Delivery Order.
    • Customer Delivery Order - Check whether over matched for imported Sales Order.
    • Customer Delivery Return - Check whether over matched for imported Delivery Order.
  • Enhanced Subsidiary Company Sync Stock Process in DynaMod Process Manager 2019.1 Build 0009 to prevent of Stock being synced but without location price price being generated. The process would be always attempt to generate any missing entries for subsidiary company location's price whenever the stock being sync is newly create or exists with update. (Ticket: 115486)



Closed Issues List

  • Fix Customer Invoice -> MORE -> Import from Subsidiary Purchase Order incorrect spelling. (Ticket: 116343)
  • Fix Stock Matrix Description 1 missing after selecting Brand/Group/Category (Ticket: 116454)
  • Fix empty Subtract Stock value for SiteGiant variant product (DynaMod Process Manager)
  • Fix Trial Balance report where the Suppress Zero logic would caused account's figure unable accumulated from previous year of PNL. (Ticket: 116418)
  • Fix multi-currency adjustment on Gain/Loss Posting whenever knock-off using Opening Payment Voucher. (Ticket: 116185)
  • Fix Customer Statement where by the footer currency ID should presented as Transaction's Currency ID and should not be Customer's currency ID.  (Ticket: 116342)
  • Fix the stock take record (whenever Is Hold was marked) would always marked as pending posting after processed by DynaMod Process Manager. (Ticket: 116571) 
  • Fix Sales and Service Tax Reports, the tax code filtering should be filtered accordingly with it's tax type whenever Filter by Range or Filter by Multi-Select. (Ticket: 116602)
    • Sales Tax Supply Listing
    • Sales Tax Tax Code Daily Summary
    • Service Tax Supply Listing
    • Service Tax Tax Code Daily Summary
  • Fix Master Code Updater, the sentence of column required was incorrectly stated. It should be ValueFrom, ValueTo. (Ticket: 116624)
  • Fix Customer Statement for ReportTypeOption 1, 2 and 3 where it does not show the knock-off transactions with still have negative balance causing the differences if compare with Report Option "Balance B/F" (Ticket: 116421)

  • Fix Purchase Request Listing by removed column SSTExemptionCertNumber and AcTariffID.
  • Fix Purchase Request Outstanding Listing by removed column SSTExemptionCertNumber and AcTariffID.
  • Fix Customer Statement for Balance B/F + Open Balance (By Document Date) where it show incorrect figures if compare with other ReportTypeOption 0, 1 and 2 (Ticket: 116757)

  • Fix Customer Aging Summary Listing Report of suppress zero (Ticket 116756)
  • Fixed SiteGiant Order screen freeze when unable to download orders
  • Fixed SiteGiant Match Product error message not specified
  • Fixed SiteGiant Product Match By Import File incorrect description in error log
  • Fixed Settle Supplier/Customer Credit or Advance able to apply amount more than the payment amount. (Ticket: 116186)
  • Fixed import of document to document (eg: Purchase Order to Suplier Invoice) does not filter by currency. (Ticket: 116315)
  • Fixed Supplier Opening will remove statement record of other Supplier if both document is using same supplier document number. (Ticket: 116195)
  • Fixed Stock Take Generate New Stock List does not reflect the default cost if the particular UOM does not have any transaction history. (Ticket: 116307)
  • Fixed Location Control does not automatically populate the module list when creating a new company. (Ticket: 116364)
  • Fixed discount amount calculate incorrectly when the item quantity is negative and the company GST/SST is disabled. (Ticket: 116353)
  • Fixed delete POS User Group will prompt error. (Ticket: 116667)
  • Fixed Supplier able to delete after creating document that does not involve stock and account posting. (Ticket: 117092)
  • Fixed Adidas Franchisee Integration error prompted and unable to connect to sftp. Error: Unable to connect to SFtp server. Key exchange failed. Requested service is not implemented. (Please update DynaMod Process Manager to 2019.1 Build 0009 as well.) (Ticket: 117141)

  • Fix Customer Credit Limit/Term Approval, the "Check Is Online" function not reflected correct Online Status of approval (Always shown max 1 online approver only). Suppose it should show the corresponding online approvers. (Fix in DynaMod Server Socket 2019.1 Build 0003). (Ticket: 116287)
  • Fix POS Simulation screen Recalculate Member Point when changing Customer ID (Ticket: 117245)