so I end up making mods directly to the mysql tables... which is not good practice....

are there better ways to quickly enter a load of cash transactions with suppliers ?

I add a supplier and set the AP account for the suppler to Petty Cash

Using Direct Invoice I add the detail, hit process. Correctly in the GL I get CR Petty cash and DR the appropriate expense account(s) much as I would expect...

BUT these direct invoices all remain unpaid until I then manually create payment from petty cash - which result in both a dr and cr in petty cash for the same amount, i.e creating a redundant transaction in the GL

So am I missing something or is this a bug ?

Hello,

Use your petty cash account. This should be established as a bank account. Then you can use this at both selling and purchasing.
Even if it is called a bank account, it is your own cash register account.

Joe

Hi Joe,
Thanks for your reply. So I guess I need to add one supplier (for the example I give its name "Cash"). And then in manage supplier page, I use Petty Cash Account for the "Accounts Payable Account". Is it correct?

EDIT:
Or I just need to enter direct invoice and then enter the payment and choose Petty Cash Account  in "From Bank Account" option?

Use your petty cash account. This should be established as a bank account. Then you can use this at both selling and purchasing.
Even if it is called a bank account, it is your own cash register account.

Joe

Thanks in advance.