Archive | February, 2013

Sum of Cardex entries must equal Item Location totals

15 Feb

On JD Edwards (JDE), the sum of cardex entries must equal item location totals.  The SQL query below will find exceptions to this rule.  These exceptions are usually due to failed transactions, so you’ll want daily monitoring.

with LOCN as (SELECT distinct limcu, liitm, sum(lipqoh) as LOCNtot , lilocn FROM library.f41021  group by limcu, liitm, lilocn order by limcu, liitm, lilocn),

LDGR as (select ilmcu, ilitm, illitm, illocn, sum(iltrqt) as Ldgtot FROM library.f4111 group by ilmcu, ilitm, illitm, illocn)

select trim(limcu), liitm, trim(substr(illitm,1,16)), lilocn, LOCNTOT, LDGTOT, LOCNtot – Ldgtot DIFF from locn inner join ldgr on limcu = ilmcu and liitm = ilitm and lilocn = illocn where LOCNtot <> ldgtot order by ilmcu, illitm, illocn

Item ledger (cardex) = F4111

Item location = F41021

 

Advertisements

Error:13 – PLD upload to UPS.com

14 Feb

I’ve run into this issue a few times on WMi (Warehouse Management for iSeries) version 260.  The program, TPM262, has this response from UPS.com:

Error: 13 – Èãã×añKñ@ñðð@à £  ¤

Error encountered when transmitting, retransmission required.

A resubmission of the PLD to UPS results in an “already submitted” response.

I haven’t sent this to Manhattan Associates nor UPS.  A Google search did not provide an explanation either.  But it rang a bell today because recently, our CNC was having issues with Text Conversion on the IFS in iSeries Navigator, V6R1, with service pack 42423.

I did a little ASCII to EBCDIC conversion, using a table I found on the web, and it looks like the response begins with HTTP/1.1 …….?  I’m not sure of the rest.

HTTP/1.1 turns up on a few Google searches, so I think I have a way into this issue.