`scripts/fix-dummy-tax.mjs`

25 lines
// Flip dummy invoice 999999 (recordId 64903) to tax-exempt, re-read calcs.
import { readFileSync } from 'node:fs';
import { fileURLToPath } from 'node:url';
import { dirname, join } from 'node:path';
const __dir = dirname(fileURLToPath(import.meta.url));
for (const line of readFileSync(join(__dir, '..', '.env'), 'utf8').split('\n')) {
  const m = line.match(/^([A-Z_]+)=(.*)$/);
  if (m && !process.env[m[1]]) process.env[m[1]] = m[2];
}
const fm = await import('../src/fm-client.js');

// readback only

const rec = await fm.getRecord('invoice', 'Order Detail', 64904);
const f = rec.fieldData;
console.log(JSON.stringify({
  Invoice: f['Invoice'],
  'TOTAL 1(1)': f['TOTAL 1(1)'], 'TOTAL 1(2)': f['TOTAL 1(2)'],
  'merch tot2': f['merch tot2'],
  'SALES TAX': f['SALES TAX'],
  'SHIPPING  HANDLING': f['SHIPPING  HANDLING'],
  'PAID ON ACCOUNT': f['PAID ON ACCOUNT'],
  'NET DUE 2': f['NET DUE 2'],
}, null, 1));