Comments
REMARK: Featuring serialized photo scanning identification in concurrence or as alternative option to holographics, maybe optimum, for purpose to potentially easy transition from conventional to advanced, purpose of comparison (e.g. auto industry and/or auto maintenance and repair, or maquiladora), purpose of conventional references, or other. (IF applicable).
I personally see this as a design defect and flaw and I cannot imagine how other customers handle this. The bank reconciliation is really a fundamental accounting principal but the process cannot be fully supported based on the current functionality that lays within the advance bank reconciliation in Dynamics. As noted and explained previously, the business will always have a discrepancy between the accounting records posted to GL vs the transactions executed on the banks side. The two sources will never be mirrored.
So what is the real purpose of having any matching rules configured with the “Action” set to “Mark new transactions” in this case. The functionality doesn´t support the base so why should we map any transaction codes to bank transaction types. This is very misleading from an accounting and audit perspective, and I highly doubt that this is accepted somehow from an internal accounting group perspective.
As noted, the voucher date when the records are posted to GL are indeed todays date or equal to the date when you imported posted the “New” transactions.
This is the issue that we are currently facing. The system should consider the value date in the statement lines and set that to the posting date on voucher level.
Another solution for that problem may be have two fields in Table "Item Units of Measure" in place of "quantity per unit of measure":
1) Qty in Unit of Measure
2) Qty in Base Unit of Measure (Initial Value of this field = 1)
Then function GetQtyPerUnitOfMeasure(Item,UnitOfMeasureCode) in codeunit 5402 must return
"Qty in Unit of Measure'/"Qty in Base Unit of Measure"
Similar way is realised in "Currency Exchange Rate" table:
1) "Exchange rate Amount"
2) "Relational Exch. Rate Amount"