Billing: XML file messed up

Creation date: 14/12/2021 12:37 Updated: 14/12/2021 12:37 #billing

Question:

Summary of issue/request/query

XML file sent from Billing looks like messed up:

PI number sometimes missing, sometimes there
Line duplication
Division code sometimes missing, sometimes there

Attached is different XML file again, even more messed up, contain billing number from past billing B000001 and contain billing from another warehouse

Answer:

Update from consultant:

What I did is this query: (internal)

UPDATE

BIL_SUMMARY A

LEFT JOIN BIL_TARIFF_DETAILS D

ON A.ORGANIZATIONID = D.ORGANIZATIONID

AND A.TARIFFID = D.TARIFFID

AND D.CHARGECATEGORY = A.`chargeCategory`

AND D.`chargeType` = A.`chargeType`

AND D.RATEBASE=A.RATEBASE

SET A.UDF01=D.UDF01, A.UDF02=D.UDF02 ,A.UDF04=D.UDF06

WHERE A.ORGANIZATIONID = 'OJV_CML'

AND A.WAREHOUSEID = 'CBT01'

AND A.UDF01 IS NULL

To ensure the 3 fields are the same then correct XML will be exported

DataImage71.png

BILLING_20211130114818137.XML

BILLING_20211129113901752.XML

BILLING_20211126182609765.XML

Files		Sort by Name Sort by Date
	DataImage71.png 497 KB
	BILLING_20211130114818137.XML 43 KB
	BILLING_20211129113901752.XML 9 KB
	BILLING_20211126182609765.XML 8 KB

Billing: XML file messed up

Contents