Search results for query: *

Good morning Anoli, Thank you for the explanation, it is much appreciated - unfortunately I have had many other things on my plate this week so I have not been able to so much as touch anything regarding this report. That's kind of how my job is here as the sole help desk and junior IT admin...

Hello Anoli, Thank you for your input 👍 So, without going into too much detail, let me elucidate the purpose of this report so you can understand why I am pulling from OEINVH. Our sales people are looking for a monthly report containing all invoicing activity on all orders, as well as all...

Hello ettienne, Thank you for your input 👍 We have set up something for us to be able to throw SELECT queries at the database to help us explore it and create reports. If you could take a look at the following two queries and their results: Query #1: SELECT ordnumber, invdate FROM oeinvh...

Hello all! :) I have been working on a web report that pulls from our SAGE 300 database and I have run into a weird situation. We have an order 0272122 that shows a LASTINVNUM of 20240201. But, if you go to the last invoice shown in Order Entry, the date shows 20240117. This report pulls all...

I apologize for the confusion. I was in the wrong database :) Thank you for your help again!

Thank you for your assistance, tuba2007. But I'm having some trouble with these links. The first link is showing nothing on screen, looks like I need account credentials of some sort. I'll try to get that sorted out with upper management, but as for the second link, the PDF references tables...

One of our departments is looking for a way to manage job tickets more efficiently. They would like a four-column table with Job #, Location, Job Status, and Job Notes (underneath "Phases" on the report). They use Service Manager - specifically, Document Entry - to manage them currently, but...

Wow, such a helpful post [smile] Had no idea they provided that kind of information, makes my job a lot easier! The report is looking good so far now, also I'm noticing that there are a few functional costs that are not showing the same value in order entry, but are showing the same value as...

Ooooh, I didn't see the sales history details table... that might help. I'm still somewhat new to ACCPAC and it's various tables, it's a little overwhelming for me at times! I saw the OEAUDD table and didn't know what I was looking at, basically. I'll try to give it another look over, along...

This is a report I wrote in PHP. Why would the EXTICOST not match what's displayed in ACCPAC?

So I'm trying to make a gross profit report for my boss, and to do that we want to compare all items on all invoices per order with their unit price against their unit cost. So all's going well, until I start noticing that the cost of each item displayed in Order Entry doesn't always match the...