Revised: 5/2021
To begin using the Due To and Due from automatic journal entry postings, you will need to activate the Web Settings for Activate Due to & Due from Posting for Journal Entries
1. Select Administrative Utilities
2. Select SDS Web Office Settings
3. Under Finance: Update Due to & Due From options
4. Select Save Changes
5. Log out/in for system changes
6. ONLY JE journal source entries will trigger the Due to & Due from posting.
7. Enter appropriate account numbers on the budget master account used as a “Trigger” to generate automatic entries.
Note: This is the same setup that has been available for AP, Cash receipts, and the Payroll ledger interface.
|
Account Number samples used below |
What they are used for |
|
25-2-104-0000-000-0000-00000-0000 |
Due to cash account is the account used in the transaction. This is the “Trigger” Account. It has the Liability, Receivable, and other Cash account entered in the appropriate fields in the budget master. |
|
25-2-411-0000-000-0000-00000-0011 |
Due to liability account |
|
11-2-101-0000-000-0000-00000-0001 |
Due from cash account |
|
11-2-131-0000-000-0000-00000-0025 |
Due from receivable account |
|
Budget Master | |||
|
Account Number |
Account Number Due To Liability |
Account Number Due From Receivable |
Account Number Due From Cash |
|
25-2-104-0000-000-0000-00000-0000 |
25-2-411-0000-000-0000-00000-0011 |
11-2-131-0000-000-0000-00000-0025 |
11-2-101-0000-000-0000-00000-0001 |
Journal Entry JE using Due to and Due from trigger account
25-2-104-0000-000-0000-00000-0000
|
Account Number |
Description |
Misc. Ref |
Amount |
|
25-2-173-0000-000-0000-00000-0000 |
Food Inventory |
test |
($1,000.00) |
|
25-2-104-0000-000-0000-00000-0000 |
Due to/Due From (PR Cash) |
test |
$1,000.00 |
Journal Entry after made permanent has four more lines:
|
Account Number |
Description |
Misc. Ref |
Amount |
|
11-2-101-0000-000-0000-00000-0001 |
Due to/Due From (PR Cash) |
Due To 25 From 11 |
$1,000.00 |
|
11-2-131-0000-000-0000-00000-0025 |
Due to/Due From (PR Cash) |
Due To 25 From 11 |
($1,000.00) |
|
25-2-411-0000-000-0000-00000-0011 |
Due to/Due From (PR Cash) |
Due To 25 From 11 |
$1,000.00 |
|
25-2-104-0000-000-0000-00000-0000 |
Due to/Due From (PR Cash) |
Due To 25 From 11 |
($1,000.00) |
|
25-2-173-0000-000-0000-00000-0000 |
Food Inventory |
test |
($1,000.00) |
|
25-2-104-0000-000-0000-00000-0000 |
Due to/Due From (PR Cash) |
test |
$1,000.00 |
Yellow = Original Entry
Blue = Due to and Due From
activity