File manager - Edit - /home/aussies6/mail/seafoodwarehouse.com.au/ianhamilton/cur/1779255838.M785498P1772392.au6.voltdns.com,S=36784,W=37573:2,S
Back
Return-Path: <SRS0=NYFW=DR=datapel.com=support@voltdns.com> Delivered-To: ianhamilton@seafoodwarehouse.com.au Received: from au6.voltdns.com by au6.voltdns.com with LMTP id B3GhLh5KDWpoCxsATr7HEg (envelope-from <SRS0=NYFW=DR=datapel.com=support@voltdns.com>) for <ianhamilton@seafoodwarehouse.com.au>; Wed, 20 May 2026 15:43:58 +1000 Return-path: <SRS0=NYFW=DR=datapel.com=support@voltdns.com> Envelope-to: ianhamilton@seafoodwarehouse.com.au Delivery-date: Wed, 20 May 2026 15:43:58 +1000 Received: from thecleaner2.voltdns.com ([107.174.176.192]:38374) by au6.voltdns.com with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.99.2) (envelope-from <SRS0=NYFW=DR=datapel.com=support@voltdns.com>) id 1wPZiq-00000007R4V-0jAD for ianhamilton@seafoodwarehouse.com.au; Wed, 20 May 2026 15:43:58 +1000 Received: from localhost (localhost.localdomain [127.0.0.1]) by thecleaner2.voltdns.com (Postfix) with ESMTP id 4gL0pN2wwSz1bcN for <ianhamilton@seafoodwarehouse.com.au>; Wed, 20 May 2026 01:43:56 -0400 (EDT) X-Virus-Scanned: Scrollout F1 at voltdns.com X-Spam-Level: ** Authentication-Results: thecleaner2.voltdns.com (amavisd-new); dkim=pass (2048-bit key) header.d=datapel.com Received: from thecleaner2.voltdns.com ([127.0.0.1]) by localhost (thecleaner2.voltdns.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id wD9jpsh3hP-8 for <ianhamilton@seafoodwarehouse.com.au>; Wed, 20 May 2026 01:43:42 -0400 (EDT) Received: from mail-pf1-f172.google.com (mail-pf1-f172.google.com [209.85.210.172]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by thecleaner2.voltdns.com (Postfix) with ESMTPS id 4gL0p614Ylz1bcG for <ianhamilton@seafoodwarehouse.com.au>; Wed, 20 May 2026 01:43:42 -0400 (EDT) Received: by mail-pf1-f172.google.com with SMTP id d2e1a72fcca58-82f8893bff3so2030262b3a.2 for <ianhamilton@seafoodwarehouse.com.au>; Tue, 19 May 2026 22:43:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=datapel.com; s=google; t=1779255821; x=1779860621; darn=seafoodwarehouse.com.au; h=sent-on:content-transfer-encoding:subject:references:in-reply-to :message-id:cc:to:reply-to:from:date:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=D16RI4lQiaPUobntljNmW3UQkpBg0UW0ogC2ldahQ4E=; b=gESSFvz7mkkG2CGeoRCnlNUfrUmPiWvCAkgrxhrWY3YCVaFJ9SUXln6q0UUeN2qAU4 PJBB9t/XK+Fb/cQD6a5YWDrfZp9nNC1cbNyOZS03MYTu7aqYDTIIdGnCpcWLQkukFILC RB+uFRN3n2p5xHJPK76gKyacehZ3XyJo11QWTayGEZ+5UcPNFXKsKurRIP2L18HP5sLv YiBGgDiil5FcrrdIdO8NvALWF5QaWFCHOFNYffHqDPtFYw/SB8Ck0F73Wu3hF+Pc/vMY kqvW7XM3j7E2gDmruWGw7KtSyNqM7naPr0fwHHTEhg+4dhH1y0lRt5fNa3gWWywY6EvC v4QA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779255821; x=1779860621; h=sent-on:content-transfer-encoding:subject:references:in-reply-to :message-id:cc:to:reply-to:from:date:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=D16RI4lQiaPUobntljNmW3UQkpBg0UW0ogC2ldahQ4E=; b=GiGuV7EGXqE8dakV2qC8htDvcaXwkEnDBVkcq/uIaiQodLEEvcvXcY8CxQOVbBDq5+ igZVu+rw5/poRKtDJwmIN01z+ZeFuQE1KgykC93rkY3q53p7rASZ9g8O1B/FMotj973d 6+smiNM6b/lBE58gBDp4zdHoY/q7yfJ/8ukDJ3AX3C9nkPqioRC9itfQPxZeMpOyphGZ 9s1mtMSWsRRgnMxkvn2vLMtHFBJALnClHdGLGdYHv+E1Q1WRPVvBQ9sxU4NxliK+UvXE C4deqOn78/AfllSm08Vxi7+Dj53hOdjPa14mE+h2D5rOwb6jLBltvziCA76jlct5aLmo LubA== X-Gm-Message-State: AOJu0YyINzzgfESuLsMusu3amDtn1diPylIazQAxQLsREUaLOYh0mUc3 nwl/pmOVCq7dt9Bhhwu/wqDmYMjYF7GgA+kfTZjVq3IKudhbnLKsPgqpTRTL4Ea3/hdWYP89wXE WPEq3 X-Gm-Gg: Acq92OF4Y5QFCuYnkjurdG3cTU7TCMVtH6qBIpBMejvBNTBJ+QeU4UYWmbBIQsQ8N1p /D8m73/1wvKBYv4GUrFk2OV0Zw5ZKAoruEuVZ0xyma6V7spUFlqI9AsNzD9o6B2sz1YgI44awD6 hI77qUoltrNX0ytHsooJOQhNj40Ggpo66CQy2y87+uHuV2WxsN81L6r3dmUjTVkrXMGN5SsY2oa 4zLNeQngrfOM1eYICi3EIUHO0PhAM1XaX5dm6ydXBdQ9dN40ilX+oPKyx2p3GCSDxIzCWvLdsHl /t2B2qoPUd4ZnVYSU54LDvjF7cVsQL+sHjq4yBpuTuHMJHgoMB3YYjXEAN2cvEz8/AduAtvcf4m wjUY8ecRv3uD02h16QdrA+WDW1njo+ecE8EwTnovMnK0wqHi7xfzk2teZSwaQvWPC36JDs8sSt6 ttgNuLCVt22hAqKEjFjL4fva6L9C4gvweyRMByZOVyVB3UZwUPn50vS8BQYVfyPG8lBf8um7oc1 GzSKwzE4NGhO1QuUCMg8XvMtw== X-Received: by 2002:a05:6a00:a221:b0:83c:5e:f647 with SMTP id d2e1a72fcca58-83f33d39e99mr21945689b3a.29.1779255820649; Tue, 19 May 2026 22:43:40 -0700 (PDT) Received: from emailteam (ec2-52-62-151-40.ap-southeast-2.compute.amazonaws.com. [52.62.151.40]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-83f197815cesm24335455b3a.24.2026.05.19.22.43.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 19 May 2026 22:43:40 -0700 (PDT) MIME-Version: 1.0 X-Received: from ip-10-21-147-242.ap-southeast-2.compute.internal (EHLO freshdesk.com) ([10.21.147.242]) by mxau.freshdesk.com (Freshworks SMTP Server) with ESMTPA ID e16d212f.; Wed, 20 May 2026 05:43:36 +0000 (UTC) Date: Wed, 20 May 2026 05:43:36 +0000 From: Datapel <support@datapel.com> Reply-To: Datapel <support@datapel.com> To: lee@seafoodwarehouse.com.au Cc: ianhamilton@seafoodwarehouse.com.au Message-ID: <6a0d4a08a013e_1e8626b0783946.sidekiq-frequent-fd-podapsoutheast2-main-blue-665cf86774-wgxj6@email.freshdesk.com> In-Reply-To: <00d501dce816$11764380$3462ca80$@seafoodwarehouse.com.au> References: <005c01dce7f4$18ac6520$4a052f60$@seafoodwarehouse.com.au> Subject: Re: 135279 [Seafood Warehouse] Assistance Required: Report including Inactive Items and Incorrect Stock Content-Type: multipart/alternative; boundary="--==_mimepart_6a0d4a08a7f8d_1e8626b078401f"; charset=UTF-8 Content-Transfer-Encoding: 7bit sent-on: 2026-05-20 05:43:36 +0000 X-FUP-PRIORITY: 5 ----==_mimepart_6a0d4a08a7f8d_1e8626b078401f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Lee, Upon further investigation into the live database data that feed= s your stock report We have isolated the exact data discrepancy causing = your macro to fail, and we want to ensure your team has the exact informa= tion needed to resolve it. What is happening: When your template requ= ests raw data from the WMS database, it is pulling a hidden system-level = placeholder batch known as the "Void Batch" (STK_BatchListID =3D 1). When= items are deactivated in the system, they are parked here with an intern= al system overflow value (1073741823). Because your report does not filte= r this batch out, Excel reads that internal code as a physical quantity o= f over 1,000,000 kg, which alters your table dimensions and causes the ma= cro to crash on a Runtime Error 1004. =C2=A0 Please reach out to Domi= nic to update the BI report update the underlying connection query or vie= w. They might need to add an exclusion filter to the SQL statement. =E2= =80=8B Kind Regards, Mhoana=C2=A0Gayoso Datapel Systems Pty. Ltd. = E: =C2=A0support@datapel.com P: =C2=A01300 137 082 F: =C2=A01300 134 95= 5 https://help.datapel.com/=C2=A0 =C2=A0 =0D =0D On=0D Wed, 20 May at 3:04 PM=0D , Lee <lee@seafoodwarehouse.com.au> wrote:=0D= =0D =0D =0D Hu, =0D =C2=A0 =0D Yes, I understand that the report was initially created by Dominic, the = error is not in the report itself but the information it is retrieving di= rectly from WMS. =0D =C2=A0 =0D Can you please investigate why the items with ~ as the batch number and = stock description #000x-xxxxx are showing as current stock with 1073742.8= 23 quantity available. =0D =C2=A0 =0D Thanks =0D =C2=A0 =0D =C2=A0 =0D =0D =C2=A0 =0D Lee Hanner =0D Administrator =0D =0D Seafood Warehouse=0D =0D 6 Industry Place =0D Capalaba Q 4157 =0D =C2=A0 =0D Ph: +61 7 3245 7008 =0D =C2=A0 =0D =0D =0D =0D From: Datapel [mailto:support@datapel.com] Sent: Wednesday, 20 May 2026= 2:09 PM To: lee@seafoodwarehouse.com.au Subject: Re: 135279 [Seafood War= ehouse] Assistance Required: Report including Inactive Items and Incorrec= t Stock=0D =0D =C2=A0 =0D =0D =0D =0D Hi Lee, =0D =C2=A0 =0D Thank you for your patience. =0D We have reviewed the report and it appears to be created by Dominic. As= the issue appears to be related to the report structure and logic, pleas= e reach out to Dominic directly for further investigation and assistance.= =0D =C2=A0 =0D If you require anything further from our side, please let us know. =0D= =0D =0D Kind Regards, =0D =0D Mhoana=C2=A0Gayoso Datapel Systems Pty. Ltd. =0D =0D =0D E: =C2=A0support@datapel.com =0D =0D P: =C2=A01300 137 082 =0D F: =C2=A01300 134 955 =0D =0D https://help.datapel.com/=C2=A0 =0D =0D =C2=A0 =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =0D =0D =0D On Wed, 20 May at 1:56 PM , Datapel <support@datapel.com> wrote: =0D =0D =0D =0D Hi Lee, =0D Thank you for reaching out. I am reviewing the issue and will provide = you with an update as soon as possible. =0D =C2=A0 =0D Kind Regards, =0D =0D =0D =0D Mhoana=C2=A0Gayoso Datapel Systems Pty. Ltd. =0D =0D =0D E: =C2=A0support@datapel.com =0D =0D P: =C2=A01300 137 082 =0D F: =C2=A01300 134 955 =0D =0D https://help.datapel.com/=C2=A0 =0D =0D =C2=A0 =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =0D =0D =0D On Wed, 20 May at 11:02 AM , Lee <lee@seafoodwarehouse.com.au> wrote: =0D= =0D =0D Hi=0D =0D We are currently experiencing issues with one of our reports that gathe= rs information from WMS. The report appears to be including:=0D =0D =0D Items that are inactive, identified by a ~ in the batch number. =0D =0D Available quantities for stock that does not exist. =0D =0D =0D These issues are causing errors with the macros in the report.=0D =0D I have attached a sample spreadsheet for your reference. Could you plea= se investigate this issue and advise on the necessary corrections so that= the report only includes active items and accurate stock quantities?=0D =0D Thank you for your assistance.=0D =0D Thank you for your assistance.=0D =0D =C2=A0 =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =C2=A0 =0D =0D =0D =0D =C2=A0 =0D =C2=A0 =0D =C2=A0 =0D =0D Lee Hanner=0D =0D =0D Administrator=0D =0D =0D Seafood Warehouse =0D =0D =0D 6 Industry Place=0D =0D =0D Capalaba Q 4157=0D =0D =0D =C2=A0=0D =0D =0D Ph: +61 7 3245 7008=0D =0D =C2=A0 =0D =0D =0D =0D =0D =0D =0D 135279:3931932=0D =0D =0D =0D =0D =0D ----==_mimepart_6a0d4a08a7f8d_1e8626b078401f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable <div style=3D"font-family:-apple-system, BlinkMacSystemFont, Segoe UI, Ro= boto, Helvetica Neue, Arial, sans-serif; font-size:14px;">=0D <div style=3D"font-family:-apple-system, BlinkMacSystemFont, Segoe UI, R= oboto, Helvetica Neue, Arial, sans-serif; font-size:14px">=0D <div dir=3D"ltr">=0D <div dir=3D"ltr">Hi Lee,<br><br>Upon further investigation into the live = database data that feeds your stock report</div>=0D <div dir=3D"ltr">We have isolated the exact data discrepancy causing your= macro to fail, and we want to ensure your team has the exact information= needed to resolve it.</div>=0D <div><br></div>=0D <div dir=3D"ltr">What is happening:<br>When your template requests raw da= ta from the WMS database, it is pulling a hidden system-level placeholder= batch known as the "Void Batch" (STK_BatchListID =3D 1). When items are = deactivated in the system, they are parked here with an internal system o= verflow value (1073741823). Because your report does not filter this batc= h out, Excel reads that internal code as a physical quantity of over 1,00= 0,000 kg, which alters your table dimensions and causes the macro to cras= h on a Runtime Error 1004. =C2=A0</div>=0D <div><br></div>=0D <div dir=3D"ltr">Please reach out to Dominic to update the BI report upda= te the underlying connection query or view. They might need to add an exc= lusion filter to the SQL statement.</div>=0D <div style=3D'font-family: "Google Sans Text", sans-serif !important; lin= e-height: 1.15 !important; margin-top: 0px !important'><br></div>=0D <div style=3D'font-family: "Google Sans Text", sans-serif !important; lin= e-height: 1.15 !important; margin-top: 0px !important' dir=3D"ltr">=E2=80= =8B</div>=0D </div>=0D <div data-skip-ai-process=3D""><div dir=3D"ltr">=0D <div>=0D <br>Kind Regards,</div>=0D <div>Mhoana=C2=A0Gayoso<span style=3D'font-family: "Helvetica Neue", Helv= etica, Arial, sans-serif; font-size: 13px; font-style: normal; font-weigh= t: 400; text-align: initial'><br>Datapel Systems Pty. Ltd.</span>=0D </div>=0D <div style=3D'font-weight: 400; font-style: normal; font-size: 13px; font= -family: "Helvetica Neue", Helvetica, Arial, sans-serif'>=0D <span style=3D"text-align: initial">E: =C2=A0</span><a href=3D"https://he= lp.datapel.com/profiles/51065806446/support@datapel.com" rel=3D"noreferre= r" style=3D"background-color: rgb(255, 255, 255); text-align: initial" ta= rget=3D"">support@datapel.com</a>=0D </div>=0D <div style=3D'font-weight: 400; font-style: normal; font-size: 13px; font= -family: "Helvetica Neue", Helvetica, Arial, sans-serif'>P: =C2=A01300 13= 7 082</div>=0D <div style=3D'font-weight: 400; font-style: normal; font-size: 13px; font= -family: "Helvetica Neue", Helvetica, Arial, sans-serif'>F: =C2=A01300 13= 4 955</div>=0D <div style=3D'font-weight: 400; font-style: normal; font-size: 13px; font= -family: "Helvetica Neue", Helvetica, Arial, sans-serif'>=0D <a href=3D"https://help.datapel.com/" rel=3D"noreferrer" style=3D'font-we= ight: 400; font-style: normal; font-size: 13px; font-family: "Helvetica N= eue", Helvetica, Arial, sans-serif; background-color: rgb(255, 255, 255);= text-align: initial' target=3D"">https://help.datapel.com/</a><span styl= e=3D"text-align: initial">=C2=A0</span>=0D </div>=0D <div><span style=3D"text-align: initial"><br></span></div>=0D <div><span style=3D"text-align: initial">=C2=A0</span></div>=0D <div><span style=3D"font-size: 8pt; font-family: Tahoma, sans-serif; line= -height: 12.2667px; color: rgb(0, 0, 0); background-image: initial; backg= round-position: initial; background-repeat: initial"><img src=3D"https://= ci3.googleusercontent.com/mail-sig/AIorK4y3xgaGeR7hzdJaMp_c6xy40T0qjKRyS1= MSTkxCq0zj4TTSCoCj1jImQXPQrupOi5Pux_pvulzMIH5U" class=3D"fr-fic fr-dii"><= br><br></span></div>=0D <div style=3D"color: rgb(34, 34, 34); font-family: Arial, Helvetica, sans= -serif; font-size: small; font-style: normal; font-weight: 400"><br></div= >=0D </div></div>=0D <div class=3D"freshdesk_quote">=0D <div class=3D"freshdesk_attr">=0D On=0D Wed, 20 May at 3:04 PM=0D <span class=3D"separator">, Lee <lee@seaf= oodwarehouse.com.au> wrote:=0D </span>=0D </div>=0D <blockquote class=3D"freshdesk_quote" style=3D"= margin:0 0 0 .8ex;border-left:1px solid #ccc;padding-left:1ex">=0D <div class=3D"WordSection1">=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Hu,</span></di= v>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Yes, I underst= and that the report was initially created by Dominic, the error is not in= the report itself but the information it is retrieving directly from WMS= .</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Can you please= investigate why the items with ~ as the batch number and stock descripti= on #000x-xxxxx are showing as current stock with 1073742.823 quantity ava= ilable.</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>Thanks</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><img width=3D"= 464" height=3D"279" id=3D"Picture_x0020_1" src=3D"https://ausattachment.f= reshdesk.com/inline/attachment?token=3DeyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1Ni= J9.eyJpZCI6NTEzMDMxNTgwNjIsImRvbWFpbiI6ImRhdGFwZWwuZnJlc2hkZXNrLmNvbSIsIm= FjY291bnRfaWQiOjM5MzE5MzJ9.cdHlMKpwtPk6M0SJVerex_mw33mkLW_sCGg5nji839U" d= ata-id=3D"51303158062"></span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><b><span style=3D'font-size:11.0pt;font-family:"= Arial",sans-serif;color:gray'>Lee Hanner</span></b></div>=0D <div class=3D"MsoNormal"><b><span style=3D'font-size:11.0pt;font-family:"= Arial",sans-serif;color:gray'>Administrator</span></b></div>=0D <div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Calibri",sans-serif;color:#1F= 497D'>Seafood Warehouse</span><span style=3D'font-size:8.0pt;font-family:= "Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'></span>=0D= </div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:8.0pt;font-family:"Cali= bri",sans-serif;color:#1F497D'>6 Industry Place</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:8.0pt;font-family:"Cali= bri",sans-serif;color:#1F497D'>Capalaba Q 4157</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:8.0pt;font-family:"Cali= bri",sans-serif;color:#1F497D'>=C2=A0</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:8.0pt;font-family:"Cali= bri",sans-serif;color:#1F497D'>Ph: +61 7 3245 7008</span></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>=C2=A0</span><= /div>=0D <div class=3D"MsoNormal"><b><span lang=3D"EN-US" style=3D'font-size:11.0p= t;font-family:"Calibri",sans-serif'></span></b></div>=0D </div>=0D <div class=3D"freshdesk_quote"><blockquote class=3D"freshdesk_quote">=0D <div>From:<span lang=3D"EN-US" style=3D'font-size:11.0pt;font-family:"Cal= ibri",sans-serif'> Datapel [mailto:support@datapel.com] <br><b>Sent:</b> = Wednesday, 20 May 2026 2:09 PM<br><b>To:</b> lee@seafoodwarehouse.com.au<= br><b>Subject:</b> Re: 135279 [Seafood Warehouse] Assistance Required: Re= port including Inactive Items and Incorrect Stock</span>=0D </div>=0D <div class=3D"MsoNormal">=C2=A0</div>=0D <div>=0D <div>=0D <div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>Hi Lee,</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>Thank you for your patience.</span></div></div>=0D= <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>We have reviewed the report and it appears to be = created by Dominic. As the issue appears to be related to the report stru= cture and logic, please reach out to Dominic directly for further investi= gation and assistance.</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>If you require anything further from our side, pl= ease let us know.</span></div></div>=0D </div>=0D <div><div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'><br>Kind Regards,</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>Mhoana= =C2=A0Gayoso</span><span style=3D'font-size:10.0pt;font-family:"Helvetica= Neue",serif'><br>Datapel Systems Pty. Ltd.</span><span style=3D'font-siz= e:10.5pt;font-family:"Segoe UI",sans-serif'> </span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.0pt;font-family:"Helvetica Neue",serif'>E: =C2= =A0</span><a href=3D"https://help.datapel.com/profiles/51065806446/suppor= t@datapel.com" rel=3D"noreferrer"><span style=3D'font-size:10.0pt;font-fa= mily:"Helvetica Neue",serif;background:white'>support@datapel.com</span><= /a><span style=3D'font-size:10.0pt;font-family:"Helvetica Neue",serif'> <= /span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.0pt;font-family= :"Helvetica Neue",serif'>P: =C2=A01300 137 082</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.0pt;font-family= :"Helvetica Neue",serif'>F: =C2=A01300 134 955</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <a href=3D"https://help.datapel.com/" rel=3D"noreferrer"><span style=3D'f= ont-size:10.0pt;font-family:"Helvetica Neue",serif;background:white'>http= s://help.datapel.com/</span></a><span style=3D'font-size:10.0pt;font-fami= ly:"Helvetica Neue",serif'>=C2=A0 </span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal" style=3D"margin-bottom:12.0pt">=0D <span style=3D'font-size:8.0pt;font-family:"Tahoma",sans-serif;color:blac= k'><img width=3D"200" height=3D"60" id=3D"_x0000_i1031" src=3D"https://ci= 3.googleusercontent.com/mail-sig/AIorK4y3xgaGeR7hzdJaMp_c6xy40T0qjKRyS1MS= TkxCq0zj4TTSCoCj1jImQXPQrupOi5Pux_pvulzMIH5U" alt=3D"https://ci3.googleus= ercontent.com/mail-sig/AIorK4y3xgaGeR7hzdJaMp_c6xy40T0qjKRyS1MSTkxCq0zj4T= TSCoCj1jImQXPQrupOi5Pux_pvulzMIH5U"></span><span style=3D'font-size:10.5p= t;font-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-family:"Arial",sans-ser= if;color:#222222'>=C2=A0</span></div></div>=0D </div></div>=0D <div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>On Wed= , 20 May at 1:56 PM <span class=3D"separator">, Datapel <</span></span= ><a href=3D"mailto:support@datapel.com" rel=3D"noreferrer"><span style=3D= 'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>support@datapel.com<= /span></a><span class=3D"separator"><span style=3D'font-size:10.5pt;font-= family:"Segoe UI",sans-serif'>> wrote: </span></span><span style=3D'fo= nt-size:10.5pt;font-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <blockquote style=3D"border:none;border-left:solid #CCCCCC 1.0pt;padding:= 0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;mar= gin-bottom:5.0pt"><div>=0D <div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>Hi Lee,</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'><br>Thank you for reaching out.<br>I am reviewing= the issue and will provide you with an update as soon as possible.</span= ></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family:"Seg= oe UI",sans-serif'><br>Kind Regards,</span></div>=0D </div>=0D <div><div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>Mhoana= =C2=A0Gayoso</span><span style=3D'font-size:10.0pt;font-family:"Helvetica= Neue",serif'><br>Datapel Systems Pty. Ltd.</span><span style=3D'font-siz= e:10.5pt;font-family:"Segoe UI",sans-serif'> </span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.0pt;font-family:"Helvetica Neue",serif'>E: =C2= =A0</span><a href=3D"https://help.datapel.com/profiles/51065806446/suppor= t@datapel.com" rel=3D"noreferrer"><span style=3D'font-size:10.0pt;font-fa= mily:"Helvetica Neue",serif;background:white'>support@datapel.com</span><= /a><span style=3D'font-size:10.0pt;font-family:"Helvetica Neue",serif'> <= /span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.0pt;font-family= :"Helvetica Neue",serif'>P: =C2=A01300 137 082</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.0pt;font-family= :"Helvetica Neue",serif'>F: =C2=A01300 134 955</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <a href=3D"https://help.datapel.com/" rel=3D"noreferrer"><span style=3D'f= ont-size:10.0pt;font-family:"Helvetica Neue",serif;background:white'>http= s://help.datapel.com/</span></a><span style=3D'font-size:10.0pt;font-fami= ly:"Helvetica Neue",serif'>=C2=A0 </span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal" style=3D"margin-bottom:12.0pt">=0D <span style=3D'font-size:8.0pt;font-family:"Tahoma",sans-serif;color:blac= k'><img width=3D"200" height=3D"60" id=3D"_x0000_i1030" src=3D"https://ci= 3.googleusercontent.com/mail-sig/AIorK4y3xgaGeR7hzdJaMp_c6xy40T0qjKRyS1MS= TkxCq0zj4TTSCoCj1jImQXPQrupOi5Pux_pvulzMIH5U" alt=3D"https://ci3.googleus= ercontent.com/mail-sig/AIorK4y3xgaGeR7hzdJaMp_c6xy40T0qjKRyS1MSTkxCq0zj4T= TSCoCj1jImQXPQrupOi5Pux_pvulzMIH5U"></span><span style=3D'font-size:10.5p= t;font-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-family:"Arial",sans-ser= if;color:#222222'>=C2=A0</span></div></div>=0D </div></div>=0D <div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>On Wed= , 20 May at 11:02 AM <span class=3D"separator">, Lee <</span></span><a= href=3D"mailto:lee@seafoodwarehouse.com.au" rel=3D"noreferrer"><span sty= le=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>lee@seafoodware= house.com.au</span></a><span class=3D"separator"><span style=3D'font-size= :10.5pt;font-family:"Segoe UI",sans-serif'>> wrote: </span></span><spa= n style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'></span>=0D= </div></div>=0D <blockquote style=3D"border:none;border-left:solid #CCCCCC 1.0pt;padding:= 0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;mar= gin-bottom:5.0pt"><div><div>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">Hi<span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>= </span>=0D </div></div>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">We are currently experiencing issues with one of our reports that gat= hers information from WMS. The report appears to be including:<span style= =3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <ul type=3D"disc">=0D <li class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-botto= m-alt:auto;mso-list:l0 level1 lfo3">Items that are inactive, identified b= y a <span style=3D'font-size:10.0pt;font-family:"Courier New"'>~</span> i= n the batch number. <span style=3D'font-size:10.5pt;font-family:"Segoe UI= ",sans-serif'></span>=0D </li>=0D <li class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-botto= m-alt:auto;mso-list:l0 level1 lfo3">Available quantities for stock that d= oes not exist. <span style=3D'font-size:10.5pt;font-family:"Segoe UI",san= s-serif'></span>=0D </li>=0D </ul>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">These issues are causing errors with the macros in the report.<span s= tyle=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">I have attached a sample spreadsheet for your reference. Could you pl= ease investigate this issue and advise on the necessary corrections so th= at the report only includes active items and accurate stock quantities?<s= pan style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'></span>=0D= </div></div>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">Thank you for your assistance.<span style=3D'font-size:10.5pt;font-fa= mily:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div style=3D"margin-top:5.0pt;margin-bottom:5.0pt"><div class=3D"MsoNorm= al">Thank you for your assistance.<span style=3D'font-size:10.5pt;font-fa= mily:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'><img w= idth=3D"464" height=3D"279" id=3D"_x0000_i1029" src=3D"https://ausattachm= ent.freshdesk.com/inline/attachment?token=3DeyJ0eXAiOiJKV1QiLCJhbGciOiJIU= zI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTIsImRvbWFpbiI6ImRhdGFwZWwuZnJlc2hkZXNrLmNvb= SIsImFjY291bnRfaWQiOjM5MzE5MzJ9.jfQeeiVOJLNbcg8YK_W-KJhNWOdQjGh6N_3rZjMv7= 3s" alt=3D"https://ausattachment.freshdesk.com/inline/attachment?token=3D= eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTIsImRvbWFpbiI6= ImRhdGFwZWwuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjM5MzE5MzJ9.jfQeeiVOJLNb= cg8YK_W-KJhNWOdQjGh6N_3rZjMv73s"></span><span style=3D'font-size:10.5pt;f= ont-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'><img w= idth=3D"566" height=3D"270" id=3D"_x0000_i1028" src=3D"https://ausattachm= ent.freshdesk.com/inline/attachment?token=3DeyJ0eXAiOiJKV1QiLCJhbGciOiJIU= zI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTMsImRvbWFpbiI6ImRhdGFwZWwuZnJlc2hkZXNrLmNvb= SIsImFjY291bnRfaWQiOjM5MzE5MzJ9.FCU_CtSCy_5L0AsyggaNykaIrCC2qY0UhdOeGtWzc= Vw" alt=3D"https://ausattachment.freshdesk.com/inline/attachment?token=3D= eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTMsImRvbWFpbiI6= ImRhdGFwZWwuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjM5MzE5MzJ9.FCU_CtSCy_5L= 0AsyggaNykaIrCC2qY0UhdOeGtWzcVw"></span><span style=3D'font-size:10.5pt;f= ont-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'><img w= idth=3D"553" height=3D"327" id=3D"_x0000_i1027" src=3D"https://ausattachm= ent.freshdesk.com/inline/attachment?token=3DeyJ0eXAiOiJKV1QiLCJhbGciOiJIU= zI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTQsImRvbWFpbiI6ImRhdGFwZWwuZnJlc2hkZXNrLmNvb= SIsImFjY291bnRfaWQiOjM5MzE5MzJ9.P4nAkS5TucVnsismJcC8VmbIvCZRh7x-uf4jRzQa-= xo" alt=3D"https://ausattachment.freshdesk.com/inline/attachment?token=3D= eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTQsImRvbWFpbiI6= ImRhdGFwZWwuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjM5MzE5MzJ9.P4nAkS5TucVn= sismJcC8VmbIvCZRh7x-uf4jRzQa-xo"></span><span style=3D'font-size:10.5pt;f= ont-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'><img w= idth=3D"573" height=3D"285" id=3D"_x0000_i1026" src=3D"https://ausattachm= ent.freshdesk.com/inline/attachment?token=3DeyJ0eXAiOiJKV1QiLCJhbGciOiJIU= zI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTUsImRvbWFpbiI6ImRhdGFwZWwuZnJlc2hkZXNrLmNvb= SIsImFjY291bnRfaWQiOjM5MzE5MzJ9.VHTOg2z8FkC_2sSh0kM648SL2Xk6WpoGXNqOPpf7l= oA" alt=3D"https://ausattachment.freshdesk.com/inline/attachment?token=3D= eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6NTEzMDMwNTIzMTUsImRvbWFpbiI6= ImRhdGFwZWwuZnJlc2hkZXNrLmNvbSIsImFjY291bnRfaWQiOjM5MzE5MzJ9.VHTOg2z8FkC_= 2sSh0kM648SL2Xk6WpoGXNqOPpf7loA"></span><span style=3D'font-size:10.5pt;f= ont-family:"Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D <div><div class=3D"MsoNormal">=0D <b><span style=3D'font-size:10.5pt;font-family:"Arial",sans-serif;color:g= ray'>Lee Hanner</span></b><span style=3D'font-size:10.5pt;font-family:"Se= goe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <b><span style=3D'font-size:10.5pt;font-family:"Arial",sans-serif;color:g= ray'>Administrator</span></b><span style=3D'font-size:10.5pt;font-family:= "Segoe UI",sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Segoe UI",sans-serif'>Seafood= Warehouse</span><span style=3D'font-size:10.5pt;font-family:"Segoe UI",s= ans-serif'> </span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Segoe UI",sans-serif'>6 Indus= try Place</span><span style=3D'font-size:10.5pt;font-family:"Segoe UI",sa= ns-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Segoe UI",sans-serif'>Capalab= a Q 4157</span><span style=3D'font-size:10.5pt;font-family:"Segoe UI",san= s-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Segoe UI",sans-serif'>=C2=A0<= /span><span style=3D'font-size:10.5pt;font-family:"Segoe UI",sans-serif'>= </span>=0D </div></div>=0D <div><div class=3D"MsoNormal">=0D <span style=3D'font-size:8.0pt;font-family:"Segoe UI",sans-serif'>Ph: +61= 7 3245 7008</span><span style=3D'font-size:10.5pt;font-family:"Segoe UI"= ,sans-serif'></span>=0D </div></div>=0D <div><div class=3D"MsoNormal"><span style=3D'font-size:10.5pt;font-family= :"Segoe UI",sans-serif'>=C2=A0</span></div></div>=0D </div></div></blockquote>=0D </div>=0D </div></blockquote>=0D </div>=0D </div>=0D <div class=3D"MsoNormal">=0D <span style=3D'font-size:1.0pt;font-family:"fdtktid",serif;color:white'>1= 35279:3931932</span><span style=3D'font-size:10.5pt;font-family:"Segoe UI= ",sans-serif'> </span>=0D </div>=0D </div>=0D </blockquote></div>=0D </blockquote>=0D </div>=0D </div>=0D =0D =0D =0D =0D =0D =0D =0D =0D =0D <span title=3D"fd_tkt_identifier" style=3D'font-size:0px; font-family:"fd= tktid"; min-height:0px; height:0px; opacity:0; max-height:0px; line-heigh= t:0px; color:#ffffff'>135279:3931932</span>=0D =0D </div>= ----==_mimepart_6a0d4a08a7f8d_1e8626b078401f--
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings