Sage 300

I would like to sort the results of the report for a rage of accounts based upon the values produced. for instance: cost of sales accounts, detailed by d(acct) for 4 separate columns from J, K, M, N and then SORT THEM by column M in decreasing values…

Hi, In an FR report, I have a heading like 00123 but in the output, it shows as 123. I have tried '00123 and formatting the cell as text but the output still comes out as 123. How do I preserve the leading zeros ? I need the leading zeros as these…

Hi, I have an FR report where there is a criteria in column B and also in the FRAMT function third parameter in the default row. It seems that when I use the third parameter of FRAMT to set criteria, it ignores the criteria in column B. Is there a way…

Hi, refer to the below, row 193 is the total from row 194 & 195 What formula should I put in cell A193 if I want to sum the range as show in row 194 & 195 and it will not show or print when it is Zero? Same goes to A203. Any advice?

Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…

I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…

I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

For the past weeks, I have been working on generating a report that will provide the inventory amount per Category and should match it with the Inventory balance per Trial Balance or G/L or Financial reporter. Does anybody built a report on this using…

Hi, Does someone written and willing to share a SQL statement that is an equivalent of FRAMTA("BALP") from the Financial Reporter? I am trying to figure out how our GL Inventory account is calculated. I read one of the discussions to run trial balance…

Hi, A client has been printing an FR Report for many months now but then she suddently started to receive an error message this week: "Initializing FR Error (12) : Fail in starting Print Financial Statements" I tried a few of the usual MS-Excel…

Good day, I have a problem with my FRView and I am desperate for help. FRView does not function properly on one of my Servers. The specifications are: Server 2012 R2 8 Virtual CPUs 16GB RAM 200GB virtual HDD When an FRView report is…

Client is currently revisiting their chart of accounts as it is making report writing impossible. They are also moving to sage intelligence but I had a quick query. They are trying to insert ”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545…

To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

I'm looking for a canned Bill of Lading report and thought I'd try the report store folks. Not showing up any longer. Does anyone know where they went?

Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.