A record in PM_Distribution_WORK_OPEN must be created for each distribution line in each transaction. Each amount in the PM_Transaction_WORK table and its related amount in the MC_PM_Transactions table, such as purchase amount, freight amount, and cash amount, has a distribution created for it. A distribution type is assigned based on which amount the distribution is for. All amounts need to be taken into consideration when creating the distributions, since a transaction will not post if the amount distributed for a type does not balance with the amounts in the PM_Transaction_WORK and MC_PM_Transactions records. The balance must also be of the correct debit or credit balance, dependent upon the transaction type. The amount indicated by the 'Other' distribution type is not related to any amount in the PM_Transaction_WORK or MC_PM_Transactions records. This type permits balanced adjustments to General Ledger. The debit amount must equal the credit amount for all 'Other' type distributions for the transaction to post. You can also enter unit accounts with a distribution type of UNIT. The amounts entered for unit accounts do not need to balance. They are not validated since they may have varying numbers of decimal places. (In SBF, you cannot enter unit accounts.)
All amounts for the transaction must be accounted for in the PM_Distribution_WORK_OPEN table. There may be an unlimited number of distribution records for each transaction. By default, there will be only one distribution per distribution type, but the user may split that record into an unlimited number of distributions as long as the total for that particular type is correct.
The "Other" distribution type is useful for appending non-related distributions to the current transaction. These distributions will post to General Ledger with the distributions for the current transaction. Dynamics verifies only that for "Other" distribution types, debits equal credits. This allows for maximum flexibility while still allowing tight verification of the posting for the transaction.
Display Name: PM Distribution WORK OPEN
Physical Name: PM10100