bcgov / lcfs

An online application for fuel suppliers to manage their compliance obligations under the Low Carbon Fuels Act
Apache License 2.0
5 stars 3 forks source link

LCFS - Add prefixes to transactions in Excel download #988

Open Grulin opened 3 weeks ago

Grulin commented 3 weeks ago

Describe the task Add transaction prefixes to the Excel file download from the Transactions page. Currently, the ID column in the exported Excel file does not include prefixes such as:

These prefixes are essential because the transaction numbers repeat for each type of transaction, and the prefixes help distinguish the type of transaction associated with each ID.

Purpose To ensure that transaction IDs in the Excel download are complete and accurate by including prefixes that identify the type of transaction. This will improve clarity and prevent confusion when reviewing transactions, especially when multiple types share the same numeric sequence.

Acceptance Criteria

Additional context

Grulin commented 1 week ago

I see the correct assignment of the transaction type in the "type" column, but we would like the prefix to be added to the ID number in the "ID column" for this Excel Sheet. For example, you can see in the screen shot that their are 2 transactions with a #10 ID number. One of these should be AA10 because it's an admin adjustment and the other should be CT10 because it is a credit transfer: Image

dhaselhan commented 1 week ago

Blocked on #1048