USERNAME: PASSWORD:
Forget Username? Forget Password?
Infinite Menus, Copyright 2006, OpenCube Inc. All Rights Reserved.
accounting software
financial software


Accounts Receivable

Accounts Receivable WorkflowAccounts Receivable ProceduresAccounts Receivable TutorialsAccounts Receivable AccountingAccounts Receivable FAQsAR Resourceserp

x

 

saas
A/R Journal Entries
saas
saas
Customer File Options  Customer Setup  Prospect to Customer Conversion  EDI setup  System Administration
saas

 

Event Customer Update Inventory Update GL Update
Order Booked Financials > Booked Orders increased
Financials > Available Credit decreased
Financials > Average Days updated
Financials > Highest Credit decreased
Financials > Last Sales Date inserted
Quantity on Hand reduced
Quantity Committed increased
None
Order Picked & Packed None None None
Order Shipped None None

None

Order Invoiced Financials > Current AR Bal increased
Financials > Total AR increased
Financials > Under 30 increased
Financials > Sales YTD increased
Financials > Sales Lifetime increased
Quantity Committed decreased

Invoice posted to G/L
Debit: A/R
   Credit: Sales
Debit: Item COGS
   Credit: Item Inventory

Sales defined by Customer or Item and displayed on Order Detail page.
A/R defined at Company Setup.
COGS defined at Item.
Item Inventory defined at Item.

Invoice Posted
(from Invoice Entry with no Order)
Financials > Available Credit decreased
Financials > Current AR Bal increased
Financials > Total AR Balance increased
Financials > Under 30 increased
(Financials > Sales fields only updated by Orders)
Quantity on Hand reduced
(No change to Qty Committed)
Invoice posted to G/L
Debit: A/R
   Credit: Sales
Debit: Item COGS
   Credit: Item Inventory
Credit Memo Posted Financials > Credit Memos increased
Financials > Last Credit Memo Date updated
Financials > Credit Memos YTD updated
Financials > Credit Memos Lifetime updated
 

Credit Memo posted to G/L
Debit: Sales
   Credit: A/R

Sales defined by Customer or Item and displayed on Detail page.
A/R defined at Company Setup.

Credit Memo Payment Issued Financials > Credit Memos decreased   Credit Memo posted to G/L
Debit: A/P******
   Credit: A/R
Note: System creates A/P Payment;
when posted, Voucher posted to G/L:
Debit: Sales
   Credit: A/P
RMA Booked

Financials > RMAs increased
Financials > Last RMA Date updated

Can book RMA from Invoice (doesn't require Order)

None None
RMA Approved None None None
RMA Received

Financials > RMAs decreased
Financials > RMAs YTD increased
Financials > RMAs Lifetime increased

Note that Aging buckets not updated until RMA credit applied to Invoice.

Quantity on Hand increased
Quantity on Order increased **

RMA Receiving posted to G/L
Debit: Sales (what about inventory?)
   Credit: A/P

RMA Receipt creates A/P Check; when posted
Debit: A/P
   Credit: Cash

Cash Receipt Posted Financials > Available Credit NOT updated
Financials > Last Payment Date updated
Financials > Last Payment Amount updated
Financials > Aging buckets NOT updated
Financials > Payments YTD Increased
Financials > Payments Lifetime increased
None Check posted to G/L
Debit: Cash
   Credit: A/R
Cash Receipt (Applied) Processed Invoice Payment tab & Payments field updated
Invoice moved to Closed Invoices
Financials > Available Credit increased
Financials > Agings decreased
Financials > Invoices YTD increased
Financials > Invoices Lifetime increased
None None

 


Footnotes:

System tracks all three (LIFO, FIFO and Average) inventory costing methods per item, however, only post’s the designated default costing method to the General Ledger.

See what else is in STFB help (for footnotes).

NEXT - Enter OE analysis doc into OE Integration page.

 

financial software

erp

The Unofficial User Forum for Aplicor Web-based and Hosted CRM and ERP Software Solutions