TRANXACT.AI يساعد

Sales order lines from a file: 5,000 lines, country compliance columns and the refused rows

The sales-order lines template now takes up to 5,000 lines (a company setting, never above 20,000), each row carrying the compliance and analysis columns of the company’s countries, and the rows it refuses come back as a workbook to correct and upload again.

New sales order (and a draft order’s Lines tab) › download the template, fill it in, upload it. What the template asks and how a configurable row is configured are unchanged; see the guides on sales order line upload.

How many lines

  • Platform › Configuration › Core Settings › Runtime Settings, Volume: Lines in one line-document template. It ships at 5000; the lowest is 50 and the highest 20000.
  • The one setting is read by every line-document template, the configured quotation lines too.
  • A file is never read past 20,000 lines, whatever is set.

Columns by country

Besides item, quantity, price, date and the questions of a configurable item, each row carries the columns of the company’s countries, and each value is checked against the company’s own masters:

Where the company operatesالأعمدة
الهندHSN/SAC and GST code
المملكة العربية السعوديةZATCA category and exemption reason
United StatesSales-tax code
ElsewhereVAT and commodity code, tariff code
Every companyCost center, project, warehouse, discount, customer number and the other analysis columns

The refused rows

  1. Upload the file. The preview judges every row; a row that fails is listed with its reasons, per column where the reason names one.
  2. Download the refused rows: a workbook with one line per problem and the row it came from.
  3. Correct those rows and upload them again. The rows that passed can be used meanwhile.

How to reuse: setting values are examples; your company’s own appear in their place.