Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A/R Aging and UnApplied Cash

Status
Not open for further replies.

Fishhead714

Technical User
Dec 9, 2004
58
US
Could someone tell me how unapplied cash should affect the A/R aging report in Macola ES Batch 340?
 
In Macola ES 340 - it should show on the AR aging as a negative amount against the customer that the cash has been allocated to. I have run Cash Flow transactions that show a customer, but the Journal entries was not recorded, which throws the AR aging off. You will see this in the actual Cash Flow Entry. You should see the below enties.

Cash is first Received:
Trx will not show on aging yet!
Debit - Cash
Credit - Unallocated Cash

2nd You Allocate:
(Assign to customer or vendor)
Debit - Unallocated Cash
Credit - AR or AP unless costed

3rd You Match:
Breaks the unapplied cash up into individual invoices.

Interesting fact : the cash receipt is stored as the total amount in the GBKMUT and is broken out into the applied / matched amounts in the Banktransaction file.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top