Description |
glije_ref glije_dr_cr_ind glije_amt glije_units glije_correcting glije_source_pgm
POST TICKETS C 2997.76 270.1000 N ptticu
glije_ref glije_dr_cr_ind glije_amt glije_units glije_correcting glije_source_pgm
POST INV. RECEIPTS D 1131.50 119.5000 N ptrctu
These transactions are from posting sales in origin. To fix all issue with origin units...
* Change import from subledger
* Change/validate conversion program
# let's drop the calculation of designation of Debit Credit of units
# assume that if the transaction is Debit amount, make sure the units is also + Debit Units
# assume that if the transaction is Credit Amount, make sure the units is also + Credit Units.
# This will ensure that as long as we are getting the proper Debit and Credit amount, the units will follow in the proper field. As you can see with the examples below. There is not a consistency in the unit valuation. It is dependent on origin posting program.
In the example above for the customer, the tblGLIjemst is showing
*S* *ales Post Tickets* would show Credit as +Units and Debit as -Units.
*Sales Credit Memo* would show Credit as -Units and Debit as +Units
*Purchases Post Inventory Receipts* would show Credit as -Units and Debit as +Units
*Negative Post Inventory Receipts* would show Credit as +Units and Debit as -Units.
|