Invoices | Mac app for creating invoices | Business library

I have a trusted MS Access database about invoices, procurement. I use it 4 years ago now, but need a re-do, to solve problems, build new things in to it, make it more easier to use. I started using MS Access more then a decade ago, but this is the first time I must ask.

I have only one problem doing that. I have two tables which has a relationship, one-to-many. One is about invoice data, the other is invoice items. In the invoice table the invoice number is an autonumber with a specified format. There is a split form, where should be a filtered datasheet, filtered to the actual invoice numbers. Now it is not working, because the two connected field parameters are not match. Yes the one is auto number, the other stored as short text.

In the old database I stored the invoice number as short text, but I hate to fill a new invoice number all the time when I create one. This must be a new feature to the database, to fill it automatically.

For more precise information:
Invoice number:
Data type: autonumber
Field size: Long integer
New values: Increment
Format: "SZ"00000

If you believe my approach is not ideal, your ideas are welcome.

...

I have a table with customers that I join with a fact table with sales, based on invoices.

What I need from my report is to get in first part the biggest value of sales based on the incoming order type (1,2,3,C,D) for a customer for last year. And in the second part to get the same but for current year. What I get as result from my current query is all incoming order types with the customer revenue made for each of them. I tried with outer apply as subquery to get only the top 1 value ordered by revenue descending, but in the result I get the same - For all order types the customer revenue. Please help! I hope my explanation isn't understood only by me (happens a lot..)

...

I have a Layout component where I compares routing query and return the layout according to it.

I want to compare dynamic routing, for example invoices/invoice-1

I currently have the following component but as you can see just configArrays.includes(pathname) doesn't work.

...

Good Afternoon, I am using the MERN stack to making a simple invoice application. I have a function that runs 2 forEach() that goes through the invoices in the DB and the Users. if the emails match then it gives the invoices for that user. When I log DBElement to the console it works, it has the proper data, but when I log test1 to the console (app.get()) it only has one object not both.

...

Good Evening, I am using the MERN stack to create an application. I am using the Stripe API to gather invoices and save some information about the invoice in MongoDB. Right now I have a function that updates my DB with any object that does not exist and I have a delete function that deletes any documents in my DB that have the paid: true. when an invoice is paid Stripe marks it paid, when its paid I want to delete it from my DB. What happens now is that I delete it and then update function runs and just puts it right back.

The data in my DB and from stripe are an array of objects:

...

I'm kind a new in programming and I'm trying to update tables with requestDto that have multiple entities with one request. Each tables mapped by Invoice tables, has Foreign Keys But I got Null from other tables when I PUT update.

...

I'm trying to generate some data for testing by duplicating existing data in my database. There are a number of tables linked by FKs and I want to keep the same data profile. I think it's easiest to explain with an example:

CustomerID Name Age 1 Fred 20 2 Bob 30 3 Joe 40 InvoiceID CustomerID Date 1 1 2020-01-01 2 2 2020-02-02 3 2 2020-03-03 4 3 2020-04-04 LineItemID InvoiceID Item Price Qty 1 1 Apples 1.5 5 2 2 Oranges 2 3 3 2 Peaches 2.5 6 4 3 Grapes 3 10 5 4 Pineapple 5 1

I want to duplicate all the customers who are older than 18, including all of their linked data. So for the Customers table it's easy enough to do something like:

...

I am looking for a way to pull all invoices from a table with the tracking number for that invoice. For example:

SELECT Invoice, FedEx, UPS, DHL from shipfile

would show all invoices and all tracking numbers. If it was shipped FedEx, the tracking number will be in the FedEx column. Same for the others. I want to be able to pull out the Invoice and then 1 other "Tracking" column that will display either the FedEx, UPS or DHL result (which ever one contains the tracking number). So if there is a FedEx tracking number, UPS and DHL will be blank, so I'd want to see the Invoice and the FedEx tracking number. And same thing if it has UPS tracking, FedEx and DHL will be blank so I want to only see the UPS result.

Before:

...

I am trying to search with a column on a connected table using with. According to laravel the following should work.

...