During open invoice migration, if you encounter an error ‘Please select an A/R account for the invoice’, check whether the customer has a default Receivables account selected. For this go to the customer record and check on the Account information section under the Financial tab. Check whether a receivables account is selected. If the field… Continue reading Open invoice migration A/R account selection
Tag: open invoice
Formula to generate the remaining amount without tax for Partially paid transaction types in proportion of amount paid to total amount
For open invoices partially paid, consider the following example… Subtotal /{ amt (net of tax) } =370.00 –> This amt is without tax Discount Item= 0 Tax Total =55.50 Total /{ total gross amount } = 425.50 Amount Due / { amt remaining }= 287.50 Amount paid= 138.00 Since we need to get the amount remaining… Continue reading Formula to generate the remaining amount without tax for Partially paid transaction types in proportion of amount paid to total amount