Monday, September 24, 2018

Cash Sales Import map to Undeposited Funds (Form displays Deposited where Account was selected with a Bank Account)


 
Steps to Reproduce:
 
1.  Create a CSV File with the following columns (sample only)
- External ID
- Customer
- Undep. Fund = Yes
- Item
- Quantity
- Price Level
- Rate
- Tax Code
- Payment Method - set the payment method (e.g. Direct Debit)
 
2.  Import cash sales transactions via CSV
 
3.  View the Cash Sales
 
Actual Result:  Instead of Undep Funds was selected, Account shows Bank Account and Status Deposited
 
Expected Result:  Cash Sales should show Account set to Undeposited Funds and Status Not Deposited
 
Solution:
 
Since there is a Payment Method on the CSV file - Navigate to Setup>Accounting>Accounting Lists>Type set to Payment Method
Click Edit next to the payment method (e.g. Direct Debit)
Check if Group with Undeposited Funds was selected or if Deposit To has been selected with the bank account set on the Account field

Per FLH - Choose the default account that autofills the Deposit To field on transactions when this payment method is selected.  Click Group with Undeposited Funds to choose Undeposited Funds as the default account.  Click Deposit To to assign a default bank account to this payment method. Then, select the appropriate account in the Account field.


Note: It should be set to Group with Undeposited Funds in order that when this payment method is selected it will default to Undeposited Funds.

No comments:

Post a Comment