Sage 100

Is anyone still relatively familiar with the OLD custom financial statements? I would like to add a ""non-printing"" line on existing financial statements. They're using the legacy custom financial statements. The client added a division and I'm trying to add a line that would subtract the amounts from that division but I need to make it hidden on the report. I tried setting the PTD and YTD tab positions to zero and leaving the title blank; That made it hidden but it still leaves a empty line for on the report (not optimal but it might work). a better answer would be to find a way in the linkages on a consolidated line to subtract out or ignore all the accounts in just that division but I don't see any possibility of that. they have aput a hundred divisions (001, 002, 003, 004,005,006 ,.......,100,101,102.... and on and on) They want all the divisions EXEPT 005. I guess I'm looking for the equivalent of the NP line feature in FRx. if anyone has ideas I'm all ears TIA

you may be able to use a consolidated line type, leaving the description blank.

that is where I'm at, but it still leaves space for that line, so if I have several of those in a row there will be a bunch of white space in the report. That might be workable but if I could avoid that, I think the client would be happier.

Page 90 of the GL manual talks about wildcards in consolidation lines https://www.dropbox.com/s/w62651xxm1dxpal/Glcd.pdf?dl=0

You should only need one blank line as you can link several gl accts to one line... using wildcards, ranges, or one acct at a time.

Maybe I'm making this harder than it should be. Here is an example: In the COGS section the original report had one consolidated line with linkage type Range for accounts 7000-000 to 7999-999 I basically need to subtract accounts 7***-005. from that line. The client only wants one line showing on the income statement for the net of those. I managed ""hide"" the original line and the ""005"" line and then put a total line showing the net. That is really close and we only have 2 blank lines in the COGS section. But I'm going to have 2 blank lines in the Sales Section, Operating costs section, and basically every section on the report (and something similar on the Balance sheet and cash flow statements). I'm still studying the GL manual Wayne sent (Thank you Wayne!). So far I'm not seeing anything that allows me to link in the accounts I need but ignore or subtract just the ""005"" accounts all on one line.

put 2 lines in the linkages section: line 1 is a range from 7000-000 to 7999-004. Line 2 is 7000-006 to 7999-999.

From my memory I used to do it the way Doug indicates

II tried that but it doesn't work because (for example) account # 7001-005 falls in the range of 7000-000 to 7999-004 (actually it also falls in the range of 7000-006 to 7999-999) so it looks like it is effectively doubling the COGS including all the 005 accounts

Why don't you just enter the accounts you want one at a time, or use as many ranges as possible in the same linkage?

If the blank lines don't satisfy the customer that is what I'll end up doing (entering all the accounts one at t time). That will take some time since there are 104 accounts in the 7000-7999 range alone. Granted, some of those are 005 accounts that I won't need to enter, so just under 80 accounts is probably what I will end up entering into each grouping. I don't see any way to copy a linkage from one line to another. I would have to shoot myself before I got done, so I may find a typist to do it for me if I go that route.

VI import or PVX utility program?

Here's some text from the old help files on Custom Fin.: Account Mask Enter an account mask to use to selectively include or consolidate information from accounts within the specified range. This field is available only for detailed line types for which you selected Range of Accounts at the Link Type field. When selecting accounts, you can use the wildcard character (*) to indicate all matching accounts to link to this line. Each wildcard character will mask a single character position. To consolidate accounts within a range, use the consolidate character (@). This feature is useful in consolidating all departmental accounts within a single line. You can use a combination of wildcard and consolidate characters within the same mask. NOTEThe Consolidate Mask feature using the @ character can be used only on the first line of linkage information. After you have specified a mask using the @ character, you cannot enter additional linkage lines for the current report line. If the report line is a detail line type, you can use the consolidation character (@) to consolidate matching accounts. When using a Range linkage type, the account mask or Mask feature is exclusive to a Detail line type. If your account mask is ###-###-###, enter the following masks to select the accounts indicated. Enter ***-500-*** to select all accounts within the range that contain 500 as the second segment. Enter ***-***-010 to select all accounts within the range that end with 010. Enter ***-***-@@@ to consolidate all accounts within the range based on the first and second segment. Accounts 100-010-001, 100-010-002, 100-010-003, etc., consolidate into one line. Accounts 100-020-001, 100-020-002, 100-020-003, etc., consolidate into another line. Enter ***-@@@-010 to consolidate all accounts within the range based on the first segment that ends with 010. Accounts 100-001-010, 100-002-010, 100-003-010, etc., consolidate into one line. Accounts 101-001-010, 101-002-010, 101-003-010, etc., consolidate into another line. Account 100-001-020 are not included in the consolidation.