ColoredCow / portal

A hub-and-spoke platform for organizations to effectively manage their operations and data. Uses GSuite.
MIT License
55 stars 51 forks source link

Monthly sales register - report from portal #3052

Open mohitsharma-22 opened 1 year ago

mohitsharma-22 commented 1 year ago

Is your feature request related to a problem? Please describe. Need a report to share it with CA for mostly invoice generated.

Describe the solution you'd like Please create a report in the attached format for Indian and International invoices.

Let me know if you have any further questions. inv_rgtr- April 2023.xlsx

pankaj-ag commented 1 year ago

@mohitsharma-22 can you clarify a few things, please

  1. I am assuming Inv_Dt is the invoice date.
  2. There are two sheets in the excel file you shared. I don't think we are storing stripe invoices in the portal yet. So should we add a blank sheet or remove the sheet altogether?
mohitsharma-22 commented 1 year ago

@pankaj-ag 1. Yes, Inv_Dt is invoice date = Date on which invoice is created.

  1. Removed the Stripe invoice tab in the sheet. inv_rgtr-.April.2023.xlsx
AbhishekNegi25 commented 1 year ago

Hey @mohitsharma-22 The sample report you shared in above comment there are less columns in 2nd table. It would be tough and extra work to add two table with different numbers of columns in a single sheet. Can we generate this excel with two different sheets? Please confirm.

Screenshot 2023-06-08 at 6 08 21 PM
pankaj-ag commented 1 year ago

Initial feedback.

mohitsharma-22 commented 11 months ago

@pankaj-ag Is this done? Let me know if we can test?