Function main

scripts/correct-salesforce-invoice.ts:59–162

()

});

async function main() {
  // 1. Find the disputed invoice
  const invoices = await stripe.invoices.search({
    query: `number:"${DISPUTED_INVOICE_NUMBER}"`,
  });

  if (invoices.data.length === 0) {
    console.error(`Invoice ${DISPUTED_INVOICE_NUMBER} not found`);
    process.exit(1);
  }

  const disputed = invoices.data[0];
  console.log(`Found disputed invoice: ${disputed.id}`);
  console.log(`  Number: ${disputed.number}`);
  console.log(`  Status: ${disputed.status}`);
  console.log(`  Amount: ${(disputed.amount_due / 100).toFixed(2)} ${disputed.currency.toUpperCase()}`);
  console.log(`  Customer: ${disputed.customer}`);

  const customerId = disputed.customer as string;
  const subscriptionId = disputed.subscription as string | null;

  // Find the price — from subscription, line item, or lookup key fallback
  let priceId: string | undefined;
  if (subscriptionId) {
    const subscription = await stripe.subscriptions.retrieve(subscriptionId);
    priceId = subscription.items.data[0].price.id;
    console.log(`  Subscription: ${subscriptionId}`);
  } else if (disputed.lines.data[0]?.price?.id) {
    priceId = disputed.lines.data[0].price.id;
    console.log(`  No subscription (standalone invoice)`);
  }

  if (!priceId) {
    // Standalone invoice with no price ref — resolve from lookup key
    const prices = await stripe.prices.list({ lookup_keys: [LOOKUP_KEY], active: true });
    if (prices.data.length === 0) {
      console.error(`No active price for lookup key: ${LOOKUP_KEY}`);
      process.exit(1);
    }
    priceId = prices.data[0].id;
    console.log(`  Resolved price from lookup key: ${LOOKUP_KEY}`);
  }
  console.log(`  Price: ${priceId}`);
  console.log(`\nWill void and reissue with PO: ${PO_NUMBER}`);

  if (dryRun) {
    console.log('\n--dry-run: Would void invoice and create corrected invoice. Exiting.');
    return;
  }

  // 2. Void the disputed invoice
  console.log('\nVoiding disputed invoice...');
  await stripe.invoices.voidInvoice(disputed.id);
  console.log('  Voided.');

  // 3. Cancel old subscription if one exists
  if (subscriptionId) {
    console.log('Canceling old subscription...');