Your trouble appears related to the fact that you have paid part of the purchase cost in cash and part by money transfer. You have mixed a cash payment with a purchase invoice, possibly duplicating part of the transaction. Look at the cash payment voucher and the money transfer voucher. Do they both post to Accounts payable? That would be correct, but I suspect they do not. And remember that cash transactions are always tax-inclusive, whereas purchase invoices are tax-exclusive unless you designate otherwise.
@AaiRIz, you paid the purchase invoice in 2 installments (1,045, and 200). The tax is apportioned over the two payments. Manager does not know that the payment is for a particular line item on the invoice (freight).
As to why the 2 reports look different:
On a cash basis, the transaction takes places when the cash is paid. You made 2 payments, so there are 2 transaction.
On a accrual basis, the transaction occurs when you make the purchase invoice. You made one purchase invoice, so there is one transaction.
But In Second transaction I paid 200. But in Cash basis (Total Purchase 190.60 and Tax Paid 20.42)
Ok that I know, But… Is there any way in manager that I can link the Transport Details with the Invoice.
Actually in our purchase Invoice, its not with Transport or Cargo Price. But I need Transport slip/Details with Link to that particular Purchase Invoice, (For Easy to find, and also for the Actual Inventory Cost). And Transport Company Dose note accept Cheque or Bank transfer for now. So We have to pay them in Cash.
Reading through the Guide Also … and also Create Separate Freight-in Invoice for Transport charge.
But That’s Not the solution.
For Example If there are two Inventory Items in different Quantity & value. Then only Inbuilt Freight-in option works Great. Manual Adding a Inventory Cost is not accurate and also we have do a double work for that simple thing So its not a solution.
In separate Invoice for Freight-in charge… its a headache for add that inventory and then in same invoice enter the negative qty to ADD only Freight-in charge to that Items without Increasing the Qty. (In this … we can use manually entering the freight charge…that’s easy… but I prefer automatic proportionate calculation of Freight-in…and its a headache work)
Can manager Team Provide solution on this? for batter management of Freight-in Cost to the Inventory. which is also linked with that Invoice… for batter identification of freight-in charge… Actually now this Topic is diverted on other point…
Where there is a separate invoice for freight-in, you don’t add any inventory to that invoice but you add the freight-in to the original inventory purchase invoice and then reverse out with a contra account, then the separate invoice for the freight-in gets posted to the contra account to cancel it out.
Original Inventory Purchase Invoice amended for separate Freight-in Invoice