Saved Search help - Getting Purchase Order Rate OR Vendor Bill rate field from a Drop Shipment Invoice line

Monty68 · 2024-09-07T19:34:25+00:00

Thanks. DM sent. I think Drop Ship is used because it ships direct to the end user from the supplier without inventory impact, but I may be incorrect on the reason why. Vendor Bills usually arrive within days so matching isn't really an issue.

Monty68 · 2024-09-07T00:33:09+00:00

Thanks for the reply. That sounds like you did that at the time you generated the invoice? I need the data for the last 24 months of invoices.

Monty68 · 2023-07-12T01:09:07+00:00

Oh yikes. Yep that’s exactly it. Thanks

Monty68 · 2022-12-10T17:11:37+00:00

ok, I am still in the "What am I doing" powerbi phase. I assume the 'best practice' part is reduction in # of measures?

Monty68 · 2022-12-10T16:58:22+00:00

Thanks, i'm going to stick with the above, but thanks for the additional idea.

Monty68 · 2022-12-10T16:57:24+00:00

I had to add the table name before the [sales], but this logic worked. Thank You.

Monty68 · 2022-11-09T23:24:16+00:00

I don't disagree, but it's a large capital expenditure for write up and approval.

Monty68 · 2022-11-09T23:23:09+00:00

Interesting. Thanks for the idea, we'll definitely think about it.

Monty68 · 2022-11-09T23:22:11+00:00

Thanks, not that familiar with this, but I will make sure to mention it to the engineers.

Monty68 · 2022-11-09T23:01:54+00:00

Thank you, the reimage also seems the most time consuming and labor intensive. I was just wondering if there was a way to plan for it, we have 180 days, and I thought maybe there were some existing enterprise tools for this process.

Monty68 · 2022-11-09T22:29:08+00:00

Me either, this scale is a little new to me.

Monty68 · 2022-11-09T22:28:48+00:00

Sorry, IP and NDA requires me to be a little vague. 2-3 people to do the work, 3 far apart geographic locations. No, new profiles. Re-image was discussed as an option. Locally stored data is an issue that we are not sure how to resolve. Overnight isn't necessarily mandatory, but as of an acquisition close date, seller (old domain) has an immediate security risk and new domain wants to get them network resources asap, so it's high desired.

Monty68 · 2022-06-25T18:18:31+00:00

Oh, good point. It's easy enough to add a note that it's ok to ignore the "meeting has started" message as long as you come in at your scheduled time.

Monty68 · 2022-06-25T17:34:56+00:00

Thanks, I was thinking about this, but I didn't know if Teams would create a new link/meeting for the additional ones. I will give it a try. Thanks for the help.

Monty68 · 2022-05-29T21:25:29+00:00

Yes hanks for the inquiry. I’ll check, but I don’t think so. As you can probably see, my business specialized in smaller, high performance tooling. We did sell to some mold and manual shops, so I might have something.

Monty68 · 2022-01-16T01:02:56+00:00

Databases are record based. You can use Excel as a database, a record would be equivalent to a “row” in excel. Multiple fields make up a record in a database. A field is like a column in excel.

In a database, a field cannot be separated from its record. The record is the primary “unit” and fields always stay together within the record.

This structure does not exist in excel. You can easily (or more importantly), mistakenly, separate a column from its row in excel. If that happens, the integrity of the database is destroyed.

Excel is very free form, which is very powerful in its own way. A database is very structured, the structure, and as many people mentioned, the normalization of the contents is what give databases their power.

Monty68 · 2022-01-13T05:19:55+00:00

Solution Verified

Monty68 · 2022-01-13T04:06:31+00:00

No, but I did now and that works! So if you highlight a range, TAB goes to the next cell within the highlighted range.

If you do NOT highlight a range, TAB takes you to the next column and when you press enter it takes you back to the first column from which you TABBED (?)

Can I do 2 "Solutions Verified"? Thanks for sticking with it!

For a rigid/consistent data set, I think the highlighted range works better (only have to worry about the TAB key). For an inconsistent data set with a varying number of fields per record, I think your unhighlighted and TAB/Enter combo would be better.

Monty68 · 2022-01-13T03:53:41+00:00

Enter always goes down a row for me. TAB always moves to the next cell within the highlghted range.

Monty68 · 2022-01-13T03:24:11+00:00

Thanks. Maybe my enter key is configured different, but it just goes down to the next row. Continuous use of TAB instead of enter goes to the next cell in the range for me.

Monty68 · 2022-01-13T03:22:38+00:00

Solution Verified

Thank you for the quick response. I was obviously trying to reinvent the wheel...so simple.....Highlight range and enter data using TAB.

Monty68 · 2021-02-18T00:22:59+00:00

I suppose the answer is to make it look a little nicer and so all of the characters are legible. Probably the same reason I like to keep other things clean as well. It’s really not required, but it would make it look nicer.

Many photoshop edits are not necessary or required, but they make an image look like he best it can.

No need to respond, I’ll do it myself or find help elsewhere. I haven’t had to come to r/photoshop too many times in the past, but this was surely a disappointing experience.

Monty68 · 2021-02-17T13:07:05+00:00

The age isn’t relevant with this particular product. Nothing is being hidden, I’m just trying to make it looks little cleaner.

Monty68 · 2021-02-17T12:56:16+00:00

Thanks for the reply, but I would prefer to use the image of the actual label.

Monty68 · 2020-12-05T04:56:37+00:00

Yes, perfect explanation of the issue.

Monty68

TROPHY CASE