Would anyone be willing to assist me in developing a bookkeeping app?

Will there be WiFi?

Will there be electricity?

Describe your pos system hardware.

Printer?

Cash box?

Bar code scanner?

Do expect the need to allow business to business sales of common goods?

Would some of the groups sell to other groups?

That affects the coding of inventory items.

Since this is only a prototype intended for the Business Expo, our POS system will be purely software-based and does not require external hardware like printers, cash boxes, or barcode scanners.The app itself will serve as the POS interface

We are not allowed to do business-to-business (B2B) sales between groups during the Business Expo. Each group will focus on selling directly to customers

Yes, our school will provide wifi and electricity

(In case you use the spreadsheet component)

1 Like

Real money or play money?

You might have to learn a little fundamental bookkeeping concepts, like double entry bookkeeping and the Chart of Accounts.

We have not yet mentioned the need to keep a price list somewhere, separate from the sales and purchases history.

1 Like

How is your project going?

From your description, your app will need to be immune to disruptions in Internet access common to big events like your business expo, where everyone fills the available bandwidth.

I recommend TinyDB for local data storage in a mixed Android/iOS environment.

Your data base is also shaped by the reports you will generate to answer common business queries like:

  • Which products generated the most profit?
  • Where did all our inventory go?
  • How did our sales vary by time of day?
  • Which products sold quickly?
  • How much tax did I collect for the government?
  • Which salesman made the most or least sales?
  • Which salesman made the most or least profit?

When is all this due, and will you have time to alpha and beta test?

Regarding the spotty WiFi threat, a common approach is to limit data base access to

  • Add a row for each transaction, with feedback success reports between row uploads
  • Download the day's transaction history and summarize in the app, if a common data base must be shared among multiple devices
1 Like

Further Project Management thoughts...

If your app is going to be used by the other teams at the event, you will need to schedule training sessions for them before the event.

That would be a good opportunity to pre-load inventory items and prices.

Real money

Yes, we were taught the Fundamentals of Accountancy, Business, and Management.

Hello, apologies for the late reply — it was our exam week.

I agree that using TinyDB would be helpful, especially since the internet connection during the expo might be unstable. My only concern is that our login system currently uses CloudDB, so I’m not sure if using both would interfere with each other. With the inventory I shared earlier, would it be possible to substitute the CloudDB I used with TinyDB instead?

The app is due in about a month, so for now I’m focusing on finishing the main features (POS, inventory, and proceeds report). If I have extra time, I’ll try to add one or two of the more detailed queries you mentioned. Since I’m still a student and new to MIT App Inventor, I’ll do my best to test the app thoroughly, but it might not go through a full alpha/beta process

Yes, we are planning to inform them and train them a week before

Thank you for this, I'll look into it.

https://groups.google.com/g/mitappinventortest/c/1fY5u1C48L0/m/Dtl89ZmaBwAJ

... from

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.