PROBLEM
hint: how to add a formula to see unpaid items in Logs (see total due for accounts payable)
from newsletter #14
DIAGNOSIS
Adding an optional formula to the log to show current
accounts payable balance
in MacNail Construction
Accounting Software
SOLUTION
1. Choose Unprotect Document from the Options menu.
2. Scroll down to the Query Box in the Labor, Material or Subcontractor Log. Click on the pd? title and the cell below it
in the Criteria area, and choose Copy from the Edit menu. Then click on a convenient blank area within the Query Box, and
choose Paste from the Edit menu.
3. With the two new cells still selected, choose Define Name from the Formula menu. Type in blank.criteria as a defined name,
then click OK.
4. Type an = (equal sign) into the blank cell just below the new pd? cell, then type the Enter key.
5. Find another convenient location in the Query Box, and type the following formula: =DSUM(Database,”total”,blank.criteria)
for a Labor or Material Log, =DSUM(Database,”amount”,blank.criteria) for a Sub or Misc Log. Type 'total unpaid'
or another title in the cell next to this one.
6. Format the cells as desired—you might want to use the $#,###.00 number format so you’ll see dollar signs and
pennies. Then choose Protect Document from the Options menu.
The new ‘unpaid’ cell will show you the total amount of all items with no text in the pd? column. MacNail’s
Post to Ledger command will mark off all costs as they are paid by putting check numbers in the pd? column. You can also
type any text yourself into the pd? column, to mark off items as having been paid. COMMENTS
Entered 1/10/96 by Rudy.
|
