Why 'Sale (Qty.)' in Item is calculated from VE, not ILE

belindasphoto

Hi everyone, when I check flowfields in Item table, I find 'Sales (Qty.)' is calculated from 'Value Entry'.'Invoiced Quantity', not 'Item Ledger Entry'.'Invoiced Quantity'.
(For other quantities, like 'Purchases (Qty.)', 'Transferred (Qty.)', 'Positive Adjmt. (Qty.)', 'Negative Adjmt. (Qty.)', they are all calculated from ILE. )

Since the posting date of 'invoiced quantity' in VE and ILE could very likely be different, calculated from 'Value Entry' means the sales qty. is counted by the date it's invoiced, not shipped. I don't understand this logic.

Could anyone help to explain why? Thanks very much.

bbrown

I think this actually makes a lot of sense. This approach will not count "shipped not invoiced" transactions as sales. The thinking likely being that it's not really a sales until you charge someone (invoice) for it. It also puts the sale in the period it was invoiced. Which may not be the same period in which it was shipped.