I'm trying to do a report to get the total value of inventory on hand vs how much we have paid for of it. I'm looking through the Value Entry, Item Ledger Entry and Vendor Ledger Entry but I can't find anything that marks the individual item as paid. All I see is the Remaining Amount field on the Vendor Ledger Entry but that applies to the whole invoice.. does anyone know what to look for to find out if a particular item from the item ledger entry is paid for?
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello,
When you pay an invoice you pay the entire document (taxes included), not an item or another (you don't choose what you pay or not, within the same invoice).
Elena -
Jet Reports Historic Posts Hi,
in the item ledger entry (also in value entry) there are fields "..amount (expexted)" and "..amount (actual)" for costs, sale and purchase.
maybe that will help you to find out, which entry isn't paid yet or which amount was paid or is to be paid…
Give it a try, i'm not really sure if it works…
There is also a boolean "completly invoiced".
Please try and give a feedback, if something works for you
jetsetter
germany -
Jet Reports Historic Posts Yeah, there is no way to do it like Elena said.
Please sign in to leave a comment.