AutoAccounting Concept in Accounts Receivables

Auto accounting is used to default the accounting information for manual transactions or imported transaction using autoinvoice. Auto accounting will be defined for:

             Receivables Account A/c 

             Revenue Account A/c 

             Tax A/c 

             Freight A/c 

             Unearned Revenve A/c 

             Unbilled Receivables A/c 

             AutoInvoice clearing A/c

To set default accounting there are two options in Auto Accounting concept. They are Tables name and Constant 

1. Table name: Incase of auto accounting with Table Name. We have Options like Salesreps, Transaction Type, Standard Lines and Taxes.
Salesreps: Accounting will be picked for above a/c's from the associated a/c's of salesperson.
Transaction Type: Accounting will be picked for above a/c's from the transaction Type selected in the AR invoice.
Standard Lines: Select this option, to use standard memo line item or inventory item to select your revenve a/c
Taxes: Enter this option to use tax codes when determining your tax account.
2. Constant: Enter the constant segment value to default the accounting to transaction.

Unable to apply Prepayment to standard Invoice. System not showing any error Message.

Problem Identification: In Prepayment Invoice distribution line the user has reversed the distribution line and then, the negative amount reversal line he made it zero and validated the invoice. As header amount and distribution are equal. System has validated the invoice. while applying standard invoice to Prepayment system is not showing prepayment invoice.
Solution: From SQL Query, I have verified the AP_Invoices_All and AP_Invoice_distributions_all Tables and found that, reversal_flag column as 'Yes' (Which should be Nil) and Prepayment_remaining_amount column as nil(As prepayment status is available Prepayment_remaining_amount column should have available prepayment amount value). Now, with update SQL Query, we have set Reversal_flag column as null and Prepayment_remaining_amount column with available amount. Now, system show Prepayment invoice, while applying with standard Invoice.