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.
NOTE-- Goldenseal accounting software includes a Pay
Bills command, which handles accounts payable very easily. It also
includes payables reports if you'd like to print out a summary
of current payables.
Comments
Entered 1/10/96 by Randy. Updated 11/10/2010.
|
