1.0.0.1 ----------------- [Fix] 1) speed up the EDC processing time 1.0.0.2 ----------------- [Fix] 1) Solve the issue of sales refund save under document Type = 7 in Logo, the sales refund should under type=2 1.0.0.3 ----------------- [Fix] 1) Solve the issue of sales refund, never reset back the document type, caused next normal sales all under type=2 1.0.0.4 ----------------- [Fix] 1) C1 Stock Return - supplier value to Logo should be taken "Process At" (s_store_key) instead of supplier code(s_supplier) 2) Skip the duplicate Item or ARAP write to log file 3) Include the SAP sales POS module 1.0.0.5 ----------------- [Fix] 1) Stock Return - waybill return sales invoice (C2) 2) DO / IB no need upload to Warehouse Entity 3) Adjustment only involved C2 1.0.0.6 ----------------- [Fix] Logo 1) Include the response failed return message in log file 2) Add item into Logo when found the return message is "Item not found" / "stok kodu bulunamadı" 1.0.0.7 ----------------- [Fix] Logo 1) Source Warehouse is retrieve from mas_store.M_CREDITOR_ACC 2) POS transaction split invoice into normal sales, eInvoice or eArchieve 1.0.0.8 ------------- [Fix] Logo 1) update the Qube Backend if is a duplicate data 2) include column "S_ACCTLINK_REMARK" in C2 stk_mledger as well SAP 1) Stock balance - Journal 1.1) Cater for consolidate table for warehouse and retail in one db 1.0.0.9 ------------- [Fix] Logo 1) Include the Stock Transfer (store to store) in MaterialSlip Waybill SAP 1) POS customer sales - Include fix prefix "Q" in VAT# when upload to SAP 1.0.0.10 ------------- [Fix] SAP 1) Combine card (Visa & Master) into one type "CARD" 1.0.0.11 ------------- [Fix] Logo 1) getToken within 1 hour instead of 3 hours 2) IB/DO waybill get the transit date instead of document date SAP 1) POS Sale and Return 1.1) Include Resend parameter to resend transaction to avoid duplicate 1.1.1) Header = "SINV"--- => seq default is "1" and resend based on parameter 1.1.2) External ID = -- => if resend will have (C) 1.1.2) Parameter -A -SAP_SALES_RESEND -MM003 -T2 -03/27/2022 -2 1.0.0.12 ------------- [Fix] Logo 1) Add store into Logo when found the return message is "Store code not found" / "cari kodu bulunamadı" 2) force skip add item and supplier/customer unless it's calling from acctlink 3) recall the getToken function if return 401 Authorise status code 1.0.0.121 ------------- [Fix] Logo 1) POS sales order by close date and include the date in log file as well 1.0.1.0 ------------- [New Features] Logo 1) Include the Payment Slip API for CARD and CASH 2) Bank code in CARD API need to be maintained in Qube backend > Store > Remark column. 1.0.1.1 ------------- [Fix] Logo 1) assign the cash and card number with fix assign value instead of '~' to avoid double upload 1) payment slip cash > number change the number using -- 2) payment slip card > number change the number using - 1.0.1.2 ------------- [Fix] Spain 1) Cater for multi invoice for same DO - receiving via QTA 1.0.1.3 ------------- [Fix] Turkey 1) Split the payment web service from sales web service call 1.0.1.4 ------------- [Fix] Turkey 1) Send multi reciept in one Json file - per store per close date 2) Allow parameter by store and closedate 2.1) -A -SALES -07/23/2022 -MI016 1.0.1.5 ------------- [Fix] Turkey 1) Adhoc parameter for eWayBill by S_ID 1.1) Parameter = A EWB 1.0.1.6 ------------- [Fix] Turkey 1) eWayBill (adhoc) by SID & eWayBill by batch 1.1) using S_SHIPDATE instead of S_TRANSITDATE 1.0.1.7 ------------- [Fix] Turkey 1) assign SOURCH_WH = 0 if not found from supplier M_CREDITOR_ACC 2) change the add item function if item not found 2.1) only add those not found item instead of looping all stk_sledger 1.0.1.8 ------------- [Fix] Turkey 1) eWaybill passing key change 1.0.1.9 ------------- [Fix] Turkey 1) eWaybill Json header value change 1.1) "ARP_CODE": "120.01.01.01.001" (from store code to this value, and maintain in WebAcctLink.ini > COMPANYID_WH) 1.2) "SHIPLOC_CODE": "MT001" (store code) 1.0.1.10 ------------- [Fix] Spain 1) Journal Web service 1.1) parameter with additional run for current month or previous mth option and specific wanted yyyyMM 1.1.1) eg. -A -SAP_JRN -1 -202202 1.2) igore if open and close balance = 0 2) PO and GR Web service 2.1) Delivery date = Qube invoice date 2.2) additional section in GR web service 1.0.1.11 ------------- [Fix] Turkey 1) POS Sales / Sales Return bulk upload 1.1) regular invoice = to be sent in bulk 1.2) e-invoice = one-to-one 1.3) e-archive invoice = one-to-one 1.0.1.12 ------------- [Fix] Spain 1) IB/DO 1.1) send the transaction per month per store 1.2) using the costtotal instead of nettotal 1.0.1.13 ------------- [Fix] Turkey 1) POS Sales 1.1) rename the Doc# when hit the duplicate 1.1.1) This is because some store delay update sales back to HQ and miss out in bulk list upload to Logo 1.1.2) Next day when upload again will hit duplicate because of doc# format is based on ddMMyyyy Spain 2) PurchaseOrder 2.1) additional section to maintain the Qube Stock Receive's Remark 3) Good Receive web services 3.1) additional resend function mainly for good receive 3.1.1) -A -SAP_R_RESEND - - 1.0.1.13 ------------- [Fix] Turkey 1) POS Sales & Payment 1.1) Use the sales_datetime and pymt_datetime as close date 1.0.1.14 ------------- [Fix] Turkey 1) use s_shipdate instead of s_transitdte when direct call from Qube backend IB or DO 1.1) parameter for direct calling from backend IB/DO >> EWB 2) include current day (dd) in the sales transaction to avoid duplicate when some of the sales record late upload to backend 3) try upload again for sales record if failed but return nothing. 1.0.1.15 ------------- [Fix] Turkey 1) using upload date instead of payment date in json >>"NUMBER" to avoid duplicate when some of the payment record late upload to backend 1.1) format: "NUMBER":--. E.g "NUMBER":"MK001-221125-70" 1.0.2.0 ------------- [New] India SAP 1) New implementation 2) Supplier SAP 2.1) maintain in mas_supplier.M_CREDITOR_ACC 2.2) post code cannot empty, default to 000000 if empty value found 2) IB / DO 2.1) using the invoice date (stk_mledger.s_validdate) Turkey Logo 1) change the docnumber to include the process date (dd), new format will be _- 2) cancel the resend process when detected duplicate return response from Logo 2.1) resend duplicate action is to solve the partial data was not sync back to backend (DCS) but this solution was not working 2.2) changing the docnumber to include process date should solve the partial upload data. 1.0.2.1 ------------- [Fix] India SAP 1) IB/DO + IB/DO GRN 1.1) existing flow = retrieve IB/DO status = 'P' and upload to SAP and create PO simultaneously 1.2) New Flow = retrieve IB/Status where s_date is 2 days before, regardless status P or H. If IB/DO status='P' only create PO in SAP 1.0.2.2 ------------- [Fix] India SAP 1) POS Sales 1.1) change value for item line to sales unit ID instead of Company ID 1.0.2.3 ------------- [Fix] Spain SAP 1) IB’s: 1.1) Cost: Now it considers “s_total”, which is cost at store level 1.2) VAT: Now the cost is the net VAT base and VAT is 21% on top of that - change following neteris instructions on 2 codes (PPSTD1, 7PR1) 1.3) Dates: We consider posting date and status P to determine the month 1.4) Type: We only include those IBs sent by the WH, not store transfer, so we only include IBs with transit date not blank 2) DO 2.1) Cost: Now it considers “s_total”, which is cost at store level 2.2) VAT: Now the cost is the net VAT base and VAT is 21% on top of that - change following neteris instructions on 2 codes (PPSTD1, 7PR1) 2.3) Dates: We consider posting date and status P to determine the month 1.0.2.4 ------------- [Fix] India SAP 1) Include action to write the error to Log when perform getSalesUnitID function 1.0.2.5 ------------- [Fix] 1) Turkey Logo (03-Oct-2023) 1.1) Use the eINV/eARCV invoice# as DOC_NUMBER instead of Qube's reference# 2) India SAP (09-Oct-2023) 2.1) reset the Journal "Set of Books" = empty 2.2) make this value as variable in INI file 1.0.2.6 ------------- [Fix] 1) Turkey Logo (20-Dec-2023) 1.1) customer invoice tag change from a8l:TotalQtyCIRqst to a8l:TotalQtyCIRqst1 1.2) include check API for GRN and customer invoice 1.0.3.0 ------------- [New] 1) Vietnam API Integration for e-invoice 1.1) POS Sales 1.2) Internal Billing 1.3) Delivery Order 1.4) Refund POS Sales 1.5) Refund Return Order 1.6) E-Waybill Internal Billing 1.7) E-Waybill Delivery Order 1.0.3.1 ------------- [Fix] 1) Allowed filter by store which set in INI file 1.0.3.2 ------------- [Fix] 1) POS refund and IB/DO stock return skip upload if EInvoice and item not found in original document 1.0.3.3 ----------- [Fix] 1) MR.DIY SPAIN 1.1) additional module to allow resend Customer Invoice by argument 1.1.1) Argument = -A -SAP_SALES_INV_RESEND - - - - 1.0.3.4 ------------- [Fix] 1) Added date filter during search for those empty invoice no. when call the API to get invoice no. by group ID 1.0.4.0 ------------- [New] 1) Vietnam SAP Integration 1.1) Purchase Receive - Stock Receive 1.2) Purchase/IB Return - Stock Return 1.3) Internal Billing 1.4) Delivery Order 1.5) Sales 1.6) Sales Return 1.7) Journal 1.0.5.0 ------------- [New] 1) Added QASLibrary.dll, FDBXURS.NET 2) WebApiAcctLinkAgent.exe.config add key="FDBXURS_FILE". Modify value accordingly. If key="FDBXURS_FILE" not set in config file, default value = "D:\QasDev\FDBXURS.NET" 20.0.5.1 ------------- [Fix] 1) (26-Feb-2024) Added another item description prefix [ITEMDESCREFUND] into [EINVOICE] in .ini file for refund 2) (28-Feb-2024) For EInvoice, change the document start date from "DOCSTART" to "EINV_DOCSTART" 20.0.5.2 (13-Mar-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) EInvoice invoice API 1.1.1) Issue: connection issue when connect to POSSYS to get the store GSTNo and SeriesID caused metadata and seriesID empty in json file 1.1.2) Solution: default the metadata if empty and connect once again to mas_store if seriesID is empty 1.2) SAP API 1.2.1) IB&DO "comment" column upload using the invoice# instead of refno 2) MRDIY Spain 1.1) new SAP Tax code 321 for tax4 0% 1.2) split the standard product code (10000000) and non inventory (10000001) based on the tax code. 1.3) make the tax code and product code flexibility by reading from INI file 20.0.5.3 (14-Mar-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) Sales refund unit price calculation error. Issue when refund qty > 1, system did not calculate the unit price by divided by qty. 20.0.5.4 (18-Mar-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) Refund summary note 1.1.1) Serial ID is referring to original invoice# instead of M_REMARK in mas_store. First 6 digits of the invoice = serial ID 20.0.5.5 (08-Apr-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) SAP - IB & DO & SR 1.1.1) S_TOARSYS not updated accordingly if the S_ID contain invoice number. 1.2) SAP - Return Order C2 1.2.1) URL was not initialise caused error "Object reference not set to an instance of an object" 1.3) EINVOICE - Search 1.3.1) Search function query issue for IB & DO, missing S_STORE_FROM in the query. 20.0.5.6 (25-Apr-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) EINVOICE - Search 1.1.1) Search function query issue for IB & DO, change S_TOARSYS='I' to S_TOARSYS IN ('I','T'). 1.2) SAP - IB/DO 1.2.1) include the S_EINVOICE in SAP IB/DO "Comment" field 1.2.1.1) eg comment = - 1.2.2) for IB/DO the GST code and GST amt should refer to _O (Output tax) instead of _I (Input tax) 20.0.5.7 (07-May-2024) -------------- [Fix] 1) MRDIY Vietnam 1.1) SAP - Receiving 1.1.1) reflected when IB/DO changes to refer to _O (Output tax) 1.1.2) for Receiving should refer to _I (Input tax) 20.0.5.8 (07-June-2024) -------------- [Fix] 1) Turkey Logo 1.1) Sales type 4 (refund) and type 7 (invoice) must use different document ID, else will hit duplicate issue 1.2) EWB - waybill direct from DO 1.2.1) using the shipdate instead of transit date 1.2.2) log the json request 20.0.5.9 (26-June-2024) -------------- [Fix] 1) Turkey Logo 1.1) Split the sales document number based on store + ctrno to avoid line limitation (20,000) in Logo 1.1.1) document format changed to 1.2) skip the product upload if s_plulinkid = '' 1.3) change the counter number value from 3 digits to 2 digits. eg T01 > T1 (27-Jun-2024) 1.4) write all the response (fail) to log (27-Jun-2024) 20.0.5.10 (28-June-2024) -------------- [Fix] 1) India SAP 1.1) change the query for POS sales payment to filter PYMT_ACTPAID > 0 to PYMT_ACTPAID >= 0 to cater for rounding fall in PYMT_ACTPAID = 0 line. 20.0.5.11 (02-July-2024) -------------- [Fix] 1) Turkey Logo 1.1) Skip to include the item line when plucode is empty 20.0.6.0 (2023-02-19) ------------- [New] 1) Enterpryze 1.1) Sales Invoice API, send summed transaction of all sales 1.2) Sales Credit Note, Sales Return, Payment Incoming, available but not used 1.3) Add [ENTERPRYZE] for setting ini 1.4) Param : -A -API_EP_SALES_INVOICE -2023-02-19 1.5) Param : -A 20.0.7.0 (2024-07-14) ------------- [New] 1) LHDN E-Invoice 1.1) Sales Invoice, Refund, Credit Note API 1.2) Add [LHDN] for setting ini 1.3) Add NuGet UblSharp, for UBL standard for xml document 2) Vietnam EInvoice 2.1) using the new EInvoice.fdb to get the buyer information