We use :order/invoice-date as a start date (last invoice date) when determining the billing period range ('end date' is always previous month last day) and update it every time the new invoice is generated or 'drop' it if the order is cancelled so it doesn't get picked up in the next billing cycle, we also retrieve orders due for billing based on this date. plus readily available product database in mobile P.O.S. Example: if order was created on 10 Feb it would be billed/invoiced on the 1 March for the hours between 10 - 28 Feb and again on the 1 April etc, if cancelled anytime, same 'Pro-rata' logic as for the first month applies. Send payment reminders, manage expenses, create bill and invoices online. get your existing customer and product data into SliQ Invoicing and Quoting. Our invoicing is done on the first of every month for the previous month's usage and orders are billed per hour. You can do this by writing simple sentences that describe how the categories interact, such as customers order products and invoices track customers. How to retrieve orders due for invoicing and determine the billing period? Is it sensible to store invoice 'totals' in the db?Ĭurrently when invoice is produced, it's totals - :invoice/vat-amount, :invoice/total-inclusive and :invoice/total-exclusive are stored on the entity, but can be calculated from :invoice/items ? 2. services on the backs of Usage-Based Pricing (UBP) and Product-Led Growth (PLG). Invoice-item :invoice-item/description string Amberflo 2 days ago That may sound like the most basic of questions. form including Invoice Number, Date of Sale, Customer ID, Product ID. Invoice :invoice/date instant date/time when invoice was created Microsoft Access takes database tables and integrates various components into an. :order/invoice-date instant last invoice date :order/date instant order creation date/time Order :order/status keyword :active or :cancelled We use datomic for our db and clojure in the backend. We are in the process of redesigning and improving (normalising data, tuning preformance, eliminating complexity where possible) our billing system, and need help understanding best practices around storing vs calculating some values in ordering and invoicing processes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |