Invoice – Invoice tables are updated.
Inventory Updated
- Inventory Detail – A record is made for each line item to leave an audit trail of activity.
Note: If an item was imported from Blend or Delivery Ticket, then the Inventory Detail entry shows the original quantity coming back in and the quantity saved with the Invoice going back out so that the change is noted. In the case where no change was made, the net effect is zero.
Note: When the item has a Manufactured Formula and that formula is set to relieve inventory at invoicing, then the raw materials are affected with an outbound entry and the finished product is affected with an inbound and outbound (no net change). - Inventory Amount on Hand – is updated for each line item.
Note: If an item was imported from Blend or Delivery Ticket, then the inventory Amount on Hand has the original quantity coming back in and the quantity saved with the Invoice going back out so this figure is changed by the difference. In the case where no change was made, the net effect is zero.
Note: When the item has a Manufactured Formula and that formula is set to relieve inventory at invoicing, then the Amount on Hand of the raw material items are decreased and the finished product has no change. - Manufactured Products – If an item has a Manufactured Formula and that formula is set to relieve inventory at invoicing, then an entry is made to the manufactured product tables.
- Customer Balances – The following is done for each customer in the split.
- New Regular Balance = Old Regular Balance + Amount Due
- New Prepay Balance = Old Prepay – Prepay $ Used
- General Ledger – A Customer-Type journal entry is made and the G/L account balances are updated.
| Customer Journal Entry | Debits | Credits |
| Total of all customer shares of Invoice | Accounts Receivable (for this location) | |
| Sales for each line item posted separately. Sum of customer shares/line item. These accounts defined at Depts. | Sales accounts | |
| Sales Tax (if used) | Sales Tax Liability |
If using Transactional Inventory Valuation, this additional posting occurs with on the journal entry:
| Customer Journal Entry | Debits | Credits |
| Cost for each item posted separately to the Inventory account defined at the department level | Cost as defined at the Inventory Department (Last, Average, Replacement, or Estimated Average) | |
| Cost for each item posted separately to the Cost of Goods account defined at the department level | Cost as defined at the Inventory Department (Last, Average, Replacement, or Estimated Average) |
- Booking – If used, quantity and dollars left is updated. If this transaction completes the Booking, then it is marked as Invoiced.
- Invoice Counter – This is incremented by one.
If Imported
- Blend Ticket(s) – Blend Tickets are marked as Invoiced.
- Delivery Ticket(s) – These are marked as Invoiced.
- Energy Ticket(s) – The status on the Energy Ticket changes from Open to Complete. The Last Delivery Gauge percentage on the tank is updated. Saving the Invoice updates the tank history.
- Void – The Invoice is marked as Voided. All other posting is offset with opposite entries. The Invoice Counter is not changed.
