Total Posted
This field displays the total amount posted to the transaction's designated journal accounts. It may be either a positive or negative number.
Whenever any function in the manufacturing modules sends transactions to one of the distribution journals, the system creates a material transaction, also known as a matltran record. Within that matltran record, the system stores the account and amount of each debit and credit sent to the journal. It also stores a unit cost for the transaction, which is calculated differently depending on the type of transaction and the item's cost type and method.
Using the stored amounts that were sent to the journal, the Material Transactions form and report attempt to show the effect the transaction had on inventory value. This value is shown in the Total Posted column. While for most transactions, the Total Posted value reflects the transaction's (unit cost * quantity), some situations cause a different calculation:
- If the quantity of the transaction is greater than or equal to zero (move into inventory), the Total Posted column shows the total of the debits sent to the journal.
- If the quantity is less than zero (move out of inventory) the Total Posted column shows the total of the credits.
For transactions with two entries, one hitting inventory with an offset to another account, the Total Posted figure typically equals the (unit cost * quantity) for the transaction. For example, a job material issue will simply debit WIP and credit inventory. Total Posted will be the credit to inventory and should match the unit cost * quantity. However, this will often not be the case for transactions that affect multiple accounts. This most commonly occurs for a transaction that is a receipt into inventory and that generates inventory adjustments due to the nature of the item's existing inventory data. The system debits inventory, credits the appropriate account such as WIP (job finish) or vouchers payable (PO receipt), and then either debits or credits inventory adjustment.
Other examples of situations that result in Total Posted not being equal to (unit cost * quantity) are listed below:
- You move a quantity into inventory for an item that has a negative on-hand. Because the negative on-hand needs to be "backed out" of the inventory account at the cost at which it went negative, you will end up with a debit to inventory, credit to WIP, and a debit or credit to inventory adjustment.
- For a specific-costed item that is not lot tracked, you move pieces into a stock location that already has a quantity and cost. That move causes the system to revalue the existing inventory at that location at the new, incoming unit cost.
- An average-costed item has different inventory accounts in its stock locations in either the same or different warehouses. Each time you receive the item into inventory, the system revalues all inventory in all accounts using the new average cost.
- When you enter a run transaction against a job, the unit cost is zero but the Total Posted will be the total of the debits for the transaction.
- You make a change to the inventory cost data for an item. The quantity in the material transaction will be zero (because on hand did not change), but the Total Posted shows the total of the revaluation at the new cost.