Search results for query: *

sage 300 advanced 2017 Previous owner of business used IC - Adjustments to decrease cost on slow moving and old inventory to get it off the books. Then they left those items in inventory and sold them slowly piece by piece. Doing it this way would show 100% profit when selling.(or nearly 100%...

LB, thanks that did the trick. I do have another question, unrelated to the ones above though. On another report i have a formula doing some calculations from the OESHHD table, i placed the formula in group header2. i can add anything from the OESHDD table and that formula factors correctly...

lbass, thanks for the reply. i believe you are pointing me in the right direction. i re-did the report in the following manner. took one of the existing reports and added the 2nd report to it as a sub report, linked the parameters from the main report to the sub-report. and then setup shared...

CR11, on Accpac 5.5 data. Hello, I have an issue that I'm not sure how to tackle. I'm trying to create a report that displays two different sets of data, and then puts that data into a report where i can run calculations on it. Basically I'm taking 2 reports that we already have created and...

ok, the formula's raja gave are correct. here is what i'm running into the pwformatdate function is formating the date into dd/mm/yyyy and i need mm/dd/yyyy i've tried a couple of solutions but keep getting errors i can't use totext because then i would have to convert everything. but when i...

thanks lbass, i'm not an everyday programmer and this was throwing me. so looks like it's a little deeper than what i thought.

oeshhd.audtdate = 20,071,211.00 pwFormatDate({OESHHD.AUDTDATE})= 12/11/2007 is that what you are needing?

record selection formula: ({@fmtdate} >= {@firstdayoflastfourthquarter}) and ({@fmtdate} <= {@lastdayofpreviousquarter}) and {OESHHD.ITEM} in {?From Item} to {?To Item} and the corresponding formulas (also posted above from raja) firstdayoflastfourthquarter...

I formatted the date easily by creating a new formula and using pwformatdate. end result is pwFormatDate ({OESHHD.AUDTDATE}) but i have a new problem that i cannot figure out. i have four formulas that figure out what period the results are in, which then figures which qtr they are in. In...

yeah i think the formulas are fine. when i go into the pervasive DB control center it says audtdate is a Decimal so i'm pretty sure i need to convert that to a date CR can understand since thats what it is looking for.

thanks raja2008 for the quick reply, i am getting an error when i go to save the record selection formula. Formula below ({OESHHD.AUDTDATE} >= {@firstdayoflastfourthquarter}) and ({OESHHD.AUDTDATE} <= {@lastdayofpreviousquarter}) and {OESHHD.ITEM} in {?From Item} to {?To Item} error on...

using CR 11, Querying Accpac 5.4 database. I'm trying to write a formula that will select the last 4 quarters from the current quarter or date. This is located in the record selection formula and the end result will display qtys of items sold in the last 4 quarters. original formula i'm...