Purchase Return (PRt) • Excel ➝ XML Accurate

XML output mengikuti struktur contoh <PURCHASERETURN> yang kamu kirim.

acacloud.id • Licensed Module

1) Upload Excel

File Excel (.xlsx / .xls)

BranchCode (override, opsional)

Jika kosong: pakai BRANCHCODE dari Excel (jika ada), jika tidak ada: 1.

EximID

Start TransactionID

Di contoh XML kamu: 997. Sesuaikan kalau perlu.

Pilih file Excel lalu klik Convert.

Sheet: Data (jika tidak ada, pakai sheet pertama).
Tanggal: bisa DD/MM/YYYY, YYYY-MM-DD, atau format date Excel.

Wajib header: INVOICENO, INVOICEDATE, VENDORID
Wajib item: ITEMNO, QUANTITY
Header opsional: GLYEAR, GLPERIOD, DESCRIPTION, WAREHOUSEID, TAXDATE, SSPDATE, APINVOICEID, RECEIVEITEMID, TAXNO, INCLUSIVETAX, ISTAXABLE, INVOICEAMOUNT
Item opsional: ITEMUNIT, UNITRATIO, ITEMOVDESC, UNITPRICE, ITEMDISCPC, TAXCODES, DEPTID, PROJECTID, GROUPSEQ, POSEQ, BRUTOUNITPRICE, WAREHOUSEID_ITEM, QTYCONTROL, INVRI, INVID, RIID, INVOICESEQ, ITEMDESCRIPTION

Alias aman: RETURNO/PRTNO → INVOICENO, DATE → INVOICEDATE, VENDORREF → VENDORID, WAREHOUSE → WAREHOUSEID.