[sohail malik]

using billing schedule table I am trying to forecast sales using ODBC. the table does not appear to indicate what invoices have been generated vs those that are still pending generation. Any ideas on how I can figure this out? There is no indication of this in the billing_schedule table but it does surface in the UI as billed or not.

One idea I had was comparing the invoices generated vs the invoices scheduled to be gen’d. This seems kinda hard and slow. Also it appears that invoices are not usually generated on the exact date the schedule indicates they should be (usually a day later, sometimes more), so matching becomes a best guess.
This is a cached copy. Click here to see the original post.

[evan_goldberg]

RE: ODBC billing_schedule and sales forecast

The “matching” happens by quantity, i.e. the system looks at the current billed quantity of the order and finds the first entry in the billing schedule that represents a higher quantity.

[Author]

Posts